What you will learn
- how to load and link data
- to write formulae in Data Analysis Expressions (DAX) language
- how to create standard and custom visualisations
- how to extract, transform and load data using Power Query from a range of sources
- the interaction between Power BI Desktop and Power BI Service
- how to build intuitive and interactive dashboards by using Power BI's powerful visualisation and insight tools to automate your reports.
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. Using hands-on examples throughout, you will learn the key features of this exciting resource, and how it can help to share data and insights.
Key information
- This course contains a collection of interactive slides and videos for you to follow, and exercises for you to complete within 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.
- This course requires you to have a basic understanding of Microsoft Excel.
- CPD certificate is available upon successful completion of the course.
