This Power BI project provides an Amazon Sales Analytics Solution designed to uncover insights into sales performance, profit trends, and product category distribution.
It visualizes key metrics to help stakeholders understand sales patterns, identify profitable states, and monitor overall performance.
- Analyze total sales, profit, and order counts.
- Identify top-performing categories and least-profitable regions.
- Explore sales trends over time to track business growth.
- Build an interactive dashboard for quick decision-making.
- Total Sales: ₹725.46K
- Total Profit: ₹108.42K
- Total Orders: 3,203
- Line Chart: Sales trends over time (Order Date).
- Treemap: Sum of Sales by Category.
- Bar Chart: Profit by State.
- Gauge Chart: Total Sales performance.
- KPI Cards: High-level summary metrics for Orders, Profit, and Sales.
- Power BI Desktop
- Excel / CSV Data Sources
- DAX for Measures & Calculations
- Data Modeling & Cleaning in Power Query
- Imported dataset (Amazon Sales data) into Power BI.
- Cleaned and transformed data using Power Query Editor.
- Built data model with appropriate relationships.
- Created DAX measures for:
- Total Sales
- Total Profit
- Order Count
- Designed dashboard layout using KPI, Treemap, Line Chart, and Gauge visuals.
- Gained hands-on experience with data modeling and visual storytelling.
- Improved understanding of sales and profit analysis through interactive dashboards.
- Enhanced Power BI visualization and design skills.
Data Source: Walmart Sales Dataset
📁 Walmart-Sales-Analytics-Dashboard
┣ 📊 Walmart-Dataset.xlsx
┣ 📄 Walamrt-Dashboard.png
┗ 📘 README.md
The Amazon Sales Analytics Dashboard helps in understanding the performance of various product categories and states, revealing actionable insights that drive smarter business strategies.
Buragapalli Kamachari
📍 Andhra Pradesh, India
🔗 LinkedIn