Do you want to create automated reports that can keep up with ever-increasing data volumes and changing reporting requirements?
In this comprehensive 2-day course, you will learn how Power BI can help you automate routine data analysis and create interactive, professional-looking reports in just minutes. No prior experience needed!
- Automate reporting
- Fast track data integration
- Discover new insights
- Super boost your productivity
How it works
|
We come to you or host remotelysaving you travel time |
|
Interactive workshopgiving you valuable hands-on experience with personalised support |
|
Two day course from 9am-5pmTeam can't spare two full days? Ask us about splitting the course across multiple sessions. |
|
Training Materials providedso you can recap after the session. See full details below |
|
$1,999 + GST per team per dayEach day of training includes optional Q&A, plus supporting course guide. |
|
Want more info?Contact us today |
Topics Covered
Day 1 Sessions |
|||
|
Introduction to Power BI DesktopLearn about the different components in the Power BI suite, and how to navigate a Power BI report |
|
Loading data into Power BIUnderstand the different ways of getting data into Power BI Desktop, and learn how to use Power Query to transform and cleanse your data |
|
Building a data model with relationshipsUnderstand how to create a flexible data model for your reporting solution using relationships |
|
Using DAX to create calculated columns & measuresLearn how to use DAX, Power BI's powerful formula language to add new columns and simple measures to your reports |
|
Creating visualisations in Power BI DesktopBecome a pro at creating professional-looking and interactive reports with the help of Power BI Desktop |
|
Understanding Power BI ServiceLearn about the features available when you publish your reports and files to the Power BI Service |
Day 2 Sessions |
|||
|
Integrating data with Power QueryDelve deeper into the capabilities of Power Query to learn how to group, append and merge datasets together |
|
Transforming data with UnpivotLearn how to transform data displayed in columns into rows at the click of a button in Power Query |
|
Using DAX to create complex measuresContinue exploring DAX functions such as CALCULATE() and ALL(), to add more complex measures to your reporting and analytics |
|
Time intelligenceCreate time intelligence analytics to gain instant insight into year-to-date and prior period performance in your organisation |
|
More visualisations in Power BI DesktopContinue exploring the different visualisation types in Power BI Desktop, to unlock hidden trends in your data |
|
Enhancing user interaction in reportsLearn how to improve the usability of your reports with Drilldowns, Drillthroughs, Bookmarks, Buttons and Custom Tooltips |
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 140 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
Don't see what you're looking for? CMBI offer a variety of training to suit all levels of experience:
See CMBI's training page for details of all courses we offer.