• No products in the basket.

Get Lifetime Access to This Course & 1900+ Others for Only £149. Subscribe Now

Course Overview

Learn how to make a genuine difference in your life by taking our popular Microsoft Power BI. Our commitment to online learning and our technical experience has been put to excellent use within the content of these educational modules. By enrolling today, you can take your knowledge of Microsoft Power BI to a whole new level and quickly reap the rewards of your study in the field you have chosen.

We are confident that you will find the skills and information that you will need to succeed in this area and excel in the eyes of others. Do not rely on substandard training or half-hearted education. Commit to the best, and we will help you reach your full potential whenever and wherever you need us.

Please note that Microsoft Power BI provides valuable and significant theoretical training for all. However, it does not offer official qualifications for professional practice. Always check details with the appropriate authorities or management.

Learning Outcomes

  • Instant access to verified and reliable information
  • Participation in inventive and interactive training exercises
  • Quick assessment and guidance for all subjects
  • CPD accreditation for proof of acquired skills and knowledge
  • Freedom to study in any location and at a pace that suits you
  • Expert support from dedicated tutors committed to online learning

Your Path to Success

By completing the training in Microsoft Power BI, you will be able to significantly demonstrate your acquired abilities and knowledge of Microsoft Power BI. This can give you an advantage in career progression, job applications, and personal mastery in this area.

Is This Course Right for You?

This course is designed to provide an introduction to Microsoft Power BI and offers an excellent way to gain the vital skills and confidence to start a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Full-time and part-time learners are equally supported, and the study periods are entirely customisable to your needs.

Assessment Process

Once you have completed all the modules in the Microsoft Power BI course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards.

Show off Your New Skills with a Certification of Completion

The learners have to successfully complete the assessment of this Microsoft Power BI course to achieve the CPD & IAO accredited certificate. Digital certificates can be ordered for only £10. Learners can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39.

Course Curriculum

