Swiggy Senior Data Analyst Interview Questions and Answers

Q1. Write SQL to print the user with the highest restaurant order. There are couple of joins to be used.
Ans. 
Use SQL with joins to find user with highest restaurant order
• Use JOIN to connect user table with order table

• Group by user and sum the order amounts

• Order by sum in descending order and limit to 1 result
Answered by AI
Add your answer

Statistical Analysis related questions

SQL test on hackerrank

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

SQL and Python coding test

Q1. Bagging vs Boosting
Add your answer
Q2. Overfitting and Underfitting in GBDT
Add your answer

Q1. Questions on Recent project
Add your answer
Q2. Deep Learning vs classical ML
Add your answer

Q1. What is a logistic regression model?
Ans. 
Logistic regression is a statistical model used to predict the probability of a binary outcome based on one or more predictor variables.
• Logistic regression is used when the dependent variable is binary (0/1, True/False, Yes/No, etc.)

• It estimates the probability that a given input belongs to a particular category.

• The model calculates the odds of the event happening.

• It uses a logistic function to map the input values to ...read more
Answered by AI
Add your answer
Q2. Explain the random forest model.
Ans. 
Random forest is an ensemble learning method that builds multiple decision trees and merges them to improve accuracy and prevent overfitting.
• Random forest is a type of ensemble learning method.

• It builds multiple decision trees during training.

• Each tree is built using a subset of the training data and a random subset of features.

• The final prediction is made by averaging the predictions of all the individual trees.

• Random...read more
Answered by AI
Add your answer
Q3. Explain decision trees
Ans. 
Decision trees are a popular machine learning algorithm used for classification and regression tasks.
• Decision trees are a flowchart-like structure where each internal node represents a feature or attribute, each branch represents a decision rule, and each leaf node represents the outcome.

• They are easy to interpret and visualize, making them popular for exploratory data analysis.

• Decision trees can handle both numerical ...read more
Answered by AI
Add your answer

Q1. How do you see yourself in next 5 years?
Ans. 
In the next 5 years, I see myself growing into a senior data scientist role, leading projects and mentoring junior team members.
• Continuing to enhance my skills in data analysis, machine learning, and programming languages such as Python and R

• Taking on more responsibilities in project management and client interactions

• Working towards becoming a subject matter expert in a specific industry or domain

• Mentoring and guiding ...read more
Answered by AI
Add your answer
Q2. What are you 5 years back.what is the difference?
Ans. 
I was a student pursuing my undergraduate degree in Computer Science.
• 5 years back, I was studying Computer Science in college.

• Now, I have completed my degree and gained experience in data science through internships and projects.

• I have developed strong analytical and programming skills over the past 5 years.

• I have also learned new technologies and tools in the field of data science.

• I have a better understanding of real
Answered by AI
Add your answer

Q1. Interviewer asked me basic SQL questions
Add your answer
Q2. In the second technical round he asked me advanced SQL topics (Windows Functions, Joins & Subqueries)
Add your answer

In the second technical round interview asked me about advanced sql topics, theory questions and two coding questions in joins and window functions.

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. Explain all of decision tree and random forest?
Ans. 
Decision tree is a tree-like model of decisions and their possible consequences, while random forest is an ensemble learning method that builds multiple decision trees and merges them together.
• Decision tree is a flowchart-like structure where each internal node represents a decision based on an attribute, each branch represents the outcome of the decision, and each leaf node represents a class label.

• Random forest is a ...read more
Answered by AI
Add your answer
Q2. Some basic probability questions
Add your answer