In the 14th session of Chandoo.org podcast, lets figure out how to make awesome dashboards.
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
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
Links & Resources mentioned in this session:
Excelapalooza Excel conference:
Advanced Excel, Dashboards & Power Pivot Masterclass:
Creating Dashboards – complete tutorials:
- Creating a KPI Dashboard – 6 part tutorial
- Customer service dashboard using Excel
- Employee vacation tracker dashboard
- More tutorials, examples & information about dashboards
Dashboard Examples & Inspiration:
- 49 dashboards on State to state migration in USA
- 66 dashboards visualizing salaries of Excel professionals
- 32 sales dashboards
- 78 Sales analytic charts & dashboards
- More dashboard examples & case studies
Creating Dynamic Charts:
- Examples of dynamic charts
- Introduction to Form controls – article, podcast
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
5 Responses to “Preparing Profit / Loss Pivot Reports [Part 2 of 6]”
[...] Preparing Pivot Table P&L using Data sheet [...]
[...] Preparing Pivot Table P&L using Data sheet [...]
[...] Preparing Pivot Table P&L using Data sheet [...]
I am not getting sound from the videos. I have checked all the settings and spent several hours searching the Internet to no avail.
Has anyone else had this problem?
Is there anyway to get the Grand Total to be broken out in the same fashion as the items above it? For instance, if you have in column 1, widget a, widget b, and have their sales by month in column 2, I'd like to see the grand total also be by month, for widget a & b combined.
I can't get anything other than a single line for the grand total, rather than the same format as the data above.
Widget A Month Sales
Jan 100
Feb 200
Widget B
Jan 150
Feb 250
Grand total - here I would also like to have Jan, Feb.
Jan 250
Feb 450