Great Online Resources for Excel Dashboards and Reports - dummies

Great Online Resources for Excel Dashboards and Reports

By Michael Alexander

Part of Excel Dashboards & Reports For Dummies Cheat Sheet

You can learn a lot from the approaches other have taken to design their Excel dashboards and reporting mechanisms. Here is a list of sites (in no particular order) dedicated to business intelligence and the presentation of data through dashboards. Visit these sites to get ideas and fresh new perspectives on Excel dashboards and reports:

  • Perceptual Edge: Visualization expert Stephen Few provides some fascinating insights on data visualization and dashboarding. A generous amount of articles and examples can be found at his site and his blog.

  • Edward Tufte’s website: Professor Edward Tufte is an icon in the field of information design and data visualization. He shares his thoughts around visual communication in a series of articles at his site. Although many of these ideas are academic in nature, they’ll get you thinking in new ways about how to best present data.

  • Chandoo’s blog: Chandoo (aka Purna Chandra) came out of nowhere around 2007 to amaze us all with his innovative Excel tips via his blog Chandoo.org. He has a knack for clean, simple visualization techniques — which he shares freely to all his readers.

  • Jon Peltier’s website: Although his is not a site dedicated to dashboarding, Jon Peltier offers over 200 pages of unique and effective Excel charting ideas. A quick look at the excellent tutorials posted on his site will have you reeling with new ideas on how to chart your Excel data.

  • ExcelCharts.com: Jorge Camoes’s blog and website is focused on helping his readers make sense of their business data through better data analysis and visualization techniques. With several years’ worth of articles, his site proves to be rich source dashboarding concepts.

  • The Dashboard Spy: The Dashboard Spy posts examples of business intelligence dashboards, pointing out examples of good and bad dashboard design. This is a virtual warehouse of dashboarding ideas.

  • Juice Analytics: Zach and Chris Gemignani of Juice Analytics use their site as a platform to critique charts and offer interesting ideas around reporting data.