1500+ Business Analyst Interview Questions and Answers

Saving account is for saving money and earning interest while current account is for frequent transactions.

• Saving account earns interest while current account does not.

• Saving account has a limit on the number of transactions while current account does not.

• Current account is meant for frequent transactions while saving account is not.

• Saving account has a higher interest rate than current account.

• Examples of saving accounts include fixed deposit accounts, recurring deposit acco...read more

R-squared measures the goodness of fit of a regression model, while p-value indicates the significance of the relationship between the independent variable and the dependent variable.

• R-squared is a measure of how well the independent variable(s) explain the variability of the dependent variable in a regression model.

• A high R-squared value close to 1 indicates a good fit, meaning the model explains a large portion of the variance in the dependent variable.

• The p-value in linear...read more

To make 4L from 3L and 5L jars, fill the 5L jar, pour 3L into the 3L jar, empty the 3L jar, and pour the remaining 2L from the 5L jar into the 3L jar. Finally, fill the 5L jar again and pour 1L into the 3L jar, resulting in 4L in the 5L jar.

• Fill the 5L jar completely

• Pour 3L from the 5L jar into the 3L jar

• Empty the 3L jar

• Pour the remaining 2L from the 5L jar into the 3L jar

• Fill the 5L jar again

• Pour 1L from the 5L jar into the 3L jar

• Result: 4L in the 5L jar

The number of tennis balls that can fit in a school bus depends on the size of the bus and the size of the tennis balls.

• The size of the school bus and the size of the tennis balls are important factors to consider.

• The shape of the tennis balls and how they are packed also affects the number that can fit.

• Assuming an average school bus size and tennis ball size, approximately 50,000 tennis balls can fit in a school bus.

Sort and remove duplicates to ensure availability of products for Blinkit and Zepto campaigns throughout the day in Python.

• Sort the products list for each campaign

• Remove duplicates from the sorted list

• Repeat the process for both Blinkit and Zepto campaigns

Data analytics allows me to use my technical skills to solve business problems and make data-driven decisions.

• Data analytics helps me to identify patterns and trends in data that can be used to improve business processes.

• It allows me to work with large datasets and use statistical methods to extract insights.

• I can use my technical skills to develop and implement data models and algorithms.

• Data analytics is a growing field with many opportunities for career advancement.

• Example...read more

Use a binary search approach to find the heavier ball among 'n' balls using a weighing balance.

• Divide the 'n' balls into two equal groups and weigh them on the balance.

• If one group is heavier, repeat the process with that group.

• If both groups weigh the same, the heavier ball is among the remaining unweighed balls.

• Continue dividing and weighing until the heavier ball is found.

The business portal added under ministry of new and renewable energy is SAMPADA.

• SAMPADA stands for System for Assessment, Awareness and Training for Renewable Energy Applications

• It is a web-based platform for promoting and creating awareness about renewable energy technologies

• It provides information on various renewable energy technologies, their applications, and financial incentives available for their adoption

• It also offers online training and certification courses on rene...read more

Find 4 consecutive empty seats in a theater using SQL window functions.

• Use a table with seat numbers and their status (occupied or empty).

• Apply window functions like ROW_NUMBER() to identify consecutive empty seats.

• Filter results to find sequences of 4 empty seats.

• Example SQL: SELECT seat_number FROM seats WHERE status = 'empty' ORDER BY seat_number LIMIT 4;

Explaining SQL JOINs: right JOIN, left JOIN, and outer JOIN with examples.

• LEFT JOIN returns all records from the left table and matched records from the right table.

• Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;

• RIGHT JOIN returns all records from the right table and matched records from the left table.

• Example: SELECT * FROM A RIGHT JOIN B ON A.id = B.id;

• FULL OUTER JOIN returns all records when there is a match in either left or right table.

• Example: SELECT * FROM A FULL ...read more

The angle at which the plane descends cannot be accurately determined without additional information.

• The angle of descent depends on the rate of descent and the distance remaining to the destination.

• The weight of the plane, wind speed and direction, and other factors can also affect the angle of descent.

• Without knowing the rate of descent or the remaining distance, it is impossible to accurately estimate the angle of descent.

I ensure customer gets the right solution by understanding their business needs, analyzing data, and collaborating with stakeholders.

• Conduct thorough analysis of customer's business needs

• Gather and analyze relevant data to identify potential solutions

• Collaborate with stakeholders to ensure solution aligns with business goals

• Provide recommendations and options for the customer to choose from

• Continuously monitor and evaluate the solution to ensure it meets customer's needs

Counting colored 1x1 cubes from a larger cube with specific color distributions.

• A cube has 6 faces; coloring 3 faces red and 3 faces blue creates various colored smaller cubes.

• 1 red face: Count cubes on red face but not on edges or corners.

• 1 blue face: Similar to red, count cubes on blue face.

