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.

Userful Links

[biwithmina]

Dear Subscribers,
Thank you for your interest in our videos.
We value all of your feedback and will do our best to reply in the comments.
Nevertheless, we may not be able to answer all practical questions, via comments.
To help with practical sessions, our dedicated team can be reached through email.

[richardnartey]

This tutorial has really helped me clear the clouds of data warehouse designing. Thank you.

[agushadianto]

Hi Mina,
I really enjoy your clear explanations in the video. It's so helpful to make understand more about how to build the dimensional model.
Thanks a lot.

[blaiseashun]

i have a project work in uk as a student and this video has opened my eyes to the solution... i was struggling but now i understand dimension tables, its entity and fact tables. ah tanks o. i appreciate.

[nadinecollard]

Great video and break down of how to process the data when starting a model 🙏🏾

[tapashmazumder]

Good Video. A question - Do we create a conceptual model in the form of star schema before converting into logical dimensional model? Don't we create a relational kind of a conceptual model and then convert it into dimensional model in the logical layer?

[El_Duderino]

Repeating Glenda's comment - Clear and concise - well done!

[WasimKhan-xmvt]

Good Explanation of Dimension modeling

[amna_c_]

Great video! I had trouble understanding the concept of dimensional modelling and this cleared all my doubts. Thanks

[shuwylicious]

I love how you explain stuff, well done!

[carloscampanholi]

Thank you! Clearly explained, really good video!!

[EagleEye]

Good day.
I would like to ask on how to include a dimension on a hierarchical design (recursion) to a fact?
Kindly set an example and provide explanation if possible.
Thank you.

[minhnguyenhainhat]

how could we define the measure of the fact table, why the measure is DrillAmount, but it is not the drilled Hole amount

[biwithmina]

Please SUBSCRIBE, SHARE, COMMENT, AND LIKE MY VIDEOS

[MrMLBson]

I've heard it's best practice to design the fact table at the lowest grain possible. What if they want to see how many holes were drilled by an employee in the morning vs the evening in the future? Doesn't this model limit yourself to potentially answering those questions?

[CrazyFunCricket]

Awesome Teaching skill !!! you are rock :)
Please make more videos with more case studies.

[SnowFlake-hy]

Could you please explain the differences between different data models(Inmon, Kimball, 3NF, Dimension Modelling, Data Vault).

[irdunno]

can you explain what is a grain? I don't really understand what lowest level of information means

[suleimanbashirshamsudeen]

Good illustration Mina. Why is the DateKey(Date_Dim) not linked to the facttable like the other dimension tables? and why in some star schemas surrogate keys are used in the fact tables instead of a primary key(drillingID) like you have here.

[dorisandjohn]

About the date Dimension, when it comes to fill it in the fact table, at minute 14:18 you add a "DateStamp" that after in the logical schema does not apears but instead there are: "DrillStartDate (FK)" & "DrillEndDate (FK)". Could you please explain why that change ? Thank you.