By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    construction analytics
    5 Benefits of Analytics to Manage Commercial Construction
    5 Min Read
    benefits of data analytics for financial industry
    Fascinating Changes Data Analytics Brings to Finance
    7 Min Read
    analyzing big data for its quality and value
    Use this Strategic Approach to Maximize Your Data’s Value
    6 Min Read
    data-driven seo for product pages
    6 Tips for Using Data Analytics for Product Page SEO
    11 Min Read
    big data analytics in business
    5 Ways to Utilize Data Analytics to Grow Your Business
    6 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Data Preparation: Is the Dream of Reversing the 80/20 Rule Dead?
Share
Notification Show More
Latest News
cloud-centric companies using network relocation
Cloud-Centric Companies Discover Benefits & Pitfalls of Network Relocation
Cloud Computing
construction analytics
5 Benefits of Analytics to Manage Commercial Construction
Analytics
database compliance guide
Four Strategies For Effective Database Compliance
Data Management
Digital Security From Weaponized AI
Fortifying Enterprise Digital Security Against Hackers Weaponizing AI
Security
DevOps on cloud
Optimizing Cost with DevOps on the Cloud
Development
Aa
SmartData Collective
Aa
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
Last updated: 2016/10/14 at 2:44 PM
BillFranks
7 Min Read
SHARE
- Advertisement -

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.

- Advertisement -

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

construction analytics

5 Benefits of Analytics to Manage Commercial Construction

Four Strategies For Effective Database Compliance
Fascinating Changes Data Analytics Brings to Finance
Use this Strategic Approach to Maximize Your Data’s Value
6 Tips for Using Data Analytics for Product Page SEO

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.

- Advertisement -

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.

- Advertisement -

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

BillFranks October 14, 2016
Share this Article
Facebook Twitter Pinterest LinkedIn
Share
By BillFranks
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.
- Advertisement -

Follow us on Facebook

Latest News

cloud-centric companies using network relocation
Cloud-Centric Companies Discover Benefits & Pitfalls of Network Relocation
Cloud Computing
construction analytics
5 Benefits of Analytics to Manage Commercial Construction
Analytics
database compliance guide
Four Strategies For Effective Database Compliance
Data Management
Digital Security From Weaponized AI
Fortifying Enterprise Digital Security Against Hackers Weaponizing AI
Security

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

construction analytics
Analytics

5 Benefits of Analytics to Manage Commercial Construction

5 Min Read
database compliance guide
Data Management

Four Strategies For Effective Database Compliance

8 Min Read
benefits of data analytics for financial industry
Big Data

Fascinating Changes Data Analytics Brings to Finance

7 Min Read
analyzing big data for its quality and value
Big Data

Use this Strategic Approach to Maximize Your Data’s Value

6 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 and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive
data-driven web design
5 Great Tips for Using Data Analytics for Website UX
Big Data

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?