Power BI
Power BI Desktop Level 2: Data Modeling & Reporting
CPE Eligible - visit /cpe for details.CPE page →
Course outline
Data Transformation using Query Editor
- 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
Improved Data Modeling in Power BI Desktop
- 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
GIS Data Usage in Power BI Desktop
- Load and Model GIS Data
- Create Visual Reports using GIS Data
Conditional, Rank, and Filter use in DAX Measures
- 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
DAX Measures using Time Intelligence
- Create a 3-Month Rolling Average
- Create To-Date Totals for Current 12 Months
- Build a Dynamic Time Matrix
Power BI Desktop Visuals and Reports
- 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
Data Connectivity and Power BI in Teams
- Schedule a Refresh of Data
- Load Power BI reports to Teams