M-463: Functional Analytics

UNIT I: Introduction to Functional Analytics

1. Meaning and Scope of Functional Analytics

Definition: Functional Analytics refers to the systematic application of statistical, quantitative, and
computational techniques to analyze data generated from various business functions (Marketing, Finance,
HR, Operations, Digital) to support managerial decision-making.

Scope: - Strategic decision support - Tactical planning - Operational control - Performance management

Functional Areas Covered: | Function | Key Analytics Focus | |----------|---------------------| | Marketing |

Customer behavior, segmentation, campaigns | | Finance | Risk, return, forecasting | | HR | Talent,
performance, attrition | | Operations | Demand, inventory, process optimization | | Digital | Web traffic,
conversion, engagement |

Exam Diagram (Textual): Business Data → Functional Analytics Engine → Insights → Decisions →
Performance

2. Role of Analytics in Managerial Decision Making

Decision Levels: 1. Strategic (Long-term) 2. Tactical (Medium-term) 3. Operational (Short-term)

Analytics Contribution: - Reduces uncertainty - Improves forecasting accuracy - Enables evidence-based

management - Enhances competitive advantage

Decision-Making Model: Problem Identification → Data Collection → Analysis → Alternatives → Choice →

Implementation → Feedback

Mini Caselet: A retail chain uses sales analytics to decide store expansion locations based on footfall,
income level, and competitor density.

3. Analytics Framework Across Business Functions

Generic Analytics Framework: 1. Data Acquisition 2. Data Cleaning 3. Data Storage 4. Modeling & Analysis
5. Visualization & Dashboards 6. Decision & Action

Cross-Functional Integration: - Marketing + Finance: CLV and profitability - HR + Operations: Workforce

productivity - Digital + Marketing: Campaign attribution

1
4. Types of Analytics

a) Descriptive Analytics

• What happened?
• Tools: Reports, Dashboards, OLAP
• Example: Monthly sales summary

b) Diagnostic Analytics

• Why did it happen?

• Tools: Drill-down, Root cause analysis
• Example: Sales drop due to price increase

c) Predictive Analytics

• What will happen?

• Tools: Regression, Time series, ML
• Example: Demand forecasting

d) Prescriptive Analytics

• What should be done?

• Tools: Optimization, Simulation
• Example: Optimal inventory levels

Analytics Maturity Ladder Diagram: Descriptive → Diagnostic → Predictive → Prescriptive

Key Metrics & Dashboards

Area Sample KPIs

Marketing Conversion rate, CAC, CLV

Finance ROI, ROE, Risk-adjusted return

HR Attrition rate, Productivity

Operations Fill rate, Cycle time

Digital CTR, Bounce rate

Exam-Oriented Questions

2 Marks: - Define Functional Analytics. - List types of analytics.

5 Marks: - Explain the role of analytics in managerial decision making. - Describe the analytics framework.

2
10 Marks: - Discuss the scope of functional analytics and its application across business functions with
diagrams.

Important Keywords

Functional data, KPIs, Decision support system, Descriptive analytics, Predictive modeling, Optimization

Revision Points

• Analytics supports fact-based decisions

• Integrates all functional areas
• Evolves from reporting to optimization

(End of UNIT I)

UNIT II: Marketing Analytics

1. Customer Segmentation and Profiling

Definition: Customer segmentation is the process of dividing a heterogeneous market into homogeneous
groups based on similar characteristics, needs, and behavior.

Bases of Segmentation: - Demographic (Age, Income, Gender) - Geographic (Region, Urban/Rural) -

Psychographic (Lifestyle, Values) - Behavioral (Usage rate, Loyalty)

Analytical Techniques: - Cluster Analysis (K-means, Hierarchical) - RFM Analysis (Recency, Frequency,
Monetary)

Process Flow (Diagram): Customer Data → Variable Selection → Clustering → Segment Profiling → Target
Strategy

Mini Caselet: An e-commerce firm segments customers into "High Value", "Occasional Buyers", and "Churn
Risk" using RFM scores.

2. Market Basket Analysis

Meaning: Market Basket Analysis identifies associations among products purchased together using
transactional data.

Key Measures: - Support - Confidence - Lift

Model: Association Rule Mining (Apriori Algorithm)

