BillDesk Business Analyst Interview Questions and Answers

Q1. Sql question on window function
Add your answer
Q2. Find the highest sells from each yr
Ans. 
Identify the highest sales figures for each year from a given dataset.
• Aggregate sales data by year to find maximum sales.

• Use SQL query: SELECT YEAR(date), MAX(sales) FROM sales_data GROUP BY YEAR(date).

• In Excel, use Pivot Tables to summarize and find max sales per year.

• Example: If 2020 had sales of $5000, $7000, and $6000, the highest is $7000.
Answered by AI
Add your answer
Q3. Guesstimate for success of cab pulling in patna
Ans. 
Assessing the potential success of cab services in Patna involves market demand, competition, and infrastructure factors.
• Market Demand: Patna has a growing population, increasing the need for reliable transportation options.

• Competition: Existing services like Ola and Uber already operate in Patna, affecting market entry.

• Infrastructure: Road conditions and traffic patterns in Patna can impact cab service efficiency.

• Loca...read more
Answered by AI
Add your answer

Q1. SQL Queries for JOINS
Ans. 
SQL queries for JOINS
• Use INNER JOIN to retrieve rows from both tables that have matching values

• Use LEFT JOIN to retrieve all rows from the left table and the matched rows from the right table

• Use RIGHT JOIN to retrieve all rows from the right table and the matched rows from the left table

• Use FULL JOIN to retrieve rows when there is a match in either table
Answered by AI
Add your answer
Q2. QUERY FOR metrics given in the sheet
Ans. 
The query is asking for metrics provided in a specific sheet.
• Identify the specific sheet being referred to in the question

• Review the metrics listed in the sheet

• Analyze the relevance of each metric to the query
Answered by AI
Add your answer

This is a case study round revolve around a business problem in which we have to analyse data driven solutions.

Q1. SQL, Python and Excel
Add your answer

Q1. Questions around Sql, python. Ranks, joins, self joins, partitions
Add your answer
Q2. Tableau powerbi basics
Add your answer

Guesstimates, business case study

Case studies about Navi UPI

Case studies about Navi UPI App

Quantitative case study on cost benefit analysis of 2 types of public buses running in a city. Need to choose one of them with higher profits

Fraud detection model: 3rd party firm proposing to use thier model for fraud detection. Need to profit analysis of whether to go for it or not.

Q1. Culture fit round to understand if compatible with the company
Add your answer

Sql and excel then tableu

Q1. Sql and excel and basic questions
Add your answer

Q1. Longterm aspiration
Add your answer

Quantitative aptitude, verbal ability, critical reasoning

Q1. SQL: find store with highest AOV
Ans. 
Use SQL query to find store with highest Average Order Value (AOV).
• Use GROUP BY clause to group by store

• Calculate AOV by dividing total revenue by total orders

• Use ORDER BY and LIMIT to find store with highest AOV
Answered by AI
Add your answer
Q2. Generic behavioural questions
Add your answer