Courses
Power BI Next Level
Length: 1 Day Cost: $695 + GST Version: Power BI
= Scheduled class 
= Guaranteed to run 
= Fully booked| Centre | Apr | May | Jun | Jul |
|---|---|---|---|---|
| Auckland | -- | 24 | -- | 30 |
| Hamilton | -- | 28 | -- | 27 |
| Christchurch | 28 | -- | 30 | -- |
| Wellington | 29 | -- | 28 | -- |
| Virtual Class | -- | -- | -- | -- |
Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.
About this Course
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.
Audience
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.
At Course Completion
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 Outline
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.
