Business Analyst

1500+ Business Analyst Interview Questions and Answers

Updated 28 Feb 2025
search-icon

Q101. What would be the probability of getting at least one six after throwing 2 unbiased dice?

Ans.

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)

Q102. how do you convince people to open demat account?

Ans.

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

Q103. Devise a strategy for new company to enter in to e-comm sector

Ans.

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

Q104. What is the difference between Random Forest and XGBoost?
Ans.

Random Forest is an ensemble learning method that builds multiple decision trees and combines their predictions, while XGBoost is a gradient boosting algorithm that builds trees sequentially.

  • Random Forest builds multiple decision trees independently and combines their predictions through averaging or voting.

  • XGBoost builds trees sequentially, with each tree correcting errors made by the previous ones.

  • Random Forest is less prone to overfitting compared to XGBoost.

  • XGBoost is com...read more

Are these interview questions helpful?

Q105. What opinion do you have about the moth courses that you have done?

Ans.

I found the moth courses to be very informative and helpful in developing my skills as a business analyst.

  • The courses provided me with a solid foundation in business analysis techniques and methodologies.

  • I particularly enjoyed the case studies and practical exercises, which helped me to apply what I had learned in a real-world context.

  • The instructors were knowledgeable and engaging, and were able to answer all of my questions.

  • Overall, I feel that the moth courses have prepare...read more

Q106. What are zero rated supplies? If they are already Zero Rated, why we won't call them exempt?

Ans.

Zero rated supplies are goods or services that are subject to a 0% value-added tax (VAT) rate.

  • Zero rated supplies are still subject to VAT, but at a 0% rate.

  • Unlike exempt supplies, zero rated supplies are eligible for VAT input tax recovery.

  • Examples of zero rated supplies include basic food items, prescription drugs, and exports of goods and services.

Share interview questions and help millions of jobseekers 🌟

man-with-laptop

Q107. 1. What are convertible Bonds ? 3. What are Currency Rate Swaps ? 4. Different type of Derivative markets and explain difference between futures & forwards? 5. What is Total Return Swaps ? 6. What is Liquidity...

read more
Ans.

Questions related to finance and banking

  • Convertible bonds are a type of bond that can be converted into shares of the issuing company

  • Currency rate swaps involve exchanging interest payments in different currencies

  • Derivative markets include options, futures, and swaps. Futures are standardized contracts traded on exchanges, while forwards are customized contracts traded over-the-counter

  • Total return swaps involve exchanging the total return of an asset or portfolio for a fixed ...read more

Q108. What tools do you use and why do you required them?

Ans.

As a Business Analyst, I use various tools to analyze data, facilitate communication, and streamline processes.

  • Microsoft Excel: For data analysis and creating reports.

  • Tableau: For data visualization and creating interactive dashboards.

  • JIRA: For project management and tracking tasks.

  • Lucidchart: For creating process flowcharts and diagrams.

  • SQL: For querying databases and extracting relevant data.

  • Confluence: For documentation and collaboration.

  • PowerPoint: For creating presentati...read more

Business Analyst Jobs

Business Anaylst, FNA 4-6 years
Maersk Global Service Centres India Pvt. Ltd.
4.2
Pune
Business Analyst - Data & Analytics 2-5 years
Schneider Electric India Pvt. Ltd.
4.1
Bangalore / Bengaluru
Business Analyst- SAP S4 HANA - Treasury Cash 5-10 years
Intel Technology India Pvt Ltd
4.2
Bangalore / Bengaluru

Q109. What is a gap analysis? How to improve the breakdown chart? How to eliminate the stakeholder absence problem? How to calculate the budget and timeline of the project and its associated sprints? What is to-do in...

read more
Ans.

Answering questions related to gap analysis, breakdown chart, stakeholder absence, budget and timeline calculation, sprint retrospective, FRD and BRD.

  • Gap analysis is a process of identifying the difference between current state and desired state. It helps in identifying areas of improvement.

  • To improve the breakdown chart, ensure that it is detailed and covers all the tasks required for the project. Use tools like Gantt chart to visualize the breakdown.

  • To eliminate stakeholder...read more

Q110. What are the critical KPIs to be monitored after creating a new website?

Ans.

Critical KPIs to monitor after creating a new website include traffic, conversion rate, bounce rate, and user engagement.

  • Traffic: Monitor the number of visitors to the website to gauge its reach and popularity.

  • Conversion Rate: Track the percentage of visitors who take a desired action, such as making a purchase or signing up for a newsletter.

  • Bounce Rate: Measure the percentage of visitors who leave the website after viewing only one page, indicating the effectiveness of the l...read more

Q111. Guesstimate question- how much revenue does a mall earn in a day.

Ans.

