PROJECT DESCRIPTION
- Designed a Medallion Architecture (Bronze/Silver/Gold) on Microsoft Fabric to industrialize ServiceNow data processing: ingestion into Lakehouse/OneLake, PySpark/Python transformations, and quality controls across ~40 business variables.
- Designed a star schema and developed data pipelines as well as Power BI/DAX dashboards, including SLA calculations, anomaly detection, and automated alerts via Microsoft Teams.
DATA FLOW
A view of the system.
- 01ServiceNow
- 02Bronze · ingestion
- 03Silver · transformations
- 04Gold · star schema
- 05Power BI / Teams