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.

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.

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.

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.

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.

Automate pre-period selection for Difference-in-Differences (DiD) analysis in 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.

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

A modular Java Employee & Payroll system with performance-based bonus calculations, tax withholdings, dual CSV file exports, and SQL analytics.

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

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.

SQL-based business analytics project using Google BigQuery on the AdventureWorks2019 dataset, delivering insights across Sales, Production, and Purchasing, including YoY growth, territory ranking, customer retention, inventory trends, and stock efficiency.

BSc Statistics graduate with strong interest in data analysis, finance, and business reporting. Skilled in SQL, Excel, and Python for data extraction, analysis, and insights. Interested in junior analyst roles in banking, audit, and consulting.

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

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

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