1. Introduction
Different business functions have unique data needs, KPIs, and decision types. This guide covers how data-driven decision making applies to each major function.
Data-Driven Decisions
Your 13-step learning path • Currently on Step 11
Introduction to Business Analytics & DDDM
Defining & Tracking KPIs
Dashboard Design & BI Tools
Experimentation & A/B Testing
Statistical Significance & Interpretation
Decision Frameworks & Structured Decision Making
Data Collection & Quality Management
Business Storytelling & Visualization
Predictive Analytics & Forecasting
Data-Driven Culture & Organizational Adoption
11
Function-Specific Data Applications
12
Capstone Projects (Portfolio-Ready)
13
Advanced Analytics & Automation
Cross-Functional Analytics
While each function has specialized metrics, many insights come from connecting data across functions:
- Marketing ↔ Sales: Lead quality, marketing attribution
- Sales ↔ Finance: Revenue forecasting, deal profitability
- Product ↔ Customer Success: Feature adoption, churn drivers
- HR ↔ Operations: Workforce planning, productivity
2. Marketing Analytics
Marketing analytics measures the effectiveness of campaigns and channels to optimize spend and growth.
Marketing KPIs
| Metric | Formula | Benchmark |
|---|---|---|
| CAC (Customer Acquisition Cost) | Marketing Spend ÷ New Customers | Varies; CAC:LTV ratio < 1:3 |
| ROAS (Return on Ad Spend) | Revenue from Ads ÷ Ad Spend | >4x for profitable campaigns |
| CTR (Click-Through Rate) | Clicks ÷ Impressions | 2-5% for search ads |
| Conversion Rate | Conversions ÷ Visitors | 2-5% for e-commerce |
| MQL/SQL Ratio | Sales Qualified Leads ÷ Marketing Qualified Leads | 30-50% |
Attribution Modeling
Which touchpoints get credit for a conversion?
- Last-touch: 100% credit to final touchpoint (simple but misleading)
- First-touch: 100% credit to first touchpoint
- Linear: Equal credit across all touchpoints
- Time-decay: More credit to touchpoints closer to conversion
- Data-driven (ML): Algorithmic attribution based on actual impact
Campaign Optimization
- A/B test ad creative, copy, landing pages
- Optimize for CAC rather than just volume
- Segment performance by channel, audience, geography
- Use cohort analysis to track long-term value
3. Sales Analytics
Sales analytics focuses on pipeline health, forecasting, and rep productivity.
Pipeline Analysis
| Metric | What It Tells You |
|---|---|
| Pipeline Coverage | Pipeline value ÷ Quota (target: 3-4x) |
| Win Rate | Deals won ÷ Total deals |
| Average Deal Size | Revenue ÷ Deals closed |
| Sales Cycle Length | Days from lead to close |
| Stage Conversion Rates | % advancing from each pipeline stage |
Sales Forecasting
- Weighted pipeline: Sum of (deal value × probability by stage)
- Historical run rate: Past performance extrapolated
- Rep-level rollup: Each rep's committed/best-case/worst-case
- ML models: Predict close probability from deal attributes
Territory Planning
Balance workload and opportunity across territories:
- Equal revenue potential per rep
- Geographic efficiency (minimize travel)
- Account load balancing
- Growth potential vs. current revenue
4. Finance Analytics
Finance analytics supports planning, reporting, and risk management.
Financial KPIs
| Category | Key Metrics |
|---|---|
| Profitability | Gross Margin, Operating Margin, Net Margin, EBITDA |
| Liquidity | Current Ratio, Quick Ratio, Cash Conversion Cycle |
| Efficiency | Revenue per Employee, Asset Turnover |
| Growth | Revenue Growth Rate, ARR Growth (SaaS), Net Revenue Retention |
Budgeting & Planning
- Top-down: Leadership sets targets, cascades down
- Bottom-up: Teams build budgets, roll up
- Driver-based: Model from key drivers (headcount, deals, etc.)
- Rolling forecasts: Continuous re-forecasting (vs. annual budget)
Risk Analysis
- Scenario planning: Best case, base case, worst case
- Sensitivity analysis: Impact of changing one variable
- Monte Carlo simulation: Probability distributions for outcomes
5. Operations Analytics
Operations analytics optimizes efficiency, quality, and cost.
Supply Chain Analytics
- Demand forecasting: Predict what customers will order
- Inventory optimization: Balance stockouts vs. holding costs
- Supplier performance: On-time delivery, quality, cost
- Lead time analysis: Time from order to delivery
Quality Metrics
| Metric | Description |
|---|---|
| Defect Rate | Defects per unit produced |
| First Pass Yield | % of units passing without rework |
| OEE (Overall Equipment Effectiveness) | Availability × Performance × Quality |
| MTBF/MTTR | Mean Time Between Failures / Mean Time To Repair |
6. HR Analytics
HR analytics (People Analytics) measures workforce health and optimizes talent decisions.
Talent Metrics
- Time to Hire: Days from requisition to offer acceptance
- Cost per Hire: Recruiting costs ÷ hires
- Quality of Hire: Performance ratings of new hires
- Offer Acceptance Rate: Offers accepted ÷ offers made
Retention Analysis
| Metric | Formula | Notes |
|---|---|---|
| Turnover Rate | Departures ÷ Avg Headcount | Track voluntary vs. involuntary |
| Retention Rate | 1 - Turnover Rate | Target: >85% for most roles |
| eNPS | % Promoters - % Detractors | Employee Net Promoter Score |
| Regrettable Attrition | High performers who left | Most critical to track |
7. Product Analytics
Product analytics measures how users interact with your product to drive engagement and retention.
Product KPIs
| Metric | Description |
|---|---|
| DAU/MAU | Daily/Monthly Active Users (engagement) |
| Stickiness | DAU ÷ MAU (how often users return) |
| Retention Curves | % of users returning on Day 1, 7, 30 |
| Feature Adoption | % of users using a specific feature |
| NPS/CSAT | User satisfaction scores |
User Behavior Analysis
- Funnel analysis: Where do users drop off?
- Cohort analysis: How do different user groups behave over time?
- Session recordings: Watch real user interactions
- Feature impact analysis: Does feature X improve retention?
8. Conclusion & Next Steps
You've now covered the key concepts in this section of data-driven decision making. Here's a summary of what you've learned:
Key Takeaways
- Each function has unique KPIs: Learn the language of the function you're supporting
- Cross-functional insights are gold: Connect data across silos
- Start with decisions: What decisions will this data inform?
- Context matters: Benchmarks vary by industry, stage, and strategy
In the next article, we'll cover Capstone Projects—putting everything together with portfolio-ready case studies.