a computer screen with a bunch of data on it

Microsoft & Data

Introduction to Microsoft Power BI Training Course

This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI.

Duration10 Hours

LevelBeginner

Access12 months online access

Course content11 modules

One-time payment Get complete course access

Original price was: £119.00.Current price is: £71.00. inc VAT

Save£48.00

Instant online access
Study at your own pace
Secure checkout

Course information

About this course

What the Introduction to Microsoft Power BI course covers

Introduction to Microsoft Power BI is taught entirely online, so there is nothing to attend and no start date to wait for. 11 modules, 10 hours of study, and no deadline on either. You keep access for 12 months rather than losing it the moment you finish.

The material takes in Prepare Data, Clean, Transform, and Load Data, Design a Data Model and Create Model Calculations using DAX. 7 more modules follow those, all named on the Modules tab.

This is a first course in microsoft & data rather than a refresher for people already trained. We list 18 Microsoft & Data courses, of which 4 sit at Beginner. Its study time is about mid-range for the subject. There is a certificate of completion at the end, available from your account. It is proof you covered the material, not a regulated qualification.

The honest caveats: It is an introduction, so it is the wrong buy if you want depth on one narrow part of the subject. And to be plain about it: there is no CPD accreditation on this course, so buy something accredited if that is what has been asked of you.

Buyer guide

Is this the right course for you?

Best fit

Introduction to Microsoft Power BI is a sensible shortlist choice when you want a structured route through the published syllabus rather than a general overview of the whole subject. Its 11-module plan starts with Prepare Data and Clean, Transform, and Load Data, which gives you a clear indication of the assumed starting point. That shape is likely to be most useful for analysts, administrators and office staff who live in spreadsheets whose training need matches those topics. It is a weaker fit if you only need one isolated skill, or if an employer has specified a different standard, awarding body or practical assessment. Before buying, compare that requirement with the final modules on Create Power App Visuals and Analysis Services and Power BI as well as the course title.

How to use the syllabus

Treat the module list as a study plan, not just a contents page. Begin with Prepare Data and Clean, Transform, and Load Data and note any terms or processes you need to revisit. Around the middle, Create Dashboards acts as a useful checkpoint: if you can explain that material without looking back, move on; if not, repeat the preceding section before adding more. The later work on Create Power App Visuals and Analysis Services and Power BI is where you can test whether the earlier ideas connect. After each block, write a short example from your own work or a realistic scenario. That simple retrieval step makes self-paced learning more useful than clicking straight through to completion.

Check before enrolling

The listed study time is 10 hours; reserve more time if the subject is new to you or you plan to make detailed notes. Access is listed for 12 months, so set a completion date comfortably before the login ends. A downloadable or printable completion certificate is described, but it records course completion rather than replacing a regulated qualification. No CPD accreditation is stated. That is fine for skills development, but not when a workplace policy specifically requires accredited training.

Full course details from the training provider

The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. This course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI. Power BI is a member of the Power Platform.

Power Apps is another component that enables everyone to build and use apps that connect to business data. This course will show you how to use the Power Apps visual to pass context-aware data to a canvas app, which updates in real-time as you make changes to your report. This will allow your app users to derive business insights and take actions from right within their Power BI reports and dashboards. Finally, this course will explore the intersections between Power BI and Microsoft’s enterprise-level data modeling and analysis platform, SQL Server Analysis Services.

Key Learning Topics In This Course

The various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI.
How to access and process data from a range of data sources including both relational and non-relational data.
How to implement proper security standards and policies across the Power BI spectrum including datasets and groups.
How to manage and deploy reports and dashboards for sharing and content distribution.
How to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.

Video Content: 10 Hours 52 Minutes
Test Questions: 75

What you will learn

Learning outcomes

Module 1 - Prepare Data
Module 2 - Clean, Transform, and Load Data
Module 3 - Design a Data Model
Module 4 - Create Model Calculations using DAX
Module 5 - Create Reports
Module 6 - Create Dashboards
Module 7 - Create Paginated Reports
Module 8 - Perform Advanced Analytics
Module 9 - Create and Manage Workspaces
Module 10 - Create Power App Visuals
Module 11 - Analysis Services and Power BI

Ready when you are

Get instant access and start learning today.

Enrol now

Course content

Modules

11 modules

01Module 1 - Prepare Data

1.1 Course Introduction
1.2 Module 1 Introduction
1.3 Introduction to Power BI
1.4 Get data from various data sources
1.5 Preview source data

02Module 2 - Clean, Transform, and Load Data

2.1 Module 2 Introduction
2.2 DimEmployee Example
2.3 DimEmployeeSalesTerritory Example
2.4 DimReseller Example
2.5 FactResellersSales Example
2.6 ResellerSalesTargets Example
2.7 Color Formats Example

03Module 3 - Design a Data Model

3.1 Module 3 Introduction
3.2 Introduction to Data Modeling
3.3 Model Relationships
3.4 Table Configuration
3.5 Model interface
3.6 Quick Measures
3.7 Many-to-many relationships
3.8 Row-level security

04Module 4 - Create Model Calculations using DAX

4.1 Module 4 Introduction
4.2 DAX context
4.3 Calculated Tables
4.4 Calculated Columns
4.5 Managing Date Tables
4.6 Measures
4.7 Filter Manipulation
4.8 Time Intelligence

05Module 5 - Create Reports

5.1 Module 5 Introduction
5.2 Basic Report Creation
5.3 Example Page 1
5.4 Example Page 2
5.5 Example Page 3
5.6 Report Publishing
5.7 Enhancing Reports
5.8 Drill-Through Pages
5.9 Conditional Formatting
5.10 Buttons and Bookmarks

06Module 6 - Create Dashboards

6.1 Module 6 Introduction
6.2 Dashboard Basics
6.3 Real Time Dashboards
6.4 Enhanced Dashboards

07Module 7 - Create Paginated Reports

7.1 Module 7 Introduction
7.2 Introduction to Power BI Report Builder
7.3 Report Layouts
7.4 Report Data
7.5 Report Tables

08Module 8 - Perform Advanced Analytics

8.1 Module 8 Introduction
8.2 Introduction to Advanced Analytics
8.3 Scatter Chart
8.4 Forecast
8.5 Decomposition Tree
8.6 Key Influencers

09Module 9 - Create and Manage Workspaces

9.1 Introduction to Workspaces
9.2 Working with Workspaces and the Portal

10Module 10 - Create Power App Visuals

10.1 Module 10 Introduction
10.2 Introduction to Power Apps Visual
10.3 Creating the App
10.4 Basic Power Apps Concepts
10.5 Refreshing the Report

11Module 11 - Analysis Services and Power BI

11.1 Module 11 Introduction
11.2 Introduction to Analysis Services
11.3 Connecting with Multidimensional Models
11.4 Premium Workspaces and Analysis Services
11.5 Course Wrap Up