1500+ Business Analyst Interview Questions and Answers

I would report the incident to the appropriate authorities and follow company protocols.

• Maintain professionalism and remain calm

• Gather evidence discreetly if possible

• Report the incident to a supervisor or manager

• Follow company policies and procedures

• Cooperate with any investigations

• Maintain confidentiality and avoid gossiping about the incident

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

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

Using Standard Cost instead of FIFO in an organization with standard costing is wrong because it does not accurately reflect the actual cost of inventory.

• Standard costing assumes that all units of inventory are valued at the same cost, regardless of when they were purchased or produced.

• FIFO (First-In, First-Out) method, on the other hand, values inventory based on the assumption that the first units purchased or produced are the first ones sold or used.

• Using Standard Cost ins...read more

Business requirements define the overall goals and objectives of a project, functional requirements describe the specific features and functionality needed, and technical requirements outline the technical specifications and constraints.

• Business requirements focus on the high-level goals and objectives of a project, such as increasing revenue or improving customer satisfaction.

• Functional requirements specify the specific features, functions, and behaviors that the system or p...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.

Identify the defective cube out of 12 identical cubes using a weight balance in minimum rounds.

• Divide the cubes into three groups of four each.

• Weigh two groups against each other.

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

• If they don't balance, take the heavier group and weigh two cubes against each other.

• If they balance, the defective cube is the remaining cube.

• If they don't balance, the heavier cube is the defective one.

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.

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.

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

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.

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.

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

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

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

The order of execution of SQL clauses is: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.

• The SELECT clause is executed first to retrieve the desired columns from the table.

• The FROM clause is executed next to specify the table(s) from which the data is retrieved.

• The WHERE clause is executed after the FROM clause to filter the rows based on specified conditions.

• The GROUP BY clause is executed to group the rows based on specified columns.

• The HAVING clause is executed after the ...read more

There are approximately 70,000 petrol bunks in India.

• India has a population of over 1.3 billion people, and a large number of them own vehicles.

• The number of petrol bunks varies from state to state, with some having more than others.

• According to a report by the Petroleum Planning and Analysis Cell, there were 69,648 petrol bunks in India as of January 2021.

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

The number of soft drinks sold in J&K on a particular day depends on various factors such as population, demand, availability, and marketing strategies.

• The population of J&K can be a factor in determining the potential number of soft drink sales.

• The demand for soft drinks can vary based on factors such as weather, events, and cultural preferences.

• The availability of soft drinks in J&K, including distribution channels and retail outlets, can impact sales.

• Marketing strategies, ...read more

The amount of cement, brick, sand, and water needed for 1 square meter brickwork depends on the specific requirements and design.

• The quantity of cement, brick, sand, and water varies based on the thickness of the brickwork.

• The type of bricks used, such as solid bricks or hollow bricks, affects the material requirements.

• The mortar mix ratio also influences the amount of cement, sand, and water needed.

• The local building codes and standards may specify the material quantities fo...read more

I will highlight the benefits of our tablets for children's education and offer discounts or promotions to attract parents.

• Emphasize the educational benefits of our tablets

• Offer discounts or promotions to attract parents

• Provide testimonials from satisfied parents

• Partner with schools or educational institutions to promote our tablets

• Create engaging and informative marketing materials targeted towards parents

• Offer a trial period for parents to test out our tablets

• Provide excell...read more

To reduce air pollution in NCR, data on sources of pollution, weather patterns, and population density is needed.

• Sources of pollution such as industries, vehicles, and construction sites

• Weather patterns such as wind direction and speed, temperature, and humidity

• Population density and distribution to identify areas with high pollution levels

• Data on emissions from power plants and factories

• Information on the types of vehicles and their emissions

• Data on the use of alternative mo...read more

Bias-Variance trade-off is the balance between overfitting and underfitting. High bias models are simple but inaccurate, low variance models are complex but overfit.

• Bias-Variance trade-off is a fundamental concept in machine learning.

• High bias models are simple and have low variance, but are inaccurate.

• Low bias models are complex and have high variance, but can overfit the data.

• Examples of high bias models are linear regression and decision trees with few nodes.

• Examples of lo...read more

To determine profitability between monthly and daily bus membership, conduct a cost-benefit analysis.

• Gather data on the cost of monthly and daily bus passes

• Determine the frequency of usage for each pass type

• Calculate the total cost of using each pass type over a given period

• Compare the costs to the benefits of each pass type, such as convenience and flexibility

• Consider external factors, such as the availability of parking and the cost of gas

• Make a recommendation based on the ...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 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

Telecom operators should invest in robust network infrastructure and implement strict security measures to prevent problems.

