All articles in '3D Maps (Power Maps)' Category
![How to get Maps in to Excel charts & dashboards [Master Class]](https://chandoo.org/wp/wp-content/uploads/2016/07/SNAG-0087.png)
This is third episode of our Monthly Master Class.
In this one, you will learn how to get maps in to your Excel workbooks. Understand 5 key techniques for making maps based visualizations in Excel – from regular charts to cell grids to VBA to Power Maps, everything is covered in this intense Master Class.
Continue »{ 3 Comments }
Analyzing half a million customer complaints – Regional Trends [Part 2 of 3]
Published on Feb 18, 2016 in 3D Maps (Power Maps), Charts and Graphs, Cool Infographics & Data Visualizations
![Analyzing half a million customer complaints – Regional Trends [Part 2 of 3]](https://chandoo.org/wp/wp-content/uploads/2016/02/regional-trends-customer-complaint-vis.png)
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.
- Regional trends by state, product & issue
- Complaints per million by state
- Complaints by zip code
