Total Sales all Regions and Channels

$3,941,901

Total Sales - Fresh Category

$1,319,554

Number of Locations

124

Number Before 125

124

SUMMARY INSIGHTS

Original Set of Research Questions Here

  • Why are the two locations in Portugal located in the west?

  • How are both locations just miles apart?

Insights
  • Portugal is a small country.

  • Use Kilometers, and the country is again small.

Link to my Linkedin Profile: https://www.linkedin.com/in/yamil-tenorio

Map of Portugal

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)

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
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

NEW FEATURES! 1. Theme is changed to “heart” 2. Three Textboxs colors changed to red, blue, orange. 3. Addition of new “green” textbox, with Pencil icon added 4. Currency sign changed to Yen. 5. Changed the outsource link to my LinkedIn profile. 6. Addition of RQs and Insights to front page. 7. Changed style of the map. 8. Size and Alpha for “Total and Fresh Sales by City” were decreased. 9. Tables and Models sections have been flipped 10. Title and Author have been updated.