Add office photos
Premium Employer

Myntra

4.0
based on 2k Reviews
Video summary
Filter interviews by

Maloo Group Interview Questions and Answers

Updated 7 Jun 2024
Popular Designations

Q1. Create the pivot table, sort the data in ascending order

Ans.

Create a pivot table and sort the data in ascending order.

  • To create a pivot table, select the data range and go to the 'Insert' tab in Excel.

  • Choose 'PivotTable' and select the location for the pivot table.

  • Drag the desired fields to the 'Rows' and 'Values' areas.

  • To sort the data in ascending order, click on the drop-down arrow next to the field name in the pivot table and select 'Sort A to Z'.

View 4 more answers

Q2. Use lookup with the product based given data and find the needed data

Ans.

Using lookup with product-based data to find the needed data.

  • Use a lookup function like VLOOKUP or INDEX/MATCH to search for the needed data

  • Identify the key or unique identifier to match the data

  • Specify the range or table where the data is located

  • Retrieve the desired data based on the lookup value

View 2 more answers

Q3. Guestimates question: How many women's drive red car in the Bangalore

Ans.

It is impossible to accurately estimate the number of women driving red cars in Bangalore without specific data.

  • There is no specific data available on the number of women driving red cars in Bangalore.

  • Estimating the number of women driving red cars in Bangalore would require access to vehicle registration data or a survey of car owners.

  • Factors such as car ownership trends among women and the popularity of red cars would also impact the estimate.

View 2 more answers

Q4. Output resukt number of rows basis the joins

Ans.

The output result number of rows depends on the type of join used.

  • Inner join returns only the matching rows from both tables

  • Left join returns all rows from the left table and matching rows from the right table

  • Right join returns all rows from the right table and matching rows from the left table

  • Full outer join returns all rows from both tables

  • Cross join returns the Cartesian product of both tables

Add your answer
Discover Maloo Group interview dos and don'ts from real experiences

Q5. Output result number of rows basis the joins

Ans.

The question asks to output the number of rows based on joins.

  • The number of rows in the output depends on the type of join used.

  • Inner join only returns rows that have matching values in both tables.

  • Left join returns all rows from the left table and matching rows from the right table.

  • Right join returns all rows from the right table and matching rows from the left table.

  • Full outer join returns all rows from both tables.

  • Use COUNT() function to count the number of rows in the out...read more

Add your answer

Q6. how will achieve GMV if your budget is over

Ans.

Achieve GMV by optimizing marketing channels, improving product offerings, and enhancing user experience.

  • Optimize marketing channels to reach a larger audience

  • Improve product offerings to increase customer interest and sales

  • Enhance user experience to encourage repeat purchases and higher order values

Add your answer
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos

Interview Process at Maloo Group

based on 17 interviews
1 Interview rounds
Technical Round
View more
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Data Analyst Interview Questions from Similar Companies

4.1
 • 33 Interview Questions
3.7
 • 31 Interview Questions
3.8
 • 25 Interview Questions
3.5
 • 11 Interview Questions
3.6
 • 11 Interview Questions
3.4
 • 10 Interview Questions
View all
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
75 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter