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.

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

A project utilizing generative AI for to automate ETL processes.

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.

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

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.

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

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.

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.

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.

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

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.

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 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 SQL data warehouse project with star schema, ETL pipeline, advanced CTE queries, and analytics.

Plataforma de observabilidad SRE para el análisis de disponibilidad de tiendas. Incluye pipeline ETL (Python), Backend (Spring Boot 3), Frontend (Angular 17+) y un agente de IA usando LangChain4j + Gemini.

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