Retail Sales Analysis
Business Problem
Understanding what drives revenue and profitability, and where regions, product categories and discounts are losing money.
Description
Analyzed 1,000 retail transactions end to end: cleaned the data with Excel, SQL and Python, built KPI analysis, and created an interactive Power BI dashboard with DAX measures, slicers and cross-filtering. Results were validated independently across Excel, SQL, Power BI and Python.
Tools Used
- Excel
- MySQL
- Power BI
- Python
- Pandas
- Matplotlib
Key Results
- $262.8K Revenue
- $29.6K Profit
- 11.2% Profit Margin
- 987 Orders
- 556 Customers
Identified loss-making regions, unprofitable product categories, and the impact of excessive discounts.
View on GitHub
Telecom Customer Churn Analysis & Prediction
Business Problem
Understanding why telecom customers churn and which customer segments are at highest risk, so retention efforts can be targeted.
Description
Cleaned and explored customer data, analyzed churn by contract type, tenure, services and payment method, built a Power BI dashboard to track churn KPIs and high-risk segments, and developed machine learning classification models to predict churn.
Tools Used
- Excel
- SQL
- Power BI
- Python
- Pandas
- Matplotlib
- Machine Learning
Key Insights
Identified the key churn drivers and turned them into actionable customer retention strategies.
View on GitHub
Low Stock Alert Automation
Business Problem
Low-stock products need to be detected quickly so replenishment decisions are not delayed.
Description
A Python inventory automation that reads stock data from Excel, flags products where current stock is at or below the reorder level, calculates reorder quantity and estimated cost, generates an Excel low-stock report, and sends email alerts.
Tools Used
- Python
- Pandas
- OpenPyXL
- Excel
- SMTP
Key Features
Automatic low-stock detection, reorder cost estimates, report generation, email alerts, and environment variables for secure email configuration.
View on GitHub
HR Employee Attrition Analysis
Business Problem
Understanding why employees are leaving the company and which factors are linked to attrition.
Description
Cleaned and analyzed HR data in Excel, answered key business questions with SQL, and built an interactive Power BI dashboard. Analyzed attrition by department, salary, overtime, experience, job role, satisfaction and work-life balance.
Tools Used
Key Insights
Identified high-risk employee groups and suggested data-driven retention strategies.
View on GitHub
Inventory & Stock Performance Analysis
Business Problem
Businesses need the right stock levels to meet demand without stockouts, excess inventory or unnecessary money tied up in stock.
Description
An end-to-end Power BI dashboard on a star-schema data model with DAX measures. It tracks inventory, sales, purchases, suppliers, stock turnover, stock coverage days and low-stock products, with filters for date, category, supplier and stock status.
Tools Used
- Power BI
- DAX
- Excel
- Data Modeling
Key Insights
Built to monitor supply chain health, optimize working capital and reduce stockout risk.
View on GitHub
