AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Lifestyle
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Lifestyle Business Analyst Interview Questions and Answers
Lifestyle Business Analyst Interview Experiences
1 interview found
Anonymous
I applied via Recruitment Consultant and was interviewed before Jan 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Question related IT and Business
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.
(5 Questions)
- Q1. Prepare All theoretical questions related to SQL and excel. Learn everything about your resume so that you will be able to explain each and everything about the resume.
- Q2. Difference between Vlookup and Xlookup ?
- Ans.
Vlookup searches for a value in the first column of a range and returns a value in the same row from a specified column. Xlookup is a more powerful and flexible function that can search in any direction and return multiple results.
Vlookup searches vertically in a table and returns a value from a specified column.
Xlookup can search in any direction (horizontal, vertical, or both) and return multiple results.
Vlookup requ...
- Q3. Difference between Subquery and CTE. Which is better?
- Ans.
Subquery is a query nested within another query, while CTE is a temporary result set defined within a query. Both have their own use cases.
Subquery is enclosed in parentheses and can be used in SELECT, INSERT, UPDATE, or DELETE statements.
CTE is defined using the WITH keyword and can be referenced multiple times in a query.
CTEs are more readable and easier to maintain compared to subqueries.
Subqueries are useful when t...
- Q4. No of records returned after applying left and inner join on 2 tables.
- Q5. Pivot the table in SQL using case when statements.
- Ans.
Pivoting a table in SQL using case when statements
Use the CASE WHEN statement to create new columns based on specific conditions
Use the SUM or COUNT function to aggregate data in the pivoted table
Group by the remaining columns to ensure correct aggregation
Example: SELECT id, SUM(CASE WHEN category = 'A' THEN value END) AS A_total FROM table_name GROUP BY id;
Business Case Questions Based on a scenario where the company's Sales is Declining. How we can address the issue using transaction data
Interview Preparation Tips
- SQL
- EXCEL
Skills evaluated in this interview
(2 Questions)
- Q1. General question on powerbi and sql
- Q2. Had solve sone queries on sql
(2 Questions)
- Q1. What is Gross profit
- Ans.
Gross profit is the total revenue minus the cost of goods sold.
Gross profit = Total revenue - Cost of goods sold
It represents the profit a company makes from its core business activities before deducting operating expenses.
It does not include expenses such as taxes, interest, and other non-operating costs.
Gross profit margin is calculated as (Gross profit / Total revenue) * 100%
Example: If a company has total revenue o...
- Q2. GP = Sales - COGS
(2 Questions)
- Q1. Hahsk kdks ksksk sks
- Q2. Jeks ksks dkkd dd fr ss
I applied via Referral and was interviewed in Sep 2023. There was 1 interview round.
(2 Questions)
- Q1. How do you align with the core values and mission of Walmart?
- Q2. What advice would you give to the CEO of walmart?
yogini katkar
I applied via Job Portal and was interviewed in Jan 2024. There was 1 interview round.
(1 Question)
- Q1. Difference between SQL /NON SQL
- Ans.
SQL is a structured query language used for relational databases, while NoSQL is a non-relational database management system.
SQL is used for structured data with predefined schema, while NoSQL is used for unstructured or semi-structured data.
SQL databases are vertically scalable, while NoSQL databases are horizontally scalable.
SQL databases are ACID compliant, ensuring data integrity, while NoSQL databases sacrifice so...
Skills evaluated in this interview
Selected
I applied via LinkedIn and was interviewed before May 2023. There were 3 interview rounds.
(1 Question)
- Q1. SQL and Visualizationbased questions
Case study for business problems
(1 Question)
- Q1. Behaviour fit round
Selected
I applied via Company Website and was interviewed before Aug 2022. There were 2 interview rounds.
(2 Questions)
- Q1. Subjective based
- Q2. Situational awareness
Interview Preparation Tips
I applied via Walk-in and was interviewed in Feb 2020. There was 1 interview round.
Interview Questionnaire
6 Questions
- Q1. How can maintain business analyst
- Ans.
To maintain as a business analyst, one should continuously update skills, stay informed about industry trends, and actively engage with stakeholders.
Continuously update skills through training, certifications, and attending industry conferences.
Stay informed about industry trends, new technologies, and best practices.
Actively engage with stakeholders to understand their needs, gather requirements, and provide valuable ...
- Q2. How can grown business.
- Ans.
To grow a business, focus on market research, customer satisfaction, innovation, and effective marketing strategies.
Conduct thorough market research to identify opportunities and target audience.
Ensure customer satisfaction by providing high-quality products/services and excellent customer support.
Encourage innovation and adapt to changing market trends.
Develop effective marketing strategies to reach and attract potent...
- Q3. How can created ticket size.
- Ans.
Ticket size can be increased by implementing strategies to upsell and cross-sell products or services.
Analyze customer data to identify opportunities for upselling and cross-selling
Train sales teams to effectively communicate and promote additional products or services
Offer incentives or discounts for customers who purchase larger ticket sizes
Implement targeted marketing campaigns to promote higher-priced products or s...
- Q4. Customers entry analysis
- Q5. In store tribal
- Q6. Inventory management
Interview Preparation Tips
Basic Aptitude question
Allocated one topic and given half an hour of time to prepare on it
(2 Questions)
- Q1. Tenchnical coding related questions
- Q2. Libraries used for interview, basic joins etc
(1 Question)
- Q1. Business related questions
(1 Question)
- Q1. Why do you want to join this company
Tell us how to improve this page.
Lifestyle Interviews By Designations
- Lifestyle CSR Executive Interview Questions
- Lifestyle Senior Cashier Interview Questions
- Lifestyle Senior Executive Interview Questions
- Lifestyle Supervisor Interview Questions
- Lifestyle Business Manager Interview Questions
- Lifestyle CSR Interview Questions
- Lifestyle Department Manager Interview Questions
- Lifestyle Sales Executive Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Development Associate Interview Questions
- Senior Business Analyst Interview Questions
- Business Associate Interview Questions
- Business Development Interview Questions
- Business Executive Interview Questions
- Business Manager Interview Questions
- Show more
Business Analyst Interview Questions from Similar Companies
|
Department Manager
256
salaries
|  ₹2.5 L/yr - ₹6 L/yr |
|
Concept Manager
236
salaries
| ₹4 L/yr - ₹9 L/yr |
|
Sales Executive
224
salaries
| ₹1 L/yr - ₹4 L/yr |
|
Cashier
221
salaries
| ₹0.6 L/yr - ₹3.7 L/yr |
|
Customer Service Representative
216
salaries
| ₹1 L/yr - ₹3.4 L/yr |
Fabindia
Westside
Pantaloons
Shoppers Stop
- Home >
- Interviews >
- Lifestyle Interview Questions >
- Lifestyle Business Analyst Interview Questions
