Enterprise AI Administration
Data Grain & Transformations
Datasets by grain, business keys, refresh, transformation and aggregation rules.
Datasets by refresh cadence
How often each grain is rebuilt
Datasets
12
Passing checks
11
Warnings
1
Owners
9
Grain & transformation register
| Dataset | Grain | Business keys | Refresh | Transformation | Aggregation | Consumers | Quality | |
|---|---|---|---|---|---|---|---|---|
| Account monthly | Account-month | account_id, month | Monthly | Billing account consolidation | Sum billed revenue | Revenue KPIs | PASSED | View details → |
| Decision actions | Action-level | action_id | On change | Action status tracking | Count by status; overdue | Stage 10 / 12; Alerts & Actions | PASSED | View details → |
| Offer campaign weekly | Offer-campaign-week | campaign_id, week | Weekly | Campaign response attribution | Count targeted, accepted, saved | Save rate; retention scenarios | WARNING | View details → |
| Complaint cases | Complaint-case | complaint_case_id | Daily | Ticket categorisation | Count cases | Complaint rate; NPS Driver Model | PASSED | View details → |
| Journey decisions | Journey-decision | decision_case_id | On change | Decision case lifecycle tracking | Count by status | Executive Decisions; Command Center | PASSED | View details → |
| Fraud cases | Fraud-case | fraud_case_id | Daily | Case enrichment with loss estimates | Sum loss; count cases | Fraud loss KPIs | PASSED | View details → |
| Product monthly | Product-month | offer_code, month | Monthly | Revenue allocation to offers | Sum revenue; count active | Revenue mix; leakage rate | PASSED | View details → |
| Regional daily | Region-day | region_code, date | Daily | Roll-up of site and subscriber data | Weighted averages | Regional dashboards | PASSED | View details → |
| Network site hourly | Site-hour | site_id, hour | Hourly | OSS counter normalisation | Average utilisation; sum outage minutes | Availability KPIs; Network Incident Risk Model | PASSED | View details → |
| Subscriber usage daily | Subscriber-day | subscriber_id, date | Daily | CDR rating and deduplication | Sum usage, count sessions | Churn Propensity Model; Variables | PASSED | View details → |
| Subscriber monthly profile | Subscriber-month | subscriber_id, month | Monthly | Roll-up of daily usage, recharge and billing | Sum revenue; average usage | ARPU, churn KPIs; ARPU Uplift Model | PASSED | View details → |
| Value periods | Value-period | value_id, period | Monthly | Expected vs actual measurement | Sum expected; sum actual | Value Realization | PASSED | View details → |