Merilytics Senior Data Analyst Interview Questions and Answers

2 MCQs sections based on SQL and Power BI.

Q1. Standard SQL question - 6 to 8 queries.
Add your answer
Q2. Case studies - 2 in total.
Add your answer
Q3. Why I'm curious about Data Science and other Data science related personal talk to understand the understanding in Data domain
Add your answer

Q1. Medical to Hard level SQL and Power BI - DAX queries. 5-6 queries.
Add your answer
Q2. Again talked about Data Science and called back again after 4 hours to know more about my SQL understandings.
Add your answer

Q1. 15 min quick discussion. Discuss the roles and responsibilities. Discuss the salary.
Add your answer
Q2. Guy looked exhausted and wrap the call quickly.
Add your answer

Q1. How will you find loyal customers for a store like DMart , SmartBazar
Ans. 
Utilize customer transaction data and behavior analysis to identify loyal customers for DMart and SmartBazar.
• Use customer transaction history to identify frequent shoppers

• Analyze customer behavior patterns such as repeat purchases and average spend

• Implement loyalty programs to incentivize repeat purchases

• Utilize customer feedback and reviews to gauge loyalty

• Segment customers based on their shopping habits and preferenc
Answered by AI
Add your answer
Q2. Who is more valuable a customer who is making small transactions everyday or the customer who makes big transactions in a month
Ans. 
It depends on the business model and goals of the company.
• Small transactions everyday can lead to consistent revenue streams and customer engagement.

• Big transactions in a month can indicate high purchasing power and potential for larger profits.

• Consider customer lifetime value, retention rates, and overall business strategy when determining value.
Answered by AI
Add your answer
Q3. What will you do as a data scientist if the sales of a store is declining
Ans. 
I would conduct a thorough analysis of the sales data to identify trends and potential causes of the decline.
• Review historical sales data to identify patterns or seasonality

• Conduct customer surveys or interviews to gather feedback

• Analyze competitor data to understand market dynamics

• Implement predictive modeling to forecast future sales

• Collaborate with marketing team to develop targeted strategies
Answered by AI
Add your answer
Q4. We have to bundle the items together in the units of 2-3 as a single units like chips of 3 packets together. how to identify which items to bundle and number of units. Create a machine learning model for i...read more
Add your answer
Q5. You are working in a project, where your approach towards problem is more innovative while the rest of the team is following conventional approach. how will you convince them to follow your approach.
Ans. 
I would showcase the potential benefits and results of my innovative approach to convince the team.
• Highlight the advantages of the innovative approach such as improved efficiency, accuracy, or cost-effectiveness.

• Provide real-world examples or case studies where similar innovative approaches have led to successful outcomes.

• Encourage open discussion and collaboration within the team to explore the potential of combining ...read more
Answered by AI
Add your answer

1. A store has promotional offers how will you analyse that offers are working in their favour.
2. What data will you require if you want to predict the sales of the chocolate in a store.
3. Why data is distributed normally in linear regression.
4. Difference between linear and logistic regression
5. A person who is senior to you and you are working on the same project. But that person has very bad reputation of misbehaving and being rude to people. And he is doing same with you. What will you do?

Aptitude test was divided into 3 parts and was not a typical quant, logical question it was more of an application based questions

Q1. What do you understand about the company?
Add your answer

Q1. Mostly behavioural and situation based questions.
Add your answer

Q1. What projects did u do?
Add your answer

There were 5 tasks/ 3hours in hacker rank R, Python, modelu and just cide and one question in sql

Presence of mind, logical approach, problem solving attitude, flexibility

Q1. Approach to solve the scenario.
Add your answer
Q2. Awareness of the things.
Add your answer

1 hour aptitude test

Q1. What is one hot encoding
Add your answer

Q1. What is your long term goal
Add your answer