Excel PowerPivot - Single Pivot table with Multiple files

Watch the video above on Power Pivot.

#excel #PowerPivot #Pakuppaivu Handling multiple files for #dataanalysis in Excel is challenge as compiling multiple file takes time as well increases the size of file where all data is stored. Power Pivot helps us to overcome this issue by compiling multiple files to a data model and establish relationship between them. Once a #datamodel is created in Power Pivot, all files connected to that data model can be accessed using single pivot table then you can navigate and analyze the data like a common #pivottable. In this video, we have explained how to activate power pivot in Excel then how to build a data model in excel then we explained about how to establish relationship between different files followed by creating a pivot table connecting all the files for data analysis. 00:00 Intro on Power Pivot 01:45 Activating Power Pivot in Excel 02:27 Building Data Model using PowerPivot 08:13 Establishing relationship between files in Data Model 10:55 Creating a new variable in data model 13:55 Pivot table creation 18:33 Conclusion If you have any questions, please post it in comment section or at our blog - https://pakuppaivu.blogspot.com