Tool Used : Power BI
Datasource : Excel
Steps : Import from Excel -> Clean Data->Data Modelling using DAX
Key Insights:
1)Total sales decreased by 31.13 % compared to LY
2)Total cost decreased by 33.75 % compared to LY
3)Profit Percentage increased by 24.01 % compared to LY(2019)
4) 1015 new customers in 2020 compared to 2019
5)Netherlands has Total cost,total sales and total profit significantly higher than that of others.