1500+ Business Analyst Interview Questions and Answers

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

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

Return all prime numbers less than or equal to a given positive integer N.

• Create a function that takes an integer N as input

• Iterate from 2 to N and check if each number is prime

• Return a list of prime numbers less than or equal to N in ascending order

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.

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

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.

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

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

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

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 }

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.

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.

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

Bubble Sort algorithm is used to sort an array of non-negative integers in non-decreasing order.

• Bubble Sort compares adjacent elements and swaps them if they are in the wrong order.

• Repeat this process until the array is sorted.

• Time complexity of Bubble Sort is O(n^2) in worst case.

• Example: For input 6 2 8 4 10, output will be 2 4 6 8 10.

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.

You can extract the month and year from a date column in Pandas using the dt accessor.

• Use the dt accessor to access the date components

• Use dt.month to extract the month and dt.year to extract the year

• Example: df['date_column'].dt.month will give you the month values

• Example: df['date_column'].dt.year will give you the year values

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

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

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

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

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