Duration
1 Days
Overview
Learning Objectives
After successfully completing our Part 1 Power BI Essentials course.
Delegates will learn how to:
- Power Query – Transform Data
- Data Model – Manage
- DAX Formulas
- Building Dynamic Reports
- Visualisations
- Power BI Service
Prerequisites
Part 1: Power BI Essentials
1. Power Query – Transform Data
- More Transformations
- Merge Queries, Append Queries
- Connect to other Data Sources
2. Data Model – Manage
- Using Calendar Tables to enable Time Intelligence
- Group Items (Group/Bin)
3. DAX Formulas
- Popular DAX Functions (COUNTROWS, RELATED…)
- Override Filters (CALCULATE, ALL etc.)
- Time Intelligence (YEAR-TO-DATE etc.)
4. Building Dynamic Reports
- Filtering and Slicers
- Interactions between Visuals, Drill-Down
- Other Visual Elements (Text Box, Shape, Image etc.)
5. Visualisations
- Formatting Visuals
- Conditional Formatting
- Custom Visuals
6. Power BI Service
- Workspaces and Sharing
- Handling Datasets, Reports and Dashboards
