Home | Power BI | Excel | Python | SQL | Generative AI | Visualising Data | Analysing Data
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 charts 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