3
Business Application: Cross-selling, Store layout optimization, Recommendation systems

Diagram: Transaction Data → Frequent Itemsets → Association Rules → Marketing Actions

3. Customer Lifetime Value (CLV)

Definition: CLV is the present value of future profits generated by a customer over the entire relationship
period.

Formula (Simplified): CLV = (Average Purchase Value × Purchase Frequency × Customer Lifespan) –
Acquisition Cost

Uses: - Budget allocation - Customer prioritization - Relationship marketing

4. Churn Analysis

Meaning: Churn analysis predicts the probability of customers leaving the company.

Techniques: - Logistic Regression - Decision Trees - Survival Analysis

KPIs: Churn Rate, Retention Rate, Repeat Purchase Rate

5. Campaign Effectiveness and ROI Analysis

Metrics: - Conversion Rate - Cost per Lead (CPL) - Return on Marketing Investment (ROMI)

ROI Formula: ROI = (Incremental Revenue – Campaign Cost) / Campaign Cost

Dashboard Elements: Impressions, Clicks, Leads, Sales, Profit

Exam-Oriented Questions (UNIT II)

2 Marks: - Define CLV. - What is churn rate?

5 Marks: - Explain Market Basket Analysis with measures. - Describe customer segmentation techniques.

10 Marks: - Discuss the role of analytics in customer relationship management using CLV and churn
models.

4
Important Keywords

Segmentation, RFM, Apriori, CLV, Churn, ROMI, Association Rules

Revision Points

• Segmentation enables target marketing

• CLV links marketing to profitability
• Churn models support retention strategy

(End of UNIT II)

UNIT III: Financial Analytics

1. Financial Statement Analysis

Meaning: Systematic analysis of Income Statement, Balance Sheet and Cash Flow Statement using
analytical tools to assess profitability, liquidity, solvency and efficiency.

Techniques: - Horizontal Analysis (Trend %) - Vertical Analysis (Common Size Statements)

Diagram (Exam): Financial Statements → Data Extraction → Ratio & Trend Analysis → Financial Health
Assessment

2. Ratio Analysis using Analytics Tools

Major Ratio Categories: | Category | Key Ratios | |---------|------------| | Liquidity | Current, Quick | |
Profitability | ROA, ROE, Net Margin | | Leverage | Debt-Equity, Interest Coverage | | Efficiency | Inventory
Turnover, Receivables Turnover |

Dashboard KPIs: Working Capital, EBITDA, Cash Conversion Cycle

3. Risk and Return Analysis

Return Measures: - Mean Return - CAGR

Risk Measures: - Standard Deviation - Beta

CAPM Model: Expected Return = Rf + β (Rm – Rf)

5
4. Portfolio Analytics

Modern Portfolio Theory (Markowitz): - Diversification - Efficient Frontier

Diagram: Assets → Covariance Matrix → Efficient Frontier → Optimal Portfolio

5. Credit Scoring and Default Prediction

Meaning: Use of statistical models to assess probability of default.

Models Used: - Logistic Regression - Discriminant Analysis - Machine Learning Classifiers

KPIs: PD, LGD, EAD

Mini Caselet

A bank uses credit scoring analytics to approve loans and set interest rates based on customer risk profile.

Exam-Oriented Questions (UNIT III)

2 Marks: - Define Beta. - What is Efficient Frontier?

5 Marks: - Explain ratio analysis using analytics dashboards. - Describe risk-return tradeoff.

10 Marks: - Discuss the application of portfolio analytics and credit scoring models in financial decision
making.

Important Keywords

Financial ratios, CAPM, Beta, Efficient frontier, Credit scoring, Default probability

Revision Points

• Analytics improves financial forecasting and risk control

• Portfolio diversification reduces unsystematic risk

(End of UNIT III)

6
UNIT IV: HR Analytics
1. Workforce Planning Analytics

Meaning: Use of data and statistical models to forecast workforce demand and supply.

Models Used: - Trend Analysis - Markov Models - Skills Gap Analysis

Diagram: Business Strategy → Manpower Forecast → Gap Analysis → Recruitment & Training Plan

2. Attrition and Retention Analysis

Attrition Rate Formula: Attrition = (No. of Employees Leaving / Avg. No. of Employees) × 100

Analytical Techniques: - Logistic Regression - Survival Analysis

