sql-analytics

Power BI IPL 2026 Complete Ball-by-Ball Dashboard with Python Data Cleaning

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

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

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.

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.

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

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

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.

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.

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.

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.