Data Projects
Dynamic Sales Dashboard
Transformed raw sales records into a filterable dashboard. Automated cleaning with Power Query. Key insight: 30% of revenue from top 5% products.
Excel
Power Query
Pivot
Python Automation Tool
GUI for repetitive data entry tasks. Reduced manual time by 40%.
Python
Tkinter
Energy Consumption Analysis
ETL with Power Query, interactive dashboards revealing seasonal trends.
Power BI
SQL
Sales Forecasting Dashboard
Prophet model + Tableau. Forecast accuracy improved by 23%.
Python
Tableau
Customer Segmentation (RFM)
SQL & Python clustering identified high-value segments for marketing.
SQL
Python
Churn Prediction Model
Scikit-learn classifier with 87% recall. Identified key churn drivers.
Python
Sklearn
Inventory Optimization
Demand forecasting using SQL & Python reduced stockouts by 15%.
SQL
Python