Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
What version of Baan have you installed
Baan IV
46%
FP3
4%
FP4
0%
FP5
0%
FP6
0%
FP7
4%
10.2 (incl. 10.2.1)
0%
10.3
7%
10.4
14%
10.5
21%
Other
4%
Total votes: 28

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 09:42.


©2001-2017 - Baanboard.com - Baanforums.com