-
Module 1: Overview of Power BI
21 Lessons-
StartModule introduction
-
StartWhy implement a BI system?
-
StartCommon BI needs
-
StartWhat is Power BI ?
-
StartPower BI positioning
-
StartPower BI overview
-
StartMicrosoft positioning vs competition
-
StartV1 Power BI limitations
-
StartHistory of V1 support for Excel versions
-
StartCurrent common components
-
StartSign up for Power BI
-
StartPowerBI.com site
-
StartQ & A
-
StartDynamic formatting
-
StartPower BI Desktop
-
StartPower BI Mobile apps
-
StartPower BI Windows app discontinued
-
StartOther tools
-
StartHow Power BI relates to Fabric
-
StartQuiz 1: Overview of Power BI
-
StartLab 1: Installing and Configuring Power BI Tools
-
-
Module 2: Discovering and preparing data with Power Query
20 Lessons-
StartModule introduction
-
StartPower BI data
-
StartConnect to data
-
StartTemplate apps
-
StartOrganizational apps
-
StartPublish from Excel discontinued
-
StartPower Query for Excel
-
StartPower Query for Excel data sources
-
StartPower Query in Power BI Desktop
-
StartLoad options
-
StartEditing queries to transform data
-
StartQuery settings
-
StartContext menus
-
StartM language script
-
StartM language reference
-
StartCombining queries
-
StartQueries as functions
-
StartAltering and refreshing queries
-
StartQuiz 2: Discovering and preparing data with Power Query
-
StartLab 2: Discovering and Preparing Data with Power Query
-
-
Module 3: Creating and enhancing semantic data models
22 Lessons-
StartModule introduction
-
StartPower Pivot in Excel
-
StartPower Pivot audience
-
StartTypical Power BI development methodology
-
StartData model views
-
StartTable relationships
-
StartDAX
-
StartDAX table references
-
StartDAX operators
-
StartDAX functions
-
StartCalculated columns
-
StartCalculated tables
-
StartDefining measures
-
StartImplicit vs explicit measures
-
StartQuick measures
-
StartManually entering data
-
StartDefining parameters
-
StartData types and formatting
-
StartHierarchies
-
StartKey performance indicators
-
StartQuiz 3: Creating and enhancing semantic data models
-
StartLab 3: Creating and Enhancing Semantic Data Models
-
-
Module 4: Creating querying and sharing dashboards and apps with the Power BI site
19 Lessons-
StartModule introduction
-
StartSign up
-
StartTry to keep up with changes
-
StartCurrent licensing
-
StartSite status
-
StartPower BI dashboard
-
StartPower BI report
-
StartWorkspace
-
StartCustom visualizations
-
StartSharing dashboards
-
StartQ and A
-
StartSynonyms and Q and A setup
-
StartScheduled and manual refresh
-
StartRefresh options
-
StartRefresh on-premises data
-
StartMicrosoft Entra ID
-
StartPower BI for developers
-
StartQuiz 4: Creating querying and sharing dashboards and apps with the Power BI site
-
StartLab 4: Creating Querying and Sharing Dashboards with the Power BI Site
-
Power BI Core Skills
Want to work with Power BI and have no idea where to start? Let us show you in this straightforward course with easy to follow practical exercises.
Course Summary
Do you need to get started with Power BI?
- You need to turn raw data into compelling, interactive reports and dashboards
- You want to understand how to connect Power BI to a variety of data sources like SQL Server, Excel, and cloud services
- You're using Excel, Tableau, or another tool, but want to upskill or switch to Power BI
- You want to learn how to get stared cleaning, shaping, and modeling your data for reliable reporting
- You need to share reports securely via Power BI Service, and understand licensing and distribution options
- You're new to Power BI or self-taught, and want a structured, professional foundation
We encourage you to complete the practical exercises. We have tried to make this as easy as possible. You do not need to install SQL Server, databases, etc. We have an online version hosted for you. All you need will need to install is Power BI and you'll want that later anyway !
