Happy Birthday Hui, An Excel Dashboard to prove you are awesome!

Share

Facebook
Twitter
LinkedIn

Happy Birthday Hui…

Note: Hui’s birthday is yesterday (13th). I planned to write this post and share the dashboard workbook with you all yesterday itself, but my daughter wasn’t keeping well and we were busy taking care of her. (And yes, she is ok now, thanks for asking. 🙂 )

Some of you know our guest author and Excel ninja Hui. Yesterday was his birthday. And I wanted to create nice birthday gift for him. So I took a database dump of our forums data and created a dashboard.

First take a look the dashboard I made for him:

[click here for a large version]

Happy Birthday Hui - Excel Dashboard to prove Hui is awesome

Some Key Findings

  • Our forums have a total of 5,227 posts, out of which Hui contributed 24% (roughly 1 in 4)
  • On average Hui takes 13 and half hours to get back to the questioner with an answer. The fastest he has been was 31 seconds. (only last year data)
  • Hui has been very busy on November 30th – 2010, answering 19 times on that day.
  • The person who got benefited most from Hui is indi visual, with 44 replies from Hui.
  • People used the words thank and Hui in same post 395 times.
  • Hui wakes up early and answers questions on our forums. Then, before sleep, he spends some time helping people.
  • If Hui had $2.5 per each letter he typed in our forums, he would be a millionaire.
  • All data as of Jan 11, 2011. Between that and now, Hui has already answered 37 more times (and still helping…)

How is this dashboard constructed?

With lots of love of course. But quite a few excel techniques were used too.

How this dashboard is constructed

Download Excel Workbook with this Dashboard

Please click here to download the workbook. It is locked.

I have made a 45 minute video explaining how this dashboard is constructed. I will be giving this video & unlocked workbook as a bonus to people joining Excel School dashboard option or purchasing Dashboard training kit.

Interested in Dashboards?

  • I recommend joining Excel School. You can learn how to make awesome charts & dashboards.
  • Visit our Dashboards Page. It has tons of useful information, examples, tutorials & templates.

Say Happy Birthday & Thanks to Hui

I am sure directly or indirectly, Hui has helped many of you. So take a minute and say thanks to him. Wish him several more years of awesomeness, happiness, wealth & health. 🙂

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

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

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst
Excel formula list - 100+ examples and howto guide for you

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

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

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Leave a Reply