Beskrivning
After this training you’ll be able to:
- Identify the primary components of data models and describe flat schemas and star schemas
- Diagnose common Power BI data modeling issues within models and recommend appropriate solutions to them
- Identify common challenges in Power BI data models, implement smart solutions, and avoid common mistakes
Audience
- Business professionals whose job requires them to design and build data models in Power BI
- Anyone preparing to take the Microsoft PL-300 exam
Prerequisites
To get the most out of this course, you should be familiar with preparing data using Power BI.
Topics
- Common Models
- Composite Models
- Complex Models
- Power BI Aggregations
- Chained Models
- Header-Details Models
- Setting the Grain of the Model
- Star Schemas
- Flat Schemas
- Multiple Fact tables
- Denormalized Fact Tables
- Role Playing Dimensions
- How to handle SCD-Dimensions
- Leveraging Junk Tables
- Bi-Directional Filtering
- Cardinality & Relationships
- Primary Keys, Surrogate Keys, Natural Keys, Foreign Keys
- DAX Calculated Tables
- DAX Calculated Columns
- DAX Calculated Measures
- DAX Date Tables
- Model Performance
Kursen levereras i samarbete med
Recensioner
Det finns inga recensioner än.