1500+ Business Analyst Interview Questions and Answers

Weigh each box one by one and compare the weight with the expected weight.

• Weigh the first box, if it weighs 100gm then it's not the defective box.

• If it weighs 99gm, then it's the defective box.

• If it weighs 101gm, move on to the next box and repeat the process.

• Continue until you find the box with the defective balls.

The last person surviving will be the 73rd person.

• The pattern of shooting skips every second person.

• After each round of shooting, the number of people remaining is halved.

• The last person standing will be the one who is skipped in every round of shooting.

My strong point is Java. I have a good understanding of inheritance, modularity, and abstraction. I also have knowledge of C++.

• Inheritance is a mechanism in OOP where a new class is derived from an existing class. Types of inheritance are single, multiple, multilevel, and hierarchical.

• C++ is a compiled language while Java is an interpreted language. C++ supports operator overloading while Java does not.

• Modularity in C++ is achieved through the use of header files and namespac...read more

The task is to find the sum of squares of the first 'N' natural numbers.

• Iterate from 1 to N and calculate the square of each number

• Add all the squares together to get the final sum

• Return the sum as the result

The last ball will be red.

• If the first two balls are of different colors, they will be replaced with a red ball.

• If the first two balls are of the same color, they will be replaced with a blue ball.

• The number of balls in the container does not affect the outcome.

• The last ball will be red because there are more red balls than blue balls in the container.

Fill the 3L jar and pour it into the 5L jar. Repeat the process with 3L jar and stop when 5L jar has 4L water.

• Fill 3L jar and pour it into 5L jar

• Repeat the process until 5L jar has 4L water

• 4L can be measured by filling 3L jar twice and pouring it into 5L jar until it reaches 4L

The minimum number of times you need to weigh the coins is 4.

• Divide the 100 coins into 3 groups of 33, 33, and 34 coins.

• Weigh the first two groups against each other.

• If they balance, the defective coin is in the third group.

• If they don't balance, the defective coin is in the lighter group.

• Divide the lighter group into 11 coins and weigh any 2 groups of 3 coins against each other.

• If they balance, the defective coin is one of the remaining 5 coins.

• If they don't balance, the def...read more

The 100th person will be alive.

• The pattern shows that every even numbered person is killed and every odd numbered person receives the sword.

• The sword eventually comes back to the 1st person who started the cycle.

• Therefore, the 100th person will be killed by the 99th person and the sword will go back to the 1st person.

• Hence, the 1st person will be the only one left alive.

Label the outcomes as 0 and 1. Toss the dice twice and record the outcome as 00, 01, 10, or 11. If the outcome is 00 or 11, discard and repeat.

• Label the outcomes as 0 and 1

• Toss the dice twice and record the outcome as 00, 01, 10, or 11

• If the outcome is 00 or 11, discard and repeat

This pen is not just a writing instrument, it's a statement of luxury and exclusivity.

• Highlight the pen's unique design and craftsmanship

• Emphasize the use of high-quality materials

• Mention any special features or functions

• Create a sense of exclusivity and rarity

• Appeal to the buyer's desire for luxury and status

• Offer personalized engraving or customization options

The exact number of orders delivered by Swiggy in Pune on a daily basis is not publicly available.

• Swiggy does not disclose the number of orders delivered in a specific city on a daily basis.

• The number of orders delivered by Swiggy in Pune may vary depending on factors such as day of the week, time of day, and season.

• Swiggy's focus is on providing timely and efficient delivery services to its customers, rather than on disclosing the number of orders delivered.

• However, Swiggy h...read more

The maximum number of corn fields possible in a 10m×10m square field without sharing edges is 25.

• The maximum number of corn fields is achieved by placing them in a diagonal pattern across the field.

• Each corn field will have 4 wheat fields surrounding it to ensure no two corn fields share an edge.

• The total number of corn fields possible in this arrangement is 25.

Weighing balance puzzle to find the lighter coin among 9 coins.

• Divide the coins into 3 groups of 3 coins each

• Weigh any two groups against each other

• If one group is lighter, weigh two coins from that group against each other

• If they are equal, the third coin is the lighter one

• If they are not equal, the lighter coin is the one that weighs less

• If both groups weigh the same, the lighter coin is in the third group

• Weigh two coins from the third group against each other to find the l...read more

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.

ERP is a software that integrates various business processes and functions into a single system.

• ERP stands for Enterprise Resource Planning.

• It helps organizations streamline their operations and improve efficiency.

• Advantages of ERP include centralized data management, improved collaboration, and better decision-making.

• It automates processes like inventory management, financials, human resources, and customer relationship management.

• ERP provides real-time visibility into busin...read more

Guesstimate the total number of Wagon-R cars sold in India.

• Consider the total population of India and the percentage of car owners

• Look at the market share of Maruti Suzuki in India

• Consider the popularity of Wagon-R among small car buyers

• Check the sales figures of Wagon-R in the last few years

• Assume a growth rate based on the current market trends

If unable to achieve company target within timeline, I will take corrective actions and communicate with stakeholders.

• Analyze the reasons for not achieving the target

• Identify the corrective actions required

• Communicate with stakeholders about the situation and the plan of action

• Re-plan the project timeline if necessary

• Ensure that the revised plan is achievable and realistic

TCS recently announced a partnership with Google Cloud to build industry-specific cloud solutions.

• TCS and Google Cloud will jointly develop cloud solutions for industries such as healthcare, financial services, and retail.

• The partnership aims to help organizations accelerate their digital transformation journey by leveraging the power of cloud technology.

