This repository hosts a Sales Dashboard developed in Power BI to visualize product sales data, covering both online and cash transactions. The dashboard displays information about profit, total sales, product types, and categories, segmented by the years 2021 and 2022, along with their respective months.
The data used in this dashboard was extracted from the company’s internal database. This source contains information on sales carried out in 2021 and 2022, including product type, category, sale date, sale amount, and payment method.
- Power BI
- Microsoft Excel
The steps for building the dashboard were:
- Importing the data into Power BI
- Creating fact and dimension tables
- Developing measures and calculations
- Designing visuals and assembling panels
The dashboard developed in this project provides a comprehensive overview of the company’s product sales. It can be used to monitor sales performance, identify trends, and support strategic decision-making.
The dashboard was developed by [Sisnando Jr].
For more information, please reach out via [nando.devs@gmail.com].
The files used for this dashboard are available in the root of this project and include:
- Sales-Dashboard.pbix — the Power BI project file
- Sales-Dashboard-practice-file.xlsx — the Excel file containing the data used in the dashboard
👉 Click here to view the interactive dashboard on Power BI
The following improvements are planned for the dashboard:
- Add filters to allow data visualization by region or sales channel
- Add performance indicators (KPIs) to monitor sales performance
Any feedback on the dashboard is welcome!