PowerPivot allows us to organize our information efficiently. We can import databases directly to PowerPivot and create relationships to better handle the information. These relationships help us to structure better pivot tables. For example, I linked three tables which contain data values, list of economic indicators, and country names from the IMF. I created a pivot table from these three different tables and used Excel sliders to extract the relevant variables that we want study.
Excel file can be found here. Enjoy!
No comments:
Post a Comment