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

Without a full data set to support the calculation, of any operational KPI, that you want to use to tune your manufacturing processes, its integrity will be called into question. Before embarking on a project to build that killer dashboard that will focus your team on improving the metrics that really matter, you need to make sure that the data that will inform it is complete and accurate.

Vital statistics

Performing a gap analysis on the significant sources of raw data is the first step on the road to a successfully utilised measure. Industry bodies such as APQC publish the definition of the metrics that you are likely to want to calculate, the difficult part is mapping the required inputs to data tables within the source. Increasingly cloud-based applications are shielding underlying databases from power users and even if you can get access, reviewing the array of columns can be a daunting task.

Leveraging the skills and knowledge of your analytics partner to identify the key data in question will accelerate your project, as the most important tables and columns will be prioritised based on previous experience.

Download the guide

Ruling out errors

Once you know the critical inputs to your metrics, defining business rules relating to your source production data is the next step. Examples of these rules might be:

  • Identifying empty or null values
  • Values that fall outside expected ranges
  • Values that have become orphaned from related records over time

Using bulk data management tools such as the Azure Data Factory in the cloud or the SQL Server Data Quality service on-premise, means you can build automation into the data pipeline that will feed your business metrics. Substitution, completion and enrichment of data can be carried out en masse with the help of your analytics partner and these rules applied to future regular data extracts.

Take control

In our experience, most manufacturing organisations don’t utilise any form of change management on key data assets such as:

  • Item masters
  • Bill of materials
  • Production routes

Introducing a business data controller, responsible for sense checking the completeness and integrity of all requests for change to the information that drives shop floor processing can be a very quick win. The benefits of putting data quality rules in place and applying them upfront, rather than reactively correcting issues downstream soon become obvious.

Adding a data quality dashboard to your toolset will help you monitor the overall status of data feeds coming from a line of business applications and other sources. Modern visualisation tools like PowerBI can also offer automated quick insights such as:

  • Outliers
  • Correlations
  • Changes in a data series over time
  • Trends and seasonality

But to take advantage of these, you need to have your dataset in the right place and to make the process optimal, remove duplicated or irrelevant data from the set.

Download the guide

Ready to begin your data audit?

The data that flows through your production processes is as much of a part of our business DNA as it is yours. If your business applications have been in place for several years, it's likely that the gap between the reality of your organisation and the data that models it in an application has begun to widen. It can also be the case that the people in your team who originally owned the data have moved on and key knowledge has been lost.

At Columbus our industry skills, expertise and experience mean that we can help you perform an audit that gets to the root of your data quality problems quickly without the need for large investments in new technology.

If you’re ready to take the first step towards a production dashboard you truly trust, contact us today.

Contact us


Discuss this post

Recommended posts

The hype around the rise of generative AI technologies makes huge promises about the potential of the technology. Yet it would be fair to say the majority of organisations are only experimenting with the technology or using it in isolated use cases.
If you organise your data and use AI strategically, you can make better decisions faster. You can for example improve your market understanding and forecasting, optimise your maintenance or reduce food waste. Choose what is most important for you!
Demand forecasters do the impossible — predict what products and services customers want in the future. Their forecasts inform decision-making about production and inventory levels, pricing, budgeting, hiring and more. "While crystal balls remain imaginary, machine learning (ML) methods can give global supply chain leaders the support they need in the real world to create more accurate forecasts." The goal is to produce exactly the amount of product to meet demand. No more. No less. Demand forecasting is used to anticipate the demand with enough time to manufacture the right stock to get as close to this reality as possible. The cost is high if you don’t get it right. Your customers will go to your competitors if you don’t have what they need. Unfortunately, capacity, demand and cost aren’t always known parameters. Variations in demand, supplies, transportation, lead times and more create uncertainties. Ultimately demand uncertainties greatly influence supply chain performance with widespread effects on production scheduling, inventory planning and transportation. On the heels of the global pandemic, supply chain disruptions and a pending economic downturn, many demand forecasters wish for a crystal ball. While crystal balls remain imaginary, machine learning (ML) methods can give global supply chain leaders the support they need in the real world to create more accurate forecasts.
If you have identified possible AI use cases for your business, the next step will be to test if they are possible to implement and if they will create great value. While there is a lot of momentum and excitement about using AI to propel your business, the reality is only 54% of AI projects are deployed. How do you ensure you’re one of the businesses that does unlock the new opportunities AI promises? Your success with AI begins by discovering AI use cases that work for your business. In the first blog of our Columbus AI blog series, we shared five areas where organisations should focus their efforts to generate ideas for AI implementations based on our experience. After generating some ideas for AI use cases that could potentially benefit your company from the first step of the Columbus AI Innovation Lab, the next step is to test which AI use cases could be operationalised by evaluating them. Columbus AI Innovation Lab
Only half of the companies starting an AI pilot project are actually executing it. The key is to choose an idea that will benefit your business. Read more about how! In 2022, 27% of chief information officers confirmed they deployed artificial intelligence (AI), according to a Gartner AI survey. Even though businesses across all industries are turning to AI and machine learning, prepare your organisation before jumping on the AI bandwagon by considering a few factors. Ask yourself: Is AI necessary for achieving the project requirements or is there another way? Does your team have the skills to support AI and machine learning? How will AI impact your current operations if you adopt it? How will you integrate AI with existing systems? What are the data, security and infrastructure requirements of AI and machine learning? The Gartner AI survey found only 54% of projects made it from the pilot phase to production. After significant investment in AI, why aren’t companies deploying it? We found the problem begins when companies define a use case. Too often, companies are not identifying AI use cases that benefit their businesses and end-users will adopt. The question is then, how should companies unlock the value and new opportunities AI promises? It starts with a systematic approach for each stage of the AI life cycle. We developed the Columbus AI Innovation Lab, a comprehensive method to address and account for all challenges when adding AI to your business operations and bring stakeholders into the process at the right time to help you operationalise AI.
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down