Hitesh Shah
17th January 2010, 20:00
A new blog entry has been added:
Excel based dashboards Sample
<span><span> 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).
<span> 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.
<span> 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/Excel%20based%20Trial%20balance%20dashboard%20report.docx)
http://www.erpjewels.com/trialbalance.xlsm
<span>
Getting graphs /charts with symbols like thermostat / speedometer etc are very easy. One can see umpteen online resource like following in the internet.
Excel based dashboards Sample
<span><span> 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).
<span> 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.
<span> 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/Excel%20based%20Trial%20balance%20dashboard%20report.docx)
http://www.erpjewels.com/trialbalance.xlsm
<span>
Getting graphs /charts with symbols like thermostat / speedometer etc are very easy. One can see umpteen online resource like following in the internet.