Excel-Vrinda-Store-data-Analysis

Project Summary: The objective is, to open a new textile store with the products contributing maximum profits based on the analysis of the products contributing to maximum sales and profits and reviews of customers to the products offered by the existing store Excel is used to clean and transform the data. By using Pivot tables, various visuals like Orders vs Sales, Order Status, Top 5 states which are contributing maximum sales, are created A dashboard is created, which contains the information of the products like men’s and women’s clothing in the form of visuals so that, the possibility of opening a new store can be analyzed