Monthly Archives: March 2011

Excel and VBA: the poor man’s QlikView

Today I have something completely different for you. It is only tangentially related to QlikView and lacks any practical application for QlikView professionals, but I know it will make you smile when you see it.

A few years ago I was the technical lead on a project that required the development of multiple Excel dashboards. I designed and developed (together with Nico Wuite, who did a lot of the coding) an Excel plug-in that could be used to generate stand-alone, fully interactive Excel dashboards. I recently rediscovered the plugin after cleaning up my archive of Excel and VBA reference files and thought it would be fun to generate a demo dashboard.

Have a look at the embedded video below (preferably in full screen HD) and see if it reminds you of a certain BI tool 😉 Also, keep in mind that this was built before PowerPivot was released, so it is a little dated by now.