Fred Servillon


	Flash Version on Metrics
	How to Create a metrics Dashboard


	email me


	fred@servillon.com

Basic knowledge in creating a simple effective metrics dashboard-

Using HTML page to display parameters and embedding script of your choice to read data from a data source using the ODBC function available in the web server can make you build your own simple effective metrics dashboard. In this example I used vbscript for ASP scripting and javascript applet for the scrolling message. If you know how to create HTML page and a script, I can send you the scrolling message applet for free.

Below is the applet used for 3 scrolling message with different variable messages applied

Although reading data from a database server is not much load for a simple query, I prefer retrieving the data fields storing to an array variables so the connection can be closed immediately.

Here’s the script to display the data per site codes.

The color of text or background can be a function variable so that it can interact with the latest values retrieved. For example it be a red color if it’s critical and green if acceptable or good.

<% for y = 1 to TOtalSite %>
 <td><%= SiteName(y) %></td>
 <td align="center"><%= SiteCompleted(y) %></td>
 <td align="center"><%= SiteActive(y) %></td>
 <td align="center" bgcolor="<%= GetAttention() %>" >"><%= FOrmatNumber(SitePercent(y),2) %> %</td>
 <td align="center" bgcolor="<%= GetBLSAttention() %>" >"><%= FOrmatNumber(SiteBLSPercentCompleted(y),2) %> % " >(<%= FormatNumber(SiteBLSCompleted(y),0) %>/<%= FormatNumber(SiteBLSTotal(y),0) %>) </td>

As a working technical person, we are all involved with a lot of work that are repetitive and time consuming. So if you want to be consistent in your tasks, play with any progamming tool that are available to you.

I have developed quite a few applications in my own initiative to face the challenge of efficient processes in institutions or places that I worked for in the past and present and all were kindly appreciated and none of those were actually sold to the public.

One example is the linen tracking usage for a hospital in the north-east where the institution wanting to manage and control the linen usage in terms of amount per patient, per day, per department and summarized reports for particular date range. By using my software, the environmental service management was able to raise awareness of the linen usage and substantially reduced the amount of usage every year and also made budgeting easier to do.

Another web-based application that I created that a software company have taken the idea from is my Service Dispatch application. A requester can go on line and submit a service request while the Dispatch center monitors the incoming request automatically appearing on the screen monitor and immediately taking appropriate response.

Another web-based application is a text paging system where it is used for communicating among co-workers, family and friends using their pagers and cell phones. If used in a business place, an employee can set the time range when he/she is available so that the font color with his/her name on would response correctly, for example color green would indicate that he/she is available, yellow would mean he/she is off, and red if he/she set his device setting to off.

For comment email Fred Servillon


	DESCLAIMER:The users assume the risk of using the services directly or indirectly AND IN NO EVENT SHALL Fred Servillon AND OWNERS BE LIABLE FOR LOSSES, DAMAGES, OR CLAIMS ARISING OUT OF THE USE OF THE SERVICES OR CONTENT IN THIS WEBSITE