Project Title: Ecommerce Sales Analysis Dashboard using Power BI
Description:
This Power BI dashboard project aims to provide insights into ecommerce sales data, allowing business stakeholders to track key metrics, identify trends, and make data-driven decisions. The dashboard is designed to be interactive, enabling users to explore the data in real-time.
Project Objectives:
- Analyze ecommerce sales data to identify trends, patterns, and correlations
- Create an interactive dashboard that allows users to explore the data in real-time
- Provide actionable insights to inform business decisions
Data Sources:
- Ecommerce sales data (extracted from Orders Excel file and Details CSV file).
Technical Requirements:
- Power BI Desktop Version
- Microsoft Excel for data transformation and cleaning
Features:
- Interactive dashboard with various visualizations (e.g. charts, tables, maps)
- Drill-down capabilities to explore sales data at different levels (e.g. product, category, region)
- Filter and slicer functionality to customize the view
- Trend analysis and forecasting capabilities
- Alerts and notifications for sales performance metrics
Key Performance Indicators (KPIs):
- Sales revenue
- Sales growth rate
- Conversion rate
- Average order value
- Customer acquisition cost
- Customer retention rate
Project Demo:

License:
This project is licensed under the MIT License.