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
6 Responses to “A quick personal update”
Thank you for the personal update. It was quite encouraging and a breath of fresh air in my Inbox. Take care and stay safe.
David
Doctors advise:
Virus obstructs lungs with thick mucus that solidifies.
Consume lot hot liquids like tea, soup, and sip of hot liquid every 20 min
Gargle w antiseptic of lemon, vinegar, & hot water daily
It attaches to hair/clothes detergent kills it, when come from st go straight shower
Hang dirty clothes in sunlight/cold overnight or wash immediately.
Wash metal surfaces as it can live on them 9 days
Do not touch hand rails
Do not smoke
Wash hands foaming 20 sec every 20 min
Eat fruit/veg and up zinc levels.
Animals do not spread it
Avoid common flu
Avoid eat/drink cold things
If feel sore throat do above immediate as virus is there 3-4 days before descends into lungs
Would love help with my database mgt in excel.
Thanks for being thoughtful of us.
BTW How do you track your expenses/income in excel? Can you share the worksheet please.
Stay safe you and your family, best wishes.
Thanks for the update and happy to know that you and family are doing good. A 21 day lockdown has now been announced in India (I live around Kolkata) so it's uncertain times ahead. I check up on your wonderful articles often and will do so even more regularly now. Stay safe and God bless.
Hi from Argentina, I follow you for a lot of years now. We here are in a quarantine for 2 or 3 weeks, because the pandemia.
Excel is also my passion and I came here looking for a Num2Words formula, but in spanish. If anyone have it, please let me know.
Best regards.
Pablo Molina
La Rioja - Argentina
I'm glad to have your personal update. I'm from India & following you for so many years. Cheers to have any further personal update.