Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring

Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring

• Border, Text alignment and font size were done
• Total sum, average, standard deviation, variance, minimum and maximum of sales were calculated
• By using pivot table, representation of table based of fields:
  • Status, Productline and sales were done
  • Quantities orderes by each country in year 2019,2020,2021 for different Quarters were done
• Total sales of all Shipped, Cancelled, Disputed, In Process, On Hold, Resolved were calculated