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
- PDF of Slides
- Workbook - Report Start
- Workbook - Report Complete
- Workbook - Filter Context
- Zip folder with all workbooks and data sets
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.