Power BI: Advanced Data Modeling and Shaping (One-Day Course)
Course Outline
In this Power BI Advanced Data Modeling and Shaping course, you will learn the techniques of data modeling and shaping in Power BI, including the Data Analysis Expressions (DAX) formulas and the Power Query M language.
Power BI: Advanced Data Modeling and Shaping (One-Day Course) Benefits
Learn how to import data into Power BI from various sources, including XLS and CSV files
Create data queries using Power BI’s toolbar navigations and Advanced Editor
Apply your knowledge in hands-on learning labs
Follow a curriculum based on Microsoft Official Courseware
Continue learning and face new challenges with after-course one-on-one instructor coaching
Power BI: Advanced Data Modeling Course Outline
Module 1: Data Modeling Basics – Getting the Data
Module 2: Getting Started with M (Power Query Language) and Relationship Between Tables
Module 3: Fact Table, Introduction to DAX Calculated Columns and Measures
Module 4: Working with Parameters and Introduction to DAX
Module 5: Working with Functions - DAX CALCULATE Function, Custom Functions and Time Intelligence Functions
Module 6: Modeling with Power BI and DAX Best Practices (Data Modeling, Optimization Techniques)
Module 7: Summary, Wrap-up, and Questions
- choosing a selection results in a full page refresh