The aim of the E-commerce Sales Dashboard project was to provide a comprehensive perspective on e-commerce sales performance. This was achieved by creating interactive and visually captivating dashboards using Power BI. These dashboards were tailored to carefully scrutinize and monitor vital Year-to-Date (YTD) metrics, including profit, quantity, profit margin, and sales trends. Leveraging data sourced from the e-commerce platform, these dashboards empowered stakeholders to make well-informed decisions, pinpoint growth opportunities, and assess the effectiveness of their marketing campaigns.
- Power BI
- Power Query
- Dax Query
- Data modeling
- Imported data from Excel file into Power BI for creating dashboard
- Used Power Query editor to clean and transform the data
- Apply all necessary cleaning steps, such as removing duplicates, renaming columns, and changing data types
- Load and Apply the cleaned data into Power BI
- Created a Calender table using DAX formula
- Later created relationship between the new created calender table and ecommerce data to create measure to show on KPI visual
- Design the dashboard layout
- Created a measures to aggregate and display the data using Dax functions
- Use Visulizations for charts and slicers for filter dashboard
- Now, Add Title Ecommerce Sales Dashboard
- Add Customer segment as Slicer and add some informative KPI
- Add Card chart, Area chart, Donut chart, Matrix chart, Bar chart, Map etc
This is an interactive Power BI Dashboard , you can interact with this dashboard from https://www.novypro.com/project/ecommerce-sales-dashboard-power-bi-1
In this project, we focused on four key performance indicators: YTD Sales, YTD Profit, YTD Profit Margin, and Quantity of Products sold. We conducted a thorough analysis of sales data across different categories, including product categories, states, and regions, to gain a comprehensive understanding of performance and distribution patterns. To convey these insights effectively, we harnessed the power of interactive dashboards, charts, and visualizations. The ultimate goal was to utilize the valuable insights from this project to make informed business decisions, drive growth, and optimize operational strategies for the benefit of the Ecommerce Sales Company.