python-etl

Datos y código para estimar y visualizar resultados electorales Argentina 2025 (legislativas). Data + notebooks + estilos web; enfoque en Buenos Aires y distritos.

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

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.

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.

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.

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.

一款易用，久经沙场的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).

OSS job aggregator for developers locked out of Upwork, Mercor, Deel, and Contra. Next.js + Prisma + Python ETL + MCP server. Beginner-friendly.

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

A Power BI Visualisation infused Python ETL based interactiive ESG Dashboard Web Applicaation.

An end-to-end Enterprise BI solution analyzing 32M+ Instacart transactions. Engineered a Python ETL pipeline, modeled data in SQL Server (OBT), managed via Jira Agile, and delivered strategic Power BI dashboards

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

An enterprise-grade ETL and BI architecture analyzing 3M+ clinical records. Built with Python, MySQL, and Power BI to decode DRG flat-rate billing and visualize 30-day hospital readmission risks.

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

工业 IoT 数据集成与拓扑校验系统。 针对多源异构数据（相同电表有3套名称：数采/业务/图纸）的兼容性痛点，设计并交付了一套基于 RESTful API 的全流程数据治理方案。通过能量守恒算法，实现了 2000+ 电表耗电量的自动化对齐与标准化集成验证