Featured Work
Data Analytics Projects
Transforming raw data into actionable business insights through Excel dashboards, Power BI dashboards, Tableau dashboards, Python analysis, SQL queries, and machine learning models.
Employee Success Analysis using SQL
HR Analytics Dashboard - SQL & Excel
Comprehensive employee performance and success metrics analysis using SQL queries and Excel dashboards. Features 26 slides with 22 interactive visualizations covering employee performance trends, success metrics, and data-driven HR insights.
Tech Stack
Key Features
- ✓SQL Query Optimization
- ✓Employee Performance Metrics
- ✓Interactive Excel Dashboards
- ✓Data-Driven HR Insights
- ✓22 Interactive Visualizations
- ✓Comprehensive Analysis Reports
NovoMed Sales Performance Analysis
Pharmaceutical Sales Dashboard - Top/Bottom Analysis
Advanced sales performance analysis for NovaMed Solutions featuring top/bottom analysis dashboards. Includes profit margin analysis, revenue trends, drug performance metrics, and customer segmentation. Built with Power BI for interactive business intelligence.
Tech Stack
Key Features
- ✓Top/Bottom Drug Analysis
- ✓Profit Margin Tracking (82%)
- ✓Revenue & COGS Analysis
- ✓Customer Performance Metrics
- ✓Month-on-Month Trends
- ✓Interactive Dashboard Views
Analysis of Choco De Luxe Sales Data
Sales Analytics Dashboard - Tableau
Comprehensive sales data analysis for Choco De Luxe using Tableau dashboards featuring 16 slides with 12 detailed visualizations. Includes sales trends, product performance, regional analysis, and actionable business insights for strategic decision-making.
Tech Stack
Key Features
- ✓Tableau Dashboard Creation
- ✓Sales Trend Analysis
- ✓Product Performance Metrics
- ✓Regional Sales Breakdown
- ✓12 Interactive Visualizations
- ✓Business Intelligence Reports
- ✓Data-Driven Recommendations
Consumer Electronic Sales Trend Analysis
Trend Analysis Dashboard - Tableau
In-depth consumer electronics sales trend analysis using Tableau dashboards with 19 slides and 11 visualizations. Features time-series analysis, product category performance, seasonal trends, and predictive insights for electronic retail business.
Tech Stack
Key Features
- ✓Tableau Dashboard Creation
- ✓Time-Series Trend Analysis
- ✓Product Category Performance
- ✓Seasonal Pattern Recognition
- ✓11 Detailed Visualizations
- ✓Predictive Sales Insights
- ✓Market Trend Identification
Week 2: Sales & Customer Behaviour Insights - Green Cart Ltd
Python Data Analysis - Customer Analytics
Comprehensive sales and customer behavior analysis using Python, Pandas, and data visualization libraries. Features data cleaning, feature engineering, statistical analysis, and multiple visualizations including line plots, bar charts, boxplots, and heatmaps.
Tech Stack
Key Features
- ✓Data Cleaning & Standardization
- ✓Feature Engineering (Revenue, Price Bands)
- ✓Customer Behavior Analysis
- ✓78 Code Cells with Analysis
- ✓Multiple Visualization Types
- ✓Statistical Insights
Week 3: Churn Prediction for Stream Works Media
Machine Learning - Predictive Analytics
Advanced churn prediction analysis using machine learning models. Features predictive modeling, customer segmentation, churn risk scoring, and actionable insights for customer retention strategies.
Tech Stack
Key Features
- ✓Churn Prediction Models
- ✓Customer Segmentation
- ✓Risk Scoring Algorithms
- ✓48 Analysis Cells
- ✓ML Model Development
- ✓Retention Strategy Insights
Tech Hub Retail Sales Analysis
Retail Analytics Dashboard - Excel
Comprehensive retail sales analysis for Tech Hub using Excel dashboards featuring executive business intelligence dashboard. Includes customer segmentation, product portfolio analysis, geographic performance, and sales profitability trends.
Tech Stack
Key Features
- ✓Excel Dashboard Creation
- ✓Executive BI Dashboard
- ✓Customer Segmentation Matrix
- ✓Product Portfolio Analysis
- ✓Geographic Performance Maps
- ✓Sales & Profitability Trends
- ✓Customer Acquisition Channels
Sales Analysis of Cafe Harmony
Restaurant Sales Analytics - Excel Dashboard
Detailed sales analysis for Cafe Harmony using Excel dashboards covering sales performance, revenue trends, product analysis, and business insights for restaurant operations optimization.
Tech Stack
Key Features
- ✓Excel Dashboard Creation
- ✓Sales Performance Metrics
- ✓Revenue Trend Analysis
- ✓Product Performance
- ✓Operational Insights
- ✓Business Recommendations
Streamline Logistic Solution Analysis
Logistics Analytics Dashboard - Excel
Comprehensive logistics solution analysis using Excel dashboards. Features supply chain optimization, delivery performance metrics, route analysis, and operational efficiency insights for logistics operations.
Tech Stack
Key Features
- ✓Excel Dashboard Creation
- ✓Supply Chain Analysis
- ✓Delivery Performance Metrics
- ✓Route Optimization Analysis
- ✓Operational Efficiency Insights
- ✓Logistics KPIs Tracking