ScatterPie Analytics Senior Data Analyst Interview Questions and Answers

50 questions 12 mins

Q1. Quant based questions (P&C,Averages,probability) followed by case study
Add your answer

Q1. We need to complete 40 questions in 20 mins
Add your answer

Q1. Guesstimate questions like no. Of I phones used in India , no. Of people drinking beverage in a day in a city like gurgaon.
Add your answer
Q2. Puzzle - 3 bulbs in a room and 3 switch in the other. How to find which bulb has what switch.
Add your answer
Q3. Excel questions related to sum if and sum ifs function, vlookup formula , conditional formatting, filter functioning etc.
Add your answer
Q4. Case study like there is a 3 year sales &volume data of a company - how will you calculate growth % , CAGR, what analysis will you give to oil and natural gas industry if it's share drops.
Add your answer

Guestimates and puzzles

Q1. Estimate the number of fliers from Delhi Airport
Ans. 
Estimate the number of fliers from Delhi Airport
• Consider the average number of flights per day from Delhi Airport

• Estimate the average occupancy rate of flights departing from Delhi Airport

• Take into account the time of year and any special events that may affect travel volume
Answered by AI
Add your answer
Q2. Estimate the number o ciggerate sold in India
Ans. 
Estimating the number of cigarettes sold in India requires analyzing market data, population demographics, and tobacco consumption trends.
• Analyze market research reports on tobacco industry in India

• Consider population demographics and smoking prevalence rates

• Look at historical sales data of tobacco companies in India

• Take into account government regulations on tobacco sales and consumption

• Consult industry experts and st
Answered by AI
Add your answer

Guestimate like how many i-phones in delhi.make a structured ans within given time pweriod using the statstical aprroach

Basic maths and logical reasoning but time management is the key

Probability based questions and case study