Master
Data Modeling
in
Power Bi
In Just 12 Days
*Disclaimer*
Everyone learns uniquely.
What matters is your focus on specific aspects of
data modeling, ensuring a comprehensive
understanding.
This Doc will help you with the same.
Day 1
Introduction to Data Modeling
Topic
Explore the fundamentals of data modeling in Power BI, its
significance in data analysis, and an overview of basic
concepts such as tables, relationships, and schema types.
Activity
Connect to SQL Server, Excel, and Web data sources.
Resources
https://powerbi.microsoft.com/en-in/what-is-data-modeling/
https://powerbi.microsoft.com/en-gb/why-power-bi/
https://www.youtube.com/watch?
v=wyKLn7C_cGw&t=24s&ab_channel=PavanLalwani
2
Day 2
Understanding Data
Relationships
Topic
Dive into the types of data relationships (one-to-one, one-to-
many, many-to-many) in Power BI and learn how to create
and manage these relationships to link different tables
effectively.
Activity
Practice creating various types of relationships using a
sample dataset to understand their impact on data analysis.
Resources
https://databear.com/relationships-power-bi/
https://www.youtube.com/watch?
v=sW5LoDA1ssM&ab_channel=AlexTheAnalyst
3
Day 3
Data Importing Techniques
Topic
Learn about the different methods of importing data into
Power BI, and explore how to connect to various data sources
like SQL Server, Excel, and web APIs.
Activity
Connect to SQL Server, Excel, and Web data sources.
Resources
https://www.youtube.com/watch?
v=K690u_FkL4A&ab_channel=Tutorialspoint
https://www.youtube.com/watch?
v=hEpzvvIY89Q&ab_channel=PavanLalwani
https://learn.microsoft.com/en-us/power-bi/connect-data/service-
get-data-from-files
4
Day 4
Data Transformation Basics
Topic
Introduction to Power Query as a powerful tool for data
transformation in Power BI, covering basic transformations
such as filtering, sorting, and basic column operations.
Activity
Use Power Query to clean and transform data.
Resources
https://learn.microsoft.com/en-us/power-bi/transform-model/
https://www.youtube.com/watch?v=Z3bqEG3zrxw
5
Day 5
Advanced Data
Transformation
Topic
Advance your Power Query skills by exploring complex data
types and transformations, including merging and appending
queries, working with text, numbers, and dates.
Activity
Perform advanced data transformations on imported data.
Resources
https://www.youtube.com/watch?
v=cx1qosaiLu8&ab_channel=AnalyticalGuy
https://www.simplilearn.com/tutorials/excel-tutorial/power-query-
in-excel
https://www.youtube.com/watch?v=-
peKp48spgY&ab_channel=Tutorialspoint
6
Day 6
Creating Calculated Columns
Topic
Learn the basics of DAX (Data Analysis Expressions) in Power
BI, focusing on creating calculated columns to add new data
based on existing dataset calculations.
Activity
Add calculated columns using DAX.
Resources
https://learn.microsoft.com/en-us/power-bi/transform-model/
desktop-quickstart-learn-dax-basics
https://www.youtube.com/watch?
v=waG_JhBgUpM&ab_channel=KevinStratvert
7
Day 7
Measures and Aggregations
Topic
Explore the concept of measures in Power BI, learn to create
basic aggregations like sums, averages, and counts, and
understand the difference between calculated columns and
measures.
Activity
Create measures using DAX.
Resources
https://learn.microsoft.com/en-us/power-bi/transform-model/
desktop-tutorial-create-measures
https://www.youtube.com/watch?
v=waG_JhBgUpM&t=25s&ab_channel=KevinStratvert
8
Day 8
Time Intelligence in DAX
Topic
Delve into time-based functions in DAX to create powerful
time intelligence measures, like year-to-date, month-to-date
calculations, and date comparisons.
Activity
Create time-based calculations (YTD, MTD, etc.).
Resources
https://learn.microsoft.com/en-us/dax/date-and-time-functions-dax
https://www.youtube.com/watch?
v=Z9xxs1hBut0&ab_channel=MicrosoftPowerBI
9
Day 9
Optimizing Data Models
Topic
Delve into time-based functions in DAX to create powerful
time intelligence measuresLearn techniques to optimize your
Power BI data models for performance, including efficient use
of relationships, minimizing column cardinality, and
understanding data model size implications., like year-to-
date, month-to-date calculations, and date comparisons.
Activity
Optimize an existing data model for better performance.
Resources
https://learn.microsoft.com/en-us/training/modules/optimize-
model-power-bi/
https://learn.microsoft.com/en-us/power-bi/guidance/power-bi-
optimization
10
Day 10
Introduction to Star Schema
Topic
Understand the Star Schema design in data modeling, its
advantages in simplifying data analysis, and how to design a
basic Star Schema for effective data modeling in Power BI.
Activity
Design a basic Star Schema for a sample dataset.
Resources
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
https://www.youtube.com/watch?v=7ciFtfi-
kQs&ab_channel=PragmaticWorks
11
Day 11
Advanced Data Modeling
Techniques
Topic
Explore advanced data modeling techniques in Power BI,
including the use of hierarchies for drill-down analysis and
the implementation of advanced filters and slicers for
interactive reports.
Activity
Implement a complex data model using learned techniques.
Resources
https://learn.microsoft.com/en-us/power-bi/guidance/powerbi-
implementation-planning-usage-scenario-advanced-data-model-
management
https://learn.microsoft.com/en-us/power-bi/create-reports/service-
metrics-get-started-hierarchies
https://www.youtube.com/watch?
v=j6jjOScCy9A&ab_channel=CCGAnalyticsSolutions%26Services
12
Day 12
Real-World Project and
Review
Topic
Apply everything learned in a mini-project.
Activity
Build a complete data model from scratch and review.
13
Remember to become best at any
topic, Consistency is the Key!
Encouraging continuous practice and
exploration of new datasets.
14
Why
Bosscoder?
1000+ Alumni placed at Top
Product-based companies.
More than 136% hike for every
2 out of 3 working professional.
Average package of 24LPA.
Explore More
