Tag Archives: data analysis

Guiding your effort

Management information is used by organizational leaders to help them gauge the efficiency and effectiveness  of the  things being managed, that is the resources within their purview (e.g., people, product, physical assets,etc.)

Ultimately this information is used to inform decision making.  In today’s environment the information is largely in digital form and the tools managers use are called management information systems (MIS)

Technology is an Enabler

This categorization (MIS) puts a technology spin on the information gathering, storage, sorting and retrieval. (often referred to as Extract, transform, load – ETL)

However, management information is not about or even truly bound to the technology.  Technology is just a tool, and that is an important distinction . Some often have difficulty with this separation.

When I first started in business, (in the dark ages) the tools used in the gathering and recording were pen and ink, the sorting was pure brain power.

Interpretation of the information was largely manual, as it continues to be today although automation, i.e., artificial intelligence, is beccoming more and more prevalent.

An Example

There are of course a myriad of information types, interpretations and uses.  The following example is intended to be illustrative of data you might collect, transform and analyze, for management purposes,  highlighting the benefits of doing this.

Whether this is an automated process, fully manual or a combination is not the point, rather just why you would collect management data and how you can use it to, well, manage.

Time Reporting

How do the human resources in your organization spend their time? First you could ask each person record their time by category (e.g. customer support, project work ,operations, administration) over a defined defined period.

By amalgamating the teams results you can get an idea on what type of work your group is focusing on.  This does not account for individual variations ( it is a group measure) but on the whole you can determine if the groups efforts are directed according to your strategic expectations.

If not, you can investigate, determine the cause and make course directions.  Without this type of data you are just guessing, so it really is invaluable.

Torturing the Data

A colleague of mine made an interesting observation today relative to a discussion about using data to draw conclusions.   “If you torture the data long enough, it will confess to anything”

There must be a reality

This is an interesting twist of words.  There certainly is some truth to the implication that a given set of data can support a variety of truths.

The reality, however, is that data does not speak, only the human interpreters do that. The point is really about salesmanship.  Interpretation of data has a subjective component.

My own personal experience with this comes from years of developing business cases.

I used to brag (cynical me) that if I was advised the organizational threshold for rate of return (aka the hurdle rate) I could document a business case that would result in approval to move ahead, every time.

The sad part of this boast is that I have been crafting business cases since 1980 ( for various organizations) and in over 35 years I have never had one business case proposal rejected. (I did not count them but we are talking about lots including one for several hundred million)

Back to the Point

Based on my own experience of torturing data, truth is, getting the data to say anything was not about the data but all about my ability to interpret, organize even shape the story the data told.

The data, well it was silent putty in my hands.

I do strongly recommend questioning and validating proposals, however my advice would be to focus on the story as oppossed to the data itself.