28% of a Data Analyst’s Time is Spent on Data Prep

Mar 3, 2023

28% of a Data Analyst’s Time is Spent on Data Prep

Data preparation

 

James Haight of Blue Hill Research recently wrote a blog post that breaks down the costs and numbers of Data Preperation. Typical reports focus on hours and efficiency. As stated by James Haight, “At Blue Hill, we recently published a benchmark report in which we made the case that dedicated data preparation solutions can produce significant efficiency gains over traditional methods such as custom scripts or Microsoft Excel.”

According to their study, data analysts spend on average about 2 hours per/day just on data preparation alone. When Blue Hill Research factored in the average salary that a data analyst makes in the U.S., it comes out to be around $62,000 per year. After doing the rough calculations, they figured out that 28% of a data analyst’s time is spent preparing data, which equals about $22,000 worth of their yearly salary. While that number seems high just considering one analyst, you can imagine how drastic that number looks when you figure in how many data analysts there can be at larger corporations. In this post, they breakdown the numbers even more. For example, say a company has 50 data analysts which is estimated that $1,100,000 is spent annually just on preparing data.

In order for data analysts to shift their full attention to where it should be, “analyzing the actual data”, there needs to be a solution implemented. PARIS Technologies has the solution. PowerOLAP is a software that was designed to take the stress and time out of preparing and comparing data. It has the capability to aggregate information from any source into a multidimensional PowerOLAP database. It empowers users the flexibility to slice and dice with ease. Learn more about how PowerOLAP could be the solution for your company facing this problem.

 

To read the Blue Hill Research post, click here.

 

(This post was originally published on April 22, 2016 and had been refreshed for you reading pleasure.)