KPIs: Retention Rate, Turnover Cost, Engagement Index

3. Performance Analytics

Metrics: - KPI Achievement - Balanced Scorecard - 360° Feedback Scores

Applications: - Promotion decisions - Training needs identification

4. Compensation and Productivity Analytics

Compensation Models: - Pay-for-Performance - Benchmarking Analysis

Productivity Metrics: Revenue per Employee, Output per Man-hour

5. Talent Analytics and Succession Planning

Meaning: Identification of high-potential employees and leadership pipeline using analytics.

Tools: - Talent Scorecards - Predictive Modeling

Mini Caselet

An IT firm uses attrition prediction models to identify high-risk employees and design retention strategies.

7
Exam-Oriented Questions (UNIT IV)

2 Marks: - Define attrition rate. - What is workforce analytics?

5 Marks: - Explain performance analytics and its role in HR decisions. - Describe compensation analytics.

10 Marks: - Discuss the application of HR analytics in workforce planning and retention.

Important Keywords

Workforce planning, Attrition, Balanced Scorecard, Talent analytics, Productivity

Revision Points

• HR analytics links people decisions to business performance

• Predictive models improve retention and succession planning

(End of UNIT IV)

UNIT V: Operations & Supply Chain Analytics

1. Demand Forecasting Analytics

Meaning: Use of historical data and statistical models to predict future demand.

Techniques: - Time Series Analysis (Moving Average, Exponential Smoothing) - Regression Models

Diagram: Historical Sales Data → Forecasting Model → Demand Forecast → Production Planning

2. Inventory Optimization

Models: - EOQ (Economic Order Quantity) - Safety Stock Models - Reorder Point Analysis

Key Metrics: Inventory Turnover, Stock-out Rate, Holding Cost

3. Logistics and Distribution Analytics

Applications: - Route Optimization - Warehouse Location Analysis - Transportation Cost Minimization

Tools: Linear Programming, GIS Analytics

8
4. Process Optimization and Bottleneck Analysis

Techniques: - Theory of Constraints - Process Mapping - Simulation Models

Diagram: Process Flow → Bottleneck Identification → Capacity Balancing → Throughput Improvement

5. Six Sigma and Lean Analytics

Six Sigma DMAIC: Define → Measure → Analyze → Improve → Control

Lean Tools: Value Stream Mapping, Kaizen, Waste Reduction

Mini Caselet

An automobile firm uses forecasting and inventory analytics to reduce stock-outs and carrying costs.

Exam-Oriented Questions (UNIT V)

2 Marks: - What is EOQ? - Define bottleneck.

5 Marks: - Explain demand forecasting techniques. - Describe Six Sigma DMAIC.

10 Marks: - Discuss the role of analytics in supply chain optimization.

Important Keywords

Forecasting, EOQ, Safety stock, Bottleneck, DMAIC, Lean

Revision Points

• Analytics improves service level and cost efficiency

• Bottleneck removal increases system throughput

(End of UNIT V)

UNIT VI: Web & Digital Analytics

1. Web Traffic Analysis

Meaning: Measurement and analysis of user visits and behavior on websites to evaluate performance.

9
Key Metrics: - Sessions - Users - Page Views - Bounce Rate - Average Session Duration

Tools: Google Analytics, Adobe Analytics

Diagram: User Visits → Tracking Tools → Traffic Reports → Insight Generation

2. Conversion Funnel Analytics

Concept: Analysis of customer movement through stages: Awareness → Interest → Desire → Action.

Metrics: - Conversion Rate - Drop-off Rate - Cost per Conversion

Diagram: Visitors → Leads → Prospects → Customers

3. Social Media Analytics

KPIs: Reach, Engagement Rate, Virality, Sentiment Score

Applications: Brand monitoring, Campaign evaluation, Influencer analysis

4. Clickstream Analysis

Meaning: Analysis of sequence of pages visited by users.

Techniques: Path Analysis, Sequence Mining

Business Use: Website optimization, Recommendation engines

5. Digital Marketing Performance Metrics

Key Metrics: CTR, CPC, CPA, ROI, Customer Acquisition Cost

Dashboard Components: Traffic Sources, Campaign Performance, Conversion Trends

Mini Caselet

