Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Pull points data from Tableau https://reporting.rbi.com/#/views/PointsBankDashboard/PointsBankDashboard?:iid=1

  2. Update data and slide in Excel Run this Notebook () and copy the data into the excel below

  3. Excel to be updated : Points Bank Tracker.xlsx

    1. Update the data you get from notebook into this tab in Excel : Data - Points Dash Sum

    2. Refresh the pivot table with correct data ranges in this tab : Weekly Execution Slide

      1. Insert a Row in column E - J and copy the formulas into it

      2. Make any adjustments as necessary

    3. Refresh the chart on the page

Info

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

Image Added