python-etl

Scalable Hybrid ETL (Python/SQL) and Star Schema DWH for industrial IoT. Features an idempotent pipeline, state-cursor validation, and Gold-layer SQL Views optimized for Power BI integration. Delivers real-time-ready KPIs for Manufacturing Utilization and Reliability, bridging the gap between raw PLC event logs and executive dashboards.

A high-performance air quality analytics platform processing municipal sensor telemetry. Implements a robust medallion data warehouse (PostgreSQL/dbt) and a low-latency NoSQL serving cache (MongoDB), fully orchestrated by Dagster with strict data quality validation gates and checksum verification.

SQL-based Financial KPI dashboard with optimized Power BI queries.

Suite de Business Intelligence en Power BI (Fabric PBIP) para una bodega ficticia: control de gestión, inteligencia comercial y supply chain -- 3 modelos semánticos, 188 medidas DAX, star schema, ETL en Python.

Production-ready Used Car Market Analytics platform analyzing 80,000+ listings ($100M+ inventory) using Python, custom DAX measures, and interactive Power BI UI.

A project utilizing generative AI for to automate ETL processes.

一款易用，久经沙场的Python ETL数据同步工具。

A modular Python tool to automate syncing Bing Webmaster performance data into BigQuery. Built to handle multiple sites with a focus on clean code, security, and easy deployment to Google Cloud.

End-to-end retail ETL pipeline — extracts 50K+ transactions from Supabase, validates and transforms through a custom Python pipeline, and produces a clean dataset for EDA.

Tableau storytelling dashboard for e-commerce order analysis (Python + Excel).

End-to-end SQL data warehouse project with star schema, ETL pipeline, advanced CTE queries, and analytics.

End-to-end Order-to-Cash analytics pipeline using Azure, Python ETL, SQL warehouse and Power BI dashboard

End-to-end personal finance analytics pipeline: Python ETL, rule-based categorization, and Power BI model built using synthetic data.

UK Workforce Planning & Labour Market Intelligence: ONS ASHE earnings analysis, regional demand forecasting, UK skill shortage metrics

Autonomous Financial AI Agent for automated P&L analysis, Holt-Winters revenue forecasting, and executive CFO advisory powered by Google Gemini API.

Self-hosted AdGuard Home analytics stack that turns DNS query logs into PostgreSQL-backed Metabase dashboards for homelab monitoring.