Power BI | Online Training Course
Power BI
Power BI online training for beginners
Make your data work for you with Power BI. This Power BI online training will teach you how to create stunning, interactive reports and dashboards that bring your data to life. No matter your experience level, this course provides a step-by-step approach to analyzing and visualizing data effectively.
What this course covers
Designed for beginners, this Power BI course requires no prior experience. We'll start with the basics and progress to building dynamic reports in Power BI Desktop. Then, learn how to publish reports to the Power BI cloud service, where you can create and share personalized dashboards with ease. By the end of the course, you'll have the business intelligence skills needed to extract meaningful insights and make informed decisions.
These new skills are highly valuable across industries, including:
- Marketing: Track and analyze campaign effectiveness.
- Finance: Monitor and manage financial performance.
- Sales: Compare quotas against forecasts and optimize strategy.
Course highlights
- Master the difference between dashboards and reports for smarter decision-making
- Import and transform data from Excel, text files, or CSV to build insightful reports
- Publish, refresh, and manage your data effortlessly in the Power BI cloud service
- Share reports securely and collaborate seamlessly with your team
- Build relationships between datasets to unlock deeper analysis
- Automate time-based insights with a dynamic, self-updating calendar table
- Use Data Analysis Expressions (DAX) to create powerful custom calculations
- Design engaging, interactive visuals — charts, maps, tree views, and more
If you're looking for a Power BI course that helps you transform raw numbers into compelling insights, this is the perfect place to start.
Syllabus
Download syllabus-
1
Collecting More Data Working with Excel data in Power BI 8m
-
2
Key Concepts for Relating Data Key concepts you should know before relating data 7m
-
3
Solving m2m Joins via Bridge tables Creating Bridge Tables in order to link tables via one to many relationships 9m
-
4
Solving m2m Joins via Composite keys Creating composite keys in order to link tables via one to many relationships 10m
-
5
Solving m2m Joins via De-Aggregation Creating new tables in order to link tables via one to many relationships 4m
-
6
Table De-Aggregation - Application Creating new dimensional tables for our sample model 9m
-
7
Dynamic Calendars - Theory How to create a dynamic self-updating calendar for your model 3m
-
8
Dynamic Calendars - Application Building a dynamic calendar for our sample model 10m
-
1
Basic Measures - Theory How and why you should create explicit measures in Power BI 5m
-
2
Basic Measures - Application Creating measures for our sample model 8m
-
3
Understanding Measure Calculation Understanding how the DAX engine calculates measure results 5m
-
4
Performing Math with Compound Measures How to perform math against pre-defined measures 7m
-
5
The CALCULATE() function - Theory Understanding CALCULATE(), the most powerful function in DAX 5m
-
6
The CALCULATE() function - Application Creating measures for our sample model using CALCULATE() 6m
-
7
The ALL() function - Theory Removing Filters with the ALL() function 3m
-
8
The ALL() function - Application Creating measures for our sample model using ALL() 6m
-
9
Quick Measures Using quick measures for time intelligence 6m
-
1
Global Visual Concepts Concepts applicable to all visuals 9m
-
2
Bar & Column Charts Working with Bar and Column charts in Power BI 6m
-
3
Line & Area Charts Working with Line charts in Power BI 6m
-
4
Combination Charts Building Combination charts in Power BI 5m
-
5
Maps Working with Maps, Azure Maps and Filled Maps in Power BI 9m
-
6
Pie Charts Working with Pie and Donut charts in Power BI 5m
-
7
Treeview Working with Treeview visuals in Power BI 7m
-
8
Cards Working with Cards and Multi-row Cards in Power BI 7m
-
9
Matrix Working with Matrix visuals in Power BI 7m
-
10
Tables Working with Table visuals in Power BI 7m
-
11
KPIs Working with KPIs in Power BI 6m
-
12
Custom Visuals - Chiclet Slicer Working with custom visuals in Power BI 9m
-
1
Overview of Power BI Components An overview of the components that make up Power BI, and their costs. 8m
-
2
Power BI Workflow A review of the Power BI workflow 5m
-
3
Introduction to Power BI An introduction to Power BI and the problems it solves for us. 5m
Certificate
Certificate of Completion
Awarded upon successful completion of the course.
Instructor
Ken Puls
Ken is a Certified Management Accountant (CMA) in Canada, who never remembers life without spreadsheets and computers! Since the late 1990s, he has spent his career in the hospitality and tourism industry, in the finance and IT fields. Ken is currently the Director of IT at a resort on Vancouver Island.
To this day, he dedicates a significant portion of his time to developing automated solutions and internal controls, as well as focusing time and energy on improving Business Intelligence systems. Through his work, he designs and develops new systems, using such technology as Excel spreadsheets and VBA (Excel's programming language), automating as many tasks as possible, and thereby saving significant costs and maximizing efficiencies. Ken says, “I love the power that Excel puts at my finger tips and I’m still amazed by the things it can do.”
Ken Puls
Excel MVP
Accreditations
Link to awards
How GoSkills helped Chris
I got the promotion largely because of the skills I could develop, thanks to the GoSkills courses I took. I set aside at least 30 minutes daily to invest in myself and my professional growth. Seeing how much this has helped me become a more efficient employee is a big motivation.
