O'Reilly logo

Instant Creating Data Models with PowerPivot How-to by Leo Taehyung Lee

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a pivot table (Simple)

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!

Getting ready

Prepare the two files entitled DatabaseData_v2.xlsx and 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required