Microsoft Power BI Desktop Fundamentals

Course Overview

Microsoft Power BI Desktop Fundamentals

This course covers all the fundamental skills required to understand and start to use Power BI with confidence. 

Course Content

Module 1 - Setting the scene

• What does Power BI do
• The Power BI ecosystem

Module 2 - Getting Started with Power BI

• The Power BI interface
• Opening, creating and saving reports
• Data source types
• Local and remote connections

Module 3 - Basic Visualizations

• Creating a table visual
• Formatting a table
• Matrix visual and formatting
• Card Visual and formatting

Module 4 - Using Visualizations

• Slicer visuals
• Formatting visualizations
• Additional report content

Module 5 - Power BI Calculations

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

Module 6 - Filtering data

• Filtering visuals
• Filtering by relative date
• Filtering pages
• Filtering the report

Module 7 - Working with the Query Editor

• The query editor window
• Loading data

Module 8 - Transforming Data

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

Module 9 - Creating Query Calculations

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

Module 10 - Editing Queries

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

Module 11 - Using Multiple Data Sources and Relationships

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

Module 12 - Publishing and the Power BI Service

• Signing into Power BI
• Publishing a report
• Power BI service structure
• Using workspaces