End-to-end SQL project on Swiggy food delivery data — data cleaning, star schema design, KPI development & business deep-dive analysis using T-SQL
End-to-end MySQL data warehouse: Bronze/Silver/Gold medallion architecture with documented data cleaning rules, star schema, and validation tests.
Enterprise Business Intelligence Platform for Insurance Portfolio, Customer, Claims & Underwriting Analytics using Python, Excel, MySQL Data Warehouse, Star Schema, SQL & Tableau.
Modern ELT Data pipeline with dbt transformation. Includes data ingestion using python from postgresql to amazon s3, copy data into snowflake from s3 build dbt models. implemented Incremental loading, SCD Type 2 using dbt snapshot
Exploratory data analysis in T-SQL on a sales data warehouse (star schema, SQL Server). Covers date and measure profiling, trends over time, running totals, YoY comparison, part-to-whole, product and customer ranking, segmentation, and two reporting views. Findings on 2010-2014 sales included.
📊 End-to-end Sales & Operations BI project: Python ETL pipeline to Star Schema (SQLite) + Interactive Power BI Dashboard with dynamic DAX KPIs.
End-to-end Northwind sales analytics project using PostgreSQL, SQL Silver/Gold layers, star schema views, and a 3-page Power BI dashboard with data quality checks.
An end-to-end Enterprise Star-Schema Data Mart and Self-Serve BI pipeline built with Python, DuckDB, and Power BI following Kimball dimensional modeling methodology.
Building a modern warehouse using sql server, include ELT process, data modeling, and analytics
To associate your repository with the start-schema topic, visit your repo's landing page and select "manage topics."