The Bright Coffee Shop Analytics solution is built on a modern, layered data architecture designed to transform raw operational data into actionable business intelligence. The system processes 149,116 transactions across three store locations, enabling data-driven decision-making at every level of the organization.
Diagram | Will auto delete in 7 days
CSV FILE | Will AUTO DELETE IN 3 DAYS
Dataset Scope: 149,116 transactions | Period: January–June 2023 | Stores: 3 locations | SKUs: 80 unique products
| Metric | Value |
|---|---|
| Total Revenue | ZAR 698,812 |
| Average Transaction Value | ZAR 4.69 |
| Unique SKUs | 80 |
| Store Locations | 3 |
| Time Period | Jan–Jun 2023 |
Coffee and Tea dominate revenue at 67% combined — representing the non-negotiable core business drivers requiring continued investment and inventory priority.
Top Performer:
- Barista Espresso: ZAR 91,406
Bottom 5 Products (Rationalization Candidates):
- Green beans
- Organic Chocolate
- (and 3 others generating <ZAR 2,800 each)
Recommendation: Evaluate discontinuation or promotional strategies for bottom-tier products.
Critical Window: 8:00 AM – 10:00 AM
- Accounts for 37% of daily revenue
- Highest operational priority for staffing and inventory
| Month | Revenue | Notes |
|---|---|---|
| January | ZAR 81,678 | Baseline |
| February | [Dip] | |
| June | ZAR 166,486 | 104% growth from Jan |
Trend: Near doubling of revenue over 6-month period.
- All three locations perform within 3% variance
- Lower Manhattan trails slightly
- Network demonstrates balanced geographic distribution
Weekdays consistently outperform weekends
| Period | Performance |
|---|---|
| Weekdays | Strong |
| Saturday | Weakest day |
Opportunity: Targeted weekend promotions to lift Saturday performance.
- Data Warehouse: Snowflake cloud platform
- ETL Tooling: Custom pipeline with schema validation
- BI Tools: Power BI / Tableau compatible
- Data Refresh: Automated scheduled reports
- Query Interfaces: MySQL / MS SQL Server support
Document Version: 0.0