Worksheet · Data Analysis · Metrics
Data cleaning checklist and report template
From the lesson Key Business Metrics
Work through each step on paper or on screen. Use a real business, a project of your own or a friend’s idea. Keep this page for your portfolio.
1List the metrics you track now.
2Keep the five that matter most.
3Note what action each would trigger.
Worked example to compare with: Comparing two products
- Product A: revenue $20,000, costs $14,000. Margin: 30 percent.
- Product B: revenue $30,000, costs $28,000. Margin: 6.7 percent.
- Insight: B brings more revenue but far less profit.
- Action: look at B's costs or raise its price.
- Check: include all costs, such as shipping and returns.
Check yourself
- I can explain "Key Business Metrics" in one sentence.
- I used a real business or project, not just an idea.
- I know what I will do next, and by when.
Notes
Free course worksheet · https://studentmarketers.com