Product Business Analyst Interview Questions and Answers

Describing day-to-day activities, A/B testing, Tata cars in India, and difference between rank functions for Product Business Analyst role.

• Day-to-day activities include gathering and analyzing data, creating reports, identifying trends, and collaborating with cross-functional teams.

• A/B testing involves comparing two versions of a product or feature to determine which performs better.

• As of 2021, Tata Motors has sold over 4 million cars in India.

• Rank, dense_rank, and row_number...read more

Answers to SQL-related questions for Product Business Analyst position

• Truncate is a DDL command that removes all rows from a table without logging the individual row deletions, while delete is a DML command that removes specific rows from a table and logs each deletion

• Drop is a DDL command that removes an entire table from the database

• Union combines the results of two or more SELECT statements into a single result set, while Union All includes all rows from each SELECT statem...read more

Criteria for finalizing a 3PL include cost, reliability, technology capabilities, geographic coverage, and customer service.

• Cost: Evaluate pricing structure and compare with competitors.

• Reliability: Check track record for on-time deliveries and accuracy.

• Technology capabilities: Ensure compatibility with your systems and ability to provide real-time tracking.

• Geographic coverage: Consider locations served and proximity to your facilities.

• Customer service: Assess responsiveness,...read more

Key performance indicators (KPIs) for improving supply chain performance include inventory turnover, on-time delivery, lead time, and supplier performance.

• Inventory turnover: measures how quickly inventory is sold and replaced

• On-time delivery: tracks the percentage of orders delivered on time

• Lead time: measures the time it takes for an order to be fulfilled

• Supplier performance: evaluates the reliability and quality of suppliers

A rolling sum for sales calculates the cumulative total of sales over a specified period of time.

• Calculate the sum of sales for each day and add it to the previous day's total

• Use a loop to iterate through the sales data and update the rolling sum

• Consider the time period for the rolling sum, such as weekly or monthly totals