Flipkart Business Analyst Interview Questions and Answers

Q1. Tell me about a project you faced difficulties?
Add your answer
Q2. Given a table ..asked some SQL questions
Add your answer

Q1. Shared a table ...asked to write some SQL queries
Ans. 
SQL queries are essential for data manipulation and retrieval in databases, crucial for business analysis.
• Use SELECT to retrieve data, e.g., SELECT * FROM employees;

• WHERE clause filters results, e.g., SELECT * FROM sales WHERE amount > 1000;

• JOIN combines data from multiple tables, e.g., SELECT a.name, b.amount FROM customers a JOIN orders b ON a.id = b.customer_id;

• GROUP BY aggregates data, e.g., SELECT product_id, C...read more
Answered by AI
Add your answer
Q2. Sman queries result how to derive in excel
Ans. 
Use Excel functions like VLOOKUP or INDEX/MATCH to derive results from SQL queries in Excel.
• Use VLOOKUP function to search for a value in a table and return a corresponding value from another column.

• Use INDEX/MATCH function to perform a two-way lookup by matching values in two different ranges.

• Import SQL query results into Excel using data connection or copy-paste method.
Answered by AI
Add your answer

Casestudy relate dto ab testing

Sql tests on joins and emp database

Q1. Why do you want to switch
Ans. 
I am looking for new challenges and opportunities for growth in my career.
• Seeking opportunities to expand my skill set

• Interested in working on different projects and industries

• Want to learn new technologies and methodologies

• Desire for career advancement and professional development
Answered by AI
Add your answer
Q2. Why do you want to join flipkart?
Ans. 
I want to join Flipkart because of its innovative work culture and market leadership in the e-commerce industry.
• Impressed by Flipkart's innovative approach to e-commerce

• Excited about the opportunity to work in a market leader in the industry

• Interested in contributing to Flipkart's growth and success

• Appreciate Flipkart's focus on customer satisfaction and user experience
Answered by AI
Add your answer

Sql joins and ranks and all

Q1. Tell about yourself
Ans. 
I am a detail-oriented Business Analyst with a passion for data-driven decision-making and a strong background in project management.
• Over 5 years of experience in business analysis across various industries, including finance and healthcare.

• Skilled in gathering and documenting requirements, as demonstrated in a recent project where I improved a client's reporting process by 30%.

• Proficient in using tools like SQL and Ta...read more
Answered by AI
Add your answer
Q2. What is expected
Ans. 
A Business Analyst identifies business needs and provides solutions to improve processes and systems.
• Understand stakeholder requirements through interviews and workshops.

• Analyze data to identify trends and insights, e.g., sales performance.

• Create documentation like business requirements documents (BRD) and use cases.

• Facilitate communication between IT and business teams to ensure alignment.

• Use tools like SWOT analysis ...read more
Answered by AI
Add your answer

Basic aptitude test which is easily done

Q1. What are joins? What is windows function
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them. Window functions perform calculations across a set of table rows that are related to the current row.
• Joins are used in SQL to combine data from multiple tables based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Window functions are used to perform calculations on a set of rows rela...read more
Answered by AI
Add your answer
Q2. Aggregation and ctes and subqueries
Add your answer