200+ Business Analyst Interview Questions and Answers for Freshers

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.

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

333 digits can number 166 pages of a book.

• Each page number takes up 2 digits.

• The first page is numbered 01.

• The last page that can be numbered is 166.

• The remaining 2 digits are used for the cover page or other information.

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.

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

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

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

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

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

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

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.

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

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.

To approach a customer for selling a costly new phone, I would focus on highlighting the unique features, benefits, and value it offers.

• Understand the customer's needs and preferences

• Highlight the unique features and benefits of the phone

• Emphasize the value and long-term benefits of investing in a high-quality phone

• Offer flexible payment options or financing plans

• Provide comparisons with other phones to showcase the superiority of the new phone

• Offer a trial period or money-ba...read more

Need is a necessity or desire for something, while demand is the willingness and ability to pay for it.

• Need is a basic requirement for survival or to fulfill a goal, while demand is the desire for a product or service backed by purchasing power.

• Need is a subjective feeling, while demand is an objective measure of the market.

• Need can exist without demand, but demand cannot exist without need.

• Example: People need food to survive, but not everyone has the demand for expensive go...read more

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.

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.

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

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

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

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.

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

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

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

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

To find the count of visitors and new visitors that came today in a database management system (DBMS).

• Use a query to filter the visitors based on the current date.

• Count the total number of visitors using the COUNT function.

• To find new visitors, compare the current date with the date of their first visit.

• Use the DISTINCT keyword to count only unique new visitors.

The exact number of Facebook users worldwide is constantly changing, but as of October 2021, there are over 2.8 billion monthly active users.

• As of October 2021, Facebook reported having over 2.8 billion monthly active users.

• The number of Facebook users is constantly changing as new users join and others deactivate or delete their accounts.

• Facebook's user base is spread across different countries and demographics.

• The number of Facebook users can be influenced by factors such a...read more

A microcontroller is a small computer on a single integrated circuit that contains a processor core, memory, and programmable input/output peripherals.

• Microcontrollers are used in various electronic devices and appliances.

• They are designed to perform specific tasks and are often embedded in systems.

• Examples include microcontrollers used in smartphones, home automation systems, and automotive applications.

Key aspects of product discovery involve understanding user needs, market research, prototyping, and testing.

• Conduct user research to understand the needs and preferences of social media app users.

• Analyze market trends and competitor offerings to identify gaps and opportunities.

• Create prototypes to visualize the app's features and gather feedback from stakeholders.

• Test the prototypes with target users to validate assumptions and iterate on the design.

• Iterate based on feedback...read more

Compare cosmetic products by considering ingredients, brand reputation, price, and reviews.

• Check the ingredients list for any potential allergens or irritants

• Research the brand's reputation for quality and ethical practices

• Compare prices across different retailers or online stores

• Read reviews from other customers to gauge effectiveness and satisfaction

• Consider any specific needs or preferences, such as vegan or cruelty-free options

Inner joins, outer joins, and left join are types of SQL joins used to combine data from multiple tables.

• Inner join returns only the matching records from both tables.

• Outer join returns all records from both tables, including non-matching records.

• Left join returns all records from the left table and the matching records from the right table.

• Example: INNER JOIN customers ON orders.customer_id = customers.customer_id

• Example: LEFT JOIN customers ON orders.customer_id = customers...read more

This question is asking for an analysis of the effectiveness and drawbacks of a certain approach or solution.

• The question is asking for an evaluation of why a particular approach or solution is effective.

• The answer should also include an analysis of the drawbacks or limitations of the approach.

• Examples and evidence should be provided to support the analysis.

• The response should demonstrate critical thinking and the ability to assess the pros and cons of a given solution.

To create a go-to-market strategy for an app in Dubai, analyze the local market, competition, cultural differences, and adjust marketing tactics accordingly.

• Conduct market research in Dubai to understand the target audience, competition, and market trends.

• Adapt the app to cater to the preferences and needs of the Dubai market.

• Localize the app content, language, and features to resonate with the Dubai audience.

• Identify key marketing channels in Dubai such as social media platf...read more

Underfitting and overfitting are common problems in machine learning models.

• Underfitting occurs when a model is too simple and fails to capture the underlying patterns in the data.

• Overfitting happens when a model is too complex and learns the noise or random fluctuations in the training data.

• Underfitting leads to high bias and low variance, while overfitting leads to low bias and high variance.

• To address underfitting, we can increase model complexity, gather more data, or use...read more

Campaign data is stored in a centralized database, which can be integrated with customer data for analysis.

• Campaign data is typically stored in a centralized database or CRM system.

• Customer data can also be stored in a separate database or CRM system.

• By integrating the two datasets, business analysts can perform comprehensive analysis to understand the impact of campaigns on customer behavior.

• For example, combining campaign data with customer purchase history can help identif...read more

Tools used by Business Analyst include data visualization, project management, and requirements gathering software.

• Data visualization tools: Tableau, Power BI, QlikView

• Project management tools: JIRA, Trello, Asana

• Requirements gathering tools: IBM Rational RequisitePro, CaliberRM, Jama Connect

Business Analyst's key strengths include problem-solving, communication, and analytical skills.

• Strong problem-solving skills to identify and analyze business problems

• Excellent communication skills to effectively communicate with stakeholders

• Ability to gather and analyze data to make informed business decisions

• Knowledge of industry trends and best practices

• Experience with various business analysis tools and techniques

• Flexibility and adaptability to work in a fast-paced and cha...read more

Approximately 50,000 tractors are sold in Haryana every year.

• Consider the population of Haryana and the number of farmers in the state.

• Look at the agricultural output of Haryana and the demand for tractors in the region.

• Take into account the number of tractor dealerships in Haryana and their sales figures.

• Research the sales figures of major tractor manufacturers in Haryana.

• Assume a growth rate based on the previous year's sales figures.

• Consider any government policies or subs...read more

The population is split into four economic classes: Low, Low and Upper Middle, and Upper Class.

• 30% of the population belongs to the Low economic class.

• 40% of the population belongs to the Low and Upper Middle economic class.

• 20% of the population belongs to the Upper Middle economic class.

• 10% of the population belongs to the Upper Class.

Analytics is crucial for informed decision-making and driving business growth. EXL's expertise and innovative solutions make them the ideal choice.

• Analytics provides valuable insights into customer behavior, market trends, and business performance.

• Data-driven decision-making is essential for staying competitive in today's fast-paced business environment.

• EXL's advanced analytics capabilities and industry expertise enable them to deliver innovative solutions that drive business...read more