Premium Employer

i

This company page is being actively managed by Baazar Retail Private Limited Team. If you also belong to the team, you can get access from here

Baazar Retail Private Limited Verified Tick

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Baazar Retail Private Limited Business Manager Interview Questions and Answers

Updated 8 Apr 2024

Baazar Retail Private Limited Business Manager Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - Aptitude Test 

Tell me about the work and give me a call when you can have a wonderful day

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Technical 

(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...

  • Answered by AI
  • 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...

  • Answered by AI
  • 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;

  • Answered by AI
Round 2 - Case Study 

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

Topics to prepare for Landmark Group Business Analyst interview:
  • SQL
  • EXCEL
Interview preparation tips for other job seekers - Solve as many Business case studies as you can. Prepare well for SQL questions. You might get asked situation-based questions. Follow and show a structured approach while solving these questions. and you are good to go.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. How do you search properties
  • Ans. 

    I search properties through online listings, networking with real estate agents, attending auctions, and utilizing property search tools.

    • Utilize online listings on websites like Zillow, Realtor.com, and MLS

    • Network with real estate agents to gain access to off-market properties

    • Attend auctions and sheriff sales to find potential investment opportunities

    • Use property search tools like PropStream or Redfin to analyze market

  • Answered by AI
  • Q2. What is market benchmarking
  • Ans. 

    Market benchmarking is the process of comparing a company's performance metrics to industry standards to identify areas for improvement.

    • Market benchmarking involves analyzing key performance indicators (KPIs) such as sales, market share, and profitability.

    • It helps companies understand their competitive position in the market and identify opportunities for growth.

    • Benchmarking can be done against direct competitors, indu...

  • Answered by AI
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. General question on powerbi and sql
  • Q2. Had solve sone queries on sql
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Aug 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Subjective based
  • Q2. Situational awareness

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for situational based scenarios questions
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Basic Aptitude question

Round 2 - Group Discussion 

Allocated one topic and given half an hour of time to prepare on it

Round 3 - Technical 

(2 Questions)

  • Q1. Tenchnical coding related questions
  • Q2. Libraries used for interview, basic joins etc
Round 4 - One-on-one 

(1 Question)

  • Q1. Business related questions
Round 5 - HR 

(1 Question)

  • Q1. Why do you want to join this company
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I was interviewed before Jan 2024.

Round 1 - Assignment 

Some power BI problems and excel problems

Round 2 - Technical 

(1 Question)

  • Q1. SQL query questions along with power bi
Round 3 - HR 

(1 Question)

  • Q1. Excel and Power Bi and Analytics
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. About sql, python, visualaization
Round 2 - Technical 

(1 Question)

  • Q1. About sql and business kpi's
Round 3 - Technical 

(1 Question)

  • Q1. Sql and business kpi's
Round 4 - HR 

(1 Question)

  • Q1. Salary negotiation
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

60 question 90 minutes

Round 2 - Group Discussion 

Faviorate sports persion of india

Interview Preparation Tips

Interview preparation tips for other job seekers - good
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jul 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Write sql query on leet code
  • Ans. 

    SQL query on LeetCode platform for business analysis.

    • Use SELECT statement to retrieve data from database tables.

    • Use JOIN clause to combine data from multiple tables.

    • Use WHERE clause to filter data based on specific conditions.

  • Answered by AI
  • Q2. Power BI interview questions

Skills evaluated in this interview

Baazar Retail Private Limited Interview FAQs

How many rounds are there in Baazar Retail Private Limited Business Manager interview?
Baazar Retail Private Limited interview process usually has 1 rounds. The most common rounds in the Baazar Retail Private Limited interview process are Aptitude Test.

Tell us how to improve this page.

Baazar Retail Private Limited Business Manager Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
Join Baazar Retail Private Limited Most Successful Value Retailer in East India

Interview Questions from Similar Companies

Reliance Retail Interview Questions
3.9
 • 1.5k Interviews
DMart Interview Questions
3.9
 • 399 Interviews
Vishal Mega Mart Interview Questions
3.8
 • 157 Interviews
Landmark Group Interview Questions
4.0
 • 147 Interviews
Lowe's Interview Questions
4.1
 • 131 Interviews
Tesco Interview Questions
3.8
 • 122 Interviews
Target Interview Questions
4.2
 • 119 Interviews
Shoppers Stop Interview Questions
4.1
 • 111 Interviews
Trent Interview Questions
4.0
 • 76 Interviews
View all
Department Manager
177 salaries
unlock blur

₹1 L/yr - ₹3.5 L/yr

Store Manager
155 salaries
unlock blur

₹3 L/yr - ₹6.8 L/yr

Assistant Store Manager
148 salaries
unlock blur

₹1.9 L/yr - ₹4.3 L/yr

Retail Store Manager
48 salaries
unlock blur

₹2.3 L/yr - ₹6.2 L/yr

Assistant Manager
44 salaries
unlock blur

₹2.2 L/yr - ₹4.5 L/yr

Explore more salaries
Compare Baazar Retail Private Limited with

Big Bazaar

4.3
Compare

Reliance Retail

3.9
Compare

Spencer's Retail

3.8
Compare

Future Retail

4.3
Compare
Did you find this page helpful?
Yes No
write
Share an Interview