A mall's daily revenue depends on various factors such as location, size, footfall, and tenant mix.

  • The location of the mall plays a crucial role in determining its daily revenue.

  • The size of the mall also affects the revenue as larger malls tend to have more tenants and footfall.

  • The footfall in the mall is directly proportional to the revenue generated.

  • The tenant mix is another important factor as high-end stores tend to generate more revenue.

  • On average, a mall can earn anywhe...read more

Q112. How do you find the count of visitors that came today and the count of new visitors that arrived today?
Ans.

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.

Q113. How many facebook users are there in the world?

Ans.

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

Q114. What is a micro controller ?

Ans.

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.

Q115. What is the difference between Machine Learning , Artificial Intelligence and Statistics?

Ans.

Machine learning is a subset of AI that uses statistical techniques to enable machines to learn from data and improve performance.

  • Artificial Intelligence is the broader concept of machines being able to carry out tasks in a way that we would consider smart.

  • Statistics is the study of the collection, analysis, interpretation, presentation, and organization of data.

  • Machine learning is a subset of AI that uses statistical techniques to enable machines to learn from data and impro...read more

Q116. How do they affect your data analysis?

Ans.

Data analysis is affected by various factors that can influence the accuracy and reliability of the results.

  • Data quality: The accuracy, completeness, and consistency of the data can impact the analysis.

  • Data sources: The reliability and relevance of the data sources used for analysis can affect the outcomes.

  • Data preprocessing: The way data is cleaned, transformed, and prepared for analysis can impact the results.

  • Data interpretation: The biases, assumptions, and subjectivity in...read more

Q117. What are key aspects of product discovery and how would you apply it for a social media app.

Ans.

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

Q118. What are the types of incidents and what is it's priority?

Ans.

There are three types of incidents - High, Medium, and Low. Priority is assigned based on the impact and urgency of the incident.

  • High priority incidents are critical and require immediate attention, such as system downtime or security breaches.

  • Medium priority incidents are important but not critical, such as performance issues or minor bugs.

  • Low priority incidents are minor issues that can be addressed later, such as cosmetic defects or feature requests.

  • Priority is determined ...read more

Q119. Describe different types of joins

Ans.

Different types of joins are used in database queries to combine data from multiple tables.

  • Inner join: Returns only the matching records from both tables.

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

  • Right join: Returns all records from the right table and the matching records from the left table.

  • Full outer join: Returns all records when there is a match in either the left or right table.

  • Cross join: Returns the Cartesian prod...read more

Q120. What type of challenges have you faced during requirement elicitation?

Ans.

During requirement elicitation, I have faced challenges related to understanding client needs, managing conflicting requirements, and dealing with changing priorities.

  • Understanding client needs: Sometimes clients may have difficulty articulating their requirements clearly, requiring additional probing and clarification.

  • Managing conflicting requirements: Different stakeholders may have conflicting needs and priorities, requiring negotiation and compromise.

  • Dealing with changing...read more

Q121. How do you handle conflicts, your approach to conflicts?

Ans.

I approach conflicts by actively listening, understanding perspectives, and finding common ground for resolution.

  • I listen to all parties involved to understand their perspectives

  • I try to find common ground and areas of agreement

  • I propose solutions that address the concerns of all parties

  • I remain calm and professional throughout the conflict resolution process

  • I follow up to ensure that the resolution is effective and sustainable

Q122. If you want buy a cosmetic product how you can compare it to other products

Ans.

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

Q123. What are inner joins, outer joins, left join

Ans.

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

Q124. Why do you think this works? What are the drawbacks?

Ans.

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.

Q125. How do you size a user story . Based on what criteria you give story points

Ans.

User story sizing is based on complexity, effort, and risk involved in completing the story.

  • Consider the amount of work required to complete the story

  • Evaluate the complexity of the story

  • Assess the level of risk involved in completing the story

  • Use a scale such as Fibonacci or T-shirt sizes to assign story points

  • Involve the development team in the sizing process

  • Story points are relative and not absolute measures of effort

Q126. How would you handle customer if they changed the requirements on the fly

Ans.

I would assess the impact of the change, communicate with the team and stakeholders, and update the project plan accordingly.

  • Listen to the customer's request and clarify the changes

  • Assess the impact of the change on the project timeline, budget, and resources

  • Communicate the changes to the project team and stakeholders

  • Update the project plan and document the changes

  • Ensure that the changes align with the project goals and objectives

Q127. What are inorganic and organic results in digital marketing

Ans.

Inorganic results are paid ads in search engines while organic results are the natural listings.

  • Inorganic results are paid advertisements that appear at the top or bottom of search engine results pages (SERPs).

  • Organic results are the natural listings that appear in SERPs based on relevance to the search query.

  • Inorganic results are marked as 'Ad' while organic results are not.

  • Examples of inorganic results include Google Ads, Bing Ads, and social media ads.

  • Examples of organic r...read more

Q128. What are underfitting and overfitting in machine learning?
Ans.

