Super Saravana Stores Data Analyst Interview Questions and Answers

Q1. Difference between where and having clause?.
Ans. 
WHERE clause filters rows before grouping while HAVING clause filters groups after grouping.
• WHERE clause is used to filter rows based on a condition before grouping them.

• HAVING clause is used to filter groups based on a condition after grouping them.

• WHERE clause is used with SELECT, UPDATE, DELETE statements while HAVING clause is used with GROUP BY clause.

• WHERE clause is faster than HAVING clause as it filters rows be...read more
Answered by AI
Add your answer
Q2. Lead lag questions . Explain windows functions and stored procedure
Add your answer

50 questions in 12 minutes to be solved.

Q1. Based on CV tell me about yourself five-year plan
Ans. 
I am an experienced Analyst with a strong background in data analysis and problem-solving. My five-year plan includes advancing my skills in predictive modeling and becoming a team leader in my field.
• Experienced Analyst with expertise in data analysis and problem-solving

• Strong background in predictive modeling

• Goal to become a team leader in the next five years
Answered by AI
Add your answer
Q2. Situational based question
Add your answer

Q1. Tell me about your projects
Ans. 
I have worked on various projects involving data analysis, process improvement, and system implementation.
• Implemented a new CRM system to streamline customer data management

• Conducted data analysis to identify trends and opportunities for cost savings

• Led a cross-functional team to improve inventory management processes

• Developed KPI dashboards to track project performance and ROI
Answered by AI
Add your answer
Q2. What are your day to day activities
Ans. 
As a Business Analyst, my day to day activities include gathering and analyzing data, creating reports, identifying business trends, and collaborating with stakeholders.
• Gathering and analyzing data to identify business opportunities and trends

• Creating reports and presentations to communicate findings to stakeholders

• Collaborating with stakeholders to understand business needs and requirements

• Conducting meetings and inte...read more
Answered by AI
Add your answer

Asked me to prepare a PPT on reliance retail

Q1. We can give only 30% hike.. why would I hire you?
Ans. 
I bring a unique combination of skills, experience, and passion for the role that will drive value beyond just the salary increase.
• My track record of delivering successful projects on time and within budget showcases my ability to add significant value to the organization.

• I possess a diverse skill set including data analysis, problem-solving, and stakeholder management which are crucial for a Business Analyst role.

• My p...read more
Answered by AI
Add your answer

Q1. What are different types of joins
Ans. 
Different types of joins include inner join, outer join, left join, and right join.
• Inner join: Returns rows when there is a match in both tables

• Outer join: Returns all rows when there is a match in one of the tables

• Left join: Returns all rows from the left table and the matched rows from the right table

• Right join: Returns all rows from the right table and the matched rows from the left table
Answered by AI
Add your answer
Q2. What is inner join, cross join, left outer join
Ans. 
Inner join, cross join, and left outer join are types of SQL joins used to combine data from multiple tables.
• Inner join: Returns rows when there is a match in both tables based on the join condition

• Cross join: Returns the Cartesian product of the two tables, combining every row from the first table with every row from the second table

• Left outer join: Returns all rows from the left table and the matched rows from the ri...read more
Answered by AI
Add your answer
Q3. Scenario based questions
Add your answer

Q1. Tell about project that you have been Working on
Ans. 
Developed a data analysis tool for tracking customer behavior on e-commerce platform
• Used Python and SQL to extract and analyze data from the database

• Implemented machine learning algorithms to predict customer preferences

• Created visualizations to present findings to stakeholders
Answered by AI
Add your answer

Q1. Vlookup sumif all excel formulas
Add your answer

Case study on Dmart financials

Q1. How soon can you join
Add your answer
Q2. Immediately I can join
Add your answer

English, Logic, Quantitative Analysis, Situation.

Q1. Can you provide an introduction and describe your past experience?
Ans. 
Experienced business analyst with a strong background in data analysis and process improvement.
• Over 5 years of experience in analyzing business processes and identifying areas for improvement

• Proficient in data analysis tools such as Excel, SQL, and Tableau

• Led cross-functional teams to implement process improvements resulting in cost savings of 10%

• Developed KPIs to track project performance and ensure alignment with bus
Answered by AI
Add your answer
Q2. What attracts you to this company, and what are your goals and areas of focus?
Ans. 
I am attracted to this company's innovative approach to problem-solving and collaborative work environment. My goal is to leverage my analytical skills to drive business growth and efficiency.
• Attracted to company's innovative approach to problem-solving

• Excited about collaborative work environment

• Goal is to leverage analytical skills for business growth and efficiency
Answered by AI
Add your answer