BBI Success Stories

Saudi Energy Efficiency CenterSaudi Arabia · Government & Public Sector

Centralized DWH & Analytical Layer

Data Catalog, SQL Server DWH & Power BI

Business problem
Fragmented Excel-based data management
What BBI changed
Built a full catalog on Informatica EDC to organize and improve data assets
Strongest supported result
Excel to DWHStated outcome
  • Excel to DWHStated outcome
  • Cataloged DataStated outcome
  • Real-Time DashboardsStated outcome
  • Scalable FoundationStated outcome

01Context

The Saudi Energy Efficiency Center (SEEC) develops and promotes initiatives to improve energy efficiency across the Kingdom and monitors energy consumption. SEEC needed to move from decentralized Excel-based data to an integrated DWH with better quality and analytics.

02Challenge

Before

  1. 01Fragmented Excel-based data management
  2. 02no central DWH for energy data
  3. 03no data catalog
  4. 04no real-time dashboards for strategy
  5. 05a need for scalable infrastructure

After, as stated

  • Excel to DWH
  • Cataloged Data
  • Real-Time Dashboards
  • Scalable Foundation

03What BBI delivered

Data Catalog, SQL Server DWH & Power BI

  1. Enterprise Data Catalog

    Built a full catalog on Informatica EDC to organize and improve data assets

  2. SQL Server DWH

    Consolidated multiple sources into a central DWH, replacing Excel files

  3. Power BI Analytics

    Delivered dashboards and reports for energy efficiency decision-making

  4. Scalable Architecture

    Enabled seamless integration of new data sources as needs evolve

  5. Governance & Quality

    Embedded governance and quality practices for a reliable environment

  6. Efficient Reporting

    Streamlined reporting to support better-informed energy initiatives

04Outcomes

Stated outcome

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

  • Excel to DWH
  • Cataloged Data
  • Real-Time Dashboards
  • Scalable Foundation

05Technology & capabilities

Technology named in the case study

Capabilities

Numbers show how many of the 50 stories share each item.

06Related stories

Source notes
  • BBI Company Profile 2025 — case studies, slide 51. The deck classifies this story under “Government & Public Sector” and lists its location as “Saudi Arabia”.
  • 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