Underfitting and overfitting are common problems in machine learning where the model is either too simple or too complex.

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

  • Overfitting occurs when the model is too complex and learns noise in the training data as if it were a pattern.

  • Underfitting can be addressed by increasing the model complexity or adding more features.

  • Overfitting can be addressed by simplifying the model, using re...read more

Q129. Write sql query to find mean waiting period for delivery partner given driver I'd, ordered time and delivered time.

Ans.

SQL query to find mean waiting period for delivery partner given driver ID, ordered time and delivered time.

  • Use AVG function to calculate mean waiting period

  • Subtract ordered time from delivered time to get waiting period

  • Filter data by driver ID and delivery partner

  • Group by delivery partner

Q130. How are they interrelated to each other ? Basically a KPI tree ?

Ans.

KPIs are interrelated in a tree-like structure, with higher-level KPIs being influenced by lower-level ones.

  • KPIs are Key Performance Indicators that measure the success of a business or project.

  • KPIs can be organized in a tree-like structure, with higher-level KPIs being influenced by lower-level ones.

  • For example, a company's overall revenue might be a high-level KPI, with lower-level KPIs such as sales revenue and customer retention influencing it.

  • A KPI tree can help business...read more

Q131. Explain opps concepts

Ans.

OPPS concepts refer to Object-Oriented Programming Principles that guide the design and development of software systems.

  • OPPS emphasizes encapsulation, inheritance, and polymorphism.

  • Encapsulation ensures that data and methods are bundled together in a class.

  • Inheritance allows classes to inherit properties and behaviors from other classes.

  • Polymorphism enables objects to take on different forms and respond differently based on their class.

  • OPPS promotes code reusability, modulari...read more

Q132. what is Agile methodology

Ans.

Agile methodology is an iterative approach to project management and software development that emphasizes flexibility and customer satisfaction.

  • Agile focuses on delivering working software in short iterations

  • It values individuals and interactions over processes and tools

  • It emphasizes collaboration between the development team and the customer

  • It welcomes changes in requirements throughout the project

  • Examples of Agile methodologies include Scrum, Kanban, and Extreme Programming...read more

Frequently asked in, ,

Q133. Why do you believe IPhone is still a niche product in India?

Ans.

IPhone is still a niche product in India due to its high price and availability of cheaper alternatives.

  • IPhone is considered a luxury item in India due to its high price.

  • There are many cheaper alternatives available in the Indian market.

  • The Indian market is dominated by budget and mid-range smartphones.

  • IPhone's market share in India is only around 2%.

  • IPhone's high price also makes it less attractive to price-sensitive Indian consumers.

Q134. Are you familiar with statistical concepts and tools?

Ans.

Yes, I am familiar with statistical concepts and tools.

  • I have experience with statistical analysis, hypothesis testing, and regression analysis.

  • I am proficient in using tools like Excel, SPSS, and R for data analysis.

  • I understand concepts such as mean, median, standard deviation, and correlation.

  • I have applied statistical methods in previous projects to derive insights and make data-driven decisions.

Q135. What are the advantage of spring boot

Ans.

Spring Boot provides rapid application development and easy deployment with minimal configuration.

  • Simplifies the development process by providing a pre-configured environment

  • Reduces boilerplate code and increases productivity

  • Supports a wide range of databases and web servers

  • Enables easy integration with other Spring projects

  • Provides built-in security features

  • Example: A Spring Boot application can be deployed as a standalone JAR file

  • Example: Spring Boot can automatically confi...read more

Q136. What is the difference between a Union and an Outer join, and can you provide the syntax for both using two simple tables?

Ans.

Union combines results from two tables, while Outer join combines matching rows and includes non-matching rows.

  • Union combines all rows from both tables, removing duplicates

  • Outer join combines matching rows and includes non-matching rows with NULL values

  • Syntax for Union: SELECT * FROM table1 UNION SELECT * FROM table2

  • Syntax for Outer join: SELECT * FROM table1 LEFT OUTER JOIN table2 ON table1.id = table2.id

Q137. How did you build a sourcing strategy, what were the steps?

Ans.

To build a sourcing strategy, I followed these steps:

  • Identified the business needs and goals

  • Conducted market research to identify potential suppliers

  • Evaluated supplier capabilities and performance

  • Negotiated contracts and pricing

  • Developed a supplier relationship management plan

  • Monitored supplier performance and made adjustments as needed

Q138. How strong in using various tools such as ETL tools, logical thinking and any DB strength for eg:- sql

Ans.

I am proficient in using ETL tools, logical thinking and SQL for database management.

  • I have experience in using ETL tools such as Talend and Informatica for data integration and transformation.

  • I possess strong logical thinking skills which enable me to analyze complex business problems and provide effective solutions.

  • I am proficient in SQL and have experience in database management, including creating and optimizing queries, designing and implementing database schemas, and pe...read more

