Course Overview
The Complete Microsoft Power BI 2021 course covers the essential features of Power BI, including data transformation, data visualisation, and data modelling. It delves into advanced functions such as DAX (Data Analysis Expressions), the CALCULATE function, and using Python for enhanced analytics. You’ll learn how to prepare data using the Query Editor, create interactive reports, apply row-level security, and integrate with Power BI Service for cloud-based analytics. By the end of this course, you will have the skills to create effective data visualisations, perform in-depth analysis, and make data-driven decisions with Power BI.
Key topics covered include:
- Introduction to Power BI and its interface
- Preparing data and transforming it using the Query Editor
- Creating a data model and building interactive reports
- Using DAX functions to manipulate data and calculations
- Integrating Python for advanced data analytics
- Understanding data visualisation principles and applying them in Power BI
- Implementing row-level security for controlling data access
- Connecting to various data sources and managing Power BI cloud services
Learning Outcomes
By the end of this course, learners will be able to:
- Navigate the Power BI interface and install Power BI Desktop
- Transform and clean data using the Power BI Query Editor
- Build a robust data model and create interactive visualisations
- Apply DAX functions, including the CALCULATE function, for data manipulation
- Use Power BI in combination with Python for advanced analytics
- Tell compelling stories with data using Power BI visualisation tools
- Manage data security through row-level security
- Connect to a range of data sources and manage cloud-based Power BI services
Why Enrol in This Course?
Power BI is a must-have skill for any data professional or business analyst. It enables users to make sense of vast amounts of data, turning it into actionable insights. This course is perfect for anyone looking to break into business intelligence or enhance their current skills.
What you gain:
- A CPD-accredited certificate recognised by employers in the UK
- A strong understanding of Power BI’s capabilities and best practices
- The flexibility to learn at your own pace with lifetime access to materials
- Expertise in DAX, Python integration, data modelling, and cloud-based analytics
Who is This Course for?
This course is ideal for:
- Aspiring data analysts or business intelligence professionals
- Business managers looking to make data-driven decisions
- Analysts seeking to improve their reporting and data visualisation skills
- Professionals wanting to learn how to use Power BI for analytics
- Anyone interested in gaining hands-on experience with Power BI tools
Prerequisites for This Course
There are no formal prerequisites for the Complete Microsoft Power BI 2021 course. It is designed for beginners and intermediate learners who are keen to develop their skills in data analysis and visualisation using Power BI.
Certification
Upon completing the course and passing the final exam, you will receive a CPD QS Accredited Certificate from Apex Learning. This certification demonstrates your qualifications and skills. The Digital version of the certificate is available for a discounted price of £9.99 only, and you can order a hard copy of the certificate for a discounted price of £14.99 only.
📍Note: Discounted certificate pricing is available for a limited time only. Secure yours before the offer ends!
Career Path
Upon completing this course, you will be prepared for a variety of roles, including:
- Data Analyst – £30,000 to £50,000 annually
Analyse and visualise data to support business decision-making. - Business Intelligence Analyst – £40,000 to £60,000 annually
Use tools like Power BI to turn data into actionable insights for organisational growth. - Data Scientist – £50,000 to £70,000 annually
Work with large datasets and advanced analytics tools, including Power BI, to drive business strategy. - Business Intelligence Consultant – £45,000 to £75,000 annually
Help organisations implement business intelligence solutions, including Power BI, to improve data processes.
Complete Microsoft Power BI 2021 | CPD Accredited Course Online – UK
Microsoft Power BI is one of the most powerful tools for data analysis and business intelligence, enabling professionals to transform raw data into insightful visualisations. The Complete Microsoft Power BI 2021 course is CPD-accredited and provides a comprehensive understanding of Power BI tools and techniques. Whether you’re looking to master data analytics, improve your reporting skills, or pursue a career in business intelligence, this course will equip you with the essential knowledge required to succeed.
Course Overview
The Complete Microsoft Power BI 2021 course covers the essential features of Power BI, including data transformation, data visualisation, and data modelling. It delves into advanced functions such as DAX (Data Analysis Expressions), the CALCULATE function, and using Python for enhanced analytics. You’ll learn how to prepare data using the Query Editor, create interactive reports, apply row-level security, and integrate with Power BI Service for cloud-based analytics. By the end of this course, you will have the skills to create effective data visualisations, perform in-depth analysis, and make data-driven decisions with Power BI.
Key topics covered include:
- Introduction to Power BI and its interface
- Preparing data and transforming it using the Query Editor
- Creating a data model and building interactive reports
- Using DAX functions to manipulate data and calculations
- Integrating Python for advanced data analytics
- Understanding data visualisation principles and applying them in Power BI
- Implementing row-level security for controlling data access
- Connecting to various data sources and managing Power BI cloud services
Learning Outcomes
By the end of this course, learners will be able to:
- Navigate the Power BI interface and install Power BI Desktop
- Transform and clean data using the Power BI Query Editor
- Build a robust data model and create interactive visualisations
- Apply DAX functions, including the CALCULATE function, for data manipulation
- Use Power BI in combination with Python for advanced analytics
- Tell compelling stories with data using Power BI visualisation tools
- Manage data security through row-level security
- Connect to a range of data sources and manage cloud-based Power BI services
Why Enrol in This Course?
Power BI is a must-have skill for any data professional or business analyst. It enables users to make sense of vast amounts of data, turning it into actionable insights. This course is perfect for anyone looking to break into business intelligence or enhance their current skills.
What you gain:
- A CPD-accredited certificate recognised by employers in the UK
- A strong understanding of Power BI’s capabilities and best practices
- The flexibility to learn at your own pace with lifetime access to materials
- Expertise in DAX, Python integration, data modelling, and cloud-based analytics
Who is This Course for?
This course is ideal for:
- Aspiring data analysts or business intelligence professionals
- Business managers looking to make data-driven decisions
- Analysts seeking to improve their reporting and data visualisation skills
- Professionals wanting to learn how to use Power BI for analytics
- Anyone interested in gaining hands-on experience with Power BI tools
Prerequisites
There are no formal prerequisites for the Complete Microsoft Power BI 2021 course. It is designed for beginners and intermediate learners who are keen to develop their skills in data analysis and visualisation using Power BI.
Assessment Method
Assessment for the course is conducted through an automated multiple-choice exam. A score of 60% is required to pass and earn the CPD Accredited Certificate. Reflective assignments are provided to enhance your learning, with expert tutor feedback available.
Certification
Upon completing the course and passing the final exam, you will receive a CPD QS Accredited Certificate from Apex Learning. This certification demonstrates your qualifications and skills. The Digital version of the certificate is available for a discounted price of £9.99 only, and you can order a hard copy of the certificate for a discounted price of £14.99 only.
📍Note: Discounted certificate pricing is available for a limited time only. Secure yours before the offer ends!
Career Path
Upon completing this course, you will be prepared for a variety of roles, including:
- Data Analyst – £30,000 to £50,000 annually
Analyse and visualise data to support business decision-making. - Business Intelligence Analyst – £40,000 to £60,000 annually
Use tools like Power BI to turn data into actionable insights for organisational growth. - Data Scientist – £50,000 to £70,000 annually
Work with large datasets and advanced analytics tools, including Power BI, to drive business strategy. - Business Intelligence Consultant – £45,000 to £75,000 annually
Help organisations implement business intelligence solutions, including Power BI, to improve data processes.
Frequestly Asked Questions
Is the Power BI course fully online?
Yes, the course is entirely online and can be completed at your own pace.
Do I need prior experience in data analysis to take this course?
No, this course is suitable for beginners and those with some experience in data analytics.
Will I receive a certificate upon completion?
Yes, you will receive a CPD-accredited certificate upon successful completion of the course.
How long will I have access to the course materials?
You will have lifetime access to the course materials.
How long does it take to complete the course?
The course is self-paced, and most learners complete it in 6-8 weeks, depending on their schedule.
Course Curriculum
- 16 sections
- 32 lectures
- 00:00:00 total length
-
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:07: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
-
Creating our initial project file 00:04:00
-
Working with the attached project files 00:04:00
-
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 1 – Exercise Solution 00:11:00
-
Advanced Editor – Best practices 00:09: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:06: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
-
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:08: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
-
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:09: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
-
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 (BayesTextAnalyzer) using Python 00:00:00
-
Performance & Troubleshooting 00:03:00
-
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
-
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
-
CALCULATE – The basics 00:11:00
-
Changing the context with FILTER 00:07:00
-
ALL 00:08:00
-
ALL SELECTED 00:03:00
-
ALL EXCEPT 00:07:00
-
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
-
Creating the layout for the Mobile App 00:04:00
-
Wrap up – Power BI Cloud 00:07:00
-
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
-
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
-
Congratulations & next steps 00:06:00
-
The End 00:01:00
-
Resources – Complete Microsoft Power BI 2021 00:00:00
-
Claim Your Certificate 00:00:00
Complete Microsoft Power BI 2021
Save 95% - Sale Ends in
Frequently Bought Together
Data Scientist Job Ready Program with Career Support & Money Back Guarantee
4.8
(7 students)
4.8 Star course rating
£21.99
£419
Save 95% - Sale Ends in
ALL COURSES FOR - £99 This course includes:
-
Duration:14 hours, 25 minutes
-
Access:1 year access
-
Level:
-
CPD Points:10
