- Advanced data transformation
- Cleaning irregularly formatted data
- Adding Columns
- Merge and Append Queries
- Query from a Folder
- View and Edit M Code
Overview
Build on your Power BI expertise with our Intermediate Power BI training course! This session focuses on mastering Data Analysis Expressions (DAX), the powerful formula language that enables advanced calculations and data manipulation in Power BI.
You’ll also dive into creating and optimizing date tables, a cornerstone of effective time-based analysis. By the end of this course, you’ll be equipped to perform complex data modeling, uncover deeper insights, and create more dynamic, interactive reports. Perfect for users ready to take their data skills to the next level!
What you’ll learn:
- Gain insight into business intelligence and how to use DAX in Power BI.
- Learn about Data Modelling and connect multiple data tables.
- Create a Date Table for better date related insights.
- Create a range of interactive visualisations including a range of charts, tables, matrixes and maps.
- How to publish and share your data.
Microsoft Power BI training course in Melbourne and across Australia. We can come to you for Face-to-face Power BI training or you can join us online for Live online Power BI training courses.
Course Materials
Detailed Course Outline
- Text and dates Date functions
- Column from Examples
- Custom Column Functions
- Blank queries
- Create Date tables
- CALENDERAUTO function
- Working with time-based data
- Date based data comparisons with DAX
- SAMEPERIODLASTYEAR function
- TOTALYTD and TOTALMTD functions
- Columns and Measures
- CALCULATE
- SUMX, AVERAGEX etc.
- FILTER
- ALL, ALLEXCEPT, ALLSELECTED
- IF, SWITCH, FIND
- RELATED
- Manage Measures
- DAX Structure
- Use Measures to populate Fields in
- Visualisations
- Conditional Formatting
- Tooltip Page
- Applying Tooltips
- Creating a Workspace
- Managing Workspace Access
- Publish to a Workspace
- Create and Publish an App
Course prerequisites
Due to some similarities between Excel and Power BI, participants will need to be familiar with Excel to an Advanced level, including a good understanding of Charts, Tables and PivotTables.
No previous experience with Power BI is required.
Inclusions

Instructor - led Training

Menual & Files

Unlimited Free Support
Related Courses
-
$385
Course Details
Private Sessions
Book a private session for 1 to 12 of your employees. Courses can be customised to suit your learning needs.
Public Sessions
Join a public course session conducted LIVE ONLINE via Microsoft Teams.
$395
Detailed Course Outline
- Advanced data transformation
- Cleaning irregularly formatted data
- Adding Columns
- Merge and Append Queries
- Query from a Folder
- View and Edit M Code
- Text and dates Date functions
- Column from Examples
- Custom Column Functions
- Blank queries
- Create Date tables
- CALENDERAUTO function
- Working with time-based data
- Date based data comparisons with DAX
- SAMEPERIODLASTYEAR function
- TOTALYTD and TOTALMTD functions
- Columns and Measures
- CALCULATE
- SUMX, AVERAGEX etc.
- FILTER
- ALL, ALLEXCEPT, ALLSELECTED
- IF, SWITCH, FIND
- RELATED
- Manage Measures
- DAX Structure
- Use Measures to populate Fields in
- Visualisations
- Conditional Formatting
- Tooltip Page
- Applying Tooltips
- Creating a Workspace
- Managing Workspace Access
- Publish to a Workspace
- Create and Publish an App
Course prerequisites
Due to some similarities between Excel and Power BI, participants will need to be familiar with Excel to an Advanced level, including a good understanding of Charts, Tables and PivotTables.
No previous experience with Power BI is required.
Inclusions

Instructor - led Training

Menual & Files

Unlimited Free Support
Related Courses
-
$385
I had the pleasure of being trained by Anton twice now for work. Always very informative and an enjoyable learning experience. His knowledge and training style definitely works for both individual and group sessions. Highly recommended!
Anton took our business through staff training with a lot of back end knowledge, patience and great communication.
We felt well supported and enjoyed our experience with Blank Page. We would highly recommend Anton for further training. Regards MA.
I had the pleasure of being trained by Anton twice now for work. Always very informative and an enjoyable learning experience. His knowledge and training style definitely works for both individual and group sessions. Highly recommended!
Anton is absolutely delightful; a great teacher and a wonderful tutor. I am a professional educator with well over 30 years experience and I can unconditionally recommend Anton and Blank Page in terms of professional instruction based on an in-depth understanding of the subject matter and great sensitivity to learner needs; personal engagement and great ability in teaching this ‘old dog’ plenty of new tricks! And I consider myself to be tech-challenged and yet I came away with confidence and as importantly competence I did not think I’d attain! Two thumbs up and Thank You Blank Page and Anton.
Anton took our business through staff training with a lot of back end knowledge, patience and great communication.
We felt well supported and enjoyed our experience with Blank Page. We would highly recommend Anton for further training. Regards MA.
Reviews
There are no reviews yet.