SQL Store Performance Analysis PROJECT_DESCRIPTION: I need a savvy data analyst who knows their way around SQL. The project involves careful examination of the sales and operations data of multiple stores to measure their individual profitability and over

Job ID: 39807749

Budget: ₹400 – ₹750 INR

I had worked on so many projects likePROJECT EXPERIENCE
Store Performance Monitoring System – SQL
• Analyzed multi-store sales and operations data to measure branch-wise profitability and performance.
• Identified underperforming branches and helped increase operational efficiency by 20% using KPIs like Sales Per Square Foot and Operating
Margin.
Profitability Analysis Dashboard – Microsoft Excel
• Designed an Excel dashboard to track revenue, cost, and profit trends across product categories and quarters.
• Incorporated Pivot Tables, Dynamic Charts, and VLOOKUP to monitor performance and identify loss-making segments.
Healthcare Analytics Dashboard – Power BI
• Built an interactive Power BI report for a hospital chain to monitor admission rates, treatment types, and department-wise performance.
• Used DAX to compute measures like Avg. Treatment Cost, Patient Retention, and Admission Trends.
Sales Forecasting Using Regression Models – Machine Learning (Python)
• Developed a regression model using Linear Regression and XGBoost to forecast monthly sales for an electronics retailer.
• Performed feature selection, cross-validation, and residual analysis to improve forecast accuracy.
• Delivered insights on demand peaks, seasonal behavior, and inventory planning.
Battery Sentiment analysis and recommendation system - NLP
• Battery sentiment analysis and recommendation system is a combination of natural language processing and machine learning
for building a recommendation logic