Check out the sample mobile analytics dashboard by Percent Mobile. It is like google analytics, but for mobile device based traffic. I liked the way they presented the information of website traffic that is coming from mobile devices.
What is WOW about it?
The top portion of the dashboard shows quick summary. This is one of the key principles of any good dashboard. Displaying summary at the top and providing detail at bottom. This creates a logical flow and viewer can decide for herself which details to seek.
The bar charts below are executed well. Often we are tempted to use colors and rich formatting, but when you use simple colors, then naturally the attention shifts from formatting to information. I like the way the charts look subtle but still provide good information, thanks to labels.
What can be improved in this chart?
The mobile ecosystem area of the dashboard looks good but it is difficult to spot any trends. Few things I can think of to improve this are,
- Reduce the number of phones displayed here to say Top 5
- Try something else like a tag cloud, but with images. It adds novelty and drives attention to most important devices.
- Restructure information by dimensions like touch-screen devices, gaming devices, good old mobile phones so that viewer will know what type of devices are visiting the site more.
What is your opinion on this dashboard?
Cool or awful? How would you improve it?
More on dashboards: KPI Dashboards using Excel (6 part tutorial and downloads), Excel Dashboards theory, principles and tutorials
[Hat tip to Digital Inspiration for percent mobile]
11 Responses to “MLB Pitching Stats Dashboard in Excel+VBA by our VBA Class Student”
Hey Dan,
Thanks a lot... this is too good 🙂
Awesome stuff Dan! very impressed..
Thanks guys.
Some nice ideas in there, thanks for sharing. I noticed the list with teams has a missing value though ('Arizona Diamondbacks'). Also when manipulating Pivot Tables with VBA you should be really careful not to try to select a value that isn't in the Pivot Table, if you do all hell breaks loose 🙂 That's not the case here but just some advise as I learned the hard way...
Ah.....ya caught me.
dnrTeamName drives both the charts and the drop down list. It refers to:
=OFFSET(PvtTeams!$A$6,0,0,COUNTA(PvtTeams!$A$6:$A$40),1)
If you change A6 to A5, it fixes that little issue.
A better question though, who actually cares about the Arizona Diamondbacks?
🙂
Excellent post. Thanks
Great job, Dan! Thanks a million!
[...] MLB Pitching Statistics Dashboard [...]
Gr8 work Dan
Hi,
I downloaded file, but looks like everything is in xml. Was there suppose to be excel file as well?
Thanks!
I'm late to the party, but seeing this file in action and studying the underlying data in this Excel file has been AWESOME. I have TONS of new ideas to implement in my work files now. THANK YOU Dan and Chandoo!