Go Back > Blogs > Hitesh Shah's blog

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 68

Baanboard at LinkedIn

Reference Content

online dashboards in Excel
By Hitesh Shah at 17 Dec 2009 - 17:44

Online dashboards coupled with in-memory analysis and predictive / statistical analytics form the major drivers of current BI solutions besides the obvious major driver routine operational reporting.

Operational baan reporting supplemented by in-memory data transformation in Excel/Baan and statistical functions in Excel substantially fulfils this need . However dashboards are an area so far unaddressed.


For online dashboards also Excel can play a good role. There is a myth that Excel can only be used with MS SQL. But that’s not correct . It can also be used with other databases like Oracle / DB2 which  may be installed on non-windows system through ADO-DB connections .

Here are certain resources which can help user build Excel based dashboards. 

Excellent dashboard reports in

Importance of using named ranges (which can be used like variables in VBA by statements like application.range(“named_range”) and functions like lookup/match etc: Very good tips to improve dashboards and having good interactivity with user with dashboards:


Importance of using less VBA as far as possible (Though dashboard with VBA is certainly not an evil):


An Overview of the Working Dashboard, Traffic Lights, New Color Schemes, Shrinking Charts, Create Magazine-Quality Charts. This link also answers questions like we already own expensive dashboard software, so why do we also need Excel dashboards?


Further there are certain illustrations to add user interactivity like double clicking a cell or pivotcell to show the detail or perform some other functions , add buttons , using named ranges to  form query , using multi-table unions (not joins ) to create a meaningful  datasource, inserting narrations/images, triggering data/chart/report refresh at certain interval etc . All these we'll illustrate in a separate blog later on.

No votes yet

All times are GMT +2. The time now is 19:19.

©2001-2018 - -