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

AIM: To create a report on requirement of team hiring for company ABC PVT.LMT. So, we performed data cleaning and Transformation using pivot tables and charts.

1. Formatting data

2. Summary of product sales like Total, Average, Maximum, Minimum, Variable, Standard Deviation

3. Pivot Table for sales by its product line and status

4. Created a new tab for formatting

5. Changing years, Spllitind data

6. Highlight top 10% of quantity odered

7. Total sales for all products.