• 1 red + 1 blue: Count cubes on edges where red and blue meet.

• 2 red + 1 blue: Count cubes on edges with 2 red faces and 1 blue face.

• 1 red + 2 blue: Count cubes on edges with 1 red face an...read more

Key metrics for tracking growth in brick and mortar business.

• Sales revenue

• Customer footfall

• Average transaction value

• Customer retention rate

• Inventory turnover rate

• Gross profit margin

• Net promoter score

• Employee productivity

• Marketing ROI

The current Sensex of India is constantly changing and can be checked on financial news websites.

• Sensex is the stock market index of the Bombay Stock Exchange (BSE) in India.

• It represents the performance of the top 30 companies listed on the BSE.

• As of now, the Sensex is constantly fluctuating due to various economic factors.

• One can check the current Sensex value on financial news websites like Moneycontrol, Economic Times, etc.

Finding the triangle with max area given sides.

• Use Heron's formula to calculate the area of each triangle.

• Compare the areas and select the triangle with the maximum area.

• For sides 300, 400, 500, area = 60000 sq. units.

• For sides 300, 400, 700, area = 72000 sq. units.

Online businesses operate through the internet, allowing customers to purchase goods or services remotely.

• Online businesses can operate through their own website or through third-party platforms such as Amazon or Etsy.

• Customers can browse and purchase products or services online, with payment and shipping options available.

• Online businesses can also use social media and digital marketing to reach a wider audience and promote their products or services.

• Examples of successful o...read more

No, two diodes in series cannot work as a transistor.

• Transistors have three terminals while diodes have two.

• Transistors can amplify signals while diodes cannot.

• Transistors can be used as switches while diodes cannot.

• Diodes in series will only increase the voltage drop.

• Transistors have different modes of operation such as common emitter, common base, and common collector.

Inner Join returns only the matching rows between two tables, while Left Join returns all rows from the left table and the matching rows from the right table.

• Inner Join only includes rows that have matching values in both tables

• Left Join includes all rows from the left table, even if there are no matching rows in the right table

• Example: Inner Join - SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id

• Example: Left Join - SELECT * FROM table1 LEFT JOIN table2 ON tab...read more

Approximately 2 million metric tons of detergent is used in India annually.

• Consider the population of India and the average usage of detergent per person.

• Factor in the usage of detergent in industries and commercial establishments.

• Take into account the different types of detergents used for various purposes.

• Refer to market research reports for more accurate data.

• Assume a growth rate in detergent usage based on population and economic growth.

• Approximately 2 million metric tons...read more

Linear Regression is used for continuous data while Logistic Regression is used for categorical data.

• Linear Regression predicts continuous values while Logistic Regression predicts probabilities.

• Linear Regression uses a straight line to fit the data while Logistic Regression uses an S-shaped curve.

• Linear Regression uses Mean Squared Error as the cost function while Logistic Regression uses Log Loss.

• Linear Regression is sensitive to outliers while Logistic Regression is robust...read more

Dimensions are categorical fields used for grouping and filtering data, while measures are numerical fields used for calculations and aggregation.

• Dimensions are qualitative data like names, dates, or categories.

• Measures are quantitative data like sales, profit, or quantity.

• Dimensions are used for slicing and dicing data, while measures are used for calculations and aggregations.

• Example: In a sales dataset, 'Product Category' would be a dimension, and 'Sales Amount' would be a...read more

The most used diagrams in Business Analytics are flowcharts, swimlane diagrams, and entity-relationship diagrams.

• Flowcharts are used to represent processes and workflows.

• Swimlane diagrams are used to show the responsibilities of different departments or individuals in a process.

• Entity-relationship diagrams are used to show the relationships between different entities in a system.

• Other commonly used diagrams include Gantt charts, pie charts, and bar graphs.

• These diagrams help ...read more

Citi bank should set up its offices in major cities like Mumbai, Delhi, and Bangalore.

• Citi bank should consider the economic and political stability of the region.

• The bank should also consider the availability of skilled workforce and infrastructure.

• Major cities like Mumbai, Delhi, and Bangalore have a large customer base and a well-established financial sector.

• Setting up offices in multiple cities can help the bank reach a wider audience and diversify its operations.

I would analyze the cost structure and pricing strategy to identify the root cause of decreasing profit.

• Analyze the cost structure to identify any cost increases that may be impacting profit margins

• Review pricing strategy to ensure it is aligned with market demand and competition

• Evaluate sales mix to determine if there are any products or services that are less profitable

• Consider implementing cost-cutting measures or adjusting pricing strategy to improve profitability

I'm sorry, I don't have access to the current data on the number of people who place online orders on Zomato.

Techniques for requirement prioritization

• MoSCoW prioritization

• Kano model

• Value vs Complexity matrix

• Risk vs Benefit analysis

• User story mapping