Dependency on Spreadsheets and Super Users is Loaded with Risk…

Posted by Maurice Lynch

09-Feb-2017 12:29:21

There are several articles on the internet telling us Microsoft Excel might be the most dangerous software on the planet.

Not that Excel is not useful or can, by itself, launch destruction upon humanity. However, the dependency most companies have on their Super Users can be an extreme risk exposure to their own sustainability.

When a business is growing and changing, the initial phase where the business intelligence is gathered is the spreadsheet. On the growth path the spreadsheet also outgrows its capacity and usefulness.

For various reasons, it is important for a business to acknowledge the tipping point where the use of the spreadsheet turns from being useful to being a hazard.

Not only is the “system” no longer adequate but the risk of losing the resources that manage and manipulate the data becomes a major headache that needs to be addressed.

This is the point where people reach out to companies like nathean.com and ask Can you provide a more enterprise approach? Can we de-risk the fact that somebody has an Excel spreadsheet on a hard drive? Can we get them out of “Excel Hell”!

 

 word cloud risk2.png

Companies find themselves at risk as they can’t really train somebody on someone else’s Excel macros. Furthermore, we have the overarching problem of people emailing spreadsheets around to each other so immediately the data is potentially changed, with the corrections being unaudited.  There is no governance hence “Excel Hell” is putting your company at risk…

It’s not untypical that we see data stored in disparate data silos such as spreadsheets, relational databases, flat-files, legacy databases and so on. Traditionally someone is tasked with manually pulling together a set of reports from various data sources. This process  is error prone and high maintenance in terms of person-hours and not easily automated or scaleable.

The aim is to reach a stage where all the information can easily be presented on dashboards, with meaningful charts and graphs, allowing business decisions to be made based on what the data is saying. Additionally, they must consider how long it takes to get from where they find themselves to where they want to be in terms of information management.

The first step is to get a handle on the sources and quality of data; put in new business systems and processes to capture the data in a more formal way rather than continually pumping data into spreadsheets.

 

 

What Nathean Logix’s gives is a complete view of your information and helps you on the journey to those wonderful visualisations.

Get in touch with us at nathean.com and learn about our Analytics & Reporting platform Logix which helps customers get new meaningful insights everyday from their data.

 

Topics: Business Intelligence, Business Analytics