A pivot table is the core business intelligence tool that helps to turn meaningless data from various sources to a meaningful result. By using different ways of presenting data, we are able to identify relations between seemingly separate data and reach conclusions to help us identify our strengths and areas of improvement.
In this section, we will use the data prepared in previous recipes to make some pivot tables that can help us make smart business decisions!
Prepare the two files entitled
GDPData_v2.xlsx from the previous recipes. We will be using these results along with other data sources to create a meaningful PowerPivot table that will be used for intelligent business ...