Most Analysts Spend 50% of Their Time Finding Data

%	Finding	Analyzing	Reporting
10	12%	6%	33%
20	14%	10%	39%
30	20%	31%	24%
40	6%	14%	2%
50	31%	16%	2%
60	14%	18%	0
70	0%	0%	0
80	0%	2%	0
90	0%	0	0
100	0%	0	0

Most analysts spend most of their time finding data.

Among other thing this can mean they are setting up data mining or data gathering process to look for the data or it can mean they reviewing their data for relevancy.

My experience is that when you spending this much time on the finding the right data phase it reflects a poorly structured data environment or a unfamiliarity with the data needed.

Dirty data is also a big time waste.

Experience is the best solution for challenges with finding data. The fact the finding phase % is so high speaks to both the explosion in the 3 V’s of Big Data (Velocity, Volume and Variety)  as well as the number of analytics newbies.

To me this should be no more than 20% of your time.

I expected finding data would be the biggest chunk, but was surprised that over 50% of my analyst connections using at least 40% of their time finding data.

If you have one day to answer a key business question, this means you are using your entire morning just finding the data.

When you get back from lunch you haven’t even started the actual analysis yet and the clock is ticking.

Data is based on a survey I sent to 3,000 of my LinkedIn connections who are either analysts or work closely with data and analysis.

Analytics Survey – DMAIPH conducts quarterly analytics surveys to collect data on current trends in analytics. We specialize in surveys that assess analytics culture and measuring how aligned an organization is to using data and analytics  in its decision-making. Contact DMAIPH now at analytics@dmaiph.com or connect with me directly to find out more about how DMAIPH can conduct surveys to help you assess the analytics culture in your business.