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.
Userful Links
amzn.to/3pIUAiG
amzn.to/3JHfsha
amzn.to/3JIViU5
- DIMENSIONAL DATA MODELING TUTORIALS - STAR SCHEMA | Based on a case study | Part 1 ( Download)
- Data Modeling Tutorial: Star Schema (aka Kimball Approach) ( Download)
- DIMENSIONAL DATA MODELING TUTORIALS - STAR SCHEMA | Based on a case study | Part 2 ( Download)
- DIMENSIONAL DATA MODELING TUTORIALS - GALAXY SCHEMA | A CASE STUDY ( Download)
- Master Dimensional Modeling Lesson 01 - Why Use a Dimensional Model ( Download)
- What is STAR schema | Star vs Snowflake Schema | Fact vs Dimension Table ( Download)
- Dimensional Data Model Tutorial - A Kimball Style Data Model ( Download)
- dbt Dimensional Modelling Project - Part 1 ( Download)
- Data Modeling (Star Schema 🌟) in Power BI – Creating Dimension Tables ( Download)
- DWBI UNIT I Lecture 8 - Schemas for Multi Dimensional Data Model ( Download)
- Practical Dimensional Data Modelling with Real Industry Example ( Download)
- Learn Data Modelling & Star Schema for Power BI in 20 minutes ( Download)
- Dimensional Data Modeling Interview Questions - Part 1 ( Download)
- What is Data Modelling Beginner's Guide to Data Models and Data Modelling ( Download)
- Data Modeling - Walking Through How To Data Model As A Data Engineer - Dimensional Modeling 101 ( Download)
