Power BI Intermediate Course

Pre-requisites

Attending the Power BI beginner is a pre-requisite for the intermediate course

About This Course

The Power BI Advanced is an instructor-led, hands-on training course. This course helps business users solve work challenges by introducing them to the latest features such as fuzzy matching, AI visualisation and queue level security.

This course is a complete overview of the BI process, from data modelling, data cleansing, data manipulation, data aggregation to data visualisation using AI-enhanced visuals and infographics. This course also introduces candidates to DAX and helps candidates build a solid foundation in DAX Power BI based on their Excel/SQL knowledge.

This training course is available in Melbourne, Sydney, Brisbane, Australia and Live Virtually

Total course bookings

Number of teachers

0 +

Classes finished

0 +

Students learning

0 +

Books

Course material for Power BI Intermediate provided

Delivery Method

Instructor-led Classroom Training at our premises
Live Virtual Online Training attend in real-time from anywhere
In-House Training at your premises (4+ participants)

Skills Gained

Introduction to the basic concepts involved in building an envelope.
Preparing data for analysis
Learning to build relationships between multiple databases using Power Pivot
Learning useful functions to help take data to the next level
Learn how to create and navigate live dashboards and interactive reports

Audience

Business analysts
Data analysts
Anyone who wants to take the next step in data processing and visualisation.

Course Outline

Introduction
Opening Power Pivot
Importing from Access
Save and Save Often
Importing from Excel
Creating Power Pivot Tables
Creating Relationships
Calculated Columns
Basic Measures
DAX & Derived Measures
CALCULATE
Lab – Creating Measures
Importing Excel Data Model into Power BI
Measures in Power BI
Visualizing Measures
Creating Calendar Tables
Save and Save Often
Sorting by Column
Drilling Down
Lab – Creating Analysis Reports
Publishing to Power BI Online
Creating Dashboards
Sharing Dashboards
Q&A
Conclusion

Register for the Course

Take the next step in your learning journey by enrolling today. Secure your spot in this course and gain access to expert-led training, hands-on practice, and resources designed to help you succeed.