...
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
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
...