Retail sales analytics dashboard
This project aims to create an analytics dashboard for
retail businesses to analyze sales trends, customer behavior,
and store performance.
The dataset includes sales data, customer profiles,
and store information. Preprocessing involves aggregating
sales data, calculating customer metrics. Visualizations can reveal insights into customer demographics, popular products, and peak shopping hours, enabling retailers to optimize inventory, plan marketing campaigns, and enhance customer experiences.
@Bostoninstituteofanalytics![SALES DASHBOARD CATEGORY
AR
PRODUCT TREND ANALYSIS
= = = = TOTAL PRICE TOTAL QUANTITY TOTAL PRODUCT. AMOUNT PER SALE AVAERAGE SALE Sum of order total
507.2K 100 497K 507.2 51K 5M
DAILY TRENDS FOR TOTAL ORDER VS PRICES MONTHLY TRENDS FOR TOTAL ORDERS TOTAL ORDER BY COUNTRY
®ctothing
om onm
069M al on 069M
I oem REA
704K = 1 1] =n
HE me
" JAN HIE MAR APR MAY JUN JUL AUG SIF OCT NOV DEC Pome Ton © £5 ht Cpr, § Aire
% OF TOTAL ORDER BY GENDER TOTAL ORDER BY YEAR VS CATEGORY TOTAL ORDER BY CATEGORY ORDER STATUS BY CATEGORY
© clothing ® rirctions ®lood © clothing ® electronics ©1000
01m Customer gender 2om
01M (2%) 2% IM gpa
® fugendes
© Agender rcteancs
om v om
2m © Non binary
(44%)
oom oom
nro 7071 027 ‘ pending Gelvered shipped](https://contents.bebee.com/users/id/7lZhS655c9b4522019/post/gfUZk65bdd03ecb008/X9OeA.png)
![SALES DASHBOARD
PERFORMANCE SUMMARY
WEEKLY TRENDS;
AT 768602 WED had highest order and 17% higher than
Tuesday
At 7681 Friday had the highest product soled and was
29.22% higher than Saturday.
The total order and total revenue are positively correlated
each other.
MONTHLY TREND:
JUN had the highest order and 49.99% higher than
December.
At 4944, JUN had the highest product sale and was
61.89% higher than JAN, which had lowest product sale
213054.
Clothing had the highest order(1751262)/product sale
(17201) and compare to food(1654507) and
electronics(1582371).
Male accounted for 45.79% total order.
The credit card payment method are use highly.
At CHINA had the highest revenue contribute to store.
= 2020 177928
@1 48394
22 46453
a3 39128
clothing 8634
electronics 16879
food 1161
@4 43953
= 2021 156566
@1 37817
22 33637
®3 42392
4 42720
= 2022 172668
oR] 40820
®2 48818
23 46864
4 36166
io BE 2AL>]
17499
3996
4692
3976
OTAL PRICE TOTAL PRODUCT SALE TOTAL QUANTITY AVAERAGE SALE AMOUNT PER SALE Sum of order total
97 1.834.31
55 879.89
60 774.22
54 724.59
0) 482.03
) 244 60
56 784.88
93 1,683.51
54 700.31
42 800.88
61 694.95
53 806.04
97 1,780.08
55 742.18
65 751.05
54 867.85
51 709.14
pL 5,071.62
514.24
556.25
516.14
483.06
499.47
511.65
511.04
509.65
481.73
547.69
496.17
510.25
478.61
503.91
1689330
391480
448368
447311
186204
402171
1519717
377625
372561
393362
376169
1779093
418356
527881
488401
344455
REE](https://contents.bebee.com/users/id/7lZhS655c9b4522019/post/gfUZk65bdd03ecb008/fJ4MO.png)
![SALES DASHBOARD
PRODUCT&CUSTOMER PERFORMANCE
TOP § COUTRY BY REVENUE
ne. I
woe, I
Sass 34K
Pagan 12K
Bean 26K
[3 sox 100K
© clothing ® rirctronscs ®lood
TOP § REVENUE BY CITY.
204
17%
Pep 17%
Menon 14K
LOWEST REVENUE BY CITY
—
Seromrst
Morse 3
TOP § PRODUCT BY ORDER
name
24%
(unen be 19%
Biber ™
Cartoon [
TOP § PRODUCT BY HIGHEST SEALE
m
Chevess ton 270
262
249
Bian wm
TOTAL PRICE
TOTAL PRODUCT SALE
TOTAL QUANTITY
LOWEST PRICEAGUNATITY BY CUSTOMER
onmaor | 2
[r— 6
re I
rem [ o
[|]
a](https://contents.bebee.com/users/id/7lZhS655c9b4522019/post/gfUZk65bdd03ecb008/kkp9y.png)
More posts from Ravichandran a
View posts
CUSTOMER SEGMENTATION (RFM) ANALYSIS - RETAIL DOMAIN
Ravichandran a · To Build a machine learning model that predicts whether an online customer of a retail shop will make their next purchase 90 days from the last purchaseTo Build a machine learning model that predicts whether an online customer of a retail shop will make their next purchase 90 day ...
EART DISEASE PREDICTION - HEALTH CARE DOMAIN
Ravichandran a · To create an efficient Machine learning models to predict the patient has Heart disease or not with the given labelled data set · PROJECT WORKFLOW · Data wrangling · Data cleaning · Outlier and statistics analysis · Exploratory Data Analysis · Hypothesis Testing · Data preprocess ...
car sales dashboard
Ravichandran a · See immediate improvements in decision-making, forecasting accuracy, and overall sales performance. The future of your sales success is just a dashboard away! · 🔍 Key Features: · Real-time sales updates 🔄 · Comprehensive sales pipeline analysis 📊 · Customer segmentation for targe ...
Related content
Chanuka Kaveesha
Healthy lifestyle: 5 keys to a longer life
· These five categories were chosen because previous research has demonstrated that they have a significant influence on the probability of early mortality. These healthful practices were defined and measured as follows: read more about
Ravichandran a
pizza sales dashboard
Visualizations can reveal insights into customer demographics, · popular products, and peak shopping hours, enabling retailers to optimize · inventory, plan marketing campaigns, and enhance customer experiences. · See immediate improvements in decision-making, forecasting acc ...
Vipin Kumar
Post from Vipin Kumar
Generate Your Revenue By Starting Your Own Crypto Exchange Business · Start your own crypto exchange business to achieve big feats with expertise and professional services. The experts of Technoloader let you do that in a very little budget. · #cryptoexchange #cryptocurrencyexcha ...
Vipin Kumar
Post from Vipin Kumar
Generate Your Revenue By Starting Your Own Crypto Exchange Business · Start your own crypto exchange business to achieve big feats with expertise and professional services. The experts of Technoloader let you do that in a very little budget. · #cryptoexchange #cryptocurrency #cry ...
Murtza Abbas
Post from Murtza Abbas
MVP is designed to make the basic product to earn the initial revenue. Once the idea deploy to the audience, tweaks get featured. · #MVP #MinimumViableProduct #business #startup · Steps to Build a Minimum Viable Product: 2021 Guide · Minimum Viable Product can be built easily. Y ...
Praveen E
5 Reasons to start an OTT business
Revenue in the OTT industry is expected to reach US $200 Billion in 2022. If you are a #video #content creator, this is the best time to start an #OTT platform. Here is the blog that lists 5 reasons to start an OTT #business: · 5 Reasons to Start an OTT Business All Perfect Stor ...
You may be interested in these jobs
-
SAP RAR-Senior
Found in: Talent IN C2 - 5 days ago
EY Noida, IndiaThe opportunity · We're looking for Senior with expertise in SAP R/3 or S4 Revenue Recognition and Reporting (RAR) to join our Practice. The SAP RAR Consultant/Analyst is responsible for implementing, configuring, and maintaining the SAP RAR module within an organization. This r ...
-
Industrial Relations Officer
Found in: Talent IN 2A C2 - 2 days ago
Swan Energy Limited Gujarat, IndiaJob Responsibilities: - · Facilitate Communication: · Act as a central point of contact for all communication between organization and government departments. Ensure that information is accurately shared and understood by all parties involved. · Relationship Management: · Bui ...
-
SAP UI5 Development
Found in: Talent IN C2 - 3 days ago
Opalforce Inc Bengaluru, IndiaKeyResponsibilities: · Designbuild and configure applications to meet business process andapplication requirements using SAP UI5Development. · Collaborate with crossfunctional teams to analyze businessrequirements and develop solutions to meet thoserequirements. · Develop and mai ...
You have no groups that fit your search
Comments