Weekly Execution - Report
- Lavanya Davluri
- Zhiyi Wang
- Igor Rahal Linkewitsch
- JinZhao Wang
Project | Business Intellingece |
|---|---|
Team | Digital and Loyalty - Tim Hortons |
Jira Initiative | |
Document Status | IN PROGRESS |
Created On | March - 2023 |
Document Owner | @Lavanya Davluri Type @ to mention users |
Team
Requirements Owner | @Lavanya Davluri @Igor Rahal Linkewitsch |
|---|---|
Business Lead | @Grace Jin @Zahra Lakhani |
Dev | @JinZhao Wang @Zhiyi Wang |
Data Lead | @Anirudha Porwal |
Tech Lead | @Shawn Zou |
Stakeholders | @Scott Williams @Adrian Monk @Amanda Khan (Deactivated) |
Project Overview
We have a weekly report on digital and loyalty performance, this report summarizes sales and traffic across our different channels and also looks at how digital and loyalty are contributing to the top line sales.
This is phase 1 of a bigger project that we are undertaking to create reports and dashboards.
Data Planning - Phase 1
We took a top-down look at the current state of reporting views we have and have a proposal of having these base reports that would feed into the dashboard (Tableau)
Report | Granularity | Splits | Metric |
|---|---|---|---|
Transaction level Features Must Have | Transaction Data Dictionary: Transaction Level Data Dictionary.xlsx | Service modes , Sub-service modes , Restaurant, Retaurant Feild Heirarchies | Sales Flags
|
Guest Level Features Must Have | Guest - Week Data Dictionary: Guest Level Data Dictionary.xlsx | Loyalty and registration status, Comping Status, Service mode transactions, loyalty redemptions | Sales Transactions Flags |
Points Nice to have | Day - Campaign | Campaigns | Points Issued |
Offers Nice to have | Data Pipeline implemented , this is views only Data Dictionary: Offer Level Data Dictionary.xlsx | ||
Specifications
Reference Links
Databricks Notebook:
Folder with all supporting documents : https://rbioffice.sharepoint.com/:f:/t/THDigitalandLoyaltyAnalyticsandOffers/Etxdxq-oqmhOmfhFIflqW_YBwpGhqbJbrvS9BGAU2pfxWw?e=uNsYsz