This repository contains an E-Commerce Dashboard developed using Power BI to visualize key business metrics and performance indicators. The dashboard provides insights into sales trends, customer behavior, product performance, and overall business health to enable data-driven decision-making.
Sales Analytics: Visualizes daily, weekly, monthly, and yearly sales trends.
Customer Demographics: Breaks down customer data by location, age group, and purchasing behavior.
Product Performance: Highlights top-selling products and tracks inventory levels.
Profitability Insights: Includes gross and net profit analysis across different periods.
Interactive Filtering: Allows users to drill down into data based on custom filters (e.g., time period, product category).
Real-Time Updates: Supports real-time or regular updates from data sources.
Power BI: Used to build interactive dashboards and visualizations.
Data Sources: CSV files, SQL databases, or live API connections (based on user data sources).
DAX (Data Analysis Expressions): For advanced data calculations and measures in Power BI.
Prerequisites
To view or modify the dashboard, you need:
Power BI Desktop
Steps to View the Dashboard:
- Download or clone this repository.
git clone https://github.com/Sarthak-Nigam/E-Commerce-Dashboard.git - Open the .pbix file in Power BI Desktop.
- Connect to your data source (if necessary) and refresh the data.
- Explore the dashboard and use filters to gain insights.
E-Commerce Dashboard.pbix: Power BI project file containing the dashboard layout and visualizations.
Business Analysts: To analyze sales and customer behavior.
E-Commerce Managers: To track product performance and profitability.
Executives: To monitor the overall health of the e-commerce business.
This project is licensed under the MIT License - see the LICENSE file for details.
Feel free to fork this repository and submit pull requests for any enhancements or fixes!
GitHub: https://github.com/Sarthak-Nigam/
LinkedIn: https://www.linkedin.com/in/nigamsarthak/