Skip to main content

Introduction to Microsoft Power BI

Beginner10 Hours 52 Minutes65 Course Videos75 Test Questions

$199.00

A beginner course on Microsoft Power BI for people who build reports in spreadsheets today. Learn to clean data, build a model, write DAX and design dashboards in 10 hours 52 minutes of video.

  • Login details sent straight after payment
  • Self-paced. Study on any device
  • StemBoss Certificate of Completion
  • 14-day refund promise

Secure checkout. Pay by card, Apple Pay or Google Pay.

Download the course outline (PDF)

Introduction to Microsoft Power BI is a beginner course that shows you how to turn raw data into clear, interactive reports with Microsoft’s business intelligence tool. It is built for analysts, finance staff and Excel users who want to move past manual spreadsheet reports. You get 10 hours 52 minutes of self-paced training across 65 videos, plus 75 practice questions.

What you will learn

  • Connect Power BI to spreadsheets, databases and cloud data sources
  • Clean and reshape messy data with Power Query before you report on it
  • Build a data model with tables and relationships that make sense
  • Write DAX measures for totals, ratios and other business metrics
  • Design interactive dashboards and reports people can filter and explore
  • Know when to use Power Query, Power Pivot or Power BI for a task
  • Follow a clear order of work: clean first, model second, calculate third, show last

Topics covered

  • Getting data from common sources
  • Data cleaning and shaping in Power Query
  • Tables, keys and relationships in the data model
  • DAX measures and calculations
  • Charts, visuals and dashboard layout
  • How Power BI fits with Excel tools such as Power Pivot
  • Solving real workplace reporting problems, not just theory

Who this course is for

  • Business analysts who need to build dashboards
  • Finance and accounting staff who make the same reports every month
  • Operations and project staff who track KPIs
  • IT staff who get asked for reports
  • Excel users moving into business intelligence
  • People applying for entry-level analyst or BI roles

Before you start

You should be at ease with spreadsheets. That means you know what rows, columns, totals and filters are, and you can sort data and write a basic formula. You do not need any coding or programming skills. A copy of Power BI Desktop on your computer will let you follow the demos and try each step on your own data as you go.

Jobs this course supports

  • Business Analyst
  • Business Intelligence Analyst
  • Data Analyst

Skill level

Beginner
Duration

10 Hours 52 Minutes
Videos

65 Course Videos
Questions

75 Test Questions
Prerequisites

Comfort with spreadsheets, filters and simple formulas. No coding needed.
Best for

Business analysts, finance and accounting staff, operations staff, Excel users, IT staff who handle reports
Topics covered

Connecting to data, Power Query, data cleaning, data models and relationships, DAX measures, reports and dashboards
Format

Online video lessons, self-paced
Language

English
Closed captions

Yes
Certificate

StemBoss Certificate of Completion

What is inside this course

11 modules and 65 lessons. Here is the full outline.

Module 1 - Prepare Data5 lessons
  1. 1.1 Course Introduction
  2. 1.2 Module 1 Introduction
  3. 1.3 Introduction to Power BI
  4. 1.4 Get data from various data sources
  5. 1.5 Preview source data
Module 2 - Clean, Transform, and Load Data7 lessons
  1. 2.1 Module 2 Introduction
  2. 2.2 DimEmployee Example
  3. 2.3 DimEmployeeSalesTerritory Example
  4. 2.4 DimReseller Example
  5. 2.5 FactResellersSales Example
  6. 2.6 ResellerSalesTargets Example
  7. 2.7 Color Formats Example
Module 3 - Design a Data Model8 lessons
  1. 3.1 Module 3 Introduction
  2. 3.2 Introduction to Data Modeling
  3. 3.3 Model Relationships
  4. 3.4 Table Configuration
  5. 3.5 Model interface
  6. 3.6 Quick Measures
  7. 3.7 Many-to-many relationships
  8. 3.8 Row-level security
Module 4 - Create Model Calculations using DAX8 lessons
  1. 4.1 Module 4 Introduction
  2. 4.2 DAX context
  3. 4.3 Calculated Tables
  4. 4.4 Calculated Columns
  5. 4.5 Managing Date Tables
  6. 4.6 Measures
  7. 4.7 Filter Manipulation
  8. 4.8 Time Intelligence
Module 5 - Create Reports10 lessons
  1. 5.1 Module 5 Introduction
  2. 5.2 Basic Report Creation
  3. 5.3 Example Page 1
  4. 5.4 Example Page 2
  5. 5.5 Example Page 3
  6. 5.6 Report Publishing
  7. 5.7 Enhancing Reports
  8. 5.8 Drill-Through Pages
  9. 5.9 Conditional Formatting
  10. 5.10 Buttons and Bookmarks
Module 6 - Create Dashboards4 lessons
  1. 6.1 Module 6 Introduction
  2. 6.2 Dashboard Basics
  3. 6.3 Real Time Dashboards
  4. 6.4 Enhanced Dashboards
Module 7 - Create Paginated Reports5 lessons
  1. 7.1 Module 7 Introduction
  2. 7.2 Introduction to Power BI Report Builder
  3. 7.3 Report Layouts
  4. 7.4 Report Data
  5. 7.5 Report Tables
Module 8 - Perform Advanced Analytics6 lessons
  1. 8.1 Module 8 Introduction
  2. 8.2 Introduction to Advanced Analytics
  3. 8.3 Scatter Chart
  4. 8.4 Forecast
  5. 8.5 Decomposition Tree
  6. 8.6 Key Influencers
Module 9 - Create and Manage Workspaces2 lessons
  1. 9.1 Introduction to Workspaces
  2. 9.2 Working with Workspaces and the Portal
Module 10 - Create Power App Visuals5 lessons
  1. 10.1 Module 10 Introduction
  2. 10.2 Introduction to Power Apps Visual
  3. 10.3 Creating the App
  4. 10.4 Basic Power Apps Concepts
  5. 10.5 Refreshing the Report
Module 11 - Analysis Services and Power BI5 lessons
  1. 11.1 Module 11 Introduction
  2. 11.2 Introduction to Analysis Services
  3. 11.3 Connecting with Multidimensional Models
  4. 11.4 Premium Workspaces and Analysis Services
  5. 11.5 Course Wrap Up

Your learning path

Where Introduction to Microsoft Power BI fits. Build your skills one step at a time.

You are hereIntroduction to Microsoft Power BI
Next stepMicrosoft SQL Server Analysis Services (SSAS)Next stepCompTIA Data+ (DAO-001)

Frequently asked questions

Do I need coding skills to learn Power BI?

No. You need to be comfortable with spreadsheets and basic formulas. DAX measures are taught from the start.

Why does the course teach data cleaning before charts?

Reports are only as good as the data behind them. The course follows a set order: clean the data, build the model, write calculations, then design visuals.

What is the difference between Power Query, Power Pivot and Power BI?

Power Query cleans and shapes data, Power Pivot builds data models inside Excel, and Power BI brings these together with interactive reports and dashboards. The course explains when to use each.

What is DAX?

DAX (Data Analysis Expressions) is the formula language used in Power BI. You use it to create measures such as totals, averages and percentages.

I mainly use Excel. Is this course a good next step?

Yes. It is aimed at Excel users who want to automate recurring reports and share interactive dashboards instead of static files.

Do I get a certificate?

Yes. You get a StemBoss Certificate of Completion when you finish the course.

Can I get a refund?

Yes, within 14 days if you have completed less than 20% of the course. See our refund policy for details. Read the refund policy.

Related courses

$199.00
Buy course