Analysis: Bona Lluna Cervesa -- Sales Channel Analytics
1. Data Quality Assessment
Completeness
What percentage of expected fields are populated in each data source? Which fields have nulls, and how many?
Consistency
Do dates, product names, and amounts align with expectations across sources? Are there format differences?
Accuracy
Do known values match? For example, do product catalog prices correspond to transaction amounts in the POS?
Timeliness
What is the most recent record in each source? Are there gaps in the time series?
2. Metric Definitions
| Metric | Plain-language definition | SQL expression | Edge cases | Cross-check findings |
|---|---|---|---|---|
| Revenue | ||||
| Volume | ||||
| Growth (WoW) | ||||
| Growth (MoM) |
3. Segmentation Findings
By channel
Revenue and volume breakdown by taproom, distribution, and online.
By beer style
Revenue and volume breakdown by beer style across all channels.
Cross-tabulation
Channel x beer style matrix showing where each style performs strongest.
4. Cleaning Decisions Log
| Decision | What was affected | Trade-off | Rows impacted |
|---|---|---|---|
5. Dashboard Purpose Statement
Audience:
Questions answered:
Questions not answered: