About this course
Learn how you can generate rich and interactive dashboards that look like they have spent weeks in development, in only a fraction of the time. Power BI Desktop is a free tool, providing interactive data visualisation software, which can interact with Power BI service to provide a scalable resource of Business Intelligence to suit any organisation.Across the modules, you will gain hands-on experience in every stage of the Power BI workflow: importing and shaping data with Power Query, modelling relational data, writing analytical measures with DAX, designing interactive visuals, and publishing secure, shareable reports in the Power BI Service. Real-world examples, step-by-step demonstrations, and structured exercises ensure that you not only understand Power BI concepts - but can also apply them effectively in business environments.
This comprehensive, self-paced programme has been updated for 2026 and moves from foundational skills to advanced reporting techniques, using a practical, case-driven approach throughout.
By completing this course, you will be able to:
- understand the Power BI ecosystem (including Desktop, Service, Mobile) and it's place in Microsoft Fabric and in the broader Microsoft data platform
- extract, transform and load data using Power Query from a range of sources
- design efficient data models
- write analytical expressions in DAX, including aggregations, filter functions, time-intelligence calculations, variables, evaluation contexts, and advanced patterns
- create standard and custom visualisations, including custom themes, bookmarks, field parameters, tooltips, and interactive controls
- build automated KPIs, variance analyses, and management-level dashboards
- utilise advanced reporting techniques, such as what-if analysis, scenario modelling, drill-through, conditional formatting, decomposition trees, and report automation
- publish, secure, and share reports using Power BI Service, including apps, permissions, refresh schedules, and collaboration features.
Key information
- This course produced by SumProduct contains a collection of videos and Excel files for you to follow along with.
- This course requires you to have a basic understanding of Microsoft Excel.
- This course requires you to download Power BI Desktop and register for the Power BI Service.
- This course requires you to use (for Windows) Excel 2016 (or newer), Excel for the web or Excel 365; (for Mac) Excel 2021 (Excel 2019 for MAC support will end in October 2023).
- The recommended operating systems for Windows are Windows 10 or 11; for MacOS is Big Sur 11 or later.
- CPD certificate is available upon successful completion of the course.