• Invest in upgrading network infrastructure to handle increasing data traffic

• Implement strong security measures to protect against cyber threats

• Regularly monitor and analyze network performance to identify and address potential issues

• Provide reliable customer support to promptly address customer complaints and concerns

• Offer competitive pricing and attract...read more

Technical requirements are specified to backend, UX, and database teams through a combination of documents and communication.

• Specify technical requirements clearly in a document or through direct communication with each team

• Ensure all teams are aligned on the requirements through regular meetings and updates

• Use tools like Jira or Trello to track and manage requirements across teams

• Consider creating separate documents for each team if the requirements are complex and detailed

• C...read more

It is not possible to accurately determine the number of tube lights in the city of Mumbai.

• The number of tube lights in a city is not publicly available information.

• The city of Mumbai has a large population and a vast number of buildings, making it impossible to count all the tube lights.

• The number of tube lights can vary greatly depending on factors such as residential, commercial, and industrial areas.

• Even if we consider an average number of tube lights per household or bui...read more

Dealing with business level client escalation requires active listening, empathy, and a solution-oriented approach.

• Listen actively to the client's concerns and acknowledge their frustration.

• Empathize with the client and show that you understand their perspective.

• Take ownership of the issue and work towards finding a solution.

• Communicate clearly and transparently with the client throughout the process.

• Follow up with the client to ensure their satisfaction with the resolution.

• E...read more

Consumer life cycle refers to the stages a consumer goes through in their relationship with a product or service.

• Consumer life cycle consists of five stages: awareness, consideration, purchase, usage, and loyalty.

• During the awareness stage, consumers become aware of a product or service through various marketing channels.

• In the consideration stage, consumers evaluate different options and compare features, prices, and reviews.

• The purchase stage involves the actual transaction...read more

VLOOKUP is a function in Excel used to search for a value in the first column of a range and return a corresponding value from another column.

• VLOOKUP stands for vertical lookup.

• It is commonly used to find specific data in large datasets.

• The function takes four arguments: lookup value, table array, column index number, and range lookup.

• VLOOKUP is case-insensitive and requires an exact match or an approximate match.

• The function returns the value from the corresponding row in th...read more

Different ways to inherit a class

• Single inheritance: A class inherits from only one base class

• Multiple inheritance: A class inherits from multiple base classes

• Multilevel inheritance: A class inherits from a derived class, which in turn inherits from another class

• Hierarchical inheritance: Multiple classes inherit from a single base class

• Hybrid inheritance: Combination of multiple inheritance types

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

I am excited to join Affine Analytics because of their reputation for delivering innovative solutions and their focus on employee growth.

• Affine Analytics has a strong track record of delivering cutting-edge solutions to clients across industries.

• I am impressed by the company's commitment to employee growth and development, as evidenced by their training and mentorship programs.

• I am excited about the opportunity to work with a talented and diverse team of professionals at Affi...read more

Financial ratios are used to interpret inventory by analyzing its efficiency, liquidity, and profitability.

• Financial ratios help assess the efficiency of inventory management, such as inventory turnover ratio.

• Ratios like current ratio and quick ratio evaluate the liquidity of inventory.

• Gross profit margin and return on investment (ROI) ratios indicate the profitability of inventory.

• Comparing inventory turnover ratios across different periods or industry benchmarks can provide...read more

Algorithm to optimize EXL interview process

• Identify key performance indicators (KPIs) for the interview process

• Use data analytics to track and analyze the KPIs

• Implement automation and AI to streamline the process

• Incorporate feedback from candidates and interviewers to continuously improve the process

The probability of getting at least one six after throwing 2 unbiased dice is 11/36.

• The total number of outcomes when throwing 2 dice is 36 (6 sides on each die)

• The number of outcomes where at least one die shows a six is 11 (6 outcomes where one die shows a six, plus 1 outcome where both dice show sixes)

To convince people to open a demat account, I would highlight the benefits of having one and provide clear and concise information on the account opening process.

• Explain the benefits of having a demat account, such as easy and secure trading, lower transaction costs, and paperless transactions

• Provide clear and concise information on the account opening process, including the required documents and any fees involved

• Address any concerns or questions the person may have, such as...read more

Develop a strategy for a new company to enter the e-commerce sector.

• Conduct market research to identify target audience and competitors

• Create a user-friendly and visually appealing e-commerce website

• Implement effective digital marketing strategies to drive traffic and increase brand visibility

• Offer competitive pricing and attractive discounts to attract customers

• Provide excellent customer service and ensure smooth order fulfillment and delivery

• Leverage social media platforms ...read more