PROJECT.01

CASE STUDY: DATA ANALYTICS

SALES PERFORMANCE
ANALYSIS

Role

Lead Data Analyst

Tools

SQL, Power BI, Excel

Duration

4 Weeks

Outcome

+15% Efficiency

Sales Analysis Dashboard Demo View

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.