Unit 1 Bda
Unit 1 Bda
Meaning
Business Data Analytics refers to the systematic process of collecting, cleaning, analyzing,
and interpreting data to extract meaningful insights that support business decisions and
improve organizational performance.
It combines:
Statistics
Data visualization
Programming tools
Business knowledge
Any business professional who makes decisions needs foundational data analytics
knowledge. Access to data is more common than ever. If you formulate strategies and
make decisions without considering the data you have access to, you could miss major
opportunities or red flags that it communicates.
Marketers, who utilize customer data, industry trends, and performance data from
past campaigns to plan marketing strategies
Product managers, who analyses market, industry, and user data to improve their
companies’ products
Finance professionals, who use historical performance data and industry trends to
forecast their companies’ financial trajectories
Human resources and diversity, equity, and inclusion professionals, who gain
insights into employees’ opinions, motivations, and behaviours and pair it with
industry trend data to make meaningful changes within their organizations
Data collection is the first and most important step in analytics. It involves gathering raw data
from various internal and external sources that are relevant to business objectives.
Sources of Data
Sales transactions
Customer databases (CRM systems)
Websites and mobile apps
Social media platforms
Surveys and feedback forms
Financial records and operational logs
Importance
If incorrect or incomplete data is collected, the entire analysis becomes unreliable. Hence,
collecting accurate and relevant data is crucial.
Real-Time Example
A retail chain collects daily sales data from billing software and customer purchase details
from its CRM system to understand buying patterns and product demand.
Duplicate entries
Missing values
Incorrect formats
Outliers or irrelevant records
Cleaning ensures the dataset becomes accurate, consistent, and ready for analysis.
Techniques Used
Real-Time Example
An online shopping company may find duplicate customer entries in its database. By cleaning
the data, it removes repeated records and corrects incomplete customer details before
analysis.
3. Data Analysis – Applying Statistical and Logical
Techniques
Meaning
Data analysis involves examining cleaned data using statistical tools, mathematical models,
and logical reasoning to identify patterns, relationships, and trends.
Methods Used
Purpose
To transform processed data into meaningful patterns that answer business questions.
Real-Time Example
A telecom company analyzes customer usage data to identify which customers are likely to
stop using the service (customer churn analysis).
Interpretation is the process of explaining analytical results in a simple and meaningful way
so that managers can understand what the data actually indicates.
Key Activities
Importance
Data analysis alone is not useful unless results are interpreted correctly. Interpretation bridges
the gap between technical analysis and managerial understanding.
Real-Time Example
After analyzing sales data, analysts interpret that “Sales increased by 20% in festival months
due to promotional offers and higher customer demand.”
5. Decision Making – Using Insights to Improve Business
Strategies
Decision making is the final step where insights derived from data interpretation are used to
formulate strategies and business actions.
Role in Business
Types of Decisions
Real-Time Example
After interpreting sales trends, a company decides to increase inventory before festive
seasons and launch targeted marketing campaigns to maximize revenue.
Manufacturing Revolution (Early 1900s): Henry Ford used these principles to measure
assembly line components for the Ford Model T, revolutionizing mass production.
Tabulating Machines: Early data processing relied on punch cards and mechanical devices
like the Hollerith Tabulating Machine to speed up census data collection.
2. The Rise of Computing & Business Intelligence (1950s–1990s)
The introduction of mainframe computers shifted the focus from manual records to electronic
data processing.
Data Storage (1950s): IBM invented the first hard disk drive in 1956, allowing businesses to
save and access vast amounts of information.
Decision Support Systems (1970s–80s): Computers began assisting executives with data-
driven decisions. The 1970s saw the birth of Relational Databases (RDBMS) and SQL.
Spreadsheet Era (1980s): The release of VisiCalc (1979) and Microsoft Excel (1985)
democratized data manipulation, allowing non-experts to perform financial modeling and
budgeting.
Data Warehousing (1990s): Systems like those proposed by Ralph Kimball and Bill Inmon
consolidated data from disparate sources, enabling deeper historical analysis.
AI and Machine Learning: Algorithms now automate complex tasks, identify patterns
invisible to humans, and enable Real-Time Analytics for instant decision-making in
industries like finance and retail.
Scope
In marketing, data analytics is used to understand customer behavior, measure campaign
performance, and optimize promotional strategies.
Applications
Customer segmentation
Targeted advertising
Campaign effectiveness analysis
Customer lifetime value prediction
Social media analytics
Example
Companies like Amazon analyze browsing and purchase history to recommend personalized
products and increase sales conversion rates.
Scope
Analytics plays a vital role in financial planning, fraud detection, risk management, and
investment decision-making.
Applications
Credit risk analysis
Fraud detection systems
Portfolio optimization
Profitability and cost analysis
Budget forecasting
Example: Banks analyze customer transaction data to detect suspicious activities and prevent
fraud in real time.
3. Human Resource (HR) Analytics
Scope
HR analytics focuses on improving workforce performance, talent acquisition, and employee
retention strategies.
Applications
Employee performance analysis
Attrition prediction
Recruitment analytics
Training effectiveness measurement
Workforce planning
Example
A company analyzes employee attendance and productivity data to identify high performers
and provide promotions or incentives.
Scope
Used to optimize production, inventory, logistics, and overall operational efficiency.
Applications
Inventory management
Demand forecasting
Supplier performance evaluation
Logistics route optimization
Production scheduling
Example
A manufacturing firm predicts raw material requirements using past production and sales data
to avoid shortages or excess stock.
Scope
Helps organizations understand sales trends, customer buying patterns, and product
performance.
Applications
Sales forecasting
Region-wise performance analysis
Product demand analysis
Pricing optimization
Example
Retail chains analyze point-of-sale data to identify best-selling products and manage shelf
space effectively.
Scope
Healthcare analytics improves patient care, hospital operations, and disease prediction.
Applications
Patient data analysis
Treatment outcome prediction
Hospital resource allocation
Disease outbreak forecasting
Example
Hospitals analyze patient admission data to forecast bed occupancy and manage medical staff
efficiently.
Scope
Used to improve student performance, curriculum planning, and institutional decision-
making.
Applications
Student performance tracking
Dropout prediction
Personalized learning analytics
Admission and enrolment forecasting
Example: Universities analyze exam scores and attendance data to identify students at
risk of failing and provide academic support.
Scope
Applications
Recommendation systems
Customer journey analysis
Cart abandonment analysis
Dynamic pricing strategies
Example
Online platforms analyze customer search and purchase data to offer personalized discounts
and improve conversion rates.
Scope
Analytics is used to monitor machine performance, improve quality control, and reduce
production costs.
Applications
Predictive maintenance
Quality defect analysis
Production efficiency measurement
Process optimization
Example
Factories use sensor data from machines to predict equipment failure and schedule
maintenance before breakdowns occur.
10. Telecommunications Analytics
Scope
Telecom companies use analytics to manage networks, predict customer churn, and optimize
service quality.
Applications
Example: Telecom firms analyze call and internet usage patterns to create customized
data plans for different customer segments.
Scope
Governments use data analytics for policy-making, public service delivery, and smart city
planning.
Applications
Example: Traffic departments analyze real-time vehicle data to manage congestion and
optimize signal timings in smart cities.
Used to optimize transportation routes, reduce delivery time, and manage fleet operations.
Applications
Route optimization
Fuel consumption analysis
Delivery time prediction
Fleet maintenance scheduling
Example
Logistics companies analyze GPS and delivery data to choose the fastest and most fuel-
efficient delivery routes.
Scope
Analytics helps farmers and agribusiness firms improve crop yield, manage resources, and
predict weather risks.
Applications
Example
Agriculture firms analyze rainfall and soil data to recommend the best crops for a particular
season and region.
Scope
Used for risk assessment, premium pricing, and claim fraud detection.
Applications
Example
Insurance companies analyze customer health and claim history to decide premium rates.
15. Media and Entertainment Analytics
Scope
Analytics helps understand audience preferences and optimize content production and
advertising strategies.
Applications
1. Data-Driven Approach
Business data analytics is completely based on data rather than intuition or assumptions.
Decisions are made after analyzing factual information collected from various sources like
sales records, customer databases, and financial statements.
Example: A retail company studies past sales data to decide which products should be
stocked more during festive seasons.
It follows a structured process that includes data collection, cleaning, analysis, interpretation,
and decision-making. Each step is logically connected to ensure accurate and reliable
insights.
Example: A company first collects customer data, cleans errors, analyzes buying behavior,
interprets patterns, and then designs marketing strategies.
The main objective of business data analytics is to convert raw data into meaningful insights
that help managers understand business performance and market behavior.
Example: After analyzing website traffic data, a company identifies that most customers visit
during evening hours and schedules ads accordingly.
5. Predictive Capability
One important characteristic is its ability to forecast future trends using historical data and
predictive models. This helps businesses plan strategies in advance.
Example: E-commerce companies like Amazon predict future product demand based on
previous purchase patterns.
Business data analytics acts as a strong decision-support tool that helps managers take
strategic, tactical, and operational decisions with greater accuracy.
Example: A bank analyzes customer credit history before approving a loan to minimize
default risk.
7. Multi-Disciplinary Nature
Modern analytics systems can process real-time data, enabling businesses to respond quickly
to market changes and customer needs.
Example: Ride-hailing platforms adjust prices dynamically based on real-time demand and
supply conditions.
9. Visualization-Oriented
Business data analytics emphasizes data visualization through charts, dashboards, and graphs,
making complex information easier to understand for decision-makers.
Example: Managers use dashboards in tools like Power BI to monitor daily sales and
performance trends visually.
Analytics is always aligned with organizational goals such as profit maximization, cost
reduction, customer satisfaction, and market expansion.
Example: A company uses analytics to identify low-performing products and redesign its
product strategy to increase profitability.
11. Continuous and Iterative Process
Business analytics is not a one-time activity; it is a continuous cycle where data is constantly
updated, analysed, and used for improving decisions over time.
Example: Monthly performance reports are analyzed regularly to refine business strategies
and achieve better results.
Organizations using business analytics gain better market understanding, faster decision-
making, and improved operational efficiency, which provides a strong competitive edge.
Example: Companies that analyze customer preferences can launch products faster than
competitors and capture larger market share.
Data analytics provides evidence-based insights, which reduce uncertainty and human bias in
decision-making. By analysing historical and real-time data, managers can make more
precise and logical decisions.
Example: A retail company studies past sales data to decide which products should be
stocked more during festive seasons, avoiding overstocking or shortages.
Analytics helps businesses detect hidden patterns and trends in large datasets that are not
visible through manual observation. This supports better planning and forecasting.
Example: An e-commerce platform like Amazon identifies seasonal buying trends and
launches targeted promotions during high-demand periods.
With data-driven insights, top management can design long-term strategies related to
expansion, pricing, investment, and product development.
Example: A company analyses market demand and customer preferences before launching a
new product in a specific region.
4. Supports Predictive Decision-Making
Predictive analytics uses past and present data to forecast future outcomes, enabling proactive
decision-making rather than reactive responses.
Example: Banks analyze customer transaction history to predict loan default risk and decide
whether to approve or reject a loan application.
Example: Logistics companies analyze delivery route data to select the fastest and most fuel-
efficient routes, reducing operational costs.
Example: Insurance companies analyses claim history and customer profiles to assess risk
levels and determine premium rates accordingly.
Customer analytics provides deep insights into customer preferences, behaviour, and
satisfaction levels, helping businesses design personalized products and services.
Example: Streaming platforms recommend movies and shows based on user watch history to
enhance customer experience and retention.
Modern analytics tools process real-time data, enabling managers to make quick decisions in
dynamic market conditions.
Example: Ride-hailing apps adjust pricing dynamically based on real-time demand and
supply data.
9. Competitive Advantage
Organizations that use data analytics can respond quickly to market changes, innovate faster,
and outperform competitors by making smarter decisions.
Example: Companies using analytics for demand forecasting can maintain optimal inventory
levels and avoid stock outs, giving them an edge over competitors.
Example: Managers use dashboards to monitor daily sales, revenue growth, and employee
performance for better control and decision-making.
For example, a company analyzes past sales data and customer preferences to decide which
product to launch in the next season. Similarly, an e-commerce company like Amazon uses
customer browsing and purchase data to decide personalized product recommendations and
pricing strategies.
Strategic decisions are long-term, high-level decisions taken by top management using
analytical insights to achieve overall business goals and competitive advantage.
Characteristics
Long-term impact
High risk and importance
Based on large-scale data analysis
Focused on growth, expansion, and policy formulation
Examples
Characteristics
Medium-term focus
Departmental level decisions
Based on performance and operational data
Examples
Operational decisions are short-term, routine decisions taken at the lower management level
using real-time and daily data analysis to manage day-to-day business activities.
Characteristics
Examples
1.1 Meaning
Qualitative data analysis refers to the process of examining non-numerical data such as
opinions, perceptions, experiences, and textual information.
It aims to understand the reasons, motivations, and underlying causes behind business
trends rather than measuring them numerically.
For example, if a company wants to know why customers are switching to competitors,
qualitative analysis helps identify reasons like poor service, high price, or better alternatives.
Types include:
Customer Feedback
Interviews
Focus Groups
A small group of people discusses a product or service, providing insights into consumer
preferences.
Observations
Content analysis involves systematically reviewing textual data to identify common words,
patterns, or issues.
Example:
A company analyzes 1000 product reviews to identify recurring complaints such as “late
delivery” or “damaged packaging”.
Price-related concerns
Product quality issues
Customer service experience
Sentiment analysis determines whether customer opinions are positive, negative, or neutral.
It is widely used in digital marketing and brand management.
Example:
Positive: “Excellent design and fast delivery”
Negative: “Poor quality and high price”
Case study analysis involves detailed examination of a single organization, event, or project
to understand practical business issues.
Example:
Studying how a startup successfully increased its market share through digital marketing
strategies.
These techniques involve direct interaction with respondents to gather detailed insights.
2.1 Meaning
Quantitative data analysis involves examining numerical data using statistical and
mathematical tools.
It focuses on measuring business performance and identifying relationships between
variables.
Examples include:
Sales figures
Profit margins
Market share percentage
Customer ratings (1–5 scale)
Website traffic metrics
Descriptive statistics summarize data using numerical measures such as mean, median, and
standard deviation.
Example:
Average monthly sales = ₹4,50,000
This helps understand overall performance trends.
Inferential statistics uses sample data to make predictions or generalizations about a larger
population.
Example:
Using past sales data to predict next year’s demand.
Correlation analysis measures the strength and direction of the relationship between two
variables.
Example:
Relationship between advertising expenditure and sales revenue.
Regression analysis predicts the impact of one variable on another and is widely used in
forecasting.
Example:
Predicting future sales based on past growth trends and market demand.
Data visualization converts numerical data into charts and graphs for easier understanding.
Common tools:
Data Type
Qualitative analysis deals with descriptive data such as opinions and experiences, while
quantitative analysis deals with numerical data like sales figures and percentages.
Purpose
Tools Used
Qualitative methods use interviews, focus groups, and thematic coding. Quantitative methods
use statistical tools like Excel, SPSS, and Python.
Output
Qualitative analysis produces insights, themes, and narratives. Quantitative analysis produces
numbers, charts, and forecasts.
Final Insight: Technical issues caused reduced traffic → Improve app speed.
Marketing
Qualitative analysis helps understand brand perception and customer preferences, while
quantitative analysis measures campaign effectiveness and market share.
Finance
Quantitative methods analyze profitability, cost control, and investment returns, while
qualitative insights assess investor confidence and market sentiment.
Human Resource Management
Qualitative data includes employee feedback and exit interviews, whereas quantitative data
measures employee turnover rate and productivity levels.
Operations Management
Quantitative analysis evaluates production efficiency and inventory levels, while qualitative
feedback helps improve workflow and employee safety conditions.
Business data analytics uses various software and programming tools to collect, process,
analyze, and visualize data for better decision-making. Some of the most important and
commonly used tools are explained below in a simple and student-friendly way.
Python
Python is a powerful programming language widely used in business analytics for data
cleaning, data manipulation, statistical analysis, and building predictive models. It supports
libraries such as Pandas, NumPy, and Matplotlib, which help analysts handle large datasets
and perform advanced analysis efficiently.
Microsoft Excel
Microsoft Excel is one of the most basic and essential tools for business data analytics. It is
used to organize data, perform calculations, create pivot tables, and generate charts and
graphs. Excel is very useful for beginners and for performing small to medium-level data
analysis tasks in finance, marketing, and operations.
Power BI
SQL
SQL (Structured Query Language) is used to store, retrieve, and manage structured data
stored in databases. It is an important tool for business analysts because most organizations
store large volumes of data in database systems. SQL helps extract required data for further
analysis.
R Programming
Tableau
Tableau is a popular data visualization tool used to create interactive charts, dashboards, and
graphical reports. It helps analyst’s present complex data in a clear and visually appealing
format, making it easier for managers to understand business insights.
Google Analytics
Google Analytics is a web analytics tool used to analyze website traffic, customer behaviour,
and digital marketing performance. Businesses use this tool to understand how users interact
with their websites and to improve online marketing strategies.
SPSS
SPSS (Statistical Package for the Social Sciences) is a statistical software used for survey
analysis, regression analysis, and hypothesis testing. It is commonly used in business
research, market research, and academic projects.
Hadoop
Hadoop is a big data framework used to store and process extremely large datasets that
cannot be handled by traditional tools. It is used by large organizations to analyze massive
amounts of structured and unstructured data.
Apache Spark
Apache Spark is a fast data processing engine used for real-time analytics and large-scale
data computations. It is widely used in big data analytics for handling complex and high-
speed data processing tasks.
Google Sheets
Google Sheets is a cloud-based spreadsheet tool similar to Excel. It allows multiple users to
work on the same dataset simultaneously and is useful for collaborative business data
analysis.
SAS is an advanced analytics software used for data management, predictive analytics, and
business intelligence reporting. It is commonly used in large enterprises for complex
statistical analysis and forecasting.