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.

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.

[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.

[connectingthedots]

Hey my sister, I’m just happy to see an intelligent black lady teach IT on YouTube and explain it the way I want it. I want to see more of your videos. Wish I can contact you and learn more from you. 👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻

[saumyavora]

Thanks for clearing my concept!! One of the best videos for the Dimensional model

[obinnau]

Good job Mina. I look forward to the T-SQL implementation and row changing dimension.

[biwithmina]

Please SUBSCRIBE, SHARE, COMMENT, AND LIKE MY VIDEOS

[BlazingDragon]

Wonderful explanation Mina, looking forward for part 3 covering data load. Thanks!

[felisiandasi]

excellent work mina you are a live saver

[saretumusa]

Very detailed explanation Mina Great Job

[olusolaalabi]

Wonderfully done Mina, I definitely will like a video on date as a role playing dimension!

[nidhisingh]

Can you plz make part 3 to show how to populate data for these tables. Thank you

[johndujany]

Dear Mina, thank you for these tutorials to show how to build a Star Schema. I am wondering if there is a way, maybe a different way to build a Star Schema if one already have a Relational database model. I would be really interested in a method to explain how to derive the Star Schema from ERM. Thx for your comment.

[norpriest]

Looking for in-depth data modeling techniques and complex data modeling such as if there are more than 1 fact table, how to connect relationship properly and what would be criteria

[adelekeseun]

Hello Mina,

I would like to see how you populate your data into MySQL most especially the date dimension

[ABBORStern]

hey Mina, thanks for the video, could you explain how did you set this PK/FK for the Role-Playing Dimensions between DimDate and FctTable?

[mwahmed]

Hi. Could you please create a video on how to populate these tables by SSIS ..thanks you

[johndujany]

Hi, about the facts "DrillStartDate" & "DrillEndDate" here as (FK), where are the corresponding (pk) in the dimensions ? Please explain more role playing dimensions. Thx.