Apnaklub Data Analyst Intern Interview Questions and Answers

Duration was of 1hour. Topics: SQL Basics, SQL Query, Case study related to Blinkit.

Q1. - Guesstimate (No. of paper cups used in one day in an Office)
Ans. 
Approximately 500 paper cups may be used in a day in an average office.
• Consider the number of employees in the office

• Think about the average number of hot beverage drinkers

• Factor in the number of meetings and events held in the office

• Take into account the availability of reusable cups

• Estimate based on personal experience or observation
Answered by AI
Add your answer
Q2. - Puzzle: Find out heavier one out of 9 ball
Add your answer
Q3. - Situation based questions (KPIs used as manager of Dark Store)
Add your answer

Q1. SQL Questions (Group by)
Add your answer
Q2. Analytical Question related to Profit loss
Add your answer

Easy questions which can be practiced from IndiaBix

Q1. Sql and pandas queries which can be practised easily online.
Add your answer

Q1. Focused on projects, sql and pandas
Add your answer

Finding error in sql query

Normal aptitude question

Detail of sql especially joins

Q1. Questions on Past Project
Add your answer
Q2. SQL Dense Rank - also having the option to do in Pandas
Add your answer
Q3. Pandas groupby on a dataset given - required to calculate group wise yoy rate of a column
Add your answer

Q1. Past project ( which he chose , he chose my very first project , which I had forgotten) so ended up screwing it
Add your answer
Q2. SQL / Pyspark question - difficult question
Add your answer

Q1. Tell me about your projects?
Add your answer
Q2. How do you approach the project if you are using logistic regression model?
Ans. 
Approach involves data preprocessing, model training, evaluation, and interpretation.
• Perform data preprocessing such as handling missing values, encoding categorical variables, and scaling features.

• Split the data into training and testing sets.

• Train the logistic regression model on the training data.

• Evaluate the model using metrics like accuracy, precision, recall, and F1 score.

• Interpret the model coefficients to under...read more
Answered by AI
Add your answer

Q1. What are you future goals?
Add your answer
Q2. What would you do if your interested field doesnt have any work in the company?
Ans. 
I would seek opportunities to apply my skills in related fields within the company.
• Explore other departments or teams within the company that may have projects related to my field of interest

• Offer to collaborate with colleagues in different departments to bring a new perspective to their projects

• Seek out professional development opportunities to expand my skills and knowledge in related areas
Answered by AI
Add your answer

Q1. Basic Recommendation System Questions
Add your answer
Q2. A B Testing Questions
Add your answer

Easy topics arrays, sequence sum.