Data analysis

dataanalyse

 

Services within Data analysis:

 

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 quality

Collecting 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.

Visualization of data

Data visualization

Visualization 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 Root Cause 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.

 

Root cause analysis

The purpose of a root cause analysis is to determine the true causes of a problem to implement targeted measures.

Lean Tech offers Root Cause Analysis training and consultancy. Here are some of the tools we use:

    • Thought map or A3 to structure the Root cause analysis
    • Statistical Process Control determines if normal or special cause variation is causing the problem
    • Process Mapping identifies possible root causes 
    • 5 Why and Fishbone identifies possible root causes
    • Graphical analysis can prove root causes
    • Hypothesis testing can prove root causes when graphical analyzes are not clear
    • Correlation and Design of Experiment - DOE can determine optimal factor values
    • Statistical Process Control (Control Chart) monitors variation of critical variables (proven root causes) and ensures lasting solution

These tools are used within Lean Six Sigma's problem-solving method DMAIC: Define (understand problem and set goals) - Measure (map current situation) - Analyze (prove root causes) - Improve (solve root causes) - Control (create lasting results). 

 

Cost benefit analysis

To choose between alternative solutions, cost-benefit analysis can help you make the right decision. It can be challenging to quantify the effect. It requires the ability to see the complete picture and how the change affect the overall business. 

Lean Six Sigma focus on gathering neutral information and make fact-based decisions. Improvements should create bottom line results and true root causes are to be solved by choosing the best option among several alternatives. Lean Six Sigma's problem-solving method DMAIC follows these steps:

  1. Define: Select the right projects and collect data to understand the problem
  2.  Measure: Map the current situation and baseline the process
  3. Analyze:  Identify root causes and analyze data to prove / disprove them
  4. Improve the process by implementing and verifying the best solution
  5. Control the new process by maintaining the solution.

The improve phase of Lean Six Sigma identifies different solutions and prioritize based on cost & benefit of the different options. To make the right decision it's important to evaluate pros and cons of the various alternatives. Cost, effect and time are common criteria to consider when deciding. Priority matrix can help you make good decision. This is one of the improvement tools available as e-learning.

A cost benefit evaluation does not need to be 100% correct, 90% is usually more than enough to make the right decision.

Contact info

Lean Tech AS | Snøfonna 5

0047 481 23 070

This email address is being protected from spambots. You need JavaScript enabled to view it.

Lørenskog, Norway

Book a meeting

Lean

L - Look for solutions

E – Enthusiastic

A – Analytical

N - Never give up

Sign up for Newsletter

* indicates required