Business Analytics
Business Analytics
Business Analytics
Pande
Business Analytics and
Dr. Tamal Mondal
Course Content
3
The Context
Consider the following problems for various industry
sectors:
Introduction
ABC Consumer Goods Pvt. Ltd. is a leading Fast-Moving Consumer Goods (FMCG) company in India.
The company manufactures and distributes a wide range of products, including food items, personal care
products, and household goods. With a vast distribution network and a diverse product portfolio, the
company faces several challenges in managing its supply chain operations efficiently.
Problem Description:
The company is experiencing issues related to inventory management, demand forecasting, transportation
logistics, and production planning. These challenges are hindering their ability to meet customer demands
while maintaining cost-effectiveness.
Demand Forecasting:
a. How can the company improve demand forecasting for its products,
considering factors like seasonality, market trends, and regional variations?
b. How can they use historical sales data and external factors to create more
accurate demand forecasts for various product categories and regions?
Inventory Management:
a. How can the company optimize inventory levels to reduce holding costs and
minimize the risk of stockouts while ensuring product availability for
customers?
b. What inventory control strategies and analytics models should be
implemented to strike a balance between excess inventory and stock shortages?
Production Planning:
a. How can the company enhance production planning and scheduling,
ensuring efficient utilization of manufacturing resources and reducing
production lead times?
b. What factors should be considered in optimizing the production
process, such as batch sizes, production cycles, and workforce
allocation?
1 2 3 4 5
Students are expected to Data analysis and modeling Recommendations on the Cost-benefit analysis for This case study offers students
analyze the current supply techniques relevant to demand selection and implementation proposed improvements and the opportunity to apply
chain operations of ABC forecasting, inventory of specific business analytics their potential impact on the business analytics principles to
Consumer Goods Pvt. Ltd. and management, transportation tools and software. company's bottom line. real-world challenges,
provide a comprehensive logistics, and production demonstrating the value of
business analytics strategy to planning. data-driven decision-making in
address the challenges optimizing supply chain
mentioned in the problem operations for an Indian
statement. The deliverables FMCG company.
should include:
Background
An Indian telecom company, XYZ Telecom, is facing
a critical challenge in retaining its customer base and
ensuring sustainable revenue growth. The company
provides a range of services, including mobile and
broadband, to a diverse customer base across the
country. In recent years, XYZ Telecom has
experienced increased competition, rapidly changing
customer preferences, and rising customer churn rates.
Customer Segmentation:
c. How can XYZ Telecom segment its diverse customer base
effectively to tailor marketing and service strategies for different
customer groups?
d. What are the characteristics that define these segments, and how
can the company create targeted marketing campaigns to improve
customer satisfaction and loyalty?
Business Analytics Sem 2 ITBM 23-25 10
Revenue Optimization:
a. What pricing strategies and service bundles can be developed to
maximize revenue while maintaining customer satisfaction?
b. How can XYZ Telecom identify cross-selling and upselling
opportunities to enhance average revenue per user (ARPU)?
Problem Description:
An Indian Automobile Company (IAC) is facing several challenges in its
operations and marketing strategies. The company is looking to address these
issues and enhance its overall performance. You are tasked with analyzing the
company's data and providing insights and recommendations. The primary focus
areas are as follows:
Background:
IndianBank is one of the leading banks in India, providing
various financial services, including loans, to a diverse
customer base. The bank has been facing challenges in
managing its loan portfolio efficiently. Specifically, they are
looking to improve their loan approval process and reduce
default rates.
Problem Statement:
IndianBank seeks to enhance its loan approval and default
prediction processes. The goal is to streamline the lending
process, reduce default risks, and improve overall profitability.
The bank wants to address the following key questions: Business Analytics Sem 2 ITBM 23-25 16
The Challenges
Loan Approval Process Optimization:
a. How can IndianBank use historical data and business analytics to assess the creditworthiness of loan applicants more
accurately?
b. What factors or variables should IndianBank consider to make informed decisions while approving or rejecting loan
applications?
c. Can business analytics tools be used to automate parts of the loan approval process, making it more efficient and customer-
friendly?
Default Prediction:
a. Can IndianBank leverage analytics to develop a predictive model that identifies high-risk loan applicants at the time of application
submission?
• What historical data and patterns can be analyzed to build a robust model for predicting the likelihood of a loan default?
• How can IndianBank use predictive analytics to adjust loan terms and interest rates for high-risk applicants while keeping the
lending process fair and compliant with regulations?
• Operational Efficiency: Business Analytics can uncover process inefficiencies, enabling organizations to streamline operations,
reduce waste, and improve productivity.
• Strategic Planning: Data-driven insights are invaluable for long-term strategic planning. Companies can make more accurate
forecasts and set achievable objectives based on realistic data.
• Personalization: Analytics allows companies to provide highly personalized experiences for their customers, whether through
personalized product recommendations, content, or services. This personalization can lead to increased customer engagement and
satisfaction.
• Continuous Improvement: Regularly analyzing data and applying insights ensures that companies can adapt to changing market
conditions and evolving customer demands, leadingBusiness Analytics Sem 2 ITBM 23-25
to ongoing growth and adaptability. 22
BA, BI and Data Science
Point of
Business Analytics Business Intelligence Data Science
Difference
Focus Primarily concentrates on analyzing past and Focuses on reporting, data visualization, Broader field that encompasses data
present data to provide insights for making and monitoring of key performance collection, cleaning, analysis, modeling, and
informed decisions and solving immediate indicators (KPIs) using historical data. It is interpretation. It focuses on predictive
business problems. It's often about optimizing more about presenting data in a user- modeling, machine learning, and uncovering
existing processes and strategies. friendly format for easy consumption by actionable insights from data.
business users.
Methods Commonly uses statistical analysis, data mining, Typically involves data collection, data Data Science employs a wide range of
and quantitative modeling techniques to extract warehousing, dashboard creation, and techniques, from statistical analysis to
insights from structured data. report generation. It does not delve deeply machine learning and deep learning, to
into predictive or prescriptive analysis. discover patterns and trends in data. It also
involves data engineering to manage and
prepare data for analysis.
Purpose It is primarily used for making data-driven Provides a snapshot of the current state of Data Science is about understanding the
decisions in areas such as marketing, finance, the business. It helps answer questions like underlying patterns and making predictions
operations, and strategy. It helps answer "What is happening right now?" and "How for the future. It helps answer questions like
questions like "What happened?" and "Why did it are we doing compared to our goals?" "What is likely to happen in the future?" and
happen?" "What actions can we take to achieve specific
outcomes?"
Tools Common tools include Excel, statistical software Tools include platforms like Tableau, Common tools include Python, R, and
like R and SAS, and data visualization tools like Power BI, and QlikView. libraries like TensorFlow and scikit-learn.
Tableau.
In the recent past there has been a significant increase in organizations stressing on business analytics
(BA).
However, before we get into the thick of things as far as BA is concerned it is important to
understand the journey that information systems have taken from merely a transaction processing
system (TPS) to providing cutting edge competitive advantage by applying the BA concepts.
• Organizations felt the need for a specialized system which could provide relevant information to the mangers for
them to take critical decisions at the right time.
• For the first time, organizations started realizing the true potential of information systems
Transaction Processing System Business Analytics Sem 2 ITBM 23-25 Management Information System 25
• By applying MIS, managers were able to take the right
decisions based on the right information provided at the
right time.
Information of
Data Processing marketing
related activities
Marketing specific
Management Information System
Though the functional information systems provided Thus, came the ERP that is Enterprise Resource Planning,
specific information to all the functional heads, there was which helped to integrate all the key functional areas.
no integration of the functional heads with each other
Marketing
Production
ER Finance
P
HR
The information systems next took another excellent leap when organizations started implementing
Decision Support Systems (DSS).
The need for DSS emerged from the fact that mangers were working in a highly dynamic and
unpredictable environment.
DSS provided the facility of What If analysis that is DSS is interactive in nature.
• Though the end goal for all managers are the same that is higher profits or lower costs, the VUCA
conditions make it extremely challenging to achieve the given targets for increased profitability and
lowering costs
• For example, the marketing manager needs to be proactive in deciding which products should come to
the market at what time, how to market that product, which products to market online and which ones
offline
• Finance manager needs to access the financial volatility in the environment to gauge the credit risk.
• The operations manager needs to store minimum inventory which depends on the fact
how he forecasts the future trend, which again is highly volatile and dynamic.
• In today’s world unlike the scarcity of data in the past, there is a deluge of data.
• Organizations are collecting not only huge amount of structured data, but also semi-
structured and unstructured data
Managers cannot take rational and informed decisions just based on information.
Traditional information systems only process data so that relevant information can
be furnished to the managers.
• Marketing
• Which advertising campaigns are the most effective? How much social media penetration should a business attempt? What
sort of things do viewers like/dislike in commercials? Business analysts help answer these questions and so many more, by
measuring marketing and advertising metrics, identifying consumer behavior and the target audience, and analyzing market
trends.
These business analytics applications collectively empower organizations to make data-driven decisions, improve operations, enhance
customer experiences, and stay competitive in today's data-centric business landscape.
Business Analytics Sem 2 ITBM 23-25 44
https://www.simplilearn.com/business-analytics-applications-and-use-cases-article
Business Analytics – Specific Applications
• Customer Segmentation
• Customer segmentation is a vital business analytics application that helps companies group their customers based on shared characteristics
such as demographics, buying behavior, and preferences. By analyzing customer data, businesses can tailor their marketing strategies,
product offerings, and customer service to target specific segments effectively, increasing customer satisfaction and overall profitability.
• Predictive Analytics
• Predictive analytics leverages historical and real-time data to forecast future trends and events. This application is used extensively in
industries like finance, healthcare, and e-commerce for tasks such as predicting stock prices, patient outcomes, and product demand. It
enables proactive decision-making, risk mitigation, and optimization of business operations.
• Churn Analysis
• Churn analysis focuses on identifying and reducing customer churn, which is the rate at which customers stop using a
company's products or services. By analyzing customer behavior and feedback, businesses can implement retention
strategies to retain valuable customers and reduce revenue loss.
• Sentiment Analysis
• Sentiment analysis, also known as opinion mining, uses natural language processing and machine learning techniques to assess public sentiment and opinions
from sources like social media, customer reviews, and surveys. Companies can gain insights into how their brand is perceived and use this information to shape
marketing strategies and product development.
Business Analytics Sem 2 ITBM 23-25 47
https://www.simplilearn.com/business-analytics-applications-and-use-cases-article
Business Analytics – Specific Use Cases
Business analytics helps organizations run more efficiently and profitably. Here are five use
cases where business analytics proves its worth in the commercial sector.
• Churn Prevention
• Churn is the customer attrition rate, a percentage of subscribers, or customers who stop doing business
with a company. Successful companies must keep the churn rate low and replace any customer losses that
inevitably occur. Furthermore, it’s more expensive to acquire new customers than it is to retain existing
ones. By using predictive analysis, a business analyst helps identify customer dissatisfaction and the most
likely risks or departure.
• E-Commerce Personalization
• Online businesses, like Amazon, collect, process, and analyze customer data to personalize their
customers’ shopping experiences. By customizing the experience, vendors can make recommendations
and increase the likelihood of further sales.
https://www.statista.com/outlook/tmo/software/enterprise-software/business-intelligence-software/worldwide#revenue
Business Analytics Sem 2 ITBM 23-25 50
https://www.alliedmarketresearch.com/business-analytics-software-market
Journey of Information Systems
The Global Analytics and BI In 2022, the market is growing Analytics and BI Software It encompasses a range of Key features of Analytics and
Software Market is anticipated at a steady rate and with the market is a dynamic and software applications designed BI Software include vendor
to rise at a considerable rate rising adoption of strategies by rapidly evolving sector within to streamline and optimize the management, procurement
during the forecast period, key players, the market is the broader realm of business procurement processes of automation, spend analysis, e-
between 2023 and 2030. expected to rise over the and technology solutions. organizations across various procurement, contract
projected horizon. industries. management, and supplier
collaboration
https://www.linkedin.com/pulse/analytics-bi-software-market-2023-insights-o8fwc/
Business Analytics Sem 2 ITBM 23-25 51
Leading Players in Analytics and BI Software
• Who are the world's leading • Informatica
manufacturers in the Analytics • MicroStrategy
and BI Software industry? • Teradata Corporation
• SAS Institute • FICO
• SAP • Information builders
• IBM • Alteryx
• Microsoft • Birst
• Tableau • GoodData Corporation
• Oracle • OpenText
• Qlik
https://www.linkedin.com/pulse/analytics-bi-software-market-2023-insights-o8fwc/
Business Analytics Sem 2 ITBM 23-25 52
Leading Players in Analytics and BI Software
• Key players in the Analytics and BI Software market are influential
companies that play a significant role in shaping the industry and driving
its growth. These players are often at the forefront of technological
advancements, product innovation, and market trends.
https://www.linkedin.com/pulse/analytics-bi-software-market-2023-insights-o8fwc/
Business Analytics Sem 2 ITBM 23-25 53
Leading Players in Analytics and BI Software
• What Are the Different Types of Analytics and BI Software on the
Market?
• On-Premise
• Cloud-Based
https://www.linkedin.com/pulse/analytics-bi-software-market-2023-insights-o8fwc/
Business Analytics Sem 2 ITBM 23-25 54
Leading Players in Analytics and BI Software
• What are the factors driving applications of the Analytics and BI
Software Market?
• Retail
• Healthcare
• Manufacturing
• Aerospace and Defense
• Transportation
• Consumer Goods
• Others
https://www.linkedin.com/pulse/analytics-bi-software-market-2023-insights-o8fwc/
Business Analytics Sem 2 ITBM 23-25 55
Key drivers of Analytics and BI Software market
• Competitive Forces: Analytics and BI Software Market competition can understand consumer behavior and market trends, enabling more informed
drive innovation, improve quality, and lower prices. Companies striving to decision-making and market development.
gain a competitive edge often lead to market growth and evolution.
Raghupathi W, Raghupathi V. Contemporary Business Analytics: An Overview. Data. 2021; 6(8):86. https://doi.org/10.3390/data6080086
Business Analytics Sem 2 ITBM 23-25 57
Business Analytics Sem 2 ITBM 23-25 58
Business Analytics Sem 2 ITBM 23-25 59
Business Analytics Sem 2 ITBM 23-25 60