Subscribe to DSC Newsletter


"Analytics is a journey and not a destination!! It takes considerable effort to frame that journey and execute it with a sense of purpose. You will encounter stumbling blocks that may threaten your initiative but you need to find a way out and keep marching ahead."

We did an analytics exercise for a US client recently in education domain that had all the flavors of roadblocks one can encounter on venturing into analytics territory. I intend to summarize those here along with solution we found in collaboration with all stakeholders:

  1. This one is most worrisome and showstopper pretty much everywhere.  Data Quality and Data Integrity!!! Many of the fields had inconsistent data, nearly 50%. Ones that had data were ambushed by missing values. At the same time data integrity was questioned. Different departments came out with  different numbers for same metrics.That’s terrifying indeed! We reconciled data across different systems. Though we never had exact match however we narrowed down differences to less than 10 %. All agreed to a 10% tolerance level. Good to go!
  2. Same metrics, different understanding! How do we define a conversion etc?  This wasn't anticipated to be honest but became clear after couple of stakeholder meetings. Good part we had every stakeholder from finance, sales, marketing and operations team on board. We were able to identify and close understanding gaps quickly.
  3. Excitement and Expectations! Kicking of analytics initiatives generated quite an excitement for all. Everyone wanted a pie of magic (isn’t that expect out of analytics these days) at the end. At this stage it was critical to set priorities right.  Even though we started with defined set of activities, things changed in weeks time when client presented alternative priorities.  Client’s executive team played an important role here in clearly defining what their priorities were what they really wanted and how they will act upon the insights we deliver. I would say clear understanding and desire on client’s part won the battle here.

 Take Aways

  • Define your data quality tolerance limits. You never will have 100% correct data. However this shouldn't stop you from acting.
  • Having all stakeholders who are linked to the project on board. This may be executive team, sales, marketing or operations team. This is where you can identify inconsistent understanding and close gaps.
  • Be clear and precise about what you want and how you plan to act upon insights.


   This was just a month's exercise. Surely we will hit many such scenarios ahead.

Views: 1614

Tags: analytics, business, data, predictive


You need to be a member of AnalyticBridge to add comments!

Join AnalyticBridge

Comment by Rohit Pandey on June 12, 2015 at 7:58am

Thanks Mr.Uparkar!

Comment by Sagar Diwakar Uparkar on June 12, 2015 at 7:55am
Hi Rohit, Good evening. It is good blog.

On Data Science Central

© 2020   TechTarget, Inc.   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service