Upload Button Icon Add office photos
Premium Employer

i

This company page is being actively managed by Practo Team. If you also belong to the team, you can get access from here

Practo

Compare button icon Compare button icon Compare

Filter interviews by

Practo Data Analyst Interview Questions and Answers

Updated 17 Nov 2015

Practo Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Pratik Chaudhari

posted on 17 Nov 2015

I applied via Referral

Interview Preparation Tips

Round: Resume Shortlist
Experience: Sent resume to an HR through Linkedin and got the call for interview

Round: Technical Interview
Experience: Had 3 rounds of technical interviews with Product Owner, Product Manager and VP Product. Most of the questions were related to maths, statistics and a few on machine learning. Even though I did not have much background on these, I was asked to give my inputs and try to find a solution. We discussed recommendation engines for Quora, Linkedin and e-commerce websites. Then they asked me how can we remove the bias that comes in the practo ratings of the doctors due to feedback from various channels. How can we identify if the customer is booking an appointment by looking at reviews or ratings? How can we identify spam reviews before publishing them? How can we build a product which can help users write a better quality review? Most of the questions were related to data science and how we can improve the products using data. The data analyst role for which I was being interviewed, was a first of its kind role in Practo. The JD was to basically work with the product team and help them in improving products, building new features etc. using data science/ data analytics.

Skills: Product Sense, Attitude, Data Science, Data Analysis, Basics Of Machine Learning
College Name: IIT Madras
Motivation: being the leader of the healthcare industry, high growth startup, opportunity to solve interesting problems using data

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Apr 2021. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Estimate the sale of Umbrella in a year in Bangalore without any inputs given.
  • Ans. 

    Estimating sales of umbrellas in Bangalore without any inputs.

    • Analyze historical sales data of umbrellas in Bangalore

    • Consider weather patterns and forecast for the year

    • Evaluate competition and market trends

    • Assess population density and demographics

    • Factor in events and festivals that may affect sales

    • Use statistical models and regression analysis

    • Consider potential impact of COVID-19 on sales

  • Answered by AI
  • Q2. They will give one online test (SQL based)
  • Q3. Questions about SQL and probablity

Interview Preparation Tips

Interview preparation tips for other job seekers - I was not prepared with SQL on an advanced level, unfortunately, I was unable to clear.
If you want to apply, Be prepared with SQL and probability and general business analysis questions.
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Prepare on SQL in depth
  • Q2. Prepare on Excel & Python in depth

Interview Questionnaire 

1 Question

  • Q1. Different types of joins in SQL, Delete drop truncate difference
  • Ans. 

    Different types of joins in SQL, Delete drop truncate difference

    • Types of joins: Inner join, Left join, Right join, Full outer join

    • Inner join returns only matching rows from both tables

    • Left join returns all rows from left table and matching rows from right table

    • Right join returns all rows from right table and matching rows from left table

    • Full outer join returns all rows from both tables

    • Delete is used to remove specific ...

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Apr 2023. There were 2 interview rounds.

Round 1 - Assignment 

Analytics data based assignment on excel. They will ask questions based on the arw data provided

Round 2 - One-on-one 

(1 Question)

  • Q1. Asked about experience

I applied via Naukri.com and was interviewed in Jun 2021. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. The questions were around technical documentation and tasks were given on documentation
  • Q2. E commerce related questions were asked

Interview Preparation Tips

Interview preparation tips for other job seekers - The managerial round was also core technical. If u do well in all the technical rounds you have high chance of clearing the interview
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Jul 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Case Study 

1. Tell me about yourself
2. Estimate the number of hospitals in India

Round 3 - Case Study 

1. There has been a decrease in 20% of the users in the past 3 days in online pharmacy application, what will you do now?

Round 4 - HR 

(4 Questions)

  • Q1. Salary negotiation on what were last salary and related questions
  • Q2. How soon can you join?
  • Q3. Are you holding any other offer, in case you do..they will try to match it which ideally depends on your interview.
  • Q4. Are you comfortable relocating to the office location?

Interview Preparation Tips

Interview preparation tips for other job seekers - The interview is fairly easy, just be confident and explain your thought process to the interviewer while answering any question. They will support you and help you reach the destination if you do so.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Salary discussion
  • Q2. Expected salary vs what they can offer

I applied via LinkedIn and was interviewed in Apr 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. How can you reduce the delivery time of the order?
  • Ans. 

    Reducing delivery time can be achieved by optimizing the supply chain, improving communication, and automating processes.

    • Analyze the supply chain and identify bottlenecks

    • Implement automation tools to streamline processes

    • Improve communication between departments and with customers

    • Use data analytics to forecast demand and plan accordingly

    • Consider outsourcing or partnering with third-party logistics providers

    • Invest in tec...

  • Answered by AI
  • Q2. Questions based on Case Studies

Interview Preparation Tips

Interview preparation tips for other job seekers - The process consisted of two rounds. First was the business analysis kind of round which included the questions like how can you reduce the delivery time of the order? The second round was technical round where the person asked the questions on SQL and Excel
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Referral and was interviewed in Sep 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Case Study 

What are the KPI to be considered in order to monitor the e-diagnostics business.

Round 3 - Not Done Yet 

(1 Question)

  • Q1. It might be cultural fitment round. Not Done Yet

Tell us how to improve this page.

Practo Data Analyst Salary
based on 5 salaries
₹1 L/yr - ₹9.3 L/yr
15% less than the average Data Analyst Salary in India
View more details

Practo Data Analyst Reviews and Ratings

based on 2 reviews

4.3/5

Rating in categories

3.7

Skill development

3.7

Work-life balance

3.7

Salary

3.0

Job security

4.0

Company culture

3.7

Promotions

3.7

Work satisfaction

Explore 2 Reviews and Ratings
Business Development Manager
244 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Product Support Specialist
137 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Territory Sales Manager
114 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Team Lead
62 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Area Manager
58 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Practo with

Lybrate

3.5
Compare

Mfine

3.6
Compare

DocsApp

3.9
Compare

Portea Medical

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview