HealthKart Data Analyst Interview Questions and Answers

Q1. Excel and SQL based questions
Add your answer

Q1. Python and project based questions
Add your answer

Q1. Why data? Why Tokopedia? Talk about bachelor's thesis?
Ans. 
Data analysis is crucial for making informed decisions. Tokopedia's vast data provides a great opportunity for analysis. My bachelor's thesis focused on data-driven insights.
• Data allows for informed decision-making and insights.

• Tokopedia's extensive data provides a valuable opportunity for analysis.

• My bachelor's thesis delved into data-driven insights and analysis.
Answered by AI
Add your answer

Q1. Walkthrough bachelor's thesis
Add your answer

Q1. All about the past projects. Few basic data visualization concepts like what charts to use, what will be the best fit for a particular scenerio
Add your answer

The assessment consists of a dataset for which we are required to build a machine learning model and submit the results along with code and detailed documentation

Q1. What are ensemble models
Ans. 
Ensemble models are machine learning models that combine multiple individual models to improve predictive performance.
• Ensemble models work by aggregating predictions from multiple models to make a final prediction.

• Common types of ensemble models include Random Forest, Gradient Boosting, and AdaBoost.

• Ensemble models are often more accurate and robust than individual models.

• They can reduce overfitting and increase genera...read more
Answered by AI
Add your answer
Q2. Difference between bagging and boosting
Ans. 
Bagging and boosting are ensemble learning techniques used to improve the performance of machine learning models by combining multiple weak learners.
• Bagging (Bootstrap Aggregating) involves training multiple models independently on different subsets of the training data and then combining their predictions through averaging or voting.

• Boosting involves training multiple models sequentially, where each subsequent model c...read more
Answered by AI
Add your answer
Q3. A lot of tree based questions
Add your answer

SQL, Python, like case about window function

Q1. All about past project
Add your answer

Q1. Advance Excel (Vlookup, Index, Countifs, sumifs and others)
Add your answer
Q2. Python Basics (data frame, data types, lamda, series etc)
Add your answer
Q3. SQL Functions (joins, limits, partitions, orders by and group by)
Add your answer
Q4. 3rd round was managerial round, where mostly non-technicial questions asked.
Add your answer

Q1. SQL: left join, right join and inner join questions find out the latest entry for an user when they log in to a app Python: few basic questions on python like count the characters in a word. Linux: what co...read more
Add your answer

Q1. What experience do you have using SQL?
Ans. 
I have extensive experience using SQL for data analysis and reporting.
• Proficient in writing complex SQL queries

• Experience in data manipulation, aggregation, and filtering

• Familiarity with joins, subqueries, and stored procedures

• Experience in optimizing queries for performance

• Examples: Used SQL to analyze customer behavior and create reports for marketing team, extracted data from multiple tables using joins and subqueri
Answered by AI
Add your answer