DIMENSIONAL DATA MODELING TUTORIALS - STAR SCHEMA | Based on a case study | Part 1

This video is a scenario-based tutorial to offer an introduction to designing a dimensional data model.
You will learn the 4-step design process for dimensional modelling, the Importance of Dimensional Data Model, the Difference Between Dimensions, Fact and Fact Tables, and design a Star Schema from a conceptual model to a logical model in Microsoft Excel.
Subsequent videos will show how to design a physical dimensional model (star schema) in Microsoft SQL Server Management Studio.

CASE STUDY

An Exploration Manager is worried about keeping the list of drilling information in excel sheets due to the exponential growth of gold exploration data in several concessions.
The budget is already in place to develop a Database that will provide the number of holes drilled per concession per day. Management will require reports that provide the total amount of charge per drilling company per concession. Management wants to leverage the database to set a target for each employee and identify potential drilling issues that impact the project.
As a data modeller, you are required to develop a refined dimensional data model that can address the company's concerns.

Видео DIMENSIONAL DATA MODELING TUTORIALS - STAR SCHEMA | Based on a case study | Part 1 канала BI with Mina