Tool Used : Power BIDatasource : ExcelSteps : Import from Excel -> Clean Data->Data Modelling using DAX Key Insights: 1)Total Head Count Increased from 157 in 2018 to 239 in 2019 and 346 in 2020.2)Total Employee Expense increase from 15M in 2018 to 24M in 2019 and 36M in 2020.3)Company have more number of FTE …
Tool Used : Power BIDatasource : ExcelSteps : 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 20195)Netherlands has Total …
Key Insights: 1)Total Sales-57438.86 2)Office suplies tops in category wise order 3)Top 5 selling products are BoomBox,FlexiSeat,DeskMate,Canvas prints and FlexiTable 4)Net Profit followed an increasing trend till 2022 and faced a slight decreasein 2023