Home Courses Power BI Next Level

Courses


Power BI Next Level

Length: 1 Day    Cost: $695 + GST    Version: Power BI

= Scheduled class    = Guaranteed to run    = Fully booked
Click on the dates to book online
CentreAprMayJunJul
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.


 Print this page