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.

Objectives

Learning objectives

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

Audience

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

Format

A very practical, interactive one-day session for a maximum group size of 8. Comprehensive materials provided, including exercise files and a unique step-by-step guide developed by the trainer specifically for this programme.

This course can be run remotely online or face-to-face onsite.

Meet the trainer

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.

Alan now freelances and almost exclusively specialises in analytics using Microsoft Power BI as a platform, however he still provide clients with Excel training when requested to. His previous 25+ years within this sector includes both freelancing, and full time employment at various companies including, Lead Trainer at Go Courses, and Training Manager at Ultima Concepts.

See what some of the participants have said about the workshops he’s delivered for us:

‘Fantastic. Well-paced and easy to follow.’
‘Great experience.’
‘Very personable, relatable, patient and able to present complicated processes in an understandable way.’
‘Friendly and good at checking people are up to speed.’
‘Very good and explained and answered all questions.’
‘Explains everything well.’
‘Excellent teacher and very intelligent.’
‘Very knowledgeable would love to have him again if there is another course – thank you.’
‘Alan explains things very clearly and addresses issues on questions before they are visible. Thank you very much!’

1 The Power Query editor

  • Grouping tables
  • Split a row by delimiter
  • Matching inconsistent data

2 Logical column functions

  • Understanding logical functions
  • Create a FIND function
  • Nest logical functions in an IF function

3 CALCULATE measure in-depth

  • Understanding CALCULATE filters
  • Add context to CALCULATE with FILTER
  • Using CALCULATE with a threshold

4 The ALL measure

  • Anatomy of ALL
  • Using ALL as a filter
  • Using ALL for percentages

5 Iterator measures in-depth

  • A closer look at SUMX
  • Create a RANKX
  • RANKX with ALL

6 Time intelligence measures in-depth

  • Developing a calendar table
  • Comparing historical data
  • Create a DATEADD measure

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

Any questions? Please just give us a call on 01582 463463 – we’re here to help!