Aims & Objectives

This session follows on from the first; covering the key steps associated with building a typical business report. You will learn how to build ‘measures’ (calculations) and will be introduced to ‘calculated columns’ and when to use one over the other. You will also be introduced to some of the most common DAX functions and how and when to use them.

This session is designed for those people who already use Power BI but want to be more creative and dynamic when building business reports. It is recommended that delegates have some experience of importing and working with files of different types.

What will I learn?

Creating Dynamic Reports

  • Import data from an Excel workbook.
  • Review the quality of the imported data and remove unwanted records.
  • Understand the difference between a ‘measure’ and a ‘calculated column’.
  • Consider how the information will be presented in the report and identify the tiles you want to use.
  • Determine how the report consumer may wish to filter / slice and drill into each tile to expose various levels of granularity.
  • Build some basic measures (calculations) & calculated columns that will be used in the report.
  • Resize, group and format tiles to get the desired look and feel as well as being easy to read and interact with.
  • Understand the difference between a standard table and a matrix and when to use one over the other.
  • Make sure the report has clearly defined sections & boundaries which are aligned and balanced with other tiles.
  • Create a title for the report so report consumers understand the purpose of the report.

How We Deliver

We currently deliver all training online to comply with the Government's guidelines.

Online training works well for businesses whose staff are mainly working from home.

It allows us to train all of your staff with the same training needs at the same time. Your people simply log on from home, using details provided in advance by our team.

Choose from Watch and Learn sessions for larger groups or interactive hands on sessions for smaller groups.

When permitted we also offer face to face training at your offices.

All sessions can be customised to a half day or 90 minute sprint session and tailored to fit your needs, covering the topic(s) within a course that are most important to your business.

Stay up to date

Subscribe to our mailing lists:

I would like to receive the following emails:
Mailing lists

We are collecting your email address to send you the emails you select above and we require your consent. By clicking the Subscribe button, we are treating this as your consent. To withdraw your consent, please use the unsubscribe option at the bottom of the received email(s)