🏛️ What We Do
We deliver the full analytics value chain — from raw ERP transactions to executive decisions.
1. The Analytics Maturity Ladder
graph LR
A[Descriptive<br/>What happened?] --> B[Diagnostic<br/>Why did it happen?]
B --> C[Predictive<br/>What will happen?]
C --> D[Prescriptive<br/>What should we do?]
2. Service Catalog
| # |
Service |
Cadence |
Deliverable |
Reference |
| 1 |
Report & Briefing |
🔁 Daily |
Management briefing from refreshed dashboards |
Daily Routine |
| 2 |
KRs Monitoring Report |
🔁 Weekly |
KR vs SLA synchronization board |
Epic 4 |
| 3 |
Ad-hoc Analytics |
On demand |
Deep-dive analyses on etl_test |
— |
| 4 |
Master Report Catalog |
Quarterly |
Index of all standardized reports |
Daily Routine |
| 5 |
Descriptive & diagnostic reporting |
Continuous |
Sales / stock / margin / cross-BU reports |
— |
| 6 |
Predictive & prescriptive reporting |
Roadmap |
Forecasts, reorder & FEFO alerts |
— |
| 7 |
Data Warehouse & ETL |
🔁 Daily |
dim_* / fact_* / agg_* tables |
ETL Guide |
| 8 |
Executive dashboards |
Continuous |
Looker Studio / Power BI boards |
— |
3. How Data Flows
graph LR
E1[Extract from das-db] --> E2[Transform & Map]
E2 --> E3[Load to Analytics DB]
E2 --> E4[Apply Business Rules]
E4 --> E5[Unified SKU]
E4 --> E6[Base UOM: PCS]
E4 --> E7[Standard Currency: MMK]
E4 --> E8[Cross-BU Mapping]
4. Operational vs Analytics — Why We Build the Warehouse
| Feature |
Operational ERP |
Analytics Warehouse |
| Unified SKUs |
❌ BU-specific |
✅ Master + BU mapping |
| Cross-BU AP/AR |
❌ Separate per BU |
✅ Consolidated view |
| Batch Tracking |
⚠️ Scattered |
✅ Centralized FEFO |
| Query Performance |
⚠️ Complex joins |
✅ Star-schema ready |
| BI Tool Friendly |
❌ Too complex |
✅ Clean dimensions |