Microsoft Power BI Desktop

Course Overview

Microsoft Power BI Desktop

Report on and present data stored in a variety of external data sources.

Course Content

Module 1 - Getting Started with Power BI

• The power bi interface
• Opening, creating and saving reports
• Data source types
• Local and remote connections

Module 2 - Working with the Query Editor

• The query editor window
• Loading data

Module 3 - Transforming Data

• Creating and managing columns
• Reducing rows and applying filters
• Cleansing and replacing values
• Sorting and grouping data

Module 4 - Editing Queries

• Query step settings
• Refreshing data
• Duplicating queries
• Merging and appending queries

Module 5 - Using Multiple Data Sources and Relationships

• Related data sources
• Creating relationship in Power BI
• Managing relationships
• Working in model view

Module 6 - Creating Query Calculations

• Using formulas
• Creating custom columns
• Modifying query functions
• Advanced query editing

Module 7 - Power BI Calculations

• Creating calculated columns in Power BI
• Using Power BI functions
• Calculated measures
• Using hierarchy groups

Module 8 - Using Visualizations

• Visualization types
• Creating and arranging visualizations
• Adding visualization fields
• Slicer visuals
• Formatting visualizations
• Additional report content

Module 9 - Viewing Report Data

• Applying visualization and page filters
• Data drill-throughs
• Grouping data
• Creating spotlights and focus
• Using report bookmarks

Module 10 - Publishing and the Power BI Service

• Signing in to Power BI
• Publishing a report
• Power BI service structure
• Using workspaces
• Power BI dashboards
• Sharing dashboards and reports