Kamis, 18 Oktober 2012

Creating Metrics for your Digital Dashboard

by Albert Anthony D. Gavino



Most businesses think or Educational Institutions think its pretty easy to make a digital dashboard, when in fact its not, the first thing you may want to consider is your available data, now if your data is in MS SQL server or in one intact database and assuming most of its records are clean and quantitative in nature, which means they consist of dates, binary codes (1,0), income levels in one rate then they are good to go, However if your database is in rotten or dirty condition, doing a data mining is not a good idea.

Furthermore, you may want to consult with your Board of Directors what kind of metrics they want, is it a metric of INCOME, what is the target Income for this year, these things are important in establishing your dashboard, which in turn will become valuable reports real-time. Its the same scenario when your buying or selling a certain stock, the data is in real time.

for example:
Number of Actual Students for SY 2011-2012: 5,000 (is your actual data)Target Metric of Students for SY 2011-2012: 6,000 (is the metric set by your BOT)
Also consider the power of your hardware in your company or institution, this way, when users query reports on your dashboard it will be speedy.

Digital Dashboard/ Business Intelligence Software

  • Qlikview
  • Cognos Insight
  • Oracle Business Intelligence
  • Dundas
  • Microsoft

Online Applications:

One of the famous free apps you can find on the web for your dashboard solutions for a website is your friendly Google Analytics apps, Google analytics is free and tags your customer base globally and regionally, most of its stats are based on IP addresses and even be used for marketing such as Google Ad Words.

to get a google analytics account you will need a gmail account and just sign up to this URL, http://www.google.com/analytics/ Voila! you know have a digital dashboard for your web site.

to set your own metrics, Google Analytics allows you to set them on your goals and objectives.

Who uses Business Intelligence and Predictive Analytics Software?

  • Banks who approve house loans, credit loans
  • Credit card companies who approve credit card applications
  • Education institutions who would want to screen for scholarship applications



Tidak ada komentar:

Posting Komentar