It’s not uncommon to see food companies having much of their business reporting run from spreadsheets. Excel is ubiquitous in offices for several reasons: spreadsheets are easy to use, easy to learn, and cheap compared to dedicated software.
It can be a great way to mine and output simple data, but how sustainable is it as your business grows and demands more information in a data-driven world?
While spreadsheet software today is inexpensive, the hidden cost is in the resource that is maintaining these outputs. Data is being pulled from multiple sources through manual refreshes and data entry before being processed with formulas and filters on products, locations and suppliers. Regular monthly reporting can often take days of effort to produce each time.
With so much manual effort and manipulation of data, it’s hardly surprising that the accuracy of data can be lost. There are various studies that report nearly 90% of spreadsheets contain errors. When this data is used to make important business decisions, the accuracy of the data is essential, and any errors can have significant impact.
Security is vital
With the advent of GDPR this year, companies need to be very mindful about where and how the data is stored; having sensitive data stored in unprotected files carries a high level of risk. That’s without considering that not all the data is suitable for everyone in your business to see. You might be able to protect a sheet or a workbook, but you cannot filter the data that can be accessed. With no audit trail, it becomes very difficult to figure out who has accessed the data and any changes they may have made.
Muddy Boots allows you to customise your own reporting through Insights Self-Serve functionality, our data analytics tool powered by Tableau. Muddy Boots curate and manage data sources that you can report from to ensure integrity. Security is built-in, so that only elected users can access the data and row-level security means they only access the data they should see, with full audit history.
Once you generate your dashboards, you can schedule these (along with our standard dashboards) on a daily, weekly or monthly frequency. The entire process can be automated saving many man hours and increasing efficiency.
Contact your account manager or get in touch to find out more about how Muddy Boots can help you overcome your spreadsheet woes.