Data and AI Training

Home | Prices | Contact Us | Courses: Power BI - Excel - Python - SQL - Generative AI - Visualising Data - Analysing Data

Power BI Intermediate Course

Who should attend

Anybody who wants to take their Power BI skills to the next level.

Course Length

2 days

Learning Objectives

Attendees will be able to use Power BI Desktop to analyse and clean data and build insightful reports and dashboards.

Pre-requisites

Basic familiarity with Power BI, for example by having attended the foundation course.

Course Content

The course covers the following topics.

• Use visual calculations: e.g., running sum, moving average, change on previous, year to date
• Calculate useful quantities with DAX e.g. sums, averages,
• Advanced clean and transform data e.g. summarise, pivot and unpivot data
• Build several chart types: bar charts, line charts, scatter plots, matrix and table visuals, and maps
• Use interactions between visuals (as a filter, highlight) to good effect
• Use field parameters to construct flexible charts
• Improve charts with reference lines e.g. averages, trends, clusters,
• Create drill-though pages
• Build custom tooltips

Example case study

One of the possible case studies for this course is to calculate the league table of football’s English Premier League from the match record. More details are here. By the end of the course, you will have created a report similar to the snapshot below.