sql-analytics

🦆 Batch data pipeline with Airflow, DuckDB, Delta Lake, Trino, MinIO, and Metabase. Full observability and data quality.

📡 Real-time data pipeline with Kafka, Flink, Iceberg, Trino, MinIO, and Superset. Ideal for learning data systems.

An End-to-End GitHub Analytics Database built with Python and PostgreSQL, featuring Synthetic Data Generation, Medallion Architecture (Bronze → Silver → Gold), Automated ETL Pipelines, Advanced SQL Analytics, Data Quality Testing, and Business-ready Reporting Views.

SAP ERP-modeled analytics platform (PostgreSQL) for aviation manufacturing. Features a Python ETL pipeline, high-performance SQL indexing, automated inventory alerting, and an executive Power BI dashboard built on a Star Schema with advanced DAX KPIs.

AI-powered end-to-end e-commerce analytics platform integrating MySQL, advanced SQL modeling, executive BI dashboards (Power BI), and generative AI reporting to deliver insights on revenue growth, retention, operational efficiency, and customer lifetime value

Academic Information System (SIAKAD) relational database optimized in 3NF and integrated with a real-time executive analytics dashboard using Python and MySQL.

Synthetic quick-commerce data pipeline (Databricks, PySpark, Delta) with SQL analysis and a Databricks Genie AI-agent evaluation.

PostgreSQL analytics warehouse integrating de novo viral metagenome assembly, CheckV quality control, and geNomad taxonomic/functional annotations to profile condition-associated bacteriophage populations in an ASD vs. TD fecal microbiota transplant gnotobiotic mouse model (Sharon et al. 2019).

Automated statistical auditing suite for A/B testing and metric validation. Implements adaptive hypothesis testing (Shapiro-Wilk, T-test, Mann-Whitney U) with automated P-value and Lift calculation for data-driven decisions.

Симулятор рыночного мониторинга с автоматическим сбором данных и SQL-аналитикой (MAX, MIN, AVG). 📈🗄

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

A robust, scalable web scraping data pipeline that extracts product data from real-world websites and transforms it into a structured, analytics-ready database.

An end-to-end Data Analytics project that demonstrates data modeling, ETL, SQL analytics, Python reporting, and BI dashboarding using a large sales dataset.

End-to-end e-commerce data analytics project using MySQL to analyze sales, customers, products, sellers, payments, reviews, and delivery performance using advanced SQL.

An example for analyzing time-event data

Pipeline de dados em Python e SQL aplicando conceitos de ETL e ELT, com validação de dados, análises analíticas e dashboard visual.

Production-style credit risk platform — default prediction, customer segmentation, SQL analytics & GenAI/RAG architecture proposal. FastAPI · React · scikit-learn · SQLite.

A modular Python ETL pipeline that fetches real‑time weather data, transforms it, stores it in SQLite, and runs SQL analytics using window functions and idempotent loading. Includes a clean CLI menu and production‑style project structure.

End-to-end E-commerce SQL Data Analysis Project: Data cleaning, MySQL loading, advanced queries, and actionable business insights.