Home » Uncategorized

5 Questions To Ask When You Get A Data Dump To Analyse

As an analyst, our first reaction when we get the data to analyse is to ask an ETA. Then we plan to attack the data left-right-centre and crush the maximum juice out of it with an exhaustive list of analysis techniques.

Oh dear, we got it all wrong!

This approach might get 50 slides to present the analysis but would miss on the most crucial aspect of any analytics engagement: a buy-in from the business folks. Because, since the start, the target of the whole analysis was data, and not the business problem for which you got the data in the first place.

To avoid such situation, it is quint essential to look out for the purpose and not just the means. Having burnt my fingers fiddling with the data bare hands, I realized some rules and checks should be set as a standard practice before seizing the hot cauldron of boiling data.

1. What is the objective of analysis

Without an objective, you would be like a swimmer in the mid of river who is unable to figure out which bank to head for. When you get a data set to analyse, especially in client-vendor situation, ask if the objective is analytics capability showcase or there is an unspoken/explicit business goal. Ask what is expected out of the analysis. The whole premise set at the start would define the course of your journey for next couple of hours or days to come.  

28083325982.  Understand all the data columns

Never ever accept a data dump without understanding the data columns. 7 of the 10 times you would find some similar columns but a different context. For example, columns like ‘Input_ASIN’ & ‘ASIN’ will leave you gaping wide for a metadata file for more context. It becomes even more challenging when there are 60-70 odd columns to work on. So, don’t presume..ASK!

3.  Who the target audience is

A very crucial piece of information about an analysis is: who is the target audience? Knowing certain information about who would consume this analysis makes a whole lot of difference:

  • What is the designation: Higher in hierarchy, lesser tactical and more strategic orientation would be. As put by Avinash Kaushik, senior managers tend to be less interested in data and more in the story or bigger picture.


  • Which business division: The focus of analysis changes with the division. Whether to focus on dispatch lead time, discount, promotions, product variety, profit or revenue… everyone has different interest.
  • Know-how of analytics: To present the analysis, you need to understand how comfortable the people are with analytics

4.  If any analysis has been done in past on the same data set    2808333813

There is nothing more frustrating to hear – ‘I know this. What else you got!’ after you put so much hard labor in preparing the analysis. If possible, enquire beforehand what analysis has been presented till date or what the client already knows about. It could be tough at times to know this, but whats the harm in asking.

5.  How will it be shared with client

Not just preparing the analysis, it is imperative to know how it would be shared with the client. Would it be an Excel file, a PowerPoint presentation or through text in email. Whether someone would present the analysis or it would be just dropped-the-other-side. Depending on the case, text amount and context would be presented in the analysis.  


Last word: While presenting the finding, talk the language of the business and less of maths and statistics so that business folks can follow you rather than just listening. For e.g. instead of saying the median of prices of products sold decreased, say, the focus of customers has shifted towards cheaper products J