How to track Points bank for Weekly execution
\uD83D\uDCD8 Instructions
Here are the resources to be updated each week:
Pull points data from Tableau https://reporting.rbi.com/#/views/PointsBankDashboard/PointsBankDashboard?:iid=1
Run this Notebook (https://dbc-9601831d-0d70.cloud.databricks.com/?o=2399142386962378#notebook/2280035661040204/command/3618400030029503) and copy the data into the excel below
This Notebook is on a scheduled job to refresh the tableau dashboard as well
Job : https://dbc-9601831d-0d70.cloud.databricks.com/?o=2399142386962378#job/16033
Excel to be updated : Points Bank Tracker.xlsx
Update the data you get from notebook into this tab in Excel : Data - Points Dash Sum
Refresh the pivot table with correct data ranges in this tab : Weekly Execution Slide
Insert a Row in column E - J and copy the formulas into it
Make any adjustments as necessary
Refresh the chart on the page
Known Diners - this data point comes from ??
Total Points = Base points + Bonus Points
Points Per guest = Total Points / Known Diners
All points are sum of daily for each week
