CP014: How to create awesome dashboards – 10 step process for you

Posted on July 10th, 2014 in Chandoo.org Podcast Sessions , Charts and Graphs - 5 comments

In the 14th session of Chandoo.org podcast, lets figure out how to make awesome dashboards.

CP014: How to create awesome dashboards - 10 step process for you

What is in this session?

Excel dashboards are much in demand these days, thanks to advancements in Excel & growing pressure on costs. Now a days, analysts & managers are expected to quickly put together a dashboard using Excel. But how do you make a dashboard? What process you should follow? These are the questions we address in this podcast.

In this podcast, you will learn,

  • Announcements about upcoming dashboard classes
  • Ten step process for creating awesome dashboards
  • 1. Talk to your end users
  • 2. Make a sketch of the dashboard
  • 3. Validate your understanding
  • 4. Collect data
  • 5. Structure the data

Go ahead and listen to the show

 

Links & Resources mentioned in this session:

Excelapalooza Excel conference:

Advanced Excel, Dashboards & Power Pivot Masterclass:

Creating Dashboards – complete tutorials:

Dashboard Examples & Inspiration:

Creating Dynamic Charts:

Transcript of this session:

Download this podcast transcript [PDF].

What process do you follow to create dashboards?

I have been following this 10 step process for the last 8 years with great success. Not only this process is easy to follow, but also it reduces the scope of errors significantly.

So what about you?What process do you follow when creating dashboards? Please share your thoughts & experiences using comments.

Subscribe to Chandoo.org Podcast

Other options to subscribe

Your email address is safe with us. Our policies

Written by Chandoo
Tags: , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

5 Responses to “CP014: How to create awesome dashboards – 10 step process for you”

  1. Paul says:

    Very interested in topic unfortunately I get no sound when I play it.

  2. Budala Ebnezer says:

    Where can I get add ins for excel 2007

  3. Andy Serna says:

    I would like to join your email newsletter.

Leave a Reply