An online retailer analyzes clickstream and funnel data to improve checkout conversion rates.

10
Exam-Oriented Questions (UNIT VI)

2 Marks: - Define bounce rate. - What is CTR?

5 Marks: - Explain conversion funnel analytics. - Describe social media analytics.

10 Marks: - Discuss the role of web analytics in digital marketing optimization.

Important Keywords

Web analytics, Funnel, Clickstream, Conversion, Engagement, ROI

Revision Points

• Digital analytics links online behavior to marketing performance

• Dashboards support real-time decisions

(End of UNIT VI)

UNIT VII: Predictive & Prescriptive Models

1. Regression and Classification Models

Regression: Used to predict a continuous dependent variable.

• Linear Regression
• Multiple Regression

Classification: Used to classify outcomes into categories.

• Logistic Regression
• Decision Trees
• KNN, Naïve Bayes

Process Diagram: Data → Model Training → Validation → Prediction → Decision

2. Simulation Models

Meaning: Imitation of real-world processes using computational models.

Types: - Monte Carlo Simulation - Discrete Event Simulation

Applications: Risk analysis, Capacity planning, Waiting line analysis

11
3. Optimization Techniques

Objective: Maximize profit or minimize cost subject to constraints.

Methods: - Linear Programming - Integer Programming - Goal Programming

Diagram: Decision Variables → Objective Function → Constraints → Optimal Solution

4. Decision Trees and What-if Analysis

Decision Trees: Graphical representation of decision alternatives, probabilities and outcomes.

What-if Analysis: Examines impact of changes in input variables on outputs.

Tools: Excel Solver, Scenario Manager, BI Tools

Mini Caselet

A manufacturing firm uses simulation and optimization to decide optimal production mix under demand
uncertainty.

Exam-Oriented Questions (UNIT VII)

2 Marks: - Define regression. - What is simulation?

5 Marks: - Explain decision tree analysis. - Describe optimization models.

10 Marks: - Discuss predictive and prescriptive analytics models used in managerial decision making.

Important Keywords

Regression, Classification, Simulation, Optimization, Decision Tree, What-if Analysis

Revision Points

• Predictive models forecast future outcomes

• Prescriptive models recommend optimal actions

(End of UNIT VII)

12
UNIT VIII: Emerging Trends in Functional Analytics
1. Big Data Analytics

Meaning: Analysis of extremely large, complex and fast-moving datasets characterized by 5Vs – Volume,
Velocity, Variety, Veracity, Value.

Technologies: Hadoop, Spark, NoSQL, Data Lakes

Business Applications: Customer behavior tracking, Fraud detection, Supply chain visibility

2. AI and Machine Learning in Business Functions

AI Applications: - Marketing: Recommendation engines, Chatbots - Finance: Algorithmic trading, Fraud

detection - HR: Resume screening, Attrition prediction - Operations: Predictive maintenance

ML Models: Supervised, Unsupervised, Reinforcement Learning

3. Real-Time Analytics

Meaning: Analytics performed on streaming data for immediate decision making.

Examples: Stock trading systems, Online ad bidding, IoT monitoring

4. Cloud Analytics Platforms

Platforms: AWS, Azure, Google Cloud, Snowflake

Advantages: Scalability, Cost efficiency, Accessibility, Collaboration

5. Ethical and Legal Issues in Business Analytics

Key Issues: - Data Privacy - Algorithmic Bias - Data Security - Regulatory Compliance (GDPR, IT Act)

Ethical Framework: Transparency → Accountability → Fairness → Consent → Security

Mini Caselet

A fintech firm uses AI-based credit scoring while ensuring compliance with data privacy laws.

13
Exam-Oriented Questions (UNIT VIII)

2 Marks: - What is Big Data? - Define real-time analytics.

5 Marks: - Explain the role of AI in functional analytics. - Describe cloud analytics platforms.

10 Marks: - Discuss emerging trends in functional analytics and their managerial implications.

Important Keywords

Big Data, AI, Machine Learning, Real-time analytics, Cloud, Ethics, Privacy

Revision Points

• Analytics is moving towards automation and intelligence

• Ethical governance is critical in data-driven decisions

(End of UNIT VIII)

END OF M-463: FUNCTIONAL ANALYTICS COMPLETE SYLLABUS

NOTES

14