PROJECTS

Build a portfolio that gets you hired.

Every project below uses real, public datasets. Fork them, remix them, or use them as inspiration.

Netflix Content Analysis

Analyze content trends, genres, and country of production over 20 years.

SQLTableau

SQLDataset

Amazon Sales Analysis

Explore revenue, categories, and top sellers from Amazon transaction data.

PythonPandas

Python

HR Analytics Dashboard

Attrition, tenure, and diversity KPIs in an executive-ready dashboard.

Power BIDAX

Power BI

Customer Churn Analysis

Identify churn drivers with cohort analysis and predictive modeling.

PythonSQLTableau

End-to-End

Retail Sales Dashboard

A multi-page dashboard breaking down sales by region, category, and time.

Tableau

Olympics Data Analysis

120 years of Olympic history — medals, nations, and athlete demographics.

SQLPython

SQL

IPL Data Analysis

Batting, bowling, and team performance across every IPL season.

PythonPandasSeaborn

Python

Spotify Streaming Dashboard

Track top artists, genres, and listening habits over time.

Power BI

HR Attrition — Excel

Build a fully interactive HR dashboard using only Excel.

Excel

Employee Directory & Tenure Analysis

DATEDIF for tenure, VLOOKUP for department, age bands using IFS, conditional formatting, PivotTable by department.

Excel

Sales Performance Tracker (Monthly)

12-month Tables; SUMIFS by region & product; RAG on target; sparklines per row; automated date header.

Excel

Invoice Aging Report

DATEDIF for overdue, IFS for aging buckets, SUMIFS by bucket, traffic-light conditional formatting.

Excel

Interactive Sales KPI Dashboard

Revenue YTD/MTD vs target KPI cards; trend chart; region breakdown; dropdown driving all charts. No VBA.

Excel

Budget vs Actual Financial Report

Multi-sheet: Assumptions → Calculations → Monthly P&L → Dashboard. Variance with RAG. Scenario Manager.

Excel

Power Query Multi-File Consolidation

12 monthly CSVs → PQ append → clean → load → PivotTable dashboard. One-click refresh.

Excel

Customer RFM Segmentation Model

Transactions → PQ clean → DATEDIF recency, COUNTIFS frequency, SUMIFS monetary → PERCENTRANK → segments.

Excel

Automated Monthly MIS Report

PQ import → PivotTable refresh → VBA: format + timestamp + PDF export. One-button monthly cycle.

ExcelVBA

Excel

Power Pivot Multi-Table Analytics

Star schema: fact (sales) + dims (customers, products, calendar). 15 DAX measures + dashboard.

ExcelPower Pivot

Excel

5-Year Financial Forecast Model

Inputs → Calcs → P&L/CF/BS → Dashboard. Sensitivity with 2-way Data Table. Scenario Manager. NPV/IRR.

Excel