<img src="https://secure.leadforensics.com/133892.png" alt="" style="display:none;">

Business never stands still. The growth of the vital transactional databases that support your manufacturing operations is something that your technical guys will have covered, but are they best placed to help you as a business leader decide what you’re still storing and for how long?

Each day an endless stream of new data such as item records, bills of material, production routings, time and finished goods bookings is created on your shop floor. A lot of time and effort is put into creating accurate new data to take you into the future, but how much thought is given to tidying away the past?

5 S for Data

If you’re familiar with the 5 S methodology, you’ll understand why the philosophy of a place for everything and everything in its place is important in the physical world – it’s also equally vital in the digital.

Volumes have been written around the tuning and performance of databases from an IT perspective but applying some sound principles that will institute regular archiving regimes can also help in this regard.

Consider how many product ranges may have been discontinued in recent times and consider the records relating to them. It quickly adds up, not necessarily to a large capacity requirement in terms of data storage, but rows and rows of data in reports and on screens that your team are scrolling past, or wasting time filtering out unnecessarily.

There are efficiency gains to be made from reducing this source of waste from a technology and people point of view.

Sorting and setting in order

Regularly asking a few simple questions of the tech and data savvy members of your team can be quite revealing. For example:

  • How many inactive BOMs are we storing?
  • What’s the number of routings for obsolete products?
  • Which bought-in components have not been purchased over the past 5 years?

Working with the business to define an audience – i.e. a subset of your data which is simply now a distraction and a source of waste, is a task that will allow you to create a set of policies for operational data retention. It’s time well spent and should be carried out at regular interviews, preferably driven by some data quality reporting.

You might wonder, what happens if we simply delete all this obsolete data, won’t we break the system somehow and destroy our historical reporting? No, is the answer, if you take the right approach to setting your data in order.

Archives you won’t even realise exist

Tools such as Azure SQL StretchDB allow you to take the retention policies you’ve defined and translate them into automated actions that will declutter your transactional databases.

For example, if you have an on-premise SQL Server database holding manufacturing execution records, you can archive data that is accessed least often, automatically to the cloud. The process happens in the background and the storage location becomes transparent and most importantly, if the data is needed again, it is accessible immediately. No re-writes of code or reports are necessary.

AzureStretchDb

 

The data can be encrypted whilst at rest in the cloud and you retain all the access control features normally associated with SQL Server. Data is also automatically backed up as part of the process.

Backup and database maintenance times are reduced, once data is moved off-premise, which translates to an increase in system performance and overall uptime of key operational systems.

A word of caution however, not all databases will be compatible with this approach, so check with your data partner before making any implementation plans.

Ready to streamline?

If you feel you could benefit from applying some Digital 5-S to your datasets, our data consultants are waiting to help you define your requirements and implement a pilot project to prove out the ROI related to good data grooming.

Click below to download our guide to using PowerBI to enable Digital Six Sigma within your operations.Learn More

 

Topics

Discuss this post

Recommended posts

A successful data breach can ruin a brand’s reputation in the competitive online world. Though some companies can salvage their reputation and remain relevant in their industry, many never recover from a data breach. You should never assume that your disaster recovery plan will be able to save your company if this type of disaster occurs. In fact, you should be tightening your cybersecurity measures across all online touchpoints and invest in preventive measures. This blog explores the anatomy of a data breach, what it can look like, and what you can do to keep your brand and your customers safe. Here’s what you need to know.
Many companies don’t see anything wrong with their data quality, management and governance processes. But upon examination, this often isn’t the case. It’s easy to forget how big of a role humans play; your people are an important cog in the stream of data. They contribute to these streams and if they’re inconsistent in their approach, it can lead to issues further down the line. I talk about this topic in more depth on an episode of Migration Minded, a podcast series created by the D365 Migration Community. Hosted by Tom Wisniewski, Microsoft’s Global Product Marketing Manager for Dynamics 365, he asks me about cloud migrations, the importance of change management, data management and more. Listen to the episode below (or watch it here).
Data has increasingly become an asset in its own right, capable of identifying and generating extensive business value in today’s digital-focused world. Data monetisation alone is a growing industry with an expected growth rate of 24% by 2027. There’s no doubt that it’s set to become more valuable this decade to those who fully embrace it.
A 2021 McKinsey report found that the use of artificial intelligence for marketing efforts, business processes and product/service development has become widespread. In fact, 56% of respondents said their business uses AI for at least one function, which is a 6 percentage-point increase from last year. 
Microsoft Power Apps, which is part of the Power Platform stack, was launched to allow organisations to quickly and easily create custom apps, regardless of your coding knowledge. Power Apps allows users to drag and drop components to create apps. Not only does this remove the need for manual code and programming knowledge, but it also makes app development much faster and more convenient.
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down