Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 26 Minute(s)
Language
English
Taught by
Ahmed Oyelowo, Foresight BI & Analytics. 100,000+ Learners
Rating
Course Overview
Learn and Master Data Modeling for Advanced Power BI Development
In this Data Modeling course, you will learn all you need to know to create and Manage Data Models in Power BI. You will be able to troubleshoot Power BI Data Models when things are broken in your reports. Taught by 5x Microsoft MVP for Data Platform and creator of Udemy's Power BI Best Seller Course.
This course is deigned to allow you gain mastery of the heart and engine of Power BI Solutions: The Power BI Data Model. You will learn about Data Modeling Concepts valuable in other data fields like Database Administration, Analytics Engineering, Data Engineering and Data Warehousing.
Below is a list of the topics covered in this Power BI Data Modeling Essentials Course:
Understanding Data Normalization Concept
Understanding Fact and Dimension Tables
Creating your own Fact and Dimension Tables from a De-Normalized Data
Using Power Query and simple M Language Technique to Normalize a Data Table
Understanding Model Relationships Cardinality and Cross Filter Direction
Understanding One to One, Many to One and Many to Many Relationships
Using DAX to create and Configure Date Tables in Power BI Data Models
Using simple Power Query M Language technique to create Date Tables for Power BI Data Models
Working with Multiple Fact Tables in a Power BI Model
Troubleshooting Data Models in Power BI
By the end of this course, you will be confident with Models in Power BI and will be on-course to Advance your Power BI knowledge, especially Data Analysis Expressions (DAX).
Enroll now and get started on your journey to Masting Data Modeling for Advanced Power BI Development.
Course Content
- 7 section(s)
- 53 lecture(s)
- Section 1 Introduction
- Section 2 Normalizing Data with Power Query
- Section 3 Working with Normalized Data in Power BI
- Section 4 Creating Date Tables with DAX in Power BI
- Section 5 Creating Date Tables with M in Power Query
- Section 6 Working with multiple Fact Tables
- Section 7 Troubleshooting Data Models in Power BI
What You’ll Learn
- Get strong foundation of data modeling useful in other data fields like Analytics Engineering & Data Engineering
- Learn modeling techniques used by database designers
- Learn all about managing and troubleshooting data models in Power BI
- Understand the business logic of Facts and Dimension Tables
- Design and Implement Star Schema Models for Power BI
- Understand Snowflake Schema in Power BI
- Dive into the world of M Language to create Data Tables with Power Query
- Learn from a 5x Microsoft MVP and Creator of Udemy Best Selling Power BI Course
Skills covered in this course
Reviews
-
HHarit Pathak
Very Good
-
BBhargav B
good
-
AAmaresh Khuntia
Nyc
-
CCesar Delgado
this course has over-passed my expectations, it is simply awesome, clear, functional and the professor's instructions are great !
