Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
-
Data cleaning and transformation: The task involves performing data cleaning and transformation using pivot tables and charts in Microsoft Excel. This process helps to organize and analyze the provided dataset to extract meaningful insights and make it suitable for reporting purposes.
-
Requirement of team hiring: The report aims to analyze the dataset to determine the requirement of team hiring in Company ABC Private Limited. By examining the sales of various products, such as Classic Cars, Motorcycles, Planes, Ships, Trains, Trucks and Buses, and Vintage Cars, the report will identify the areas where additional team members might be needed.
-
Manufacturing and sales of various products: The dataset contains information about the sales of different products manufactured and sold by Company ABC Private Limited. These products include Classic Cars, Motorcycles, Planes, Ships, Trains, Trucks and Buses, and Vintage Cars. The report will utilize this data to gain insights into the sales performance of each product category.