Skip to content

Latest commit

 

History

History
34 lines (15 loc) · 1.14 KB

File metadata and controls

34 lines (15 loc) · 1.14 KB

Store-Data-Analysis-and-report-generation

The above project mainly focuses on data analysis of a store and its sales using Microsoft Excel and creating dashboard.

Project Logo

The Excel dashboards contain cross-filtering visuals, allowing for deeper and more comprehensive analysis of the data.

dashboard_image: Screenshot 2023-03-12 003002

Analysis

INSIGHTS:

Most of the sales and incoming orders happened in the March 2022.

Well! obviously, Overall shopping done by Women is 64% compared to Men.

There's a good news 92% of orders received were successfully delivered.

Top 5 states based on investment, Maharashtra seems to be at Top-1.

Your store attracts Female Adults as they've made more transactions, least is Senior Men.

Channel flow for sales in mainly from Amazon,Myntra and Flipkart.