Skip to content

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

Notifications You must be signed in to change notification settings

DivyaAnalyst/Store-Data-Analysis-and-report-generation

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 

Repository files navigation

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.

About

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

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published