Fri 14 Sep 2012
Business Intelligence, Where Art Thou? (1st of 3 part BI Series) [Guest Post]
Posted by me under business , how tos , softwareAdd Your Comments
Business Intelligence? More like Business Misinformation…
As CFO for a Salt Lake City eCommerce company (annual revenue 17 million), I am frequently asked about how we make and lose money, where we can save dollars and how we can increase profitability. Stakeholders want timely, actionable business intelligence (BI).
Based on my experience, stunningly enough, most companies (from large to small) have highly anemic BI systems. But BI is one of the most important business tools; effective biz-intel gives instant feedback to management about how the company is performing. Traditionally, we rely heavily on financial statements like the cash flow statement and the balance sheet and ad hoc reporting to provide business performance insight. These traditional methods are rendered less effective because of the time delay of financial statements and one-off report preparation. Financial statements are completed typically 1-2 weeks after a month is over. In many industries, that information is too stale for good decisions, and the feedback is too late for agile AB testing of business initiatives. In many cases, untimely intelligence is worse than no intelligence at all.
To better understand business reporting, I’ve broken it into three sections:
- Historic: Historical reporting is financial statements that are prepared by the accounting department. These are typically used for external entities like banking and investors.
- Current: Current reporting is much more effective for day to day business management. This is BI reports and managerial accounting.
- Future: Future reporting is projections and forecasting. This is for planning, acquisitions, and obtaining debt and equity financing.
Each of these categories is crucial for business success, but the #2 (current) is the one most neglected and yet most important for day-to-day business operations. Fast and accurate current reporting is a proven competitive advantage. Effective current reporting makes businesses more adaptable and nimble in the ever changing business environment. Many companies have initiative to create business intelligence, but most have been unsuccessful, wasting large sums of money. A quick brainstorm netted these 5 major obstacles to effective BI:
- PLANNING: BI needs to be a well thought-out plan that doesn’t necessarily require hundreds of thousands of dollars purchasing software and servers. It always seems like companies are just throwing money at the situation and still cannot create effective BI.
- KNOWLEDGE: BI is created by technical types. Techies are the ones that know how to create advanced queries and display the custom data, but techies are not usually trained on creating usable and intuitive reports. This was the biggest issue with my company. Techies created BI reports but they were very misleading (and often inaccurate). So in order for BI to be effective you need the fusion of technical know-how combined with skill in financial and business reporting.
- ACCESS: Real-time access to the underlining data is extremely important to creating effective BI. The I.T. department wants to protect its data for stability, and the finance department wants to protect its reports for privacy. Of course the data is confidential, but there are ways to summarize data and not provide all the details.
- DISPLAY: It is very important to display the data in an effective format. If all you display is a line graph of daily sales for the last month, that really doesn’t say much. Sales should be compared to the past – recent past and distant past – to give a comparison.
- SPEED: When creating a single dashboard that summarizes millions even billions of database records, speed becomes a major obstacle. On my next blog post I’ll talk about how I overcame report slowness.
STAY TUNED:
In the next installment, “Zero to DIY BI in 30 days”, I’ll explain how I surmounted these obstacles, and how we went from bad data to effective BI in 30 days. We’ll talk about integrations, real-time data, data warehousing, KPIs, and iterative development.
Matt Budd, CFO
With contributions by Ryan Byrd, CTO
picture credits: Confusion by Adi Ron (2005)