Want to continue your Power BI journey? Dive into DAX and Power Query's M programming language in CMBI's one-day "Advanced Power BI Desktop" course.
This course picks up where the 2-day Introduction to Power BI Desktop course leaves off. It takes a deep dive into the more programmatic aspects of Power BI to take your reporting solution to the next level!
At the end of this course you will be able to create your own custom functions in Power Query using the M programming language, extend your knowledge of creating measures with DAX, and use custom visualisations to create compelling reports that will revolutionise the way you work with your data.
How it works
|
We come to you or host remotelysaving you travel time |
|
Interactive workshopgiving you valuable hands-on experience with personalised support |
|
One day course from 9am-5pmTeam can't spare a full day? Ask us about splitting the course across two sessions. |
|
Training Materials providedso you can recap after the session. See full details below |
|
$2,499 + GST per teamIncludes a day of training with optional Q&A, plus supporting course guide. |
|
Want more info?Contact us today |
Topics Covered
|
Advanced Data TransformationDelve deeper into the capabilities of Power Query to learn how to create variables and functions, and use M to augment the data model. |
|
Parameterise QueriesLearn how to parameterise the data load process to create a more flexible and future-proof data model |
|
Create Custom FunctionsAutomate even the most complex load and transformation tasks using custom functions. Never manually edit a data file again! |
|
Build dynamic tables with MLearn how to use Power Query's M programming language to augment the data model and build dynamic data tables. |
|
Use DAX to create complex measuresExplore DAX iterator functions such as FILTER(), SUMX() and RANKX() to gain greater insight on your reporting and analytics |
|
Advanced RelationshipsLearn how to use the DAX function, USERELATIONSHIP() to reference inactive relationships in measures |
|
Exploring Visualisations in Power BIContinue exploring the different visualisation types in Power BI Desktop to unlock hidden trends in your data |
|
Custom VisualisationsBrowse the AppSource marketplace to add third-party custom visualisations onto your reports |
Want more info?
Download a detailed course overview
Delivery Method
Each workshop is presented as a series of practical exercises, that give attendees hands-on experience of all aspects of Power BI. All our training exercises are supported by detailed course materials for reference during and after the training day.
CMBI can present this training session either in-person onsite, or host it live remotely, using industry-leading video conferencing software. Learn more about Remote Training here.
Materials and support
Our course materials support learning and re-enforcement well beyond the workshop.
Each session includes an associated set of support materials to help attendees complete the tasks on the day, as well as provide support after course completion:
- Supporting course notes PDF document (approx 60 pages, printed on request)
- Complete Power BI models for all exercises
- Datasets for all examples
- Optional Q&A time at the end of the session for anyone interested in asking specific questions
More Training Options
Interested in other courses? CMBI offer a variety of training to suit all levels of experience:
See CMBI's training page for details of all courses we offer.