<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

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.