Leverage Data through Power Pivot, Power Query and Power BI - eLearning
This activity is presented by Sum Product. 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. Leverage Power Query and Power Pivot in Excel, and how they can interact with Power BI to analyse and report key information.
*The course provider, SumProduct, will email you login details within 48 hours of receiving your registration. Please contact us if you have not received your login details after this time.
*Your login is valid for a 12 month period.
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 module 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. The course has been developed by Liam Bastick and Tim Heng, who are both well respected financial modelling trainer in Australia and around the world and have been awarded the title of Most Valuable Professional by Microsoft, specialising in Excel. Liam and Tim are also the author and editor respectively of the textbook “Introduction to Financial Modelling”.
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.
Harness the power of data and learn to design rich and interactive analysis tools that enable deeper business insight in a fraction of the time.
Topic: Corporate Finance
Sub-Topic: Operational Excellence
Proficiency Level: Intermediate, Advanced
CPD: Upto 24 hours