Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
File Uploaded for your reference
D -
H-
| Product Line | Cancelled | Disputed | In Process | On Hold | Resolved | Shipped | Grand Total |
| Classic Cars | 59242.81 | 26012.87 | 57760.66 | 49039.65 | 25799.34 | 3701776.33 | 3919631.66 |
| Motorcycles | 31821.9 | 4992.61 | 1129573.83 | 1166388.34 | |||
| Planes | 35432.71 | 3843.84 | 34727.53 | 34532.92 | 866466.57 | 975003.57 | |
| Ships | 56665.65 | 3070.4 | 23664.61 | 39863.71 | 591172.76 | 714437.13 | |
| Trains | 5082.42 | 5808.48 | 215352.57 | 226243.47 | |||
| Trucks and Buses | 43026.41 | 20193.29 | 20472.75 | 1044097.39 | 1127789.84 | ||
| Vintage Cars | 38063.89 | 7463.85 | 43942.89 | 40553.02 | 30049.56 | 1743093.63 | 1903166.84 |
| Grand Total | 194487.48 | 72212.86 | 144729.96 | 178979.19 | 150718.28 | 9291533.08 | 10032660.85 |