Rapido interview experience Real time questions & tips from candidates to crack your interview

Business Analyst

Rapido
upvote
share-icon
1 rounds | 2 Coding problems

Interview preparation journey

expand-icon
Journey
I focused on building a strong foundation in SQL, Python, and Excel to strengthen my data analysis skills. I practiced writing queries, manipulating datasets, and performing calculations in SQL and Excel. In Python, I learned to handle data structures, perform data cleaning, and write scripts to automate tasks. This combination of tools helped me gain hands-on experience in analyzing, processing, and visualizing data effectively.
Preparation
Topics: SQL, Python, and Excel
Application process
Where: Coding Ninjas Placement Cell
Eligibility: Master’s OR Bachelor’s degree

Interview rounds

01
Round
Medium
Online Coding Interview
Duration
Interview date15 May 2025
Coding problem2

1. Handling NULLs and Duplicates with SQL Joins

Analyze and implement SQL joins (INNER, LEFT, RIGHT, FULL) to manage scenarios involving NULL values and repeating records. Write queries that correctly handle these cases and interpret the resulting output to ensure accurate data retrieval.

2. Retrieve Top Product per Category

Write an SQL query to identify the top product in each category based on a specified criterion (e.g., highest sales, rating, or revenue). The query should group products by category and return the product that meets the criterion within each group.

Here's your problem of the day

Solving this problem will increase your chance to get selected in this company

Skill covered: Programming

What is recursion?

Choose another skill to practice
Similar interview experiences
Product Engineer
2 rounds | 2 problems
Interviewed by Rapido
2849 views
0 comments
0 upvotes
Senior Product Engineer
2 rounds | 2 problems
Interviewed by Rapido
1276 views
1 comments
0 upvotes
SDE - 1
3 rounds | 7 problems
Interviewed by Rapido
3315 views
0 comments
0 upvotes
Business Analyst
2 rounds | 4 problems
Interviewed by Rapido
281 views
0 comments
0 upvotes