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


Share on facebook
Share on twitter
Share on linkedin

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

Share on facebook
Share on twitter
Share on linkedin

Share this tip with your colleagues

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Chandoo is an awesome teacher

– Jason

Excel formula list - 100+ examples and howto guide for you

100 Excel Formulas List

From simple to complex, there is a formula for every occasion. Check out the list now.

20 Excel Templates

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Extract words from sentence using FILTERXML - formula tip

#awesome trick – Extract word by position using FILTERXML()

This is CRAZY!!!. I stumbled on a weird use for FILTERXML() while reading a forum post earlier today. So I couldn’t wait to test it. I am happy to share the results.

Say you have some text (sentence / phrase / keyword etc.) in a cell and you want to extract the nth word. Unfortunately Excel doesn’t have SPLIT() formula. So we end up writing obscenely long array formulas or use gazillion helper columns.

Here is the super sneaky trick. Use FILTERXML() instead.

7 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.

  4. Shashank Verma says:

    Hello Chandoo,
    i am one of the great fan of your. i am one MIS executive in realstate company.And i try make dash board for CRM(Client Relation Management) Dept formance and anlysis process.Its get created not so effective according to can u suggest me .what i hve to give or take for makeing it for effective and attractive?.

    Shashak verma

  5. Hi,

    I want to create an interactive dashboard in excel (Google Drive) which should have multiple data along with beautiful charts..

    I handle two teams in IT Tech support so were preparing 2 different dashboards.. however need to club and want to create single report, can anyone help something like

Leave a Reply