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
-
Notifications
You must be signed in to change notification settings - Fork 0
An Excel Dashboard is created which displays Vrinda Store Data Analysis. Different kinds of Charts like Column chart, bar chart, pie chart, Slicers and filters are used for analysis. Mathematical, logical, string functions and pivot tables are used in the analysis
SailajaViswanatha/Excel-Vrinda-Store-data-Analysis
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
An Excel Dashboard is created which displays Vrinda Store Data Analysis. Different kinds of Charts like Column chart, bar chart, pie chart, Slicers and filters are used for analysis. Mathematical, logical, string functions and pivot tables are used in the analysis
Topics
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published