Power BI Intermediate Course
Lenght
1
Price
$123
Version
22
Course Detail:
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
Register Now
0
Total course bookings
0
+
Number of teachers
0
+
Classes finished
0
+
Total students learning
Pre-requisites
- Attending the Power BI beginner is a pre-requisite for the intermediate course
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
Course Outline
- 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