Power BI Desktop Level 2: Data Modeling & Reporting
Advance from reports to real data models in Power BI. Merge and profile data in Query Editor, build composite models and date hierarchies, write DAX with time intelligence, create advanced visuals, and schedule refreshes.
Course objective
Students will transform data in Query Editor, build advanced data models with composite models and date hierarchies, write DAX measures using filters, ranking, and time intelligence, create advanced visuals, and schedule refreshes and share reports in Teams.
Prerequisites
To ensure your success, we recommend that you have experience with loading and shaping data, building calculated columns and measures, and creating reports in Power BI Desktop. Students can obtain this level of skill through our Power BI Desktop Level 1 course. Contact us to discuss if this class is right for you.
Course outline
- Identify Strategies to Reduce Data Load in the Model
- Create Dimension Tables by Grouping Data
- Overcome Bad Data issues with Multi-Column to Row Data Merging
- Promote/Demote Row Data to a Header
- Merge Queries using Fuzzy Matching
- Use Pivot and Unpivot to Transform Column and Row Data
- Profile Data in Query Editor with Column Distribution, Quality and Profile Features
- Overcome Relationship Errors in Model
- Create Composite Models
- Explore Cross Filter Direction Impact on Data Precision
- Create a Table to store Measures
- Create a Disconnected Table
- Create Date Hierarchies as a Table Field
- Use Custom Format Strings in Data Model
- Load and Model GIS Data
- Create Visual Reports using GIS Data
- Explore Comparison Operators use in DAX
- Use Variables in DAX Expressions
- Filter Use in the Calculate Expression
- Create a Rank Measure
- Use If and Between in Calculated Columns and Measures
- Differences Between ALL and ALLSELECTED as Filters in CALCULATE
- Create a 3-Month Rolling Average
- Create To-Date Totals for Current 12 Months
- Build a Dynamic Time Matrix
- Apply Advanced Conditional Formatting Options to Data Fields
- Use Dual Card, Filled Map and Gauge Visuals in a Report
- Identify Factors that Impact Desired Results with the Key Influencers Visual
- Work with Report Layouts and Themes
- Schedule a Refresh of Data
- Load Power BI reports to Teams