Thomas is an expert in Supply Chain and Manufacturing Optimization with more than 10 years of experience originating from Medical Device and High-Tech & Electronic Industries. He comes with a background as an Electronics engineer, complemented with a Master in Technology Management. Thomas has held positions in multinational corporations such as Nilfisk, heading the internal optimization program as well as the supply chain organization.
The curse of isolated data islands
The other day I was enjoying a very nice ocean view. I was standing on the top of a hill and I could spot a few islands on the horizon. As I was trying to single out that island I was going to visit later that day, the whole experience made me think of the concept of isolated data islands.
What is a data island?
- When product quality data is stored in a spreadsheet on a laptop with no connectivity to the rest of the department.
- When customer data is stored in the sales database and the rest of the organization cannot access the customer data.
Isolated data islands are like those islands I could spot on the horizon because the distances in between those islands are like the disconnect between various databases. And while the view from above is nice and scenic, things start to become complicated once you need access to one of these islands because:
- Islands are difficult to get to as access is limited or rigidly defined.
- It also costs a lot more to “get to” the island. - Once you get to the island, you find out that you don’t speak the same language (file types are different and/or difficult to work with). - You also have to learn how to live (operate) in the island’s environment that will most likely feel very foreign, perhaps even intimidating.
Isolated data islands exist in all organizations
This scenario essentially reflects the situation that exists in companies of all sizes across the globe.
Companies have been using a wide variety of point solution applications and tools to support daily operational tasks such as change management, quality, tooling and requirements management etc.
By following this pattern, companies develop isolated data islands that are not shared nor maintained very well across the enterprise.
The curse of isolated data islands
The are several issues here.
- If data is not easily available to those who need it within the organization, they will waste an unnecessary amount of time searching for that data.
- Without a clear central data source, the risk of finding the incorrect version of that data increases dramatically.
The end result of data islands is that staff as well as managers make decisions based on incorrect data.
Departments turn to the Excel solution
Used by many, the Excel solution reflects the cheapest and most common solution utilized across companies.
This “powerful” tool provides the basic business functionality of being readily available, holding data, and providing the option to write simple code. As a result, it is used to implement “business applications” that is comprised of a combination of data governed by “business rules”.
The problem with the Excel solution
In time, the basic functionality of Excel will no longer suffice, due to the overwhelming size and complexity of the file.
What is more important. There is no traceability, no history and no collaboration tools integrated in Excel.
But it doesn’t stop there...
Because multiple departments exist within a company, several database products exist, as well. Sometimes, these products have simple functionalities and every so often, they even hold the same data across departments. This creates islands of data with duplicate data within a company. It leaves the question, where is the correct master file?
When each department or division possesses its own Excel, without any cross-departmental communication, data is shared without a centralized database to keep it normalized.
While new versions of Excel may be able to hold near 65,000 records, the bigger the file, the slower the access speed to data, which is delayed even further when complex codes are utilized.
How we can help
With Aras Innovator, we can provide a second to none configuration flexibility, with a centralized location for data that is authorized and scalable.
Aras Innovator covers all drawbacks that generally accompany customized applications. With Aras, all customizations made is guaranteed to be upgraded as part of the subscription agreement. This means that there is no risk of being left on old unsecure technology, or that an upgrade will turn into a costly re-implementation. With Aras, you can get exactly the solution you need, that solves your specific needs and requirements. And in addition, it is future proof, and the cost is 100% predictable. All in all, Minerva and Aras Innovator offers the full package for product data management.