Cart 0

Power BI: Advanced Data Modeling and Shaping
Course 8646
2 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 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

Course Dates
Attendance Method
Note about the Certification Exam

When you register for the course, you will be prompted to choose Y/N to take the exam. Please select yes, as all HHS CISO employees are required to attempt the exam if one is offered for the course. Please be advised, if your course if funded by DIR, the Certification Organization has agreed to provide DIR the pass/fail status of your exam. DIR will only share this information in an aggregated report to state leadership that reflects total exam pass or fails. No individual names of any students will be included in any reports.

DIR requires that you submit the request for your exam voucher within one month of the last day of your course. DIR requires that you take your exam within six months of the last day of your course.

Additional comments or questions (optional)