Sales Performance Dashboard
Designed an interactive sales dashboard using Advanced Excel, Pivot Tables, Pivot Charts, Power Query, slicers, and advanced formulas. Analyzed sales, revenue, profit, and regional performance; automated KPI reporting; and created dynamic product-wise and region-wise reports.
Customer Churn Prediction
Performed exploratory data analysis on 7,000+ customer records using Pandas, NumPy, and Seaborn. Built a Logistic Regression model with nearly 80% prediction accuracy and applied feature engineering, preprocessing, missing value handling, and categorical encoding.
Open Access Energy Consumption Dashboard
Developed an interactive Power BI dashboard using Power BI and Excel to monitor energy consumption, billing, and financial KPIs. Created DAX measures, drill-through reports, bookmarks, and slicers, and integrated multiple Excel datasets using Power Query.
IPL Analytics Dashboard
IPL 2022 Batting Analytics Dashboard | Power BI • Analyzed 1,500+ IPL matches & 20,000+ ball-by-ball records • Built DAX KPIs: Strike Rate, Dot Ball %, Economy, Total Runs • Created interactive slicers for season, venue & batting team • Delivered player & team-level batting insights Tools: Power BI, DAX, SQL, Excel