How to prevent a computerized product data mess?

How to prevent a computerized product data mess?

The original article was published?on my?Beyond PLM blog

Data is taking a central stage in everything that businesses do these days. You can hear about digital strategies and digital transformation every day today. So, let's bring computers and solve the problem of data mess. Not so fast. For most companies, bringing computers actually ends up with not solving a problem, but creating a computerized mess. How to prevent it and what indicators will tell you that you're moving from data mess to computerized data mess? I'm continuously hearing top managers, engineers, procurement, and other departments of manufacturing companies speaking with growing concerns about the data and their ability to perform their work. According to many people, I'm talking continuously, here are 5 concerns they have about the data.

5 Indicators of Product Data Mess

1- One Crucial Spreadsheet. There is one important spreadsheet that collects a very important set of information that is critical for many people and represents centralized storage of data about products. This data is managed by multiple people and departments. The data can be outdated quickly if it is not updated. At the same time, updating this data manually requires too much time and effort. You hope this Excel will be secured with the top priority.

2- Data Traceability Mess. Each project is represented by an Excel file that includes components, assemblies, and corresponding data such as quantity, suppliers, cost, and other information. The person who created it is your data mastermind (or Chief Excel Officer), but there is no easy way to trace data relationships back to the original - design data, additional materials, type of information cost, suppliers. You hope the questions about traceability won't be asked every, because they are hard to answer.

3- Parts, components, materials are listed multiple times differently in multiple Excels. The data identification is a mess. You might have multiple projects Excels with the same components named differently. The data was entered by different people at different times. Each Excel by itself is important because it represents a critical piece of product data, suppliers data, cost, and other information. However, the task of consolidating these multiple Excels together is overwhelming, so you continue to go into this vicious cycle again and again.?

4- There are no measurable KPIs to quantify product design, cost, suppliers, procurement. It is easy for companies to quantify sales numbers. Most companies' sales numbers are known. However, to connect this information to product, design, suppliers, cost of materials and other information is not. What was the actual cost of the equipment produced and sold? Such a question can put in a freeze mode an average operational manager in a medium-size manufacturing company with next to impossible probability to get these numbers and connect the cost of actual inventory used to build a product to sales cost.

5- IT reports are always late and irrelevant when delivered. Company effort to collect information from multiple places is hugely underestimated. It is very common to take multiple weeks to produce an actual project cost report, monthly analytics takes 30 days to produce and the impact of lead time change on supplied materials takes longer than lead time itself.

?Where is THE button?

When companies are coming to me with such a level of problems, I ask them about what is the plan to make a change? Unfortunately, for many companies, this is quickly becoming the hardest moment. They don't know. Companies live in such a mess, but they use TLAs way of silo thinking about finding a solution. Unfortunately, many of the companies are thinking about how to import all Excel data in some magical system that will solve all problems and also looking for a button that is supposed to be called - "Make all work".?Unfortunately, both methods are not very helpful.

Data Strategy and How to Make a Change?

The change is hard and when it comes to the data mess, it is even harder. There is no other way than to make your hands "dirty" with the data and start cleaning your data records and eliminate the mess. But, things should not look too gloomy if you apply a structured process that can help you separate tasks and make changes by stages. Here are 3 important steps to make:

1- Think about data identification first. For many companies, it starts from Part Numbers. Once you know how you identify what you use, life will be much easier for you, because ABC-123, will mean only one thing.

2- Focus on a centralized catalog (Item database) of every material, component, assemblies, part you use, and how you collect information about each item and establish the process of new item creations and re-use. New Part Numbers are expensive, especially when they apply to already existing items.

3- Prioritize data sharing and re-use. To have updated information trumps everything else. Knowing that you work "on the same BOM" can solve thousands of problems you will have otherwise.

What is my conclusion?

Don't bring computers in your messy data? You will end up in a bigger mess. Spreadsheets are quick to create but terrible to share, update and manage. Bringing all your data into a spreadsheet can give you a false sense of ownership, structure, and protection, but will not solve the fundamental problem - data identification. reuse and sharing. Focus on these three priorities and build a roadmap to get out of the data mess. Just my thoughts…

Best, Oleg

Disclaimer: I’m co-founder and CEO of?OpenBOM?developing a digital network-based platform that manages product data and connects manufacturers, construction companies, and their supply chain networks.?My opinion can be unintentionally biased.

要查看或添加评论,请登录

Oleg Shilovitsky的更多文章

  • In-Person CIMdata’s 2022 PLM Market & Industry Forum Is Cleared For Takeoff

    In-Person CIMdata’s 2022 PLM Market & Industry Forum Is Cleared For Takeoff

    Dear friends, I'm super excited. Later this week, I will be attending the first in-person PLM event for a little bit…

    3 条评论
  • RIP PLM IT?

    RIP PLM IT?

    The original article was published on my Beyond PLM blog No man is an island. And the IT department shouldn’t be one…

    8 条评论
  • How PLM Will Expand Into Electronics and Semiconductor Design

    How PLM Will Expand Into Electronics and Semiconductor Design

    The original article was published on my Beyond PLM blog Today's manufacturing environment is changing more quickly…

    1 条评论
  • Open Semantic Data Modeling Layer For Connected PLM

    Open Semantic Data Modeling Layer For Connected PLM

    The original article was published on my Beyond PLM blog Connected PLM transformation is one of the strong trends I can…

    9 条评论
  • Connected PLM Transformation

    Connected PLM Transformation

    The original article was published on my Beyond PLM blog The weekend is a good time to catch up on multiple…

    2 条评论
  • Getting Ready for PI DX Spotlight - Is a Truly End-to-End Digital Enterprise Achievable?

    Getting Ready for PI DX Spotlight - Is a Truly End-to-End Digital Enterprise Achievable?

    The original article was published on my Beyond PLM blog Today's manufacturing companies are facing challenges that go…

  • Data Model Evolution For Future PLM Platforms

    Data Model Evolution For Future PLM Platforms

    The original article was published on my Beyond PLM blog Data is at the heart of every PLM technology and system…

    3 条评论
  • How To Sell PLM To Engineers?

    How To Sell PLM To Engineers?

    The original article was published on my Beyond PLM blog For the last two decades, PLM was developed in the…

    2 条评论
  • PLM Upgrades Trends

    PLM Upgrades Trends

    The original article was published on my Beyond PLM blog I spent some time this weekend catching up on PLM news and…

  • Demystifying Modern PLM - Event, Videos, and Slides

    Demystifying Modern PLM - Event, Videos, and Slides

    The original article was published on my Beyond PLM blog As COVID hit the world, the PLM industry, like many other…

    2 条评论

社区洞察

其他会员也浏览了