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

Title: Data Cleaning and Transformation using Pivot Table and Charts for the Report on Team Hiring Requirements at ABC Private Limited

Description: ABC Private Limited is a company that manufactures and sells a variety of products, including Classic Cars, Motorcycles, Planes, Ships, Trains, Trucks and Buses, and Vintage Cars. As a Business Analyst at the company, you are tasked with analyzing the sales data for these products and creating a report on the team hiring requirements based on the sales trends.

The project will involve cleaning and transforming the sales data using pivot tables and charts in Microsoft Excel. The cleaned and transformed data will then be used to create a report that will provide insights into the sales trends of each product and the team hiring requirements based on these trends.

The project deliverables will include:

1. A cleaned and transformed dataset using pivot tables and charts in Microsoft Excel
2. A report summarizing the sales trends for each product and the team hiring requirements based on these trends
3. Visualizations such as charts and graphs to support the report findings

The project will require strong analytical and data manipulation skills, as well as proficiency in Microsoft Excel. The end goal is to provide valuable insights to the company's management team that can inform their decision-making process in terms of team hiring requirements.