CASE STUDY: DATA ANALYTICS
SALES PERFORMANCE
ANALYSIS
Role
Lead Data Analyst
Tools
SQL, Power BI, Excel
Duration
4 Weeks
Outcome
+15% Efficiency
Click to Expand
View Live Demo
Overview
This project involved a comprehensive deep-dive into multi-channel retail data. By leveraging SQL for data extraction and Power BI for visualization, I identified key underperforming regions and suggested a strategy that led to a hypothetical 15% increase in inventory efficiency.
Tech Stack
Power BI
Excel
SQL
The Challenge
The primary hurdle was reconciling disparate data sources from three different retail platforms. Data cleaning and normalization were critical to ensure the accuracy of the final revenue projections.