Data Modelling in Excel, from Pivot Table to Power Pivot
Details
PivotTables are great for easily summarizing data but are linked to one large data table that contains all the data to be analysed, so as the data grows or becomes more complex so do the limitations of PivotTables.
Power Pivot takes this to the next level by replacing one big data table with a data model using tables from multiple data sources and creating relationships between the tables.
This presentation will go over how to go from formatting data from a single table in a PivotTable to creating a relational data model in Power Pivot, including the use of Power Query and DAX to provide data analysis and insights that would not be possible with a PivotTable.
Ben Weiner is a CIMA qualified accountant who has been using Excel in finance teams for 15 years, specialising in automating workflows using modern Excel features including Power Query and Dynamic Arrays.