This project is a complete Sales Analytics Dashboard built using Excel for data cleaning and Power BI for modeling, visualizations, and insights.
The objective is to understand sales performance, analyze product trends, evaluate regional contributions, and identify revenue growth patterns.
- Removed duplicate records from the dataset
- Standardized text fields
- Cleaned date column and ensured a consistent date format
- Removed null or missing values
- Fixed incorrect number formats
- Trimmed extra spaces and corrected case formatting
- Verified product, quantity, and price fields
- Added month and year helper columns for analysis
- Finalized a clean base dataset for Power BI
- Corrected data types
- Removed unnecessary columns
- Replaced nulls with appropriate values
- Extracted Year, Month, and Month Name from the Date column
- Renamed columns for consistency and clarity
- Ensured a clean, optimized dataset ready for reporting
- Loaded the cleaned Sales table
- Created a simple Date table for visuals requiring a proper date hierarchy
- Built relationships automatically handled by Power BI (if applicable)
- Designed dashboards using clean, modern visualization standards
- Total Revenue
- Total Quantity
- Total Customers
- Average Unit Price
- Revenue YTD
- Running Revenue
- Revenue Growth %
- Total Revenue
- Total Quantity Sold
- Total Customers
- Average Unit Price
- Top Salesperson Performance (Bar Chart)
- Revenue by Product Category (Donut/Pie Chart)
- Monthly Revenue Trend (Line Chart)
- Revenue by Region (Clustered Bar Chart)
- North region shows the highest sales performance
- Kavitha is the top-performing salesperson
- Electronics category contributes the most revenue
- Monthly revenue shows peak performance in mid-year
- Customer and product performance indicators show stable trends
- Total Revenue
- Total Quantity Sold
- Average Unit Price
- Revenue by Product Name (Tree Map)
- Best-Selling Products (Bar Chart)
- Category-wise Monthly Trend (Line Chart)
- Product Performance by Region (Clustered Bar Chart)
- Shirt, Sofa, and Laptop are top-selling products
- Electronics category dominates overall revenue
- Home product category contributes the least
- Q2 shows strong product performance
- Product demand varies across regions
- Total Revenue
- Revenue Growth %
- Cumulative Revenue
- Revenue YTD
- Cumulative Revenue Trend (Area Chart)
- Revenue Growth Percentage (Card)
- Revenue by Category (Bar Chart)
- Regional Revenue Contribution (Pie Chart)
- Revenue shows a steady upward growth
- Electronics category drives major growth
- North region contributes the largest revenue share
- Year-to-date revenue trend indicates consistent performance
- Cumulative revenue shows a positive progression
This project demonstrates a full data analytics workflow:
- Excel for cleaning raw data and preparing a reliable dataset
- Power BI for modeling, creating DAX measures, and building meaningful dashboards
- Visual insights that highlight sales trends, product performance, and regional contributions
The dashboards together provide a clear, interactive, and insightful understanding of business sales performance.
**Name:**Sona Jestin **LinkedIn:**www.linkedin.com/in/sonajestin