Comprehensive Power BI:
From Basics to Advanced
This six-week course is aimed at beginners and intermediate users looking to learn end to end Power BI and best practices.
Rather than purely focusing on the product, it also teaches the underlying theoretical skills needed to excel in data analysis.
.Attendees can pick their desired track to learn how to analyse data relevant to their domain.
Course Duration
The class runs from 1st November, 2023
to 15th December, 2023
Expected Effort
Attendees are expected to spend 7-12 hours per week on class material.
Skills Learned
Users will learn a combination of theoretical, domain based, and technical skills including DAX, Power Query, Visualisation, and Data Modelling
Ther hands-on course balances technical skills, domain knowledge, and theoretical understanding to be effective in data management and analysis with Power BI. Throughout the course, students delve into diverse topics ranging from data extraction and transformation techniques to effective data modeling. Participants learn how to write Data Analysis Expressions (DAX), build data models, visualization techniques, and using advanced features like custom formatting and AI visuals to effectively communicate insights. The course also covers strategies for sharing and deploying Power BI content, dataset configuration, workspace management, deployment options, and introduces learners to version control and DevOps practices.
The course has a mixture of weekly, on demand content, live sessions with weekly QnA, weekly quizzes and homework, plus domain specific seminars. The course finished with a capstone project that users will be able to share as part of their data portfolio.
To complete the class and gain a certificate, attendees must complete all weekly homework and finish the capstone project. The live class runs from 1st November 2023 to 15th December 2023, with new content released each week. To pass, attendees will have until 31st January 2024 to complete all material.
Syllabus
Week 1 - Loading data
Prepare the data - Extract the Data
In this module, participants learn how to extract data from various sources and prepare it for analysis in Power BI. They will explore techniques for connecting to different data sources, transforming and cleaning data.
Prepare the data - Data Transforms
Building upon the earlier data module, this module delves deeper into data transformation techniques in Power BI. Participants will learn advanced data shaping techniques, merge and append queries.
The fundamental theory Data modelling
This module focuses on creating data models in Power BI. We’ll define what a star schema is and define dimensions, facts, keys, and relationships between tables.
Loading your data
Finance Track: Understand common data sources, how to combine multiple files, and different layouts for financial data.
Marketing Track: Connect to common CRM systems and pull in data.
General Track: Learn the most common connection types and how to import a variety of sources.
QnA & Homework
Week 2 -Model and DAX
Create a Data Model
This module focuses on creating data models in Power BI. They will how to create a STAR schema is and configure relationships between tables.
Writing DAX
This module introduces participants to Data Analysis Expressions (DAX), the formula language used in Power BI. Participants will learn how to write DAX formulas to perform calculations and business logic.
The fundamental theory of DAX
This module introduces key concepts of DAX. We look at how DAX runs under the covers, focusing on the concepts of evaluation contexts and iterators
DAX Seminar
Finance Track: Understand the unique complexities of financial data, how to handle header and details, and how to model and write DAX for financial reports.
Marketing Track: Learn how to tailor reports for marketing purposes and analyse marketing-related data in Power BI.
General Track: Learn how to best practices and data modelling for Power BI.
QnA & Homework
Week 3 -Visualise the Data
Storytelling with data
This module focuses on the art of storytelling with data using Power BI. Participants will learn how to effectively communicate insights and narratives by customizing experiences, using hierarchies, and using advanced features like custom formatting and AI visuals.
Advanced Power BI Desktop
This module dives into advanced visualization techniques in Power BI Desktop. Participants will learn how to utilize advanced features like custom visuals, bookmarks, tooltips, drill-through, and build interactive and dynamic reports.
Visualization tips and tricks
Learn different tips and tricks to create professional and polished looking reports.
Create Reports in Power BI Desktop
Tips and tricks on how to create well running, appealing financial reports in Power BI.
Finance Track: Tips and tricks on how to create well running, appealing financial reports in Power BI.
Marketing Track: Use statistics and analytics to visualise customer behaviour.
General Track: Learn how to create visually stunning reports quickly.
QnA & Homework
Week 4 -Deploy and Share
Deploying & Managing Model cycle
This module focuses on skills needed to efficiently maintain, update, and deploy Power BI models. It covers topics such as dataset configuration, workspace management, and deployment options. It also introduces learners to version control and DevOps practices.
Sharing Power BI Content
This module covers different sharing strategies for Power BI content. You will learn about sharing distributing content with Apps. You will also learn how to collaborate with workspaces and compare different sharing techniques.
Enforcing Permissions & Security
This module focuses on how to enforce permissions and security in your Power BI models. You will learn how to configure role-based access control (RBAC), implement RLS and OLS, and apply security labels. We’ll learn some common data leak pitfalls and how to avoid them.
On Demand Seminar
Understand how to deploy, manage, and share content with you teams
QnA & Homework
Weeks 5 & 6 -Capstone Project
Reporting Capstone
Take the skills you have learned over the previous week to put into action. You'll create and configure a report from scratch, being able to share it in your portfolio when complete. Available for the General, Finance, or Marketing tract.
Start learning today
$699
✔️ All on-demand, live, and QnA sessions
✔️Real-world projects from leading experts
✔️ Start a data portfolio for job applications
✔️ Hands-on learning through practical exercises, projects, and interactive sessions
About the Class
-
To optimize your chances of success, we recommend that you understand the basics of Power BI. If you have never used Power BI before, you will have access to the free on-demand course “Up and running with Power BI”
-
This is a hybrid course. You will have access to weekly live session with QnA office hours. You will also get access to the weekly on demand lectures, plus domain specific seminars.
-
In Power BI, the need for skilled professionals is growing across industries. Our classes emphasize hands-on learning through practical exercises, projects, and interactive sessions. This approach ensures that you not only grasp the theoretical concepts but also gain confidence in applying them to real-world scenarios.
-
This course has been designed by Steve Campbell. Steve has trained around the world as well as led global teams in Data Analytics. Understanding how Power BI applies to your specific domain is crucial. This class goes beyond the technical aspects, delving into real-world scenarios and case studies that are relevant to your industry. This domain-specific knowledge will help you create insightful reports tailored to your business needs.
While practical skills are essential, understanding the theoretical underpinnings is equally important. The course will provide you with a solid grounding in data visualization principles, data modeling concepts, and best practices. After the class, the projects you create will be available in a personal portfolio to demonstrate your new Power BI proficiency.