OoredooMaldives · Telecommunications

Full DWH Revamp and Migration

Telecom Data Modeling, Quality & Real-Time BI

Business problem
An obsolete DWH unable to support KPIs
What BBI changed
Built a model covering subscription, traffic, service, prepaid transactions, revenue and POS data
Strongest supported result
Near Real-Time DataStated outcome

Results

  • Near Real-Time DataStated outcome
  • Standardized KPIsStated outcome
  • Modern DWH ModelStated outcome
  • Future EDW RoadmapStated outcome

01Context

Ooredoo Maldives is a leading mobile operator providing GSM and value-added services, and was the first in the Maldives to launch 3.5G HSDPA. Ooredoo aimed to migrate and revamp its DWH into a modern, best-practice telecom model supporting near real-time data and better analytics.

02Challenge

Before

  1. 01An obsolete DWH unable to support KPIs
  2. 02poor data quality with no metadata or glossary
  3. 03DataStage-to-Informatica and Cognos-to-BO migrations
  4. 04parallel BSCS and IN upgrades

After, as stated

  • Near Real-Time Data
  • Standardized KPIs
  • Modern DWH Model
  • Future EDW Roadmap

03What BBI delivered

Telecom Data Modeling, Quality & Real-Time BI

  1. Telecom DWH Model

    Built a model covering subscription, traffic, service, prepaid transactions, revenue and POS data

  2. ETL & BI Migration

    Migrated ETL from DataStage to Informatica and BI from Cognos to Business Objects

  3. Data Quality Profiling

    Ran full data quality profiling to address poor quality and missing metadata

  4. KPI Standardization

    Standardized company KPIs across business domains for a single version of truth

  5. Corporate Dashboards

    Implemented performance dashboards with near real-time transaction and network data

  6. EDW Roadmap

    Delivered a scalable roadmap for future EDW strategy and empowered the DWH team

04Outcomes

Stated outcome

Listed as an outcome in the case study, without a figure.

  • Near Real-Time Data
  • Standardized KPIs
  • Modern DWH Model
  • Future EDW Roadmap

05Technology & capabilities

Source notes
  • BBI Company Profile 2025 — case studies, slide 12. The deck classifies this story under “Telecommunications” and lists its location as “Maldives”.
  • Outcome labels are quoted from the case study. Their grouping (impact, scope, delivery, stated) is editorial.
  • The animation at the top of the page is an illustration, not a diagram of the client's systems.

→Contact BBI

Talk to BBI about your data and AI goals.

Contact form on bbi.ai
Head office
Office no 8 C6, I-Rise Tower, Barsha Heights, P.O. Box 119160, Dubai, UAE