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
Total course bookings
Number of teachers
Classes finished
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
The training courses are designed for participants who need to create compelling visual reports, who want to update their basic knowledge and learn the DAX language to create more complex measures, columns, and tables.
- Suite 2, 53 Dryburgh Street, West Melbourne VIC 3003
- 1300 649 299
- [email protected]