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.

Automate pre-period selection for Difference-in-Differences (DiD) analysis in SQL.

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.

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.

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

An example for analyzing time-event data

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

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

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

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.

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

Docker MySQL üzerinde çalışan, LAG() Window fonksiyonu ile ham verilerden anlık SaaS MRR büyüme trendlerini hesaplayan ve Pytest ile şema doğruluğu test edilmiş kurumsal backend analitik motoru. 📊🐳🧪

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.