Excel Dashboards: do you need VBA?

Do you need VBA to create an Excel dashboard? Should you take the plunge and go beyond Excel formulas? Well, I think you should, but feel free to disagree. Charley Kyd, commenting on my review of his e-book, disagrees: As a consultant, I visited too many clients where an Excel user had written some macros, … Read more

10 tips to improve your Excel dashboard

Excel is a great (but underrated) BI tool. Several BI vendors gave up fighting it and offer Excel add-ins as front-ends for their BI solutions. So, if you want to create a dashboard you should consider Excel, since it really offers better functionalities than many other applications for a fraction of the cost and development … Read more

The Excel Demographic Dashboard in StarOffice/OpenOffice? Not yet.

I tried to create a Crystal XCelsius version of my Demographic Dashboard and failed miserably. But what about a new spreadsheet version? That should work, right? Wrong. I downloaded StarOffice 8 and just linked the pivot table (“datapilot”) to the Access population database via ODBC and waited… and waited… and waited… and finally was able … Read more

No Crystal Xcelsius dashboard, sorry

This is the last post in a series where I examined the possibility of creating a Crystal Xcelsius dashboard using my Demographic Dashboard as a benchmark. I’ll discuss here my overall conclusions. I must say from the start that I am very disappointed. Let’s start by the data set and Xcelsius integration with Excel. I … Read more

Is Crystal Xcelsius a toy piano?

Pascal Comelade, a french musician, plays toy pianos for a living. How many of us could do the same? How many of us could (professionally) use toys instead of our standard, grown-up tools? Now imagine that a toy maker starts marketing their toys as serious musical instruments. How would Beethoven’s 5th Symphony sound like? At … Read more

How to create a dashboard in Excel

Excel dashboards and executive reports are powerful, fairly easy to design and a great way to improve your Excel and data visualization skills. Because of its flexibility, you can virtually design any dashboard in Excel exactly the way you, or the users, imagined. And, best of all, you may want to implement it yourself or … Read more