Big Bazaar Business Associate Interview Questions and Answers

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.
Add your answer
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...read more
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer
Q4. No of records returned after applying left and inner join on 2 tables.
Add your answer
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
Add your answer

Business Case Questions Based on a scenario where the company's Sales is Declining. How we can address the issue using transaction data

Q1. General question on powerbi and sql
Add your answer
Q2. Had solve sone queries on sql
Add your answer

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...read more
Answered by AI
Add your answer
Q2. GP = Sales - COGS
Add your answer

Q1. Hahsk kdks ksksk sks
Add your answer
Q2. Jeks ksks dkkd dd fr ss
Add your answer

Q1. What is you future goal
Add your answer
Q2. What is you next step
Add your answer
Q3. What is you financial independent
Add your answer
Q4. What is you expect salary
Add your answer
Q5. What is you experience
Add your answer

Q1. How do you align with the core values and mission of Walmart?
Add your answer
Q2. What advice would you give to the CEO of walmart?
Add your answer

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...read more
Answered by AI
Add your answer

Q1. SQL situation based questions
Add your answer

Q1. Have good understanding of the projects
Add your answer

Q1. How important is Vendor relationship for a product team?
Ans. 
Vendor relationships are crucial for a product team's success as they impact product quality, cost, and delivery timelines.
• Vendor relationships can impact product quality by ensuring high-quality materials and components are used.

• Strong vendor relationships can lead to cost savings through negotiated pricing and discounts.

• Timely delivery of components and materials is crucial for meeting product deadlines, which can be...read more
Answered by AI
Add your answer
Q2. How would you give each brand a personality and a customer profile?
Ans. 
To give each brand a personality and customer profile, I would conduct market research, analyze target demographics, create brand messaging, and tailor marketing strategies accordingly.
• Conduct market research to understand target demographics and consumer behavior

• Create brand messaging that resonates with the target audience

• Tailor marketing strategies to reach and engage with the specific customer profile

• Use customer f...read more
Answered by AI
Add your answer

Q1. What was the biggest challenge in your career?
Ans. 
The biggest challenge in my career was managing a team through a major company restructuring.
• Navigating uncertainty and keeping team morale high during the transition

• Balancing the needs of upper management with the well-being of my team

• Adapting to new roles and responsibilities in the restructured organization
Answered by AI
Add your answer
Q2. If you have a team of X number of people, how would you manage each individual basis, their skill set?
Ans. 
I would assess each team member's skill set, assign tasks accordingly, provide necessary training and support, and regularly review performance.
• Conduct individual skill assessments to understand strengths and weaknesses

• Assign tasks based on each team member's skill set

• Provide necessary training and support to enhance skills

• Regularly review performance and provide feedback for improvement

• Encourage collaboration and know
Answered by AI
Add your answer

Q1. What are the missing gaps on the floor in terms of product offering for youth label and smart label?
Ans. 
The missing gaps in product offerings for youth label and smart label on the floor need to be identified and addressed.
• Expand the range of trendy and fashionable clothing options for the youth label to attract younger customers.

• Introduce more tech-savvy and innovative products under the smart label to cater to the needs of tech-savvy consumers.

• Consider adding sustainable and eco-friendly options to both labels to appea...read more
Answered by AI
Add your answer
Q2. How would you increase Denim contribution in sales?
Ans. 
To increase Denim contribution in sales, focus on marketing campaigns, product innovation, and customer engagement.
• Launch targeted marketing campaigns highlighting the unique features of Denim products

• Introduce new styles and designs to attract a wider customer base

• Offer special promotions or discounts on Denim products to boost sales

• Collaborate with influencers or celebrities to promote Denim products on social media
Answered by AI
Add your answer