Skip to content
View khaledzidan203-stack's full-sized avatar

Block or report khaledzidan203-stack

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
khaledzidan203-stack/README.md

Khaled Zidan

Healthcare, Business Intelligence & Analytics Engineering

Power BI · SQL · Python · DAX · Power Query · Analytics Engineering

I build end-to-end analytics solutions that turn complex operational and public datasets into governed KPIs, validated semantic models, interactive dashboards, and decision-ready insights.

My portfolio is centered on healthcare, pharmacy, retail, commercial performance, customer analytics, reconciliation, data quality, and operational decision support—with an emphasis on analytical correctness, reproducibility, and business context.

LinkedIn · GitHub Portfolio

Featured Projects

Project What it demonstrates Core stack
Healthcare Data Governance & Quality Control Center End-to-end governance and quality-control analytics on the CMS 2010 BSA Carrier Line Items PUF, with RAW/STAGING/ANALYTICS architecture, governed KPIs, source-conflict preservation, SQL/Python reconciliation, a 10-table semantic model, and a seven-page PBIP/PBIR report SQL Server · Python · Power BI · DAX · PBIP/PBIR · TMDL · PowerShell
Transparency in Coverage PUF Analytics End-to-end analysis of CMS insurer/plan transparency data with governed KPI logic, availability modeling, claims denials, appeals, data-quality controls, PBIP/PBIR delivery, and runtime DAX reconciliation Power BI · DAX · Python · Power Query · PBIP/PBIR · TMDL
Saudi Healthcare Analytics Official Saudi MOH healthcare statistics transformed into canonical analytical data, SQL validation, governed KPIs, and a source-controlled Power BI semantic model SQL Server · Power BI · DAX · Python
Hospital360 Production-style hospital analytics using realistic synthetic data across patient activity, claims, finance, workforce, operations, capacity, and technology reliability PostgreSQL · SQL · Python · Power BI
Online Retail Growth & Customer Intelligence Transaction-to-insight analytics covering revenue, repeat purchasing, customer value, RFM, cohorts, retention, cancellations, and management reporting SQL Server · Python · Power BI · Excel
Pharmacy Category Management Category performance, assortment, margin, inventory, supplier service, pricing, promotion, and branch-level decision support SQL Server · Python · Power BI
Regional Sales Performance Analytics Budget gaps, LFL performance, AST, customer traffic, recovery analysis, lifecycle effects, and offline Windows analytical delivery Power BI · JavaScript · Tauri · SQL
Transaction Reconciliation & Anomaly Detection Explainable matching, reconciliation, exception handling, anomaly detection, and financial exposure analysis Python · SQL · Power BI

What I Work On

  • Healthcare Analytics — claims, utilization, capacity, workforce, hospital operations, payer analytics, pharmacy operations, and performance
  • Business Intelligence — semantic models, governed DAX, Power BI, KPI frameworks, executive dashboards, and analytical storytelling
  • Analytics Engineering — canonical datasets, dimensional modeling, grain control, validation, reconciliation, and reproducibility
  • Pharmacy & Retail Analytics — sales, category management, inventory, pricing, suppliers, customer behavior, and branch performance
  • Commercial Analytics — revenue, budget variance, customer contribution, performance diagnostics, and management decision support
  • Data Quality & Governance — duplicate/orphan detection, availability semantics, KPI reconciliation, exception handling, and analytical controls

Technical Toolkit

BI & Semantic Modeling

Power BI · DAX · Power Query · PBIP · PBIR · TMDL · Excel

Data & Analytics

SQL Server · PostgreSQL · Python · pandas · NumPy · openpyxl

Analytics Engineering

Dimensional Modeling · Canonical Data Models · KPI Contracts · Data Quality · Reconciliation · Validation Workflows

Development & Delivery

Git · GitHub · HTML · CSS · JavaScript · Tauri

How I Build Analytics

Business Problem → Analytical Questions → Grain & Keys → Data Quality → KPI Contracts → Data Model → Validation → Visualization → Insight → Action

My projects consistently emphasize:

  • validating grain, keys, and relationships before aggregation
  • separating zero, missing, suppressed, and not-applicable values
  • using governed and reusable KPI definitions
  • reconciling important metrics independently
  • preserving source anomalies instead of hiding them
  • separating descriptive evidence from unsupported causal claims
  • designing dashboards around business decisions, not decoration
  • keeping analytics reproducible and reviewable through source control and validation

Portfolio Areas

Healthcare & Payer Analytics · Healthcare Data Governance & Quality · Hospital Operations · Pharmacy & Retail Analytics · Sales & Commercial Performance · Customer Intelligence · Category Management · Inventory Analytics · Transaction Reconciliation · Data Quality & Analytics Governance

More Projects

Current Focus

I am focused on opportunities in Data Analytics, Business Intelligence, Healthcare Analytics, Commercial Analytics, and Performance Analytics, especially where Power BI, SQL, Python, analytical modeling, and business-domain understanding are used together.

Recommended starting points for recruiters and reviewers

  1. Healthcare Data Governance & Quality Control Center
  2. Transparency in Coverage PUF Analytics
  3. Saudi Healthcare Analytics
  4. Hospital360
  5. Online Retail Growth & Customer Intelligence

Connect

LinkedIn — Khaled Zidan

Pinned Loading

  1. online-retail-growth-customer-intelligence online-retail-growth-customer-intelligence Public

    End-to-end retail analytics portfolio using SQL Server, Python, Power BI, DAX, RFM, cohort analysis and management Excel outputs.

    Python 1

  2. pharmacy-category-management pharmacy-category-management Public

    Production-style pharmacy category management analytics portfolio using SQL Server, Python, Power BI/DAX, inventory, supplier, assortment and commercial analytics.

    TSQL

  3. Hospital360 Hospital360 Public

    Production-style hospital analytics platform designed around real-world healthcare performance use cases, covering patient activity, finance, workforce, operations, and technology using PostgreSQL,…

    Jupyter Notebook

  4. regional-sales-analytics-portfolio regional-sales-analytics-portfolio Public

    Regional sales performance analytics portfolio covering budget gaps, LFL analysis, intervention impact, channel contribution, AST, customer count, and data quality.

    HTML

  5. saudi-healthcare-analytics saudi-healthcare-analytics Public

    End-to-end Saudi healthcare analytics using official MOH statistics, SQL Server, Power BI, DAX, PBIP/PBIR and governed KPI validation.

    Python

  6. transaction-reconciliation-anomaly-detection-analytics transaction-reconciliation-anomaly-detection-analytics Public

    Transaction reconciliation, exception analytics and anomaly detection using Python, SQL, fuzzy matching, automated tests and Power BI-ready outputs.

    Python