Start Where You Are

In the previous lab, you explored the "blueprint" of a business—the data model. You saw how tables like customer, rental, and payment interact to record every heartbeat of a DVD rental store. However, data without direction is merely noise. In Chapter 2, we discussed the vital link between Strategy and Analytics.

Strategy is operationalized through Key Performance Indicators (KPIs). To measure if a strategy is working, we must identify the specific metrics that define success, then work backward to the data model to extract and transform that information into a "front-end" system for decision-makers.

The Strategic Mandate

The corporate office of our fictional DVD rental business has issued a clear strategic goal for this fiscal year:

Strategic Objective: Increase monthly per-customer revenue.

To achieve this, management cannot simply "hope" for higher sales. They must execute specific programs—initiatives—and measure their effectiveness using the data at their disposal.

Task 1: Defining Initiatives and Metrics

Below is an example of how a manager might translate this corporate strategy into actionable programs.

Initiative A: The "New Release" Loyalty Upsell

• Description: A program targeting frequent renters with discounted "New Release" bundles to increase the frequency and value of their visits.
• Metrics & Targets:
  1. Average Monthly Revenue Per Customer: Target an increase from $12.50 to $15.00.
  2. Rental Frequency: Target 3.5 rentals per month per active customer.
  3. New Release Capture Rate: 40% of all rentals should come from the 'New Release' category.

Initiative B: Late Fee Optimization & Retention

• Description: Implementing a tiered late fee structure and "forgiveness" tokens for high-value customers to ensure they return to the store rather than abandoning the service due to high fines.
• Metrics & Targets:
  1. Average Monthly Revenue Per Customer: Maintain at least $12.50 while increasing customer lifetime value.
  2. Late Fee Collection Efficiency: 85% recovery of generated late fees.
  3. Churn Rate: Reduce customer "churn" (customers who haven't rented in 30 days) by 10%.

<aside> 💡

The Prerequisite: Using Data to Set Targets

Before you can set a target of $15.00 for revenue, you must understand your baseline. Data is required not just to measure the result, but to design the initiative itself. Without historical analysis, your initiative may fail to make any impact because it is based on guesswork rather than reality. Consider these questions:

• What is the current pattern of late fees? If current data shows that late fees are already a negligible part of revenue, an "optimization" program won't move the needle on total revenue.
• Do our most loyal customers pay a lot of late fees? If your best customers are the ones being penalized most heavily, they are the highest risk for churning. You need to see the correlation between payment amounts and customer_id loyalty.
• What is the current average customer spending? If the current average is $12.00, a target of $15.00 is ambitious but possible. If the current average is only $5.00, your target is likely unrealistic without a fundamental change in business model. </aside>

Task 2: Mapping Metrics to the Data Model

To calculate these metrics, you must combine data from several tables. Refer to your ERD (Entity Relationship Diagram) to trace these connections.

Data Integration Plan: