This course combines engaging instructor-led presentations and useful demonstrations with valuable hands-on labs and engaging group activities. Throughout the course you'll learn how to:

Choose the appropriate method for data ingestion

• Use the Power Query Editor to perform transformations in data
  • Understand and select appropriate data types
  • Find and correct empties and errors
  • Add new columns
  • Remove unnecessary rows
  • Merge and append queries
  • Create, modify and delete Applied Steps
  • Introduction to the 'M' language.
• Create a star schema semantic model
  • Understand the different types of relationships in Power BI
  • Create appropriate relationships
  • Create and activate a date table
• Use the DAX language to:  
• Create a calculated column
• Create simple measures
• Understand filter and row context at the entry level
• Create a multi-page report with a variety of visualizations:
  • Identify which type of visualization to use for a specific purpose
  • Formatting pages and visualizations
  • Change or delete interactions between visuals
  • Sync slicers
  • Create a drillthrough page
  • Use the Filter panel to filter data in the report
  • Create bookmarks and buttons
  • Enhance the data model with hierarchies and hidden fields
  • Use the Performance Analyzer feature to measure a report's performance
  • Identify elements that affect your report's performance
• Publish a report to the Power BI Service
  • Understand the difference between Workspaces and My Workspace
  • Navigate the Power BI Service
  • Set up an automated refresh schedule
  • Choose appropriate settings for a report
• Create a dashboard
  • Understand the different ways to share reports with a wider audience
  • Creating an app
  • Sharing a report to Teams
  • Sharing a report to SharePoint
• Understand the licensing structure

This introductory-level hands-on course is designed for users who are new to Power BI and are responsible for accessing organizational data, transforming that data and generating reports.

Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We'll work with you to tune this course and level of coverage to target the skills you need most. Topics, agenda and labs are subject to change, and may adjust during live delivery based on audience skill level, interests and participation. 

Introduction to the Power BI ecosystem

• What is Power BI?
• Overview of the Power BI Ecosystem
  • Power Query Editor; Power BI Desktop; Power BI Service
• Tour of the Power BI Desktop
• Tour of the Power Query Editor

The Extract, Transform, Load process

• Introduction to the Power Query Editor
• Clean and transform raw data using the ribbon
• Mastering data types
• Understanding some of the PQE 'rules'
• Leveraging Applied Steps
• Finding nulls/blanks/empties
• Adding custom columns
• Removing unnecessary columns
• Introduction to the 'M' language
• Modifying the M in the Formula Bar
• Merging/appending data sources
• Saving/applying transformations

Creating the data model

• What is a data model? Why is it necessary?
• Reviewing relationships/creating new ones
  • One to many; Many to many; One to one
• Using basic DAX to add data
  • Measures; Calculated columns; Tables
• Introduction to filter context and DAX  

Enhancing the semantic model

• Hierarchies
• Hidden fields
• Adding synonyms
• Adding descriptions  

Creating a date table

• Why is a date table necessary?
• Where is the date table created?
• Creating a basic date table
• Connecting in a date table

Creating a report

• Formatting pages and using themes
• Choosing and placing visuals
• Formatting visuals
• Visual header controls
• Editing visual interactions
• Slicers and the filter panel
• Syncing slicers
• Formatting tooltips/creating a tooltip page
• Creating a drill through
• Understanding and evaluating page/visual performance

Publish a report and semantic model

• Publish the report to a designated workspace
• Tour of the Power BI Service
• Apps; Workspaces; My workspace
• Review of the five types of a content a workspace can store
• Reports; Dashboards; Datasets; Dataflows; Apps

Understanding Workspaces

• Viewing a report or dashboard
• Review of menu options
• Understanding editing privileges in Workspaces
• Review of menu options in edit mode
• Editing a report and saving changes
• Creating a dashboard
• Setting up a refresh schedule
• Creating an app and defining audiences
• Publishing a report or dashboard to an app