Multi Table Analysis with Power Pivot Tools in Excel
Expert Excel With Dr. Chang - Episode 5
Multi Table Analysis with Power Pivot Tools in Excel
Pivot Tables is a useful tool for data analysis. However in the real world, data is not usually that simple and usually come in a form of relational data source e.g. Relational DBMS. It is possible to use Pivot Tables for multi-table analysis.
One of the easier approach is to use the Power Pivot tool in Excel. It is an application add-in that allows the easy setup of multi-table pivot tables.
Once the tool is enabled, the user will have to import the tables to the Data Model. Define the relationship between the keys of the tables to finish up the Data Model. You can now easily create a multi-table pivot table from the Power Pivot tools. Try using all the features you have used from Pivot Tables to create your report. A useful tip is to use Slicers and Timeline with Pivot Charts to create dynamic charts.
Resource File:
https://bit.ly/3Akxmk6
If there are any requests for Excel Tips and Tricks, please write them down in the comment and I'll try to create a video answer in the future.
By Asst. Prof. Dr. Pisal Setthawong
Department of Digital Business Management
Assumption University
Facebook:
/ pisal.setthawong
Twitter:
@PisalST
Music Credits:
Cyberleaf Studio - TechShow Loop 1