Cians Analytics Senior Business Analyst Interview Questions and Answers

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

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

Q1. Advanced SQL queries
Add your answer
Q2. Advanced excel functions
Add your answer

Q1. GUESSTIMATE ROUND , GUESS THE SELL OF STARBUCKS AT RAJIV CHOCK METRO STARTION
Add your answer
Q2. NO SECOND QUESTION ASKED IN THIS
Add your answer

HOW DO IT COMPANY INC. THERE SELL BY 20 %

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