Leverage Data through Power Pivot, Power Query and Power BI eLearning
Learn how to convert mountains of data into key business information efficiently.
This course has been acquired via a partnership with SumProduct.
About
Power Pivot, Power Query and Power BI are tools that enable database-like computational power on our desktops, firstly within the familiar environment of Excel, and then within Power BI as it takes, automates and elevates the process of reporting and generating dashboards.
This self-paced course will develop a sophisticated case study exploiting many of the powerful tools and functionalities. Using hands-on examples throughout, you will learn how to convert mountains of data into key business information efficiently. Key management reporting, variance analysis and KPIs can be delivered faster than you can imagine.
Learning outcomes
This self-paced course will develop a sophisticated case study exploiting many of the powerful tools and functionalities. Using hands-on examples throughout, you will learn how to convert mountains of data into key business information efficiently. Key management reporting, variance analysis and KPIs can be delivered faster than you can imagine.
Learning outcomes
Upon satisfactory completion of this activity, you will be able to:
- Load, link and update data in Power Pivot.
- Write formulae in Power Pivot's Data Analysis Expressions (DAX) language.
- Use Time Intelligence functions to analyse data across periods.
- Import data using Power Query from a range of sources.
- Format and transform ’dirty’ data into a usable form to enable analysis.
- Build intuitive and interactive dashboards by using Power BI to automate your reports.
EVENT DETAILS
Topic: Corporate Finance, Future Focused
Sub-Topic: Business Reporting, Operational Excellence
Format: eLearning
Proficiency Level: Intermediate, Advanced
CPD: Upto 24 hours