Asad Ali Shah
Data Analyst Building Clear, Decision-Driven Dashboards.
New to Contra
Asad Ali is building their profile!
Excel Sales Analysis Dashboard
I developed an interactive Excel Sales Analysis Dashboard to transform raw sales data into meaningful business insights. This project focuses on structured data analysis to support data-driven decision-making rather than just data visualization.
Project Overview:
This dashboard enables users to analyze sales performance, identify trends, and evaluate business performance through interactive visuals and KPIs.
Approach:
Cleaned and organized raw sales data for accurate analysis
Used Pivot Tables to identify patterns and trends
Created key performance indicators (KPIs) aligned with business goals
Built an interactive dashboard using slicers for real-time exploration
Key Insights:
Identified top-performing regions and product categories
Analyzed sales trends and performance over time
Evaluated overall business performance using KPIs
Outcome:
This project strengthened my ability to convert raw data into actionable insights and demonstrated the importance of analytical thinking in solving business problems.
I’m continuously building data analytics and dashboard projects to improve my skills and deliver impactful insights.
0
3
Most businesses know their total sales. Very few know which products are silently killing their profit.
I analyzed 10,000+ retail transactions across 4 years to uncover the insights that actually move the needle for a business.
The Problem
The company was offering heavy discounts on Furniture — specifically Tables and Bookcases — without realizing these sub-categories were generating consistent losses quarter after quarter.
The Finding
Technology drives 80% of total profit. Furniture, despite high sales volume, is deep in the red. The discount strategy needed an immediate review.
The Deeper Problem
749 customers had silently stopped purchasing. Using RFM Analysis (Recency, Frequency, Monetary), I segmented all customers and identified exactly who was at risk of churning — before it showed up in revenue numbers.
The Recommendation
Stop discounting loss-making products immediately
Launch a targeted retention campaign for At-Risk customers — estimated recovery of 15–20% of lost revenue
Double down on Technology and high-margin Office Supplies
0
9