ICAEW.com works better with JavaScript enabled.
Exclusive

Power Tools Part 4: Build dynamic dashboards with Power Pivot

Author:

Published: 04 Mar 2024

Exclusive content
Access to our exclusive resources is for specific groups of students, users, subscribers and members.
This webinar explores the fundamentals of Power Pivot and how to best use this functionality in Excel to structure and analyse data, based on real-life examples accounting and finance professionals will encounter.
Allow StreamAMG video

This video is provided by StreamAMG. We ask for your permission before anything is loaded as they place a few cookies on our site. For more information on how we handle cookies, please see our privacy policy and cookies policy. To view this content on the website, please accept and continue.

This webinar, from the Excel and Data Analytics Communities, is part of a series exploring Microsoft's "Power Tools".

In this webinar, Mark Proctor, Director at Twenty Seven Solutions Limited and Microsoft MVP, will demonstrate how to use Power Pivot in Excel to create dynamic reporting and analysis that cannot be achieved with standard PivotTables. Learn how Power Pivot can be used to structure, filter, and analyse financial data from multiple tables and discover how to create powerful data models to deliver insights and more impact.

Some of the areas and examples we will be covering in this webinar include:

  • Creating relationships and data normalisation
  • Building a star schema
  • Using a calendar table for time intelligent calculations
  • Obtaining complete reporting flexibility with cube formulas

First broadcast on 5 March 2024

Webinar resources

This webinar has closed captions enabled. In order to enable this feature, please click on the “CC” icon at the bottom of your screen. Please note that the transcript is automatically generated and errors may occur.

CPD

This webinar could contribute to up to 1 hour of verifiable CPD, so long as you can demonstrate that the content is relevant to your role. Find out more.

Open AddCPD icon

Add Verified CPD Activity

Introducing AddCPD, a new way to record your CPD activities!

Log in to start using the AddCPD tool. Available only to ICAEW members.

Add this page to your CPD activity

Step 1 of 3
Download recorded
Download not recorded

Please download the related document if you wish to add this activity to your record

What time are you claiming for this activity?
Mandatory fields

Add this page to your CPD activity

Step 2 of 3
Mandatory field

Add activity to my record

Step 3 of 3
Mandatory field

Activity added

An error has occurred
Please try again

If the problem persists please contact our helpline on +44 (0)1908 248 250