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.

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

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.

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

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

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

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.

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.

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.

SQL-based fraud analysis of a 6M+ financial transaction dataset using PostgreSQL. The project follows audit-style workflows, preserves raw data integrity, applies performance indexing, and identifies systemic fraud patterns, balance inconsistencies, and high-risk transaction channels.