Last year, I was traveling between St. Louis. MO and St. Paul, MN. I looked at the screen on the back of the seat in front of me and learned that I was somewhere off the coast of Africa. In fact, since my time to destination was zero, it appeared as though I had already landed in Africa. Now, clearly that was wrong and my initial thought was that I hoped that the navigation system the pilots were using was more accurate. But it triggered another thought. It reminded me that I rarely believe much of what I hear, read, or sometimes even see with my own eyes.
In a day and age when there is so much information available coming at us with such a frenetic pace, it’s more important than ever to vet it yourself, or at a minimum, to make sure that someone who you know and trust has done so.
I deal mostly with financial data but when trying to understand any data set, it’s important to keep in mind that it’s incredibly easy to download large amounts of data into a spreadsheet or to look at the number at the bottom of a multi-page report without ever digging into the detail to understand how it was compiled. This is a poor practice and often leads to spurious conclusions.
Here are a few examples:
- An analyst at a client firm recently delved into a spreadsheet and found multiple errors. On the surface it looked fine, but a deeper understanding revealed links that went to the wrong place. Fortunately, he found the issues on a timely basis.
- I recently looked at two key items on an inventory report. Upon questioning them, we found that both were in error. Accepting the report at face value would have resulted in mis-stating profits by $100,000 for the month.
- An executive at one of my clients read a division profitability report (which is technically correct) and drew the conclusion that eliminating a few divisions which have small losses would make the company more profitable. But just the opposite would happen. Those groups absorb substantial company overhead that would get allocated elsewhere if they didn’t exist. Not understanding how the reports are produced, and how they are intended to be used, lead to the wrong conclusion.
Whenever I see a report, hear a conclusion, or read the “headline” I almost always seek to learn more about the underlying data, how it was produced, and whether or not the inputs are valid. Does the data really support the conclusion or are there flaws in the data or methodology, that if corrected, would lead to a different answer?
Don’t take anything at face value – otherwise you’ll get off a plane believing that you’re in Africa when you’ve never left the United States.
If your business could benefit from fractional CFO services, I would welcome the chance to speak with you. Please give me a call at (314) 863-6637 or send an email to [email protected]
The archive of these monthly newsletters is posted at the Resources section of homza.com
your cash is flowing. know where.®
Ken Homza
Copyright @ 2020 Homza Consulting, Inc.b