Data Analysis Techniques

When you understand data analysis techniques, you take a big step towards making product and process improvements. How do you know when you implement a change, that the change was effective?

The Problem

Have you ever encountered a manager who said “I just made a change to the way we do things here. Now things are better.”? When you review the final outcome, you find things are not improved. In fact the improvements may be counter productive. Why did the manager make these statements?

  1. The manager’s ego may prevent him / her from realizing the change was not effective.
  2. There may not be any measurements in place to monitor the change.
  3. The measurement may be on the wrong item. In this case, your point of view is different then your manager’s point of view.
  4. The data is collected correctly but your manager is not reviewing the data. The data is not being analyzed.
  5. The manager does not understand the definition of improvement. When you say improvement what does that mean? How does data analysis link to improvement?

This Data Analysis Video teaches you the basic tools for understanding, summarizing, and making future predictions with your collected data. Includes MS Excel templates.

Data Analysis Video

The Answer

Now you realized things did not improve. How can you prove to your manager and others that things are not improved? A discussion without data is a wasted conversation. In fact approaching others without data could lead to unwanted arguments. Understanding data analysis techniques avoids he said - she said arguments.

With data, your armed with tools to support your case. When you present your data in pictures, such as histograms and pareto charts, you support your line of reasoning. Logical management understands these tools and sound rational changes are implemented.

Your Training

You can learn these tools and start using them within one hour. The introduction into data analysis video provides basic data analysis techniques. Learn how data links with improvement. Learn the key statistics that drives improvement. Learn how to present data in easy to review formats. Prevent undesired arguments. Help yourself and management to focus on the important measurements. To make you effective, this training video shows you to use Microsoft Excel to quickly conduct data analysis.

To learn data analysis techniques, you do not need an advance degree. If you can add and subtract, you can learn data analysis. This class teaches the key ideas to data analysis. The class condenses 8 hours of material into 1 hour. But it does not over load the student. The course simplifies the concepts and provides many examples.

Best of all, you can learn it at your computer. No need for travel. No need for unnecessary expenses. You take it at your convenience.

This Data Analysis Video teaches you the basic tools for understanding, summarizing, and making future predictions with your collected data. Includes MS Excel templates.

Data Analysis Video

What is Data Collection for Data Analysis Techniques

Data Collection helps your team to assess the health of your process. To do so, you identify the key quality characteristics you will measure, how you will measure them, and what you will do with the collected data

What Exactly is a Key Quality Characteristic?

It is a feature of the product or service produced by a process that customers have determined is important to them. Every product or service has multiple key quality characteristics. Key quality characteristics include such things as the speed of a service, the finish on a set of stainless steel shelves, the precision of an electronic component, or the effectiveness of an administrative response.

When you select processes to improve, you need to find the process step that produce the characteristics your customers perceive as important to product quality. Collecting data is nothing more than planning and gathering useful information on key quality characteristics produced by your process.

However, simply collecting data does not ensure you obtain the relevant or specific enough data that reflects your process. The key issue is not...How do we collect data? Rather, it is...How do we collect useful data?

This Data Analysis Video teaches you the basic tools for understanding, summarizing, and making future predictions with your collected data. Includes MS Excel templates.

Data Analysis Video

Why Do We Need to Collect Data?

Every process improvement effort relies on data to provide a factual basis for making decisions throughout the Plan-Do-Check-Act cycle.

Gathering data enables a team to formulate and test working assumptions about a process. This information leads to the improvement of the product or service. Data improves your decision-making by helping you focus on objective information that describes the process, rather than subjective opinions.  In other words, the phrase "I think the problem is..." becomes... "The data indicate the problem is..." .

Defined Your Data Collecting Process.

For your team to collect data uniformly, you need to develop a data gathering plan. The elements of the plan must be clearly and unambiguously defined — operationally defined.

When Should We Develop a Data Collection Plan?

You develop your plan during the first phase of the Plan-Do- Check-Act (PDCA) cycle. The PDCA cycle provides a framework for you to build an understanding of your process. PDCA shows you how to obtain and interpret data that will lead to real process improvement.

The difference between Data, Information, Knowledge and Wisdom

Process Improvement, KPOVs and Data

Learn Regression Analysis

Using a Run Chart

Quality Assurance Solutions
Robert Broughton
(805) 419-3344

Unique QA Products

All Products

Software, Videos, Manuals, Training Material

8D Manager

Corrective Action Software

Snap Sampling Plans!

AQL Inspection Software

TrainingKeeper Software

Plan and Track Training

StreamLiner Software

Lean and Continuous Improvement

Statistical Process Control

Training Video

ISO 9001:2015 QA Manual

Editable Template

ISO 9001 Calibration Manual

Editable Template

ISO 9001:2015 QMS Kit

Templates, Guides, QA Manual, Audit Checklists

Risk Management Certification

On-Line Training. Accredited and 20 Approved Units

All Products

Software, Videos, Manuals, Training Material

Please Recommend Us!

submit to reddit