Section 01: Introduction
Welcome! 00:01:00
What is Power BI? 00:03:00
Download & Installing Power BI Desktop 00:04:00
Getting to know the interface 00:03:00
Mini Project: Transform Data 00:06:00
Mini Project: Visualize Data 00:05:00
Mini Project: Creating a Data Model 00:07:00
Course Outline: What will you learn in this course? 00:05:00
How to learn best with this course? 00:03:00
Section 02: Preparing our Project
Creating our initial project file 00:04:00
Working with the attached project files 00:04:00
Section 03: Data Transformation - The Query Editor
Exploring the Query Editor 00:06:00
Connecting to our data source 00:07:00
Editing rows 00:08:00
Changing data types 00:08:00
Replacing values 00:03:00
Close & Apply 00:03:00
Connecting to a csv file 00:03:00
Connecting to a web page 00:05:00
Extracting characters 00:06:00
Splitting & merging columns 00:09:00
Creating conditional columns 00:06:00
Creating columns from examples 00:09:00
Merging Queries 00:17:00
Pivoting & Unpivoting 00:06:00
Appending Queries 00:08:00
Practice & Solution: Population table 00:15:00
The Fact-Dimension-Model 00:09:00
Practice: Load the dimension table 00:04:00
Organizing our queries in groups 00:03:00
Entering data manually 00:05:00
Creating an index column 00:03:00
Workflow & more transformations 00:05:00
Module summary 00:05:00
Exercise 1 – Instruction 00:02:00
Exercise Solution 00:11:00
Section 04: Data Transformation - Advanced
Advanced Editor – Best practices 00:05:00
Performance: References vs. Duplicating 00:10:00
Performance: Enable / Disable Load & Report Refresh 00:05:00
Group by 00:05:00
Mathematical Operations 00:05:00
Run R Script 00:15:00
Using Parameters to Dynamically Transform Data 00:07:00
M formula language: Basics 00:07:00
M formula language: Values, Lists & Tables 00:14:00
M formula language: Functions 00:13:00
M formula language: More functions & Steps 00:05:00
Exercise 2 – Instructions 00:01:00
Exercise 2 – solution 00:05:00
Section 05: Creating a Data Model
Understanding the relationship 00:05:00
Create & Edit Relationships 00:06:00
One-to-Many & One-to-One Relationship 00:06:00
Many-to-Many (m:n) Relationship 00:06:00
Cross Filter Direction 00:06:00
Activate & Deactivate Relationships 00:06:00
Model Summary 00:03:00
Exercise 3 Create Model 00:02:00
Exercise 3 Solution 00:02:00
Section 06: Data Visualization
Our first visual 00:08:00
The format tab 00:12:00
Understanding tables 00:10:00
Conditional formatting 00:09:00
The Pie Chart 00:06:00
All about the filter visual 00:13:00
The filter pane for developers 00:11:00
Cross filtering & edit interactions 00:04:00
Syncing Slicers Across Pages 00:07:00
Creating drill downs 00:08:00
Creating Drill Throughs 00:07:00
The Tree Map Visual 00:07:00
The Decomposition Tree 00:05:00
Understanding The Matrix Visual 00:05:00
Editing pages 00:07:00
Buttons & Actions 00:09:00
Bookmarks to Customize Your Report 00:10:00
Analytics and Forecasts with line charts 00:10:00
Working with custom visuals 00:07:00
Get data using R Script & R Script visual 00:08:00
Asking Questions – Q&A visual 00:04:00
Wrap up – Data Visualization 00:08:00
Section 07: Power BI & Python
Python in Power BI – Plan of attack 00:03:00
Setting up Python for Power BI 00:03:00
Transforming data using Python 00:11:00
Creating visualizations using Python 00:08:00
Violin Plots, Pair Plots & Ridge Plots Using Python 00:15:00
Machine learning (Bayes Text Analyzer) using Python 00:00:00
Performance & Troubleshooting 00:03:00
Section 08: Storytelling with Data
Introduction 00:01:00
Show Empathy & Identify the Requirement 00:03:00
Finding the Most Suitable KPI’s 00:02:00
Choose an Effective Visualization 00:04:00
Make Use of Natural Reading Pattern 00:03:00
Tell a Story Using Visual Cues 00:05:00
Avoid Chaos & Group Information 00:02:00
Warp Up – Storytelling with Data 00:02:00
Section 09: DAX - The Essentials
Introduction 00:03:00
The Project Data 00:04:00
Measures vs. Calculated Columns 00:15:00
Automatically creating a date table in DAX 00:08:00
CALENDAR 00:05:00
Creating a Complete Date Table with Features 00:04:00
Creating Key Measure Table 00:03:00
Aggregation functions 00:06:00
The different versions of COUNT 00:14:00
SUMX – Row based calculations 00:09:00
Section 10: DAX - The CALCULATE function
CALCULATE – The basics 00:11:00
ALL 00:08:00
ALL EXCEPT 00:07:00
Section 11: Power BI Service - Power BI Cloud
How to go on now? 00:03:00
Power BI Pro vs Premium & Signing up 00:04:00
Exploring the interface 00:04:00
Discovering your workspace 00:03:00
Connecting Power BI Desktop & Cloud 00:04:00
Understanding Datasets & Reports 00:03:00
Working on Reports 00:04:00
Updating reports from Power BI Desktop 00:04:00
Creating and Working with Workspaces 00:07:00
Installing & Using a Data Gateway 00:13:00
Get Quick Insights 00:03:00
Creating Dashboards 00:04:00
Sharing our results through Apps 00:10:00
Power BI Mobile App 00:05:00
Power BI Mobile App 00:05:00
Creating the layout for the Mobile App 00:04:00
Wrap up – Power BI Cloud 00:07:00
Section 12: Row-Level Security
Introduction 00:03:00
Creating a Row-Level Security 00:05:00
Row-Level Security in the Cloud 00:04:00
Row-Level Security & Data Model 00:05:00
Dynamic Row-Level Security 00:07:00
Dynamic Many-to-Many RLS 00:04:00
Hierarchical Row-Level Security 00:13:00
Section 13: More data sources
JSON & REST API 00:10:00
Setting up a local MySQL Database 00:14:00
Connecting to a MySQL database in Power BI 00:05:00
Connecting to a SQL database (PostgreSQL) 00:05:00
Section 14: Next steps to improve & stay up to date
Congratulations & Next Steps 00:06:00
The End 00:01:00
Resources – Microsoft Power BI Masterclass 2021 00:00:00
Assignment – Microsoft Power BI 00:00:00