Fiaz AnjumData · BI · Transformation
Let's Connect

Projects & Case Studies

Enterprise data & analytics case studies

Five organizations, five kinds of challenge. Each case study covers the business problem, a conceptual architecture diagram, my responsibilities, implementation and documented outcomes. Diagrams are conceptual and demo panels use synthetic data; no confidential employer information is disclosed.

  • 01Manufacturing (FMCG)

    Gourmet Pakistan

    A Medallion-Architecture Enterprise Data Warehouse on ClickHouse

    BI & Data Engineering Analyst · Jan 2026 – Present

    One governed analytics platform across three manufacturing units: CDC ingestion from ERP and operational systems, dbt-modeled gold datasets, and Superset decision dashboards.

    • ClickHouse EDW
    • Airbyte CDC
    • dbt
    • Apache Superset
    • 3 manufacturing units
    Read case study
  • 02Government & Official Statistics

    HBS — Statistics Centre Abu Dhabi

    Census Abu Dhabi Analytics: Enterprise Reporting for Government

    Senior Consultant Data Analyst · Mar 2024 – Dec 2025

    Led the end-to-end Census Abu Dhabi Analytics Project: 50+ dashboards, 25+ automated reports, secure portal access for 800+ users and 150+ staff trained.

    • 50+ dashboards
    • 70%+ effort reduction
    • 10M+ records
    • 800+ users
    Read case study
  • 03Banking

    Bank of Punjab

    Secure Performance Reporting for 900+ Bank Branches

    Data Visualization Lead · Oct 2022 – Feb 2024

    Led BI for Consumer Banking and Cards: 30+ dashboards, a SQL Server data warehouse fed from Oracle, and Row-Level Security on Power BI Report Server.

    • 30+ dashboards
    • 900+ branches
    • SQL Server DW
    • RLS
    Read case study
  • 04Logistics & Fintech

    PostEx

    Logistics & Cash-on-Delivery Analytics at Transaction Scale

    Data Analyst & BI Developer · Jan 2022 – Sep 2022

    15+ Power BI dashboards for parcel tracking, COD reconciliation and vendor settlements, on a unified layer over Redshift, SQL Server and CRM data.

    • 15+ dashboards
    • AWS Redshift
    • COD reconciliation
    • 99.9% accuracy
    Read case study
  • 05ERP & Enterprise Software

    Teksof

    ERP-Driven Procurement & Cash-Flow Analytics on Azure

    Microsoft Power BI Developer · Feb 2020 – Nov 2021

    ETL from SAP ERP, SAP HANA and MYCOM into an Azure data mart, with Power BI analytics for spend, supplier performance and cash flow.

    • SAP ERP
    • SAP HANA
    • Azure data mart
    • Spend analytics
    Read case study

Business & Project Collaboration

Have a Data, Analytics or Digital Transformation Project?

Looking to modernize your data infrastructure, build an enterprise data warehouse, automate business reporting, or implement intelligent business analytics?

Let's discuss your requirements and explore how I can help turn your business challenges into practical technology solutions.

Discuss Your Project Send a Project Inquiry Connect on LinkedIn

Engagements I can discuss

  • Enterprise Data Engineering Projects
  • Data Warehouse & Lakehouse Implementation
  • Power BI & Superset Development
  • Business Intelligence Consulting
  • ERP Data Integration
  • Reporting Automation
  • Digital Transformation Initiatives
  • Analytics Architecture & Strategy
  • Technical Consulting & Collaboration

Inquiries are handled personally and confidentially. I take on engagements as an independent professional, not as a registered consulting firm.