Sales and Profit Dashboard

(Data Visualization, Dashboarding)

Scenario

“The dataset is about a chocolate company. They provided five months of data for a single year. They want to increase their sales and identify the reason for sales growth.”

Data

Data Cleaning

• Import dataset
• Set appropriate data types per column

Relationships

Measures

Total Amount = SUM(sales[Amount])

Total Cost = SUM(sales[Cost])

Total Profit = [Total Amount] - [Total Cost]

Profit Ratio = DIVIDE([Total Profit], [Total Amount], 0) 

Link: https://github.com/dvmangrobang/Sales-and-Profit-Dashboard

(This is the data visualization project of the online course: “Data Storytelling with PowerBI” by Edureka on Coursera)