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

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

A project utilizing generative AI for to automate ETL processes.

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

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.

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).

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

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

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.

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.

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