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

a. Done formatting of the data with using borders, font size and appropriate alignment of the content.

b. 1. Total Sum of Sales = 10032660.85

2. Average of Sales = 3553.90

3. Standard Deviation of Sales = 1841.86

4. Varience of Sales = 3392432.13

5. Maximum Sales = 14082.80

6. Minimum Sales = 482.13

c. Created Pivot Table(Pivot1) to analyse the sales happened by product line and status.

d.

e. Analysed the Quantities ordered by each Country in Year 2019,2020 and 2021 for different Quarters using Pivot Table(Pivot 2).

f. Presented the data in different colours for values in field Status and ProductLine using conditional formatting.

g. Changed values of 2003 to 2019, 2004 to 2020 and 2005 to 2021

h. Calculated the total sales of all “Shipped”, “Cancelled”, “Disputed”, “In Process”, “On Hold”, “Resolved” products using Pivot Table(Pivot 3).

i. Splited the product code field into two using text to coloumn function.

j. Highlighted the top 10% values of QuantityOrdered field using Conditional Formatting.