Total Sales all Regions and Channels

$3,941,901

Total Sales - Fresh Category

$1,319,554

Number of Locations

124

SUMMARY INSIGHTS

Original Set of Research Questions Here

  • RQ1
  • RQ2
Insights

  • Insights 1

  • Insights 2

You can add a link to an outside source: https://www.donorsearch.net/our-data/

INSIGHTS Of the 124 observations, 77 were from hotel cafe’s or retail stores in Libson.

Number of Hotel Cafe Observations in Libson

59

Number of Retail Store Observations in Libson

18

Insights about Sales Distribution by Department and ChannelS - Hotel Cafe’s sell 34% more fresh food than Retail Stores - Retail Stores sell more grocery products than Hotel Cafe’s - Deli is the least combined type of product bought by customers and Hotel Cafe’s and Retail Store’s.

Sales Distribution by Department and Channel
Channel Fresh Milk Grocery Frozen Soap Deli
Hotel_Cafe 48% 13.0% 16% 15% 3% 4.5%
Retail_Store 14% 21.9% 38% 4% 18% 3.4%
Fresh and Total Sales by City and Channel
Region Channel Total Fresh Grocery Milk Frozen Soap Deli
Lisbon Hotel_Cafe $1,538,342 $761,233 $237,542 $228,342 $184,512 $56,081 $70,632
Lisbon Retail_Store $848,471 $93,600 $332,495 $194,112 $46,514 $148,055 $33,695
Porto Hotel_Cafe $719,150 $326,215 $123,074 $64,519 $160,861 $13,516 $30,965
Porto Retail_Store $835,938 $138,506 $310,200 $174,625 $29,271 $159,795 $23,541
Dataset

SEGMENTATION MODEL INSIGHTS
Write some amazingly interesting insights about the customer segmentation here!

  • Bullet 1

  • Bullet 2

  • Bullet 3

Note this content does not specify a fixed row height. So it will increase or shrink based on the amount of content. Thus, it allows the cluster image box to adjust size accordingly. (Contrast with the fixed row height specification method for Channel insights → )

CUSTOMER SEGMENTATION (CLUSTERING)
CUSTOMER SEGMENTATION (BAR PLOT)

CHANNEL CLASSIFICATION MODEL INSIGHTS
Write some amazingly interesting insights about the channel classification
- Bullet 1
- Bullet 2
- Bullet 3
Note this card method for coding the narrative content fixes the size, in this case to 40%.

If you have more content, it just scrolls

More content here

More content here

More here

and more here

and more here

CHANNEL CLASSIFICATION MODEL
Observations 124
Dependent variable Channel.b
Type OLS linear regression
F(2,121) 75.72
R² 0.56
Adj. R² 0.55
Est. S.E. t val. p
(Intercept) -0.70 0.17 -4.18 0.00
pctFresh -0.35 0.13 -2.58 0.01
log(Detergents_Paper) 0.17 0.02 8.43 0.00
Standard errors: OLS
  1. Number of Locations box from orange to red
  2. Changed the row height from 80 to 60
  3. Added a bar plot showing the distribution of customer segments
  4. Models tab from Column to Row height of 40%
  5. Added a value box counting the Number of Hotel_Cafe Observations in Libson
  6. Added a value box counting the Number of Retail_Store Observations in Libson
  7. Added a card to the Tables tab
  8. Added a card for Insights about Sales Distribution by Department and Channel
  9. Changed the map from a topographical map to a worldview map

Number of Changes

10