All articles with 'GETPIVOTDATA' Tag

Analyzing half a million customer complaints – Regional Trends [Part 2 of 3]

Analyzing half a million customer complaints – Regional Trends [Part 2 of 3]

This is part two of our three part series on how to analyze half a million customer complaints. Read part 1 here.

Analyzing Regional Trends

As introduced in part 1, our complaints dataset has geographical information too. We know the state & zip code for each complaint. Please note that zip codes are partial or missing for a 10% of the data.

In this article, let’s explore three ways to analyze regional trends.

  1. Regional trends by state, product & issue
  2. Complaints per million by state
  3. Complaints by zip code
Continue »

How to use GETPIVOTDATA with Excel Pivot Tables

Published on Aug 26, 2015 in Pivot Tables & Charts
How to use GETPIVOTDATA with Excel Pivot Tables

Pivot tables are very powerful analysis tools. They can summarize vast amounts of data with just few clicks. But they are lousy when it comes to output. Imagine the horror of putting a pivot table right inside your beautiful dashboard. One refresh could ruin the layout and create half-an-hour extra work for you.

How to combine the power of pivot tables with elegance of your dashboards?

The answer is: GETPIVOTDATA()

Continue »

Product Recommendation – Excel Dashboard Training Kit

Published on Jan 14, 2010 in Charts and Graphs, products
Product Recommendation – Excel Dashboard Training Kit

If you want to make better charts and create lasting impressions, chances are you have heard about Jorge Camoes. He writes at excelcharts.com (previously charts.jorgecamoes.com). I have been reading Jorge’s blog for over 2 years now and have linked to his excellent articles on PHD several times. Jorge also has an Excel Dashboard Training Kit, which teaches us how to make a dynamic and comprehensive excel dashboard. The dashboard training kit is a culmination most of his lessons implemented in a practical way using Excel.

In this article, I review the product and tell you why you should get a copy of it.

Continue »