CP053: Excel Data Validation for Dummies
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 53rd session of Chandoo.org podcast, let’s talk about data validation.
What is in this session?
In this podcast,
- What is data validation
- How Excel DV compares with database & software DV?
- Types of data validation rules
- List & custom rules explained
- Input & error messages
- Alternatives to data validation
- Enhancing data validation
- Removing data validation rules
- Homework problem for you
- Resources & show notes
Analyzing half a million complaints – Customer Satisfaction Scorecard [Part 3 of 3]
This is the final part of our series on how to analyze half a million customer complaints. Click below links to read part 1 & 2.
- Complaint reason analysis – Part 1
- Regional trends & analysis – Part 2
Customer satisfaction scorecard
In the previous parts of this case study, we understood what kind of complaints were made and where they came from (states). For the customer satisfaction scorecard, let’s focus on individual companies.
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.
- Regional trends by state, product & issue
- Complaints per million by state
- Complaints by zip code
Formula Forensics 040 – Apportioning Sales by Criteria
Lets look at how to apportion sales according to multiple criteria
CP052: Book Review – M is for Data Monkey by Ken & Miguel
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 52nd session of Chandoo.org podcast, let’s discuss monkeys, Ok, I am kidding. We are going to talk about M is for Data Monkey book.
What is in this session?
In this podcast,
- Updates: Why so much gap between episodes?
- Quick introduction to Power Query
- Why you should get this book?
- What is in this book?
- A very cool example of the techniques you will learn
- Conclusions
KPI performance charts & dashboards – 43 alternatives (contest entries)
Hello all, prepare to be amazed! Here are 43 creative, fun & informative ways to visualize KPI data.
About a month ago, I asked you to visualize KPI data. We received 65 entries for this contest. After carefully reviewing the entries, our panel of judges have discarded 22 of them due to poor charting choices, errors or just plain data dumps. We are left with 43 amazing entries, each creatively analyzed the data and presented results in a powerful way.
How to read this post?
This is a fairly large post. If you are reading this in email or news-reader, it may not look properly. Click here to read it on chandoo.org.
- Each entry is shown in a box with the contestant’s name on top. Entries are shown in alphabetical order of contestant’s name.
- You can see a snapshot of the entry and more thumbnails below.
- The thumb-nails are click-able, so that you can enlarge and see the details.
- You can download the contest entry workbook, see & play with the files.
- You can read my comments at the bottom.
- At the bottom of this post, you can find a list of key charting & dashboard design techniques. Go thru them to learn how to create similar reports at work.
Thank you
Thank you very much for all the participants in this contest. I have thoroughly enjoyed exploring your work & learned a lot from them. I am sure you had fun creating these too.
So go ahead and enjoy the entries.
CP048: How to create animated charts in Excel?
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 48th session of Chandoo.org podcast, let’s make some animated charts!!!
What is in this session?
In this podcast,
- Announcements
- Why animate your charts?
- Non-VBA methods to animate charts
- Excel 2013’s built-in animation effects
- Iterative formula approach
- VBA based animation
- Cartoon film analogy
- Understanding the VBA part
- Example animated chart – Sales of a new product
- Resources and downloads for you