Total Sales all Regions and Channels
$3,941,901
Total Sales - Fresh Category
$1,319,554
Number of Locations
124
Original Set of Research Questions Here
- RQ1
- RQ2
Insights 1
Insights 2
You can add a link to an outside source: https://www.donorsearch.net/our-data/
| 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% |
| 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 |
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
| 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 |
CHANGES
The following changes were made to the dashboard:
Theme: The theme was changed from Cosmo to Sandstone
Logo: The logo was updated to the company’s logo.
Total Sales all Regions and Channels: The color and icon of the value box were updated to match the new theme.
Total Sales - Fresh Category: The color and icon of the value box were updated to match the new theme.
Number of Locations: The color of the value box was updated to match the new theme.
Map: Scale and a full screen option were added to the Portugal map.
Stacked Bar Chart: Changed the colors to Portugal’s flag colors.
Total and Fresh Sales by City: The plot was made interactive and its colors were updated to match the rest of the plots.
Total and Fresh Sales by Type: The plot’s colors were changed to match the rest of the plots
Dashboard Updates: A new tab was added to specify the changes made to the dashboard, and to reference any external sources used in that process.
REFERENCES
Quarto dashboards. Quarto. (n.d.). https://quarto.org/docs/dashboards/