Working as a Product Manager at , a Business Intelligence company, I eat and sleep with data, either figuratively or literally 🤣 Holistics Since Pivot Tables are one of the most popular visualizations to present insights, it plays a significant role in my daily analysis work. However, it took me a while to get familiar with the concept for the first time since mostly all the examples are something Finance or Sales related, using random dummy datasets. But it’s easiest to develop your data knowledge when working with data sets that you already understand. That’s how I came up with the idea of learning about pivot tables through more commonly known data points such as those of Pokemon, Football, Marvel Heroes, etc. What is a Pivot Table and Why Should You Care? Basically, a Pivot Table helps you transform the data in Raw Tables into readable and meaningful insights quickly using just drag-and-drop, which we will see through more examples below. Since it’s very powerful, the feature is available in most of the spreadsheet editors such as Excel, Google Spreadsheet, … In this tutorial, I will use CloudPivot because of its ease of sharing online. CloudPivot.co We will use this data table below across all the examples, let’s take a look 👉 Pokemon Dataset Some exploratory questions might pop up in your mind, for example, ”. And you want to have an answer like the table below? “How many Normal Pokemon and Legendary Pokemon are there? This, is what we call Pivot Table ✌️ How do we achieve that? And, it’s called pivot table ✌️ Pivot Table Concept Pivot Table is the result of summarizing and grouping the raw table through these 4 properties: Values Aggregated fields, numerical values that can be used for different types of calculations. For the text fields, they need to be turned into Possible values: Count of Pokemon, Average Strength, Maximum Weight, Sum of Attack, etc. Example 👉 Drag into the to count ? Count of Name Values Area how many Pokemon are there There are 800 Pokemon in total Columns Group same values and calculations into columns. Example 👉 Keep and drag into the to count ? Count of Name Legendary Columns Area how many Legendary and Non-Legendary Pokemon are there There 735 Non-Legendary and 65 Legendary Pokemon Rows Group same values and calculations into one or multiple rows. Example 👉 Keep and drag into the to count ? Count of Name Legendary Rows Area how many Legendary and Non-Legendary Pokemon are there Same answer, different display Filters To apply filters to the entire table. Example 👉 Keep in Values Area and in the Count of Name Legendary Rows Area, then we add a filter to get Legendary Pokemon only Only Legendary Pokemon Advanced Examples The examples above are just the beginning, with Pivot Tables, you can achieve more meaningful insights by mixing the Rows, Columns, Filters and Values area. How many Legendary/Non-Legendary Pokemon by Generation? Generation in Rows, Legendary in Columns Generation and Legendary in Rows How many Legendary/Non-Legendary Pokemon by Type 1? Average HP, Attack, Defense, Speed, Special Atk & Def of Legendary/Non-Legendary Pokemon From Pivot Tables to Charts Another nice thing about Pivot Tables is that they make your data prepared for charts. With the example of the Legendary/Non-Legendary Pokemon above you can easily turn your pivot table into a Pie Chart like the one below Pivot Table to Pie Chart Pivot Table is a very powerful concept in data analysis, this first part might be short but I hope it’s useful for you to start as an overview. In the next part, we will go through more complicated questions and datasets. If you like it, follow me to get the latest update of this series and don’t hesitate to ask me any questions! : is a free web app for data community to visualize data built by . You can upload or connect your data to quickly visualize and share with others. Disclaimer CloudPivot Holistics.io Sample Datasets for You to Play Around Pokemon with Gif Images Fifa 19 Sample E-commerce

Google

4 Case Study Questions for Interviewing Data Analyst at a Startup

A Database Diagram Designer Built for Developers and Analysts

Twitter

Read My Stories

Too Long; Didn't Read

Make resilience your competitive advantage

Using Pivot Table for Dummies with Pokemon Data — Part 1

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

Untitled Story

The Rise of Reusable SQL-based Data Modeling Tools and DataOps services

10 Ways to Optimize Your Database

10 Best React Native Chart Libraries

10 Best Datasets for Time Series Analysis

12 Mistakes that Data Scientists Make and How to Avoid Them

The Rise of Reusable SQL-based Data Modeling Tools and DataOps services

10 Ways to Optimize Your Database

10 Best React Native Chart Libraries

10 Best Datasets for Time Series Analysis

12 Mistakes that Data Scientists Make and How to Avoid Them

Light-Mode

Classic

Newspaper

Dark-Mode

Neon Noir

Minty

HN StartUps