---
title: "Data analysis examples with dashboards | Oplema"
description: "Work through six data analysis examples, from AR aging and budget vs actual to churn and CAC, each with a flow and a dashboard, on fictional data."
url: "https://oplema.com/use-cases"
updated: "2026-11-04"
---

# Worked data analysis examples

Each example takes one or two questions from raw exports to a decision and an interactive dashboard, built in Oplema. Strata works out the answer, Vista puts it on a dashboard you can change, and Cloud publishes it and reruns it on a schedule. The companies and data are fictional; the method is real.

- [
  ## Month-end reporting for a small business
  The AR aging and contribution margin cases as one month-end: a call list, a product decision and a schedule for July.
  Read the month-end case
  Close timeline
  1. July 1 Ask two questions and read the books
  2. July 2 Build two flows
  3. July 3 Answer both on one dashboard
  4. July 6 Publish it and schedule next month
  5. August 1 Upload July's shop export
  6. August 2 The flows run on schedule
  ](https://oplema.com/use-cases/month-end-reporting)
- [
  ## AR aging report with a collections call list
  Fern and Cedar each have a 90+ day invoice with £0 paid. Cedar has paid half its bills; Fern has paid none, so Fern gets the first call.
  Read the AR aging case
  Invoices by customer
  - **Fern Home**
    - INV-1003: Unpaid and late
    - INV-1015: Unpaid and late
    - INV-1016: Unpaid and late
    - INV-1038: Unpaid and late
    - INV-1039: Unpaid and late
    - INV-1046: Unpaid and late
  - **Cedar Goods**
    - INV-1013: Unpaid and late
    - INV-1032: Paid
    - INV-1033: Part-paid
    - INV-1034: Unpaid and late
    - INV-1037: Paid
    - INV-1049: Paid
  - Paid
  - Part-paid
  - Unpaid and late
  - Not due yet
  ](https://oplema.com/use-cases/ar-aging)
- [
  ## Contribution margin by product
  The best seller keeps 8% of each sale. The runner-up keeps 46%, and over five times the money.
  Read the contribution margin case
  Net sales vs contribution, by product
  - Insulated bottle *£3,914* **£327**
  - Cooler bag *£3,735* **£1,720**
  - Steel flask *£1,984* **£1,016**
  - Travel cup *£1,782* **£1,101**
  - Net sales
  - Contribution
  ](https://oplema.com/use-cases/contribution-margin)
- [
  ## Budget vs actual variance by department
  The total is 0.6% over budget. Marketing alone is £38,918 over and rising every month.
  Read the budget vs actual case
  Over or under budget, by department
  - Marketing **£38,918**
  - Legal **£4,861**
  - Sales **£4,230**
  - Finance **£3,968**
  - Training **\-£3,500**
  - Engineering **\-£5,871**
  - Customer support **\-£15,616**
  - Facilities **\-£17,098**
  ](https://oplema.com/use-cases/budget-vs-actual)
- [
  ## CAC by channel and cost per retained customer
  Meta wins customers for less, but Google Search costs less per customer who stays 90 days.
  Read the CAC by channel case
  Cost per customer won, then kept
  ](https://oplema.com/use-cases/cac-by-channel)
- [
  ## Customer churn analysis by onboarding and segment
  Customers who skipped onboarding canceled three times as often. That doesn't prove why.
  Read the customer churn case
  Churn by onboarding
  - **Not onboarded** 16 of 27
  - **Onboarded** 6 of 31
  - Canceled by day 89
  - Still subscribed at day 90
  ](https://oplema.com/use-cases/customer-churn)

## FAQ

**Are these companies and figures real?**

No. The companies, people and data are fictional. The method is real, and every figure on a page comes from running its flow.

**Can I run these analyses on my own data?**

Yes. Each example lists the columns it needs. Export those from your own systems, load them into the flow in Strata and run it.

**Do I need to write code?**

No. Each flow is built from blocks such as Filter, Summarize and Join. A few steps use a short formula, and Elara, Oplema's AI assistant, can help write it.

## Build these analyses from your exports

Rerun them whenever the data changes. Local runs are free.

[Try it on your exports](https://oplema.com/editor?path=%2F%3Fopen%3Dstrata) [Read the docs](https://oplema.com/docs)
