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.

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.

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

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

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

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

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

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

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.

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. 📊🐳🧪

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

Enterprise-style SaaS churn intelligence project using Python, BigQuery, SQL, XGBoost, and Power BI for churn risk migration, retention prioritization, and customer 360 analytics.