What a Dashboard Is and Does

A dashboard is a collection of reports displayed together in one main report, where the only logic linking the resulting information is its relevance to the overall business strategy. Data can come from the same database, or from a number of different sources or databases. Even where the reports interrogate only one database, data can be reported in very different ways, and the results returned in a variety of formats.

This is where record-keeping methodology and software selection can help to facilitate the implementation of these BI tools. Many small business owners often assume that this is beyond their budget and fail to understand the greater benefits such reporting brings. In addition, the cost behind such implementation need not be substantial and can often be tailored to individual business needs. What is often critical is that the business starts with the right pillars or foundation. This is often overlooked or carelessly cast aside until bottlenecks occur when it is usually too late!

This high level view of the pertinent aspects of a business issue is an invaluable tool in the interpretation and communication of up-to-the-minute results, and an important aid to strong decision making.

The logical approach to all this boils down to 3 simple steps:

  1. Know your business objectives.
  2. Know what to do to accomplish the objectives.
  3. Know how to measure what your business do. If you can’t measure, you can’t manage.

Some practical starters for new business owners:

  1. Give some thoughts on your record-keeping. Your accountant should be able to work with you to give you an idea on the structure behind these records.
  2. Start with the simplest technology or software, taking into consideration future expansion. The simplest is not always the cheapest. Focus on productivity and efficiency in terms of administration as it will reap benefits for your business in the long run.
  3. Start only with a few drivers to measure your business. Do not be overly-ambitious with too many but really focus on the key drivers. If the wrong drivers are selected, they can always be changed. You can only tell they are wrong if they are being measured!


Programming Codes

HTML Template that is used to arrange posts in a consistent manner.

SQL Stored Procedures for processing pay runs

Excel VBA codes for processing csv files for accounting and bookkeeping

Excel VBA codes for Stock Trading

Excel VBA codes for Email Program

Excel VBA codes for Backup of Files of any Types

SQL Codes for Finding out information about Servers

VBA Codes for Designing a File Navigator with an Excel Table Output

VBA Codes for Internet Login

True Scholar

True Scholar Insights

I came across this in my readings and found that there are gems in applying scholastic perspective on the things that we do.

  1. Observation – To observe the matter-at-hand accurately and thoroughly. Many a times, we see ‘what we want to see’ but do we really see what we are actually seeing?
  2. Understand – To be able to comprehend clearly what we have observed.
  3. Evaluate – Assessing our understanding by making some decisions on what is true and valuable.
  4. Feel – To feel intensively about what we have considered to be true and valuable. This has to penetrate our heart if we are to be able to stand by strongly on what we have evaluated.
  5. Apply – The application of what we have learned in the first four stages and integrating that into our lives wisely.
  6. Express – The complete acceptance of what we have carefully thought through should be communicated to others, whether in speech, writing and/or deeds, so as to help convey the value of that truth that we have gleaned, in the objective of making this aware to others so that they may share in the joy of knowing the truth.

In my encounters with various business scenarios, the above concepts have being true in bringing about a carefully planned execution of ideas into making a positive change. Though there were failures, it only means that we are humans. But more importantly, the understanding of “failures” through the above scholastic perspective often brings about new open doors and opportunities that helps us to overcome limitations.

Source: “The Pastor as Scholar by John Piper”