What is Power BI?
- Power Query
- The Data Model/Power Pivot
- Rich interactive visualisations
- Power BI Desktop and Power BI Service
The Power BI Desktop Interface
- Different Views
- Visualisation and Fields pane
- Power BI Desktop Options
Getting Data into Power BI
- From Text Files
- From CSV files
- From Web
- From Folder
- From Excel ranges and sheets
Understanding Power Query
- Understanding the Power Query interface
- Renaming and deleting steps
- Cleaning messy data example
- Refreshing a query
- Power Query Options
Common Power Query Features
- Unpivot Columns
- Setting Data Types
- Append Queries
- Merge Queries
Creating the Data Model
- Create table relationships
- Edit and delete relationships
- Understand filter context
Getting Started with DAX
- How is DAX different to Excel Formulas
- Calculated Columns vs Measures
- Creating a Calculated Column
- Creating Measures
- Using Common DAX Functions
Getting Started with DAX
- How is DAX different to Excel Formulas
- Calculated Columns vs Measures
- Creating a Calculated Column
- Creating Measures
- Using Common DAX Functions
Lookup and Filter DAX Functions
- Why these functions are useful?
- RELATED Function
- CALCUALTE Function
- FILTER Function
Interactive Visualisations
- Adding tiles to a Report
- Creating Charts
- Using Geographic Data
- Creating Matrixes
- Using Slicers
- Other Filter tools (Report, Pages, Visualisations)
- Editing Interactions
- Highlight vs Filter
- Formatting Visualisations
- Drill Down
Power BI Service
- Publishing your Report
- Mobile Layout
- Reports and Dashboards
- Bookmarks
- Understanding Gateways
- Refreshing your Reports