• TCS will also establish a Google Cloud Academy to train its employees on Google Cloud technologies.

• This collaboration highl...read more

The number of people traveling from city A to B by road is unknown.

• There is no available data to determine the exact number of people traveling from city A to B by road.

• Without specific data, it is impossible to provide an accurate answer.

• A survey or data collection process would be required to determine the number of people traveling between the cities.

Inheritance, polymorphism, and classes are fundamental concepts in object-oriented programming.

• Inheritance allows a class to inherit properties and methods from another class.

• Polymorphism allows objects of different classes to be treated as if they are of the same class.

• Classes are blueprints for creating objects that have properties and methods.

• For example, a Car class can inherit from a Vehicle class, and a SportsCar class can inherit from the Car class.

• Polymorphism allows ...read more

A business analyst is responsible for analyzing business processes and identifying areas for improvement.

• Gathers and analyzes data to identify problems and opportunities for improvement

• Works with stakeholders to define business requirements and develop solutions

• Creates reports and presentations to communicate findings and recommendations

• Helps to implement and monitor changes to ensure they are effective

• Examples: identifying inefficiencies in a manufacturing process, developin...read more

Possible reasons for a car manufacturer's decline in profits by 40% year over year

• Decreased demand for cars due to economic downturn

• Increased competition from other car manufacturers

• Rising production costs and expenses

• Decline in consumer confidence and spending

• Changes in government regulations impacting the automotive industry

Excess reserve & surplus can be allocated through various methods such as reinvestment, dividends, or debt repayment. Revenue recognition under Ind AS 115 follows a five-step model. Balance sheets of companies differ from banks in terms of assets, liabilities, and capital structure.

• Excess reserve & surplus allocation methods: reinvestment, dividends, debt repayment

• Revenue recognition under Ind AS 115: five-step model

• Differences between company and bank balance sheets: assets,...read more

Filtering and aggregating data in pandas dataframe. Linear regression and its assumptions.

• To filter data in pandas, use the 'query' or 'loc' function based on specific conditions

• To aggregate data in pandas, use the 'groupby' function along with aggregation methods like 'sum', 'mean', etc.

• Linear regression is a statistical technique used to model the relationship between a dependent variable and one or more independent variables

• Assumptions of linear regression include linearit...read more

Different techniques for gathering requirements include interviews, surveys, observation, and prototyping.

• Interviews: one-on-one discussions with stakeholders

• Surveys: questionnaires to collect data from a large group

• Observation: watching users perform tasks to identify needs

• Prototyping: creating a model to test and refine requirements

A diode is an electronic component that allows current to flow in one direction, while a rectifier converts alternating current to direct current, and an amplifier increases the amplitude of a signal.

• A diode is a two-terminal device that conducts current in one direction and blocks it in the opposite direction.

• A rectifier is a device that converts alternating current (AC) to direct current (DC) by using diodes.

• An amplifier is an electronic device that increases the amplitude ...read more

In 3 attempts, the heavier ball can be found using the weighing balance.

• Divide the balls into 3 groups of 3, 3, and 5 balls.

• Weigh the first two groups against each other.

• If they balance, the heavier ball is in the third group. Weigh two balls from the third group against each other to find the heavier one.

• If they don't balance, the heavier ball is in the heavier group. Take two balls from the heavier group and weigh them against each other to find the heavier one.

Find the heavier ball out of 8 using a weighing balance in minimum and maximum attempts.

• Divide the balls into 3 groups of 3, 3, and 2.

• Weigh the first two groups against each other.

• If they balance, the heavier ball is in the third group.

• If one group is heavier, weigh two balls from that group against each other.

• If they balance, the heavier ball is the remaining one.

• If one ball is heavier, that is the answer.

• In the worst case, it takes 3 attempts to find the heavier ball.

SQL query to get top 100 Uber drivers by city

• Join drivers and users tables on city

• Aggregate driver ratings and count of rides

• Order by rating and count of rides

• Limit to top 100

An infinite loop is a loop that runs indefinitely without stopping.

• It can cause a program to crash or freeze.

• It is usually caused by a logical error in the loop condition.

• Example: while(true) { //code }

• Example: for(;;) { //code }

As of 2021, India's GDP growth rate is approximately 9.2% and its dollar value is around $3.05 trillion.

• India's GDP growth rate is one of the highest among major economies.

• The GDP growth rate indicates the rate at which the country's economy is expanding.

• The dollar value of India's GDP represents the total economic output in terms of US dollars.

• The GDP growth rate and dollar value are subject to change as new data becomes available.

To open an e-commerce website like Flipkart, one must keep in mind various factors such as target audience, product range, user experience, logistics, and marketing.

• Identify the target audience and their preferences

• Offer a wide range of products to cater to different needs

• Ensure a seamless user experience with easy navigation and quick loading time

• Establish a robust logistics network for timely delivery and hassle-free returns

• Invest in effective marketing strategies to reach ...read more

The camel will take 1000 bananas to reach point B.

• The camel will eat one banana per kilometer.

• The maximum number of bananas the camel can carry is 1000.

• The camel can take frequent stops.

• Therefore, the camel will take 1000 bananas to reach point B.

Optimizing the listing of Restaurants on Swiggy involves using data-driven strategies to improve visibility, relevance, and user experience.

• Analyze user behavior and preferences to understand their needs and preferences

• Implement a ranking algorithm based on factors like ratings, reviews, popularity, and delivery time

• Optimize search functionality to ensure accurate and relevant results

• Collaborate with restaurants to improve their online presence and menu offerings

• Leverage cust...read more