Power BI – intermediate (1-day workshop to follow the 2-day introduction)

A one-day workshop

This course is designed for those already familiar with Power BI Desktop and are ready to work with more comprehensive elements of analysing and reporting in Power BI. The course maintains a balanced look at data analysis including the Query Editor, with a deep dive into writing DAX formulas, and enhanced dashboard visualisations.

The aim of this course is to provide a more complete understanding of the whole Power BI analytics process, by working with examples that will equip you with the necessary skills to output comprehensive reports and explore Power BI’s analytical capabilities with more depth.

Who should attend?

Managers and others who need to use or create reports and tables to support business management and decision-making. Our assumption is you are already a Power BI Desktop user and are comfortable with the fundamentals. If not, we recommend attending the 2-day Introduction to Power BI course first.

Format

A very practical, interactive one-day session for a maximum group size of 8. This course can be run remotely online or face-to-face onsite.

Expert trainer

Alan became a professional IT trainer in 1995, when on completion of an NVQ accreditation in IT, the organisation providing the course, Apex North London, asked if he would like to join their team, which he happily did. Alan went on to become a City & Guilds Assessor with them.

Session outline

1. The Power Query editor

2. Logical column functions

3. CALCULATE measure in-depth

4. The ALL measure

5. Iterator measures in-depth

6. Time intelligence measures in-depth

7. Visualisations in-depth

Heatmaps in Power BI
Applying static filters
Creating lists
Creating a scatter chart
Analysing chart trends
Creating dynamic dashboards
Customising tooltips