Cookies help us display personalized product recommendations and ensure you have great shopping experience.

By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    sales and data analytics
    How Data Analytics Improves Lead Management and Sales Results
    9 Min Read
    data analytics and truck accident claims
    How Data Analytics Reduces Truck Accidents and Speeds Up Claims
    7 Min Read
    predictive analytics for interior designers
    Interior Designers Boost Profits with Predictive Analytics
    8 Min Read
    image fx (67)
    Improving LinkedIn Ad Strategies with Data Analytics
    9 Min Read
    big data and remote work
    Data Helps Speech-Language Pathologists Deliver Better Results
    6 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: How to Track Your Data for Six Sigma Use
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Analytics > How to Track Your Data for Six Sigma Use
Analytics

How to Track Your Data for Six Sigma Use

knowwareman
knowwareman
4 Min Read
SHARE

While most companies have too much data, people can always identify something they aren’t tracking that they should be tracking. Then they think they have to set up a whole system to collect the measurement. This is a mistake. You don’t know if the measurement is useful until you have collected some. Rather than wait for a measurement system, start today using the simplest of tools: a checksheet.

checksheet

While most companies have too much data, people can always identify something they aren’t tracking that they should be tracking. Then they think they have to set up a whole system to collect the measurement. This is a mistake. You don’t know if the measurement is useful until you have collected some. Rather than wait for a measurement system, start today using the simplest of tools: a checksheet.

More Read

Do We Really Need More Data?
What Makes Effective Business Intelligence?
Consumerization Revisited: Why Aesthetics Matter
First Look – SPSS Predictive Analytic Software 13
5 Reasons You Should Consider Taking Analytics to the Cloud

checksheet

I’ve use these kinds of checksheets when I’m working with a team to implement Six Sigma. They find causes, I write them down and tally the number of times each occur. By the 30th data point, a pareto pattern appears that points us at the most common (i.e., root) cause of the problem.

Checksheet Data Collection
Nothing could be simpler than data collection with a checksheet. The QI Macros have a template in the improvement tools to get you started:

Excel Checksheet for collecting data

Simply print it out and start writing on it. What to write?

  • In column A, write the first instance of any defect, problem or symptom you detect. For example, if someone is calling us for support and they have a problem with understanding GageR&R, then we’d write “GageR&R” in A3 and put a stroke tally in the day of the week (e.g., Monday):

    Excel Checksheet with stroke tally

  • Then continue as the week goes on, adding defects, problems or symptoms. By the end of the week, we’ll have an interesting picture of support calls.

    Excel Checksheet for support

Just add up the number of calls and “Excel disabled macros ” jumps out as the majority of the calls. Create a pareto chart to better demonstrate this.

Pareto chart in Excel of Checksheet data

But now the questions arise:

  • Does a specific version of Excel disable the macros?
  • What are the SPC Questions about? Histograms? Control Charts? Which control chart?
  • And so on.

Well, if we spent a lot of time and money setting up a measurement system to track just these items, it wouldn’t do us much good. Now we can tune up the checksheet to give us better data:

Excel Checksheet for support revised

Use a checksheet to prototype your data collection efforts. Iterate until you start to understand what you really need to know to make improvements. A series of checksheets may be all you need to solve a pressing problem. If necessary, you can implement a measurement system to collect the data over time.

So please, don’t wait for a magical, all encompassing measurement system to deliver data. It’s not going to happen. And I often find it’s just an excuse to avoid making improvements (“I can’t because I don’t have the measurements I need.”) 

TAGGED:datadata collectionsix sigma
Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

sales and data analytics
How Data Analytics Improves Lead Management and Sales Results
Analytics Big Data Exclusive
ai in marketing
How AI and Smart Platforms Improve Email Marketing
Artificial Intelligence Exclusive Marketing
AI Document Verification for Legal Firms: Importance & Top Tools
AI Document Verification for Legal Firms: Importance & Top Tools
Artificial Intelligence Exclusive
AI supply chain
AI Tools Are Strengthening Global Supply Chains
Artificial Intelligence Exclusive

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

big data solution
Big Data

The Latest in Big Data Solution Trends

3 Min Read
disaster recovery plan
AnalyticsBig DataData Science

Data Analytics Solves Major Fire Safety Challenges

7 Min Read
customer data collection
AnalyticsBig DataBusiness IntelligenceCollaborative DataData ManagementData WarehousingDecision ManagementExclusiveNewsWeb Analytics

See Why Businesses Can’t Do Without Customer Data Collection

7 Min Read
big data helping to translate
Big DataExclusive

Big Data Provides Invaluable Translation Services For Marketers

10 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

ai chatbot
The Art of Conversation: Enhancing Chatbots with Advanced AI Prompts
Chatbots
data-driven web design
5 Great Tips for Using Data Analytics for Website UX
Big Data

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-25 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?