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.

Designed for the end user / power user looking to get more out of Power BI without needing to be a developer.

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.

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

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.