Welcome to the Madhav Store Ecommerce Sales Dashboard repository! This project was created using Power BI Desktop to help the owner of Madhav Store track and analyze their online sales across India.
Project Objective
The primary objective of this project was to assist the owner of Madhav Store in gaining insights into their online sales data. By creating an interactive and visually appealing dashboard, we aimed to provide the owner with a tool to make data-driven decisions and enhance their online sales strategy.
Getting Started
To view and interact with the dashboard, you'll need Power BI Desktop. You can download and install it from the Microsoft Store or by following this link(https://www.microsoft.com/en-us/download/details.aspx?id=58494).
Data Source
The sales data is stored in CSV format, split across two files. The following steps were followed in the project:
- Extract the Data: The sales data was extracted from the provided CSV files.
- Transform the Data: Power BI's Power Query editor was utilized to transform and clean the raw data, making it suitable for analysis.
- Load the Data in Power BI: The transformed data was loaded into Power BI for visualization and analysis.
Project Learning
During the course of this project, the following key skills and techniques were utilized:
- Interactive Dashboard Creation: Created an interactive dashboard that allows users to explore online sales data easily.
- Advanced Visualization Techniques: Implemented complex parameters, filters, and slicers to enable dynamic and detailed data exploration.
- Data Manipulation and Calculation: Created connections, joined new tables, and performed calculations to manipulate data and enhance visualizations.
- Customized Visualizations: Utilized various customized visualizations such as bar charts, donut charts, clustered bar charts, slicers, etc., to present data effectively.
Acknowledgments
Special thanks to Rishabh Mishra for the valuable tutorials and guidance during the development of this project. You can find the tutorials here(https://www.youtube.com/watch?v=6cV3OwFrOkk&list=PLdOKnrf8EcP2ivbQIcVuknjdlUqkoprKo).
We hope this dashboard provides valuable insights for Madhav Store's online sales strategy. Feel free to explore the visualizations and use the interactive features to gain a deeper understanding of the data. Happy analyzing!