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
    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
    data driven insights
    How Data-Driven Insights Are Addressing Gaps in Patient Communication and Equity
    8 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: Data Preparation: Is the Dream of Reversing the 80/20 Rule Dead?
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 > Data Preparation: Is the Dream of Reversing the 80/20 Rule Dead?
AnalyticsData Management

Data Preparation: Is the Dream of Reversing the 80/20 Rule Dead?

BillFranks
BillFranks
7 Min Read
SHARE

I recently had someone ask me, “For years we’ve talked about changing analytics from 80% data prep and 20% analytics to 20% data prep and 80% analytics, yet we still seem stuck with 80% data prep. Why is that?” It is a very good question about a very real issue that causes many people frustration.

Contents
Breaking New GroundRevisiting A Well-Worn PathThe Big Challenge of Big DataKeep The Right Perspective

I believe that there is actually a good answer to it and that the perceived lack of progress is not as bad as it first appears. To explain, we need to differentiate between a new data source and/or a new business problem and existing ones we have addressed before.

I recently had someone ask me, “For years we’ve talked about changing analytics from 80% data prep and 20% analytics to 20% data prep and 80% analytics, yet we still seem stuck with 80% data prep. Why is that?” It is a very good question about a very real issue that causes many people frustration.

More Read

implement manufacturing analytics
Here’s How To Implement Manufacturing Analytics Today
GDPR Could Impact How Remote Teams Work
Predictive Analytics: 8 Things to Keep in Mind (Part 1)
Freakonomics and Your Data
How Top Brands Are Wielding Data and Analytics

I believe that there is actually a good answer to it and that the perceived lack of progress is not as bad as it first appears. To explain, we need to differentiate between a new data source and/or a new business problem and existing ones we have addressed before.

Breaking New Ground

Whenever a new data source is first acquired and analyzed, there is a lot of initial work required to understand, cleanse, and assess the data. Without that initial work, it isn’t possible to perform effective analysis. Much of the work will be a one-time effort, but it can be substantial. For example, determining how to identify and handle inaccurate sensor readings or incorrectly recorded prices.

From the earliest days of my career, some of the most challenging work has been working with new data. For the first couple of analytics on a new data source, the ratio of data prep and other grunt work to analytics is certainly much closer to 80% prep/20% analysis than to 20%/80%. However, as time passes and more analytics are completed with that new data source, things become much more streamlined and efficient.

Revisiting A Well-Worn Path

Once a data source has been utilized for a range of analytics and is well understood, developing a new analytic process with it starts to drift towards the 20/80 ratio. By making use of things like Enterprise Analytic Datasets, it is possible to jump almost directly into a new analysis as long as that analysis can utilize the same type of metrics that past analysis made use of.

In fact, many large organizations have greatly standardized and streamlined the use of traditional data sources for analytics. For example, transactional data is utilized to analyze customer behavior in a wide range of industries. Many organizations have a large number of standardized customer metrics available that can feed analytics both new and old. I know of companies with tens of thousands of metrics for each customer based on transactional history. Spinning up a new analytic process with these metrics is not that difficult and can often be more of a 20% prep/80% analysis proposition than an 80/20 proposition.

Even if you accept all of the points above, doesn’t it still seem like your analytics organization is spending a ton of time on data preparation today? Well, your instinct is probably on target, but not for the reasons you may initially think of.

The Big Challenge of Big Data

The rise of big data has led to a proliferation of data sources over the past few years. Simultaneously, analytics have become a major focus and there is demand for analytics to address an ever-widening range of business problems. When combining these two trends, we are left with a large amount of new ground to break, which drives us back to the need for an abundance of work to understand, cleanse, and assess data. We, therefore, end up spending much of our time on data preparation and still see an 80/20 ratio.

However, it is important to look backward and recognize the progress that has been made. The data that required a lot of work a few years ago likely does NOT require a lot of work today. The ratio of data prep to analysis may well be nearing the 20/80 target ratio in those cases. We tend to lose sight of this progress when we are inundated with the data issues of today. Even though we have made a lot of progress with our old data and analytics, we’re simply facing a huge amount of new data and problems to work on.

Keep The Right Perspective

It can certainly be frustrating to feel like your organization is forever stuck doing more data preparation than analysis. However, it is critical to recognize that the data and problems for which you’re doing that prep are constantly changing. It is simply impossible to analyze new data for a new problem without going through a bunch of grunt work and data prep at the outset. There is nothing wrong with this.

In fact, if your organization is breaking enough new ground with analytics to feel stuck in a data preparation mode, then you should be happy because it means you are likely making progress. The key is to ensure that once you’ve solved today’s problems and understand today’s data sources that you drive to a higher level of automation and standardization for those data sources and processes. By making analytics easier for the data and problems you already understand, you free up time to prepare the data for your next analytics adventure.

Original Article

Share This Article
Facebook Pinterest LinkedIn
Share
ByBillFranks
Follow:
Bill Franks is Chief Analytics Officer for The International Institute For Analytics (IIA). Franks is also the author of Taming The Big Data Tidal Wave and The Analytics Revolution. His work has spanned clients in a variety of industries for companies ranging in size from Fortune 100 companies to small non-profit organizations. You can learn more at http://www.bill-franks.com.

Follow us on Facebook

Latest News

data analytics and truck accident claims
How Data Analytics Reduces Truck Accidents and Speeds Up Claims
Analytics Big Data Exclusive
predictive analytics for interior designers
Interior Designers Boost Profits with Predictive Analytics
Analytics Exclusive Predictive Analytics
big data and cybercrime
Stopping Lateral Movement in a Data-Heavy, Edge-First World
Big Data Exclusive
AI and data mining
What the Rise of AI Web Scrapers Means for Data Teams
Artificial Intelligence Big Data Exclusive

Stay Connected

1.2kFollowersLike
33.7kFollowersFollow
222FollowersPin

You Might also Like

Image
Data Management

Increasing Importance of Governed Data Access

3 Min Read

EmSense, a “neuromarketing” company founded in 2004 by seven…

2 Min Read
Image
AnalyticsBig Data

Governance Helps Perfect Big Data Initiatives

3 Min Read

Analytics in Malaysia: News and Interviews from the SAP Analytics Tour

1 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 in ecommerce
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence
giveaway chatbots
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive

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?