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/

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
Largest Sales by Product Category
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 → )

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
MODIFICATIONS

  1. I have changed the size of the “Total Sales all Regions and Channels” so it stands out in bigger size since this is one of the most important details to look at.

  2. I have changed the color of the Value box from blue to purple.

  3. I have added a second row column for the other two value boxes “Total Sales - Fresh Category” and “Number of Locations”

  4. I have added a new table indicating the “Largest Sales by Product Category”.

  5. I have moved the Column “Summary Insights” next to the number of locations, allowing more space to display the map and the tabs that show graph with the sales performance.

  6. In the Models section, I have added a new Product Segmentation Clustering in a tabset formatting.

  7. I have edited the map so instead of the pins it shows a label with the names of the cities, just to make it easy to read and identify and avoid to have to zoom in to get the names of the cities.

  8. I have re positioned the “Summary Insights” value box to be part of the tabs so it occupies less space and shows in a chronological order that makes it easier to follow and understand.

  9. I have changed the layout of the Visualization tab. Now it only has 5 sections. First and the biggest the Total Sales amount, Second and third the total sales of the fresh categories in dollar amounts and the number of total locations. Then the map of Portugal indicating the 2 locations with labels to easily identify which is which and lastly 4 tabs with insights, totals and channel type by city.

  10. I have added a new tab to indicate the modifications done in this dashboard.

  11. I have added an image in the upper left corner to give more visibility to the heading of the dashboard.