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

docker airflow automation big-data etl grafana s3 data-visualization metabase data-engineering data-pipeline trino data-lineage promotheus delta-lake lakehouse duckdb sql-analytics medallion-architecture batch-analytics

• Updated Nov 5, 2025
• Python

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

docker open-source aws big-data etl s3 data-visualization data-engineering minio apache-flink apache-kafka real-time-data data-pipeline trino streaming-analytics apache-superset apache-iceberg lakehouse sql-analytics

• Updated Jan 18, 2025
• Python

Open-source warehouse-native product analytics for DuckDB, Snowflake, ClickHouse, Databricks, and Postgres. Funnels, retention, paths — directly on your warehouse, no ingestion pipeline, no per-event fees.

docker open-source analytics clickhouse web-analytics postgresql snowflake data-visualization self-hosted business-intelligence sql-editor databricks product-analytics cohort-analysis funnel-analysis retention-analysis duckdb sql-analytics warehouse-native warehouse-analytics

• Updated Apr 30, 2026
• TypeScript

The Fifa-Dataset-SQL-Data-Analysis project uses SQL to explore FIFA player data, analyzing performance and attributes to extract meaningful insights on player statistics, trends, and patterns in football.

data statistics csv sql database project sql-query dataset football-data data-analysis football sqlquery fifa dataanalysis dataanalytics football-analytics sqlqueries sql-analysis sql-analytics

• Updated Jun 9, 2024

Pizza Sales Report project, where we leverage SQL for data analysis and Power BI for creating interactive visualizations. This project provides in-depth insights into pizza sales data, including daily and monthly trends, sales by pizza category and size, and identifying top-selling pizzas based on revenue, quantity, and total orders.

visualization sql data-visualization data-analysis powerbi sql-analytics

• Updated Nov 4, 2023

This repository helps you gain valuable insights from your sales data using SQL and RFM analysis and segment customers based on their RFM score and the churn rate.

visualization sales sql analytics tableau rfm-analysis sql-analytics

• Updated Jun 14, 2023
• SQL

SQL-based ecommerce performance analysis using Google BigQuery and the Google Analytics sample dataset, delivering insights on traffic, user behavior, revenue by channel, purchasing patterns, and ecommerce funnel conversion.

bigquery web-analytics traffic-analysis data-analysis funnel-analysis user-behavior sql-analytics ecommerce-analytics

• Updated Apr 2, 2026

End-to-End IPL Data Analytics Project using Python, SQL, and Power BI to analyze team performance, player statistics, and venue impact.

mysql python data-visualization statistical-analysis data-analysis feature-engineering powerbi large-dataset sports-analytics sql-analytics ipl-analysis powerbi-dashboard python-eda

• Updated Mar 5, 2026
• Jupyter Notebook

Run SQL directly against Parquet, CSV, and JSON files in Backblaze B2 with DuckDB's httpfs extension — query-in-place with no ETL or warehouse, and materialize results back to B2 as Parquet. Next.js + FastAPI sample app.

nextjs data-lake parquet object-storage httpfs backblaze-b2 cloudstorage fastapi s3-compatible duckdb sql-analytics b2-labs query-in-place

• Updated Nov 1, 2026
• TypeScript

postgresql query-builder cloud-database supabase database-integration sql-analytics

• Updated May 24, 2026
• Python

visualization aws apache-spark aws-s3 end-to-end data-engineering databricks ipl-data-analysis sql-analytics

• Updated May 5, 2024
• Jupyter Notebook

An automated end-to-end data science pipeline built on Ubuntu Linux. Features CLI data exploration, Python-based ETL (Pandas), MySQL database modeling, and business analytics via SQL and Makefiles.

mysql python linux bash data-science automation ubuntu pandas data-engineering portfolio-project etl-pipeline sql-analytics

• Updated Jul 23, 2026
• Jupyter Notebook

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.

postgres etl data-engineering dax powerbi data-modeling python-pandas star-schema bussiness-intelligence kpi-dashboard sap-erp sql-analytics

• Updated Aug 20, 2026
• Python

A collection of real-world SQL projects focused on business insights, data analysis, and advanced querying using MySQL.

mysql data-science sql data-engineering business-intelligence data-analysis data-wrangling relational-databases query-optimization data-cleaning data-quality real-world-project advanced-sql etl-process window-functions data-analytics-project sql-analytics product-analysis

• Updated May 23, 2026

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.

github python etl postgresql data-engineering business-intelligence data-analytics data-modeling data-pipeline data-quality data-warehousing database-design synthetic-data github-analytics advanced-sql sql-analytics medallion-architecture

• Updated Sep 28, 2026
• Python

Large-scale PaySim fraud analytics using SQL/DuckDB, risk segmentation, BI-ready reporting, dashboards, and model-supported review prioritization.

python machine-learning sql scikit-learn exploratory-data-analysis power-bi pandas business-intelligence xgboost data-analysis feature-engineering financial-data fraud-detection imbalanced-learning paysim duckdb data-storytelling fraud-analytics sql-analytics

• Updated Aug 21, 2026
• Jupyter Notebook

DW://master is an interactive educational platform for mastering data warehousing concepts — from core architecture to advanced slowly changing dimensions (SCD), schema design, IBM Watsonx.data lakehouse technology, and SQL aggregation analytics. Features an AI tutor powered by Claude Sonnet 4 that answers questions about each topic in real-time📊.

data-engineering data-lake educational cube scd slowly-changing-dimensions data-warehousing data-mart group-by star-schema snowflake-schema data-architecture lakehouse sql-analytics watsonx ai-tutor grouping-sets

• Updated Mar 6, 2026
• JavaScript

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

mysql python dashboard data-visualization data-engineering database-design streamlit sql-analytics

• Updated Jul 3, 2026
• Python

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

mysql ecommerce eda powerbi rfm-analysis sql-analytics data-analyst-portfolio olist-dataset

• Updated Feb 28, 2026
• Python

A normalized PostgreSQL database for a travel agency: data-integrity constraints, analytical views with window functions, data-quality checks, and CI-tested.

sql ci relational-databases data-modeling data-quality normalization database-design postresql travel-agency github-actions window-functions sql-analytics

• Updated Jul 9, 2026
• PLpgSQL