1500+ Business Analyst Interview Questions and Answers

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

Approximately 8000 balls can be placed with 49% wastage.

• Calculate the volume of the cube (10*10*10) and the volume of one ball (4/3*3.14*(0.5/2)^3)

• Divide the volume of the cube by the volume of one ball to get the maximum number of balls that can fit

• Calculate the volume of the placed balls and subtract it from the volume of the cube to get the wastage

• Wastage percentage can be calculated by dividing the wastage volume by the volume of the cube and multiplying by 100

The 4 P's of marketing are Product, Price, Place, and Promotion.

• Product: Refers to the goods or services offered by a company.

• Price: The amount customers are willing to pay for the product.

• Place: The location or channel through which the product is made available to customers.

• Promotion: The marketing activities used to communicate and promote the product.

Computer science has numerous programming languages.

• There are over 700 programming languages in use today.

• Some popular languages include Java, Python, C++, and JavaScript.

• Languages can be categorized as low-level, high-level, or scripting languages.

• Each language has its own syntax, rules, and purpose.

• New languages are constantly being developed to meet evolving needs.

A Business Analyst plays a crucial role in an organization by analyzing business processes, identifying problems, and proposing solutions.

• Analyzing and documenting business requirements

• Identifying and evaluating business problems

• Developing and implementing effective solutions

• Collaborating with stakeholders to gather and prioritize requirements

• Conducting feasibility studies and cost-benefit analysis

• Creating and maintaining project documentation

• Facilitating communication betwee...read more

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

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

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

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.

Implementing policies to reduce car emissions and promote alternative modes of transportation.

• Encourage the use of public transportation by improving infrastructure and increasing frequency of services.

• Promote carpooling and ridesharing initiatives to reduce the number of vehicles on the road.

• Incentivize the adoption of electric vehicles through subsidies and tax breaks.

• Implement stricter emission standards for vehicles and enforce regular emissions testing.

• Create designated ...read more

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 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

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

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.

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

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

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