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 caseClose timeline
- July 1 Ask two questions and read the books
- July 2 Build two flows
- July 3 Answer both on one dashboard
- July 6 Publish it and schedule next month
- August 1 Upload July's shop export
- August 2 The flows run on schedule
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 caseInvoices 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
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 caseNet sales vs contribution, by product
- Insulated bottle
- Cooler bag
- Steel flask
- Travel cup
- Net sales
- Contribution
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 caseOver 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
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 caseCost per customer won, then kept
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 caseChurn by onboarding
Not onboarded 16 of 27
Onboarded 6 of 31
- Canceled by day 89
- Still subscribed at day 90
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.