Q139. What are the marketing strategies according to you?

Ans.

Marketing strategies are plans and tactics implemented by businesses to promote their products or services and reach their target audience.

  • Identifying target audience and market segmentation

  • Creating a unique value proposition

  • Developing a marketing mix (product, price, place, promotion)

  • Utilizing digital marketing channels (social media, email marketing, SEO)

  • Implementing content marketing and storytelling

  • Building brand awareness through advertising and PR

  • Engaging in influencer ...read more

Q140. 2. What is the role of business analyst in sprint planning

Ans.

The business analyst plays a crucial role in sprint planning by facilitating communication between stakeholders and the development team.

  • The business analyst helps to define the scope of the sprint by gathering requirements from stakeholders

  • They work with the development team to ensure that the requirements are feasible and can be implemented within the sprint timeframe

  • The business analyst helps to prioritize the requirements based on business value and urgency

  • They also help ...read more

Q141. Assume you want to create go to market strategy for an app to be released in Dubai given that it is already established and successful in US.

Ans.

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

Q142. How frequently do you play Badminton? (Hobby)

Ans.

I play badminton twice a week as a hobby.

  • I enjoy playing badminton as a way to stay active and relieve stress.

  • I usually play with friends or family members at a local community center.

  • I have been playing badminton for several years and have improved my skills over time.

Q143. How would you rate our stand in customer and market capture

Ans.

I would rate your stand in customer and market capture as strong.

  • Your company has a strong presence in the market with a loyal customer base.

  • Your sales figures and market share indicate a successful capture of the market.

  • Your customer feedback and reviews are positive, indicating a satisfied customer base.

  • Your marketing strategies and campaigns have been effective in reaching and attracting customers.

  • Your competitors are not posing a significant threat to your market capture....read more

Q144. What are underfitting and overfitting in machine learning models?
Ans.

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

Q145. What is the difference between cost accounting and financial accounting

Ans.

Cost accounting focuses on internal costs and helps in decision-making, while financial accounting focuses on external reporting and compliance.

  • Cost accounting is used for internal purposes, such as determining the cost of producing a product or service.

  • Financial accounting is used for external reporting to stakeholders, such as investors, creditors, and regulatory authorities.

  • Cost accounting helps in decision-making by providing information on costs, profitability, and perfo...read more

Q146. What is the difference between UL and VUL

Ans.

UL and VUL are both types of life insurance policies, but VUL offers investment options while UL does not.

  • UL stands for Universal Life Insurance, which offers a fixed premium and death benefit but no investment options

  • VUL stands for Variable Universal Life Insurance, which offers investment options in addition to a flexible premium and death benefit

  • VUL policyholders can choose to invest in stocks, bonds, and mutual funds, while UL policyholders cannot

  • VUL policies have the pot...read more

Q147. Where do you store the Campaign Data, can you use that data with your customer data while doing analysis ?

Ans.

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

Q148. Can you write same sql queries in python?

Ans.

Yes, SQL queries can be written in Python using libraries like SQLAlchemy or Pandas.

  • Python provides libraries like SQLAlchemy and Pandas for executing SQL queries.

  • SQLAlchemy allows writing SQL queries in Python syntax and provides an Object-Relational Mapping (ORM) layer.

  • Pandas provides a SQL-like interface called 'pandasql' to query DataFrames using SQL syntax.

  • Both libraries offer flexibility and convenience in executing SQL queries within Python scripts.

Q149. Choosing a marketing strategy for Capital One (Phone Calls or Letters)

Ans.

Phone calls are more effective for Capital One's marketing strategy.

  • Phone calls allow for immediate feedback and personalized communication.

  • Letters may be ignored or lost in the mail.

  • Capital One can track phone call success rates and adjust their strategy accordingly.

  • Phone calls can also be used to cross-sell and upsell products.

  • Letters may be more appropriate for certain types of communication, such as legal notices or account statements.

Q150. Puzzle 1: Calculate the probability of a girl child when one of the two children is boy

Ans.

Probability of a girl child when one of the two children is boy

  • Use Bayes' theorem to calculate the conditional probability

  • Assume equal probability of having a boy or girl child

  • Answer is 1/2 or 50%

Previous
1
2
3
4
5
6
7
Next
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Interview experiences of popular companies

3.7
 • 10.4k Interviews
3.8
 • 8.1k Interviews
3.6
 • 7.5k Interviews
3.7
 • 5.6k Interviews
3.8
 • 5.6k Interviews
4.1
 • 5k Interviews
3.8
 • 3.1k Interviews
3.8
 • 2.8k Interviews
3.7
 • 738 Interviews
3.7
 • 328 Interviews
View all

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary

Business Analyst Interview Questions
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+

Reviews

4 L+

Interviews

4 Cr+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter