Data Analytics
Case Studies

End-to-end business analytics using SQL Server, Excel, and Power BI — turning raw data into decisions that drive real outcomes.

5+ Projects Built

3 Core Tools

100K+ Rows Analyzed

End-to-End

Full Pipeline Projects

⭐ Featured

Marketing Campaign Performance Analysis

SQL Server Excel Power BI

Analyzed 100K+ campaign records across 6 marketing channels to uncover performance gaps and ROI patterns.

📈 Identified top-performing channels — improved marketing efficiency by reallocating budget to high-conversion segments.

📋 Read Case Study 📊 Live Dashboard </> GitHub

Credit Card Transaction Analysis

SQL Server Power BI

Analyzed 50K+ transactions to identify customer spending behavior and high-value segment patterns.

🎯 Segmented customers by spend category — enabled targeted campaigns for high-value customers worth 3x average spend.

📋 Read Case Study 📊 Live Dashboard </> GitHub

Skill Projects

Individual Tool Deep Dives

Blinkit Sales & Profitability Analysis ⭐

Excel

Analyzed $1.2M in sales across 8,523 transactions. Identified revenue drivers and profitability gaps using Pivot Tables, XLOOKUP, and dynamic dashboards.

📋 Case Study 📊 Excel Dashboard 💻 Documentation

Advanced SQL Business Analysis

SQL Server

Solved complex business problems using Window Functions, CTEs, Joins and correlated subqueries. Covers EDA and performance optimization patterns.

📋 View Analysis </> SQL Scripts

Business Insights 360 Dashboard ⭐

Power BI

Built interactive multi-page Power BI dashboards using DAX measures, KPI cards, and drillthrough pages. Hosted live on NovyPro.

📊 Live Dashboard 🌐 NovyPro

Python EDA Project

Python

Performed data cleaning and exploratory analysis using Pandas and Matplotlib. Built the analytical foundation for automation workflows.

🔄 In Progress

⚡

All Projects on GitHub

SQL scripts · README documentation · Data dictionaries · Query explanations

</> View GitHub Repository →

Data AnalyticsCase Studies