In this article, we will follow a manufacturing company that wants to better monitor its production to optimize its performance and efficiency. With this in mind, it undertakes the set up of a tool capable of enhancing production management.
Evaluate your production to optimize performance and efficiency through a production dashboard
For a modern manufacturing company to be efficient, it is more important than ever to monitor its production on an ongoing basis. Having access to real-time production data becomes a necessity. Only an automated tool can meet this demand, given the significant amount of data to be processed in real-time. To achieve this, the company plans to create a production dashboard to ensure the monitoring of key performance indicators on an ongoing basis.
A production dashboard will assess all production data in real time, while facilitating the analysis of various key performance indicators relating to production. Obviously, the synthesis of the overall production results will go through the monitoring of the production volume, the performance of the machines, and the quality of the products, etc.
Building a step-by-step production dashboard
You will surely understand by reading the previous articles on the strategic and financial dashboards how this first step is crucial for the project. Indeed, the objectives of the project will be defined, and from these will follow the rest of the project.
What problem do we want to solve with the dashboard?
The goal will be to have better monitoring of the company’s operational performance to optimize production, and income.
Who will be the dashboard audience?
The audience will consist of the teams involved in production.
What are we going to share with the audience?
The objective will be to present an overview of the production volume of the machines in order to help the operational team identify and anticipate potential problems, but above all, give them the necessary information to optimize performance and efficiency of production.
KPIs are the indicators that will be used to quantify the level of performance of the company. In the case that concerns us today, here are the selected indicators:
- production volume and its evolution over time,
- active machinery,
- volume of orders,
- production volume per device,
- rate of defective products.
Taking advantage of a well-underway digital transformation, the company has already automated the extraction of data related to its operations, and these are stored in an external server in the cloud. The company therefore has complete and up-to-date data for building its dashboard.
This data is then gathered in an automated and regular manner to generate the KPIs that were defined in the previous step. Regular data updates are one of the strengths of this type of dashboard, as reliability of the information that will be presented is guaranteed.
The dashboard will have the following elements:
- KPIs: quantified results concerning the volume and quality of production as well as the productivity of machines,
- the evolution of production volume over the past few days,
- the evolution of sales figures in recent months.
Microsoft’s Power BI was chosen as the dashboard support as it offers a number of different features and has significant advantages over other tools:
- unique tool that centralizes all stages of data aggregation, processing, analysis and presentation,
- collaborative tool: ideal for sharing with different team members,
- familiar interface that aligns with that of other products from the same manufacturer,
- possibility of relying on Business Intelligence.
The interface will be uncluttered to make it easier to read and interpret information, and KPIs will be presented in such a way that they are easily identifiable. Finally, graphs will be used to show the evolution of the results over time.
Deployment of the dashboard
After going through the various stages, here is the dashboard that the team will use on a daily basis
Once the dashboard is deployed, the relevance of the different information will be reassessed regularly as the needs and goals of the business change, and it is essential that the dashboard in place reflects these changes. In summary, the dashboard will be more effective if it reflects the needs and goals of the business. It goes without saying that everyone has their role to play in accomplishing this; whether it’s the team that designs it, or the one that uses it daily.