Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
Make summary of Products Sales by providing
| Total Sum of Sales | 10032628.9 |
| Average of Sales | 3553.88907 |
| Standard Deviation of Sales | 1841.86511 |
| Variance of Sales | 3392467.07 |
| Maximum of Sales | 14082.8 |
| Minimum of Sales | 482.13 |
Calculate the total sales of all “Shipped”, “Cancelled”, “Disputed”, “In Process”, “On Hold”, “Resolved” products.
| Cancelled | 194487.48 |
| Disputed | 72212.86 |
| In Process | 144729.96 |
| On Hold | 178979.19 |
| Resolved | 150718.28 |
| Shipped | 9291501.08 |