Who is this course for? Anybody who wants to take their Power BI skills to the next level.
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 Power BI 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 parameter to construct flexible charts
- Improve charts with reference lines e.g. averages, trends, clusters,
- Create drill-though pages
- Build custom tooltips
- Use ChatGPT and other generative AI to help with data analysis.