Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
ABC Private LimitedProductCountryTotal salesShippedCancelledDisputedIn ProcessOn HoldResolvedS101678YEAR
| 1 | Classic Cars | India | 52225.00 | 4562.00 | 2019 | |||||||
| 2 | Motorcycles | Russia | 112288.00 | 6555.00 | 2020 | |||||||
| 3 | Planes | America | 123335.00 | 6666.00 | 2021 | |||||||
| 4 | Ships | Britain | 85565.00 | 5456.00 | ||||||||
| 5 | Trains | Australia | 54666.00 | 8454.00 | ||||||||
| 6 | Trucks and Buses | Greece | 88554.00 | 5452.00 | ||||||||
| 7 | Vintage Cars | Turkey | 78799.00 | 5551.00 | ||||||||
| 8 | Total Sum of Sales | 595432.00 | ||||||||||
| 9 | Average of Sales | 85061.71 | ||||||||||
| 10 | Standard Deviation of Sales | |||||||||||
| 11 | Variance of Sales | |||||||||||
| 12 | Maximum Sales | 123335.00 | ||||||||||
| 13 | Minimum Sales | 52225.00 |