Baanboard.com

Go Back   Baanboard.com > Blogs > Hitesh Shah's blog

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
28%
500 - 800 GB
3%
800 - 1200 GB
10%
1200 - 1500 GB
10%
1500 - 2000 GB
13%
> 2000 GB
20%
Total votes: 40

Baanboard at LinkedIn


Reference Content

 
Excel based dashboards Sample
By Hitesh Shah at 17 Jan 2010 - 19:00

Online dashboards are frequent user queries / reports with set of all inter-related questions capable of being answered by the dashboard under user control (and not the user under control of dashboard).

 

Online Multi-dimensional modeling, online slicing & dicing ,charting & graphical analysis (thermostat, speedometer ,charts etc ) , drill-down to details for exceptional item etc are some of the essential features of dashboards.

 

Here is a sample of an excel based dashboard which gives online trial balance in multi-dimensional format with possibility to drill down to details from any database through ADODB.

 

Here are the links one can use to study , understand ,develop and use XL based dashboards.

http://www.erpjewels.com/Excel based Trial balance dashboard report.docx

http://www.erpjewels.com/trialbalance.xlsm

 

Getting graphs /charts with symbols like thermostat / speedometer etc are very easy. One can see umpteen online resource like following in the internet.

http://peltiertech.com/Excel/Charts/SpeedometerXP.html

http://chandoo.org/wp/2008/09/09/excel-speedometer-chart-download/

 

Happy dashboarding in excel.

0
No votes yet


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


©2001-2018 - Baanboard.com - Baanforums.com