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

In this Project the Company ABC Private Limited is manufacturing and selling various products. As a  Business Analyst of the Company my primary objectives are to optimize data presentation,derive valuable insights and facilitate informed decision-making within the organization.The key tasks involved in the project are Data Formatting, Calculation of Sales Metrics, Quantities Ordered Analysis: Through pivot tables, Sales Happened by product line and order status: Through pivot tables,Text Functions for enhancing data granualarity, Conditional Formatting for highlighting the data as per business requirements, Date Formatting by appropriately reformatted to ensure consistency and clarity in reporting and Sales Totalization by SUMIF functions according to the product status.