Course Topics
Get to know Power BI
- What is Power BI?
- Understanding Power BI Desktop and Power BI Service
- Dataset, report, dashboard: terminology explained
Retrieve and structure data
- Prepare data for Power BI
- Retrieving data in Power BI Desktop
- Opening and understanding the Power Query Editor
- Change data type
- Editing columns and rows in the Power Query Editor
- Show report, data and models
Visualise data
- Creating a visualisation
- Edit visualisation
- Activating data labels
- Creating reference lines
- Changing the order of values
- Displaying the visualisation data
Create filter
- Create and format a slicer
- Adjusting interactions between visualisations
- Creating page and report filters
Formatting and publishing a report
- Add pages and format report
- Optimising a report for mobile devices
- Publishing a report
Introduction to Power BI Service
- Find your way around the Power BI service
- Switching workspace
- Update semantic model
- Sharing reports via Power BI Service
- Export report
- Integrate report into Teams and SharePoint
Compile and share dashboards
- Creating a new dashboard
- Pinning a visualisation to the dashboard
- Pinning a tile from another dashboard
- Pinning a report page as a live tile
- Configuring the dashboard
- Sharing a dashboard within your organization
Use intelligent functions
- Asking questions about data
- Predefining questions about a dashboard
- Generating quick insights