http://budurl.com/exceldashboardlesson
All business intelligence dashboard practitioners are encouraged to watch that video lesson by Chandoo.
Update on this post about Excel Dashboard Tutorials: An excellent series of posts on how to use microsoft excel for dashboard reports has been posted on Dashboards By Example: Excel Dashboard Tutorials. The Dashboard Spy article includes links to sample excel dashboard worksheets that you can download.
As each version of Excel grows in features and visual sophistication, the product becomes a really compelling choice as a dashboarding platform. In my opinion, even if the functionality wasn't there (oh - but it is, especially in the Office 2007 version - very dashboard friendly!), Microsoft Excel is a must-consider choice simply because of the size of its user base.
This being the case, it behooves us dashboarders to understand the dashboarding capabilities of Excel.
What better way than to walk through a real hands-on workshop with an information visualization pro like Jorges Camoes? Check out his post titled "How to Create a Dashboard in Excel" and be sure to download and follow along with his tutorial.
Here is a screenshot of the dashboard you'll be creating. It's a Demographics Dashboard.
3 comments:
I want to build an interactive dashboard as well as one that is updated say every hour but my only connection to the db is thru Crystal Reports which would have to be refreshed every hour to capture current information then exported into Excel. How can I extract this information using Crystal Reports as the medium? Thanks.
Tutorial is really helpful and I am going to try it now if you find myself in any difficulty, I'll definitely let you know.
Excel Dashboards
Post a Comment