Data acquisition

data collection

The amount of data we have access to is overwhelming; but what data is interesting? What data is important to reach your targets? 

When implementing new production lines with data acquisition, spend resources to collect only the data you need.

Are you not sure what data you need? Use resources to decide. Here are some questions that might be of help;

- What are the relevant process indicators or KPI's (Key performance indicators) for manufacturing?

- What data is necessary to follow up these targets?

- What other measures will be relevant in the future? Why?

Companies implementing comprehensive data acquisition can risk production downtime due to overloaded system or failure. The rule "Make it simple" applies here as well. Lean Tech can help you define goals and measure to collect the right data, and to ensure good data quality. 

Data quality

data qualityCollecting lots of data doesn't help if the data quality is poor. The data needs to be consistent with the data source. Ensuring good data quality can be time consuming and resource demanding. However, it's well worth it! If you do not trust your data, will you take actions based on them? If your "gut feeling" is not aligned with the data, do you trust your "gut feeling" or the data?

If you do not trust your data, it is easy to make decision based on "gut feeling" rather than the data. 

Data quality can be addressed by monitoring production events during a given time; log manually all relevant events and verify that the collected data is aligned with your observations. A challenge when checking data quality is to reveal problems that occur occasionally. 

Lean Tech has experience with quality assurance of data at a company that loged up to half a million data per hour from different machines. There were different suppliers involved, and extensive root cause analysis was conducted to reveal the causes of unstable data collection and missing data. In such cases it is important to obtain as much information as possible about the situation that caused the instability.

Data visualization

data visualizationVisualization of data helps communication, understanding, evaluation and planning. If "A picture is worth a thousand words"; what is a graph worth to you?

You can use excel to visualize data, or you can use more sophisticated tools like JMP, Minitab, Modde, Sigma XL or others. Lean Tech use JMP, Minitab or SigmaXL (dependent of the customers preference) for Lean Six Sigma training.

Visualization of data makes it easier to see connections and trends between different variables and data sets. There are different graphical plots that are used for different data and purposes. The course Graphical Analysis cover this.

Visualization of data makes it easier to identify outliers in your data set and investigate these data. This is useful when controlling the quality of your data.  

Regression analysis shows the correlation between various factors. Are there a correlation between the in-process controls and the final product quality? Are there a correlation between variables? Positive or negative correlation? Linear or non-linear? Can the correlation be explained?

If you have data set you would like to analyze for trends and correlation you can contact Lean Tech.



  • daryl powell"I was very impressed with Sissel's Lean Six Sigma knowledge. She makes it easy to identify improvements and create results"
    - Daryl Powell, Research Manager, Sintef ManufacturingValue stream mapping
  • eivindwilloch.original"Sissel has proven herself as a competent and committed employee. She has been an important contributor to make good progress in the projects she has worked with. At the same time she is accurate and has good quality of the work she performs."
    - Eivind Willoch, Project Manager, Cambi AS lean engineering
  • benchmarking"We are very happy with the work carried out. We was not very clear what the order was, but with your background and expertise the outcome was what we were looking for and a document we will benefit from in the future"
    - Roger Søråsdekkan, Site Leader at Allnex, Norwaybenchmarking
  • kjelleven rez"We hired Lean Tech to develop monitoring program for air emission. The assignment was delivered with the correct content at the right time. Recommended." monitoring program
    - Kjell Even Misfjord, SHE manager at Allnex, Norway  
  • rsz 1thomasløvik"Sissels ability to quickly understand the issue, as well as her commitment and expertise is impressive. Her analytical and thorough contribution to our monitoring program has been precise and targeted, and very educational. " monitoring program
    - Thomas Løvik, HSEQ advisor at TWMA, Norway
  • Joakim Holm Hansen"Very nice and professional service. Delivered a good job within deadlines" verdistrømsanalyse
    - Joakim Holm-Hansen, Plant Manager at Solenis, Norway
  • Feedback from course participants:
    "Inspiring, professionally competent, popularize a theoretical discipline."
    "Made a difference, engaged and skilled."
    "Academic highly skilled and clear performance. Fun and builds trust."
    lean six sigma kurs