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:
- New section: included a section with the dashboard updates
- Theme: Changed the theme to flattly to make it look more professional
- Icons: Got rid of the icons as it looked unprofessional
- Logo: Updated the logo and added the actual logo of the company
- Valueboxes: Changed the color of the valueboxes to the same, blue is the color to make it look more professional
- Total and Fresh Sales by City: Changed the Color and assign each city colors that represent the Portugal flag
- Total and Fresh Sales by Type: Each type of sale has a color assign related to Portugal
- Customer Channel Type by City: Assign each city colors that represent Portugal
- Map: Added a scale and full screen option to the Map to make it easier to visualize
- Refence: Added reference list
REFERENCES
Quarto dashboards. Quarto. (n.d.). https://quarto.org/docs/dashboards/