• Skip to main content
  • Skip to footer

Abbotts

  • Home
  • About Us
    • Abbotts History
    • Our People
      • Directors
        • Andre Parker
        • Bez Esquivel
        • Bradley Abbott
        • Briony Knott
        • Christopher Higham
        • David Drake
        • Eric Ballard
      • Associates
        • Melissa Hansen
        • Stephen Hollyock
      • Client Managers
        • David Chang
        • Elliot Moses
        • Gabrielle Zonato
        • Vishen Bisnath
      • Finance Brokers
        • Bez Esquivel
      • Financial Advisers
        • Andre Parker
        • Amanda Kirkpatrick
        • Briony Knott
        • Fiona Chua
        • John Donald
        • Michelle Baker
      • Accountants/Bookkeepers
        • Angeline Camaya
        • Lewis Grant
        • Debbie Byrnes
      • Administration
        • Anne Abbott
        • Jaymee Sunder
        • Kevin Thomson
    • Careers
    • Our Philosophy
    • Social Responsibility
    • Testimonials
    • Our Clients
  • Services
    • Taxation Services
      • Taxation Compliance
      • Strategic Planning
      • Capital Gains Tax (CGT)
      • Fringe Benefits Tax (FBT)
      • Goods & Services Tax (GST)
      • Business Structures
      • Research and Development
      • Foreign Taxes
      • Tax Deductions
      • Tax Audit
    • Business Services
      • Commence a Business
      • Run a Business
      • Succession Planning
      • Advisory Services
      • Systems Integration and Support
      • Corporate Secretarial
      • HR and Payroll
    • Finance Broking
      • Loan and Borrowings
      • Venture Funding
      • Debt Management
    • Wealth Management
      • Establish Your Wealth
      • Execute Your Strategy
      • Maintain Your Strategy
      • Strategies and Structures
    • Superannuation
    • Bookkeeping
      • MYOB Bookkeeping
      • MYOB Setup and Training
      • Xero Bookkeeping
      • Systems Integration and Support
      • HR and Payroll
  • Industries
    • Farming and Agribusiness
    • Supermarkets
    • Medical
    • Construction
    • Pharmacy
  • Insights & News
  • Client Portal
    • Make a Payment
    • myprosperity
    • MYOB Document Portal
    • Resources
  • COVID-19 Hub
  • Contact Us
You are here: Home / Advisory & Business Services / Reporting: Why too much data is a problem and how to prevent it

Reporting: Why too much data is a problem and how to prevent it

May 14, 2019 By Aaron Davidson

Gathering data is a part of business. From needing financial data to produce accounts that are submitted to statutory bodies like the ATO to reviewing your sales data to see how many widgets you are selling, every action in a business produces it and systems are generally in place to capture that information.
The information collected by a business can be a key source of knowledge to be used to assess potential changes and improvements. It can also be used to compare your performance with targets (budgets), historical trends and the performance of competitors and industry participants.

Despite the obvious advantages data brings, correctly using it can be a difficult balancing act. You might know the name of each customer that enters your store, but do those customers really want a salesman they have never met greeting them by name? Some data needs to be paired up with personality and put into context before it can be used effectively. Similarly, you might have data detailing sales for 30 sub-departments within a retail store, but when is the data too useful for its own good and you end up micromanaging details and losing sight of the bigger picture (and profits)?

When looking at the data a business has available, I like to rate it using a ranking coined “the Goldilocks principle” – based on the fairy tale of Goldilocks and the Three Bears. In the fairy tale, Goldilocks tastes three bowls of porridge, finding she prefers porridge that is neither too hot nor too cold, but has just the right temperature.

The same idea can be applied to the data gathered from a business. You want the right type, amount and detail of information necessary in a report to maximise effectiveness for you as a user, while minimising information overload and redundant information (“too hot”) and avoiding incomplete and inaccurate results from not using enough data (that can be seen as “too cold”).

What does it look like when your information is “too cold”?

To define a report on the financials of your business as “too cold” means you are either not collecting otherwise available data or having trouble extracting the right data from the systems. The lack of information might not be obvious at first but once you try to compare against an industry benchmark or past or planned outcomes you may quickly realise the data that has been gathered is lacking in one respect or another.

You may for example extract data for completion of your BAS requirements but fail to analyse that data for performance appraisal because it is extracted in a manner that is suitable for tax reporting but lacks the depth for performance reviews.

You may be able to conduct a top-down review of sales volumes but miss the opportunity to determine the reasons behind sales growth or contraction at a deeper level.


In this example, a comparison on a stores departmental sales is being made to an industry benchmark. The lack of available information leaves the comparison lacking. The data is from different levels of depth, and cannot be compared in this context with any relevance. As a result, little if any knowledge can gained from the comparison.

How can your use of information become “too hot”?

You would think that having more and more data to review is never a bad thing. It provides the opportunity to review details of a business through multiple levels of detail and if you use my grocery store example from above means you can follow down the chain, splitting transactions down in depth. This allows you to examine unit and divisional performance and the effectiveness of your resource allocations.

Too much data however exposes you to the risk of having conflicting conclusions and can result in each set of data not being given enough intellectual space to allow it to be properly examined. You may end up with raw data that does not reveal valuable management information or you may be drawn to data sets that lack enough relevance to justify their own existence in a performance report or even draw your attention away for other more telling analytics.

An abundance of data can look impressive but may end up being more of a hindrance than a help.

If your business regularly reviews ratios like net sales-to-wages, do you really need to detail 20 different types of cost of sales to get to that figure?

Use the information you really need to make it “just right”.

So far we have discussed how reports that lack adequate detail can result in lost opportunities to gain knowledge form readily available data. Similarly, there are other reports that provide so much detail that they may lose their relevance and simply waste the readers time or draw a reader to an incorrect or erroneous conclusion.

What you want to see in a financial or management report is that happy middle – the Goldilocks region of being “just right” – where the reports created for your business provide just the right level of information and depth to influence the viewer and positively impact your business health. By accessing the full depth of data available and then filtering, summarising and re-configuring for relevance and readability as a set of valuable management reports, the business owner is then able to identify the messages it is conveying.


The team at Abbotts knows how to collect and utilise the information created by your business and in consultation with you can produce customised management reports that identify the key revenue, expense and capital drivers that define your businesses success.

If this sounds interesting and you would like to know more, please get in touch with us using one of the forms on our website, via email at recep@abbotts.net.au or phone us at (08) 9321 2642.

Filed Under: Advisory & Business Services Tagged With: advisory, business advice, grocery, management accounting, medical, metrics, reporting, supermarket

Aaron Davidson

Footer

Connect with Abbotts Group

+61 8 9321 2642

+61 8 9322 1385

recep@abbotts.net.au

PO Box 414, West Perth WA 6872

813 Wellington Street, West Perth WA 6005

Abbotts

Disclaimer | Terms of Use | Privacy
Liability limited by a scheme approved under Professional Standards Legislation.
Abbotts Wealth Management Pty Ltd (AFSL 303138)
Abbotts Finance Brokers Pty Ltd (ACL 467436)

Our Services

Taxation Services
Business Services
Finance Broking
Wealth Management
Superannuation
Bookkeeping

Copyright © 2022 · Gallery Pro on Genesis Framework · WordPress · Log in