10+ Piramal Capital Housing Finance Interview Questions and Answers

The number of delivery boys who called customers more than 5 times is not provided.

• Data on the number of delivery boys who called customers more than 5 times is missing.

• Need to gather data on the number of delivery boys and their call logs.

• Analysis can be done once the data is available.

The minimum number of trips required to achieve a rating of 4.5 is 20.

• To calculate the minimum number of trips required, we need to find the difference between the current rating and the desired rating.

• Since the desired rating is 4.5 and the current rating is 4.2, the difference is 0.3.

• Each trip contributes to the rating, so we need to divide the difference by the rating increment per trip.

• The rating increment per trip can be calculated by dividing the additional discount (10...read more

To understand the supply of restaurants in a particular area of a city, we can use various methods.

• Collect data from online directories like Yelp, Zomato, etc.

• Conduct surveys to gather information about the number of restaurants in the area.

• Analyze the population density and demographics of the area to estimate the demand for restaurants.

• Check the number of restaurant permits issued by the local government.

• Use GIS mapping tools to visualize the distribution of restaurants in ...read more

SQL query to find mean waiting period for delivery partner given driver ID, ordered time and delivered time.

• Use AVG function to calculate mean waiting period

• Subtract ordered time from delivered time to get waiting period

• Filter data by driver ID and delivery partner

• Group by delivery partner

Types of SQL joins and their minimum and maximum possible rows.

• Types of joins: Inner, Left Outer, Right Outer, Full Outer, Cross

• Minimum rows: Inner - 0, Left/Right Outer - 1, Full Outer - 0, Cross - product of rows

• Maximum rows: Inner/Left/Right/Full Outer - product of rows, Cross - product of rows

Steps involved in analyzing decrease in sales for a particular area

• Identify the time period for which sales have decreased

• Analyze the sales data for the area and compare it with previous periods

• Identify any external factors that may have contributed to the decrease in sales

• Conduct customer surveys to identify any issues with products or services

• Analyze competitor activity in the area

• Develop a plan to address the issues identified

• Implement the plan and monitor the results

The drop in Flipkart's revenue in December compared to November can be attributed to seasonal factors, promotional activities, or changes in consumer behavior.

• Seasonal factors such as holiday sales in November leading to higher revenue compared to December

• Promotional activities like Black Friday or Cyber Monday driving higher sales in November

• Changes in consumer behavior, such as delayed purchases or reduced spending after the holiday season

To count distinct unique names from a table, use the SELECT DISTINCT statement with the name column.

• Use SELECT DISTINCT to retrieve unique names

• Specify the name column in the SELECT statement

• Example: SELECT DISTINCT name FROM table_name

• Store the result in an array of strings

I chose Swiggy for its innovative technology, market leadership, and growth potential.

• Swiggy's cutting-edge technology in the food delivery industry stood out to me

• The company's strong market presence and leadership position were appealing

• I was impressed by Swiggy's rapid growth and expansion in the market

• Swiggy's customer-centric approach and focus on quality service were values I admired

Null behaves differently in different types of joins in SQL

• In INNER JOIN, rows with NULL values are excluded from the result set

• In LEFT JOIN, rows with NULL values from the left table are included in the result set

• In RIGHT JOIN, rows with NULL values from the right table are included in the result set

• In FULL OUTER JOIN, rows with NULL values from either table are included in the result set

Rolling sum query adds up a specified number of rows in a table based on a given condition.

• Use the OVER() function to specify the window frame for the rolling sum.

• Specify the number of rows to include in the window frame using ROWS BETWEEN.

• Use ORDER BY to specify the order of rows in the window frame.

• Example: SELECT column1, SUM(column2) OVER (ORDER BY column1 ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS rolling_sum FROM table_name;

Skewness is a measure of the asymmetry of a distribution.

• Skewness indicates the lack of symmetry in a distribution.

• Positive skewness means the tail on the right side of the distribution is longer or fatter.

• Negative skewness means the tail on the left side of the distribution is longer or fatter.

• Types of skewness: Positive skewness, Negative skewness, and Zero skewness (symmetric distribution).

Outliers can be handled by identifying, analyzing, and deciding whether to remove or adjust them based on their impact on the analysis.

• Identify outliers using statistical methods like Z-score, IQR, or visualization techniques like box plots.

• Analyze the outliers to understand if they are due to errors in data collection or represent true anomalies.

• Decide whether to remove outliers if they are errors or adjust them if they are valid data points.

• Consider the impact of outliers o...read more