Sales and Profits Visualization


Project information

Roles:

  • Data Analyst

Key Skills:

  • Data Cleaning
  • Data Analysis
  • Data Visualization

Summary

A dashboard showing the sales, profits and discounts of products in different regions. In this personal project, I created a dashboard that shows the sales of different product categories and profits obtained. In this dashboard, viewers will also be able to see the discounts given per each product category.

Visualization

Sales and Profits Dashboard
The discount view shows a breakdown by location. Viewers will be able to see the discounts given in each state of the 4 Regions. Filters are available based on product category and region. When a viewer clicks on a product category, the discount visualization will be filtered with values for the selected product category and region.

From the dashboard, we can see that:
  • The business made losses from the sale of Furniture in Central Region.
  • The business made more profit from the sales of Technology.
  • Sale of Furniture is not a very profitable business.

Takeaways and Learnings

  • How to clean and prepare data
  • Data visualization techniques