Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
Which method you mostly follow during Infor Product implementation?
Waterfall
43%
Agile/Scrum
43%
Lean Development
0%
RAPID
14%
Total votes: 7

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 07:19.


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