Case Study
SELA KSA Retail POS Analytics
Five POS Systems Consolidated Into One Microsoft Fabric Lakehouse
Overview
Executive Summary
Challenge
Multiple retail outlets on diverse, disconnected POS platforms with no single version of the truth
Solution
A Microsoft Fabric Lakehouse consolidating five POS systems with Medallion Architecture and five Power BI dashboards
Outcome
A single source of truth for retail performance, with executive and store-level visibility delivered in weeks
The Problem
The Challenge
SELA KSA operates multiple retail outlets across diverse, disconnected Point-of-Sale platforms. This data fragmentation made consolidated sales reporting, executive KPI visibility, and store-level performance management difficult — each POS system reported differently, and there was no single version of the truth for the business.
| Pain Point | Impact |
|---|---|
| Five disconnected POS platforms | No single version of the truth |
| Each POS reporting differently | Difficult consolidated reporting |
| No company-level KPI view | Limited executive visibility |
| Fragmented store performance data | Hard store-level management |
| No governed data foundation | Slow, manual analysis |
Our Approach
The Solution
Qrestik consolidated transactional data from five cloud-based POS systems into a Microsoft Fabric Lakehouse, applying Medallion Architecture to standardise and refine data through automated, scheduled ingestion pipelines. Integration methodology was matched to each source system's capability — API-based integration where available, flat-file export as a structured fallback. Five Power BI dashboards were delivered, all optimised for responsive display across desktop, tablet, and mobile.
Consolidate five cloud POS systems into Microsoft Fabric Lakehouse
Medallion Architecture standardisation and refinement
Automated, scheduled ingestion (API + flat-file fallback)
Five Power BI dashboards (Executive, Payment, Store, Product, Trend)
Responsive layouts for desktop, tablet, and mobile
Transformation
Before vs. After
Before
- Five disconnected POS systems
- Each system reporting differently
- No single version of the truth
- Limited executive KPI visibility
- Fragmented store-level data
- Manual, slow reporting
After
- Unified Microsoft Fabric Lakehouse
- Standardised, governed data
- Single source of truth across stores
- Executive-level KPI dashboards
- Granular store-level operational detail
- Foundation for predictive analytics
Outcomes
Results & Impact
Executive Overview
Company-level KPIs consolidated into a single executive dashboard.
Payment Analysis
Payment method breakdown and trends across all integrated stores.
Store Performance
Per-store revenue, traffic, and conversion visibility for store managers.
Product Performance
SKU-level sales and margin analysis across the retail estate.
Sales Trend Analysis
Time-series patterns and seasonal analysis for planning.
AI-Ready Foundation
A governed data foundation for predictive analytics and demand forecasting in later phases.
Performance
Operational Improvement Metrics
Percentage improvements across key operational metrics
“For the first time, our leadership team can see performance across every store in one place. Qrestik built something genuinely useful — not just technically impressive — and delivered it in weeks, not months. — Chief Operating Officer, SELA, KSA”
Impact
One Source of Truth Across Every Store
By consolidating five cloud POS systems into a single Microsoft Fabric Lakehouse, SELA KSA gained a single source of truth for retail performance — executive KPI visibility at the company level and granular store-level operational detail for managers. Built on Medallion Architecture with responsive Power BI dashboards, the platform established the governed foundation for predictive analytics, demand forecasting, and AI-driven insight in subsequent phases.
Deliverables
Key Capabilities Delivered
- Microsoft Fabric Lakehouse (OneLake, Data Factory, Dataflows Gen2)
- Five-system POS data consolidation (API and flat-file integration)
- Medallion Architecture (Bronze / Silver / Gold)
- Five Power BI dashboards with drill-down analytics
- Responsive layouts for desktop, tablet, and mobile
- Governed foundation for predictive analytics and forecasting
Client
About SELA, Kingdom of Saudi Arabia
SELA operates multiple retail outlets across the Kingdom of Saudi Arabia. SELA invests in data and analytics capabilities to gain consolidated visibility across its retail estate and support data-driven decision-making.
Partner
About Qrestik Technologies
Qrestik Technologies delivers Microsoft Fabric and Databricks Lakehouse platforms, data governance, and Power BI analytics. Qrestik helps retail and CPG organisations consolidate fragmented POS data into governed, AI-ready business intelligence.