| Ecommerce Sales & Returns | CSV files or Excel workbook | 6 tables to relate | Order activity, repeat customers, payments, and refunds | Preventing duplicated revenue across order lines and refunds |
|---|
| SaaS Subscriptions & Churn | CSV files or Excel workbook | 5 tables to relate | Current MRR, retention, billing, and payment outcomes | Defining active status from one subscription period per account |
|---|
| Marketing Campaigns & Conversions | CSV files or Excel workbook | 4 tables to relate | Spend, conversion rate, CAC, ROAS, and channel mix | Joining daily spend to individual leads without fanout |
|---|
| Inventory & Supply Chain | CSV files or Excel workbook | 7 tables to relate | Stock position, receipts, supplier lead time, and adjustments | Explaining balances from opening stock and signed movements |
|---|
| Workforce & Employee Attrition | CSV files or Excel workbook | 5 tables to relate | Headcount, recorded exits, tenure, role mix, and review coverage | Keeping employee, employment-period, and review-event counts separate |
|---|
| AI Agent Operations | CSV files or Excel workbook | 8 tables to relate | Cost per session, completion rate, tool errors, and evaluation pass rate | Combining call-level cost with session-level evaluations without double counting |
|---|
| Bike Sharing Demand | CSV files or Excel workbook | Two grains of one table; use one at a time | Hourly demand, seasonality, weather, and rider type | Comparing hourly and daily grains correctly |
|---|
| US Flight Delays | CSV files or Excel workbook | 4 tables to relate | On-time rate, cancellations, delay causes, and route performance | Averaging delays when cancelled and diverted flights have none |
|---|