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

This video focuses on designing a physical dimensional model (star schema) in SQL Server Management Studio (SSMS) using the graphical user interface. It offers an introduction to conceptual, logical Dimensional Data Model Designs.
Watch    • DIMENSIONAL DATA MODELING TUTORIALS -...  , where we explained the basic concepts in designing a Star Schema from a conceptual model to a logical model.

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 must develop a refined dimensional data model that can address the company's concerns.