Power BI Next Level
Overview
Do you love the dynamic reporting capabilities of Power BI? Have you created a few Power BI reports, but unsure of how to take your reporting to the next level? This course will highlight some of the intermediate to advanced features of Power BI, as well as provide you with some pro tips that will save you time and frustration when building Power BI reports.
Who should attend
Designed for the end user / power user looking to get more out of Power BI without needing to be a developer.
Prerequisites
Before attending this course, students should attend Power BI Essential Skills or have equivalent knowledge of Power BI. In particular, students should be familiar with creating visualizations in Power BI desktop and have a basic understanding of 1 to many relationships.
What you'll learn
In this hands-on course students will create a Power BI report from data to dashboard. Upon completion of this course you will:
- Create a dynamic report and dashboard
- Drill-through from a report summary page into detailed information
- Filter and slice visualisations using clever interactions
- Use the filter pane to reach a wider audience within one report
- Secure your data using row level security
- Schedule automatic refresh of data
Course content
Power BI Essential Skills Review
Get data from Excel, create relationships and publish a
simple dashboard.
Power Query Timesaving Tips
Get data from an entire folder, learn how to edit M query
code in the formula bar, edit Applied Steps to troubleshoot data import errors
and discuss best practice tips for data transformation in Power Query.
Introduction to DAX
Work with simple DAX functions and discuss the difference
between calculated measures and calculated columns.
Analysing Data with Visualizations
Explore various Power BI visualizations such as gauges, KPIs
and more. Filter visualizations, sync slicers and edit interactions between
visuals to show exactly what you need. Implement row-level security to enable
your report to automatically filter for each user.
Format reports
Create interactive reports that drill-through to detailed pages, drill down through hierarchies and use buttons and bookmarks to make the report easier to use and understand. Use conditional formatting to highlight important data. Learn timesaving tricks to align, format and edit existing visualizations so your report looks professional.
Common questions
When does Power BI Next Level next run?
The next date is Mon, 31 Aug 2026, and there are 15 further dates scheduled. Delivered ACE Training Hamilton, ACE Training Wellington, ACE Training Christchurch, ACE Training Auckland. Every date and its format is listed on this page.
How much does Power BI Next Level cost?
From $745 + GST per person. Pricing can differ by date and location, so check the option you want before booking.
Do I need any prior experience?
Before attending this course, students should attend Power BI Essential Skills or have equivalent knowledge of Power BI. In particular, students should be familiar with creating visualizations in Power BI desktop and have a basic understanding of 1 to many relationships.
Can I attend online, or does it have to be in a classroom?
Both. Some dates run live online and others in-class — each date on this page shows its format, so pick whichever suits.
Can you run this course for my team?
Yes. Any ACE course can be delivered in-house at your workplace and tailored to your team's tools and goals — quote course code PowerBI-Next-Level when you enquire.