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 based on your data sources and analysis goals.
• Use the Power Query Editor to clean, transform, and shape data effectively.
• Create a star schema semantic model to organize data for efficient analysis.
• Use DAX language to create calculated columns and simple measures for deeper insights.
• Understand filter and row context at an entry level to write more effective calculations.
• Design and build a multi-page report using a variety of interactive visualizations, slicers, and tooltips.
• Publish reports to the Power BI Service and manage refresh schedules to keep data current.
• Create dashboards to present key insights and share them effectively with your team.
• Understand the different methods for sharing reports and dashboards with wider audiences, including apps and embedding.
• Gain a basic understanding of Power BI's licensing structure to ensure appropriate usage and distribution.

This introductory-level hands-on course is geared for anyone new to Power BI who needs to work with data, create reports, or support data-driven decision-making. Ideal roles include analysts, business users, report creators, and professionals responsible for managing or transforming organizational data.

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. 

1. 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

1. 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

1. 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  

1. Enhancing the semantic model

• Hierarchies
• Hidden fields
• Adding synonyms
• Adding descriptions  

1. 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

1. 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

1. 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

1. 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