Hi Shane,

So i dissected our our function and booking data for 2024 found here:

Ramblin Events_2024.csv

Below you fill find the insights i have created from looking at our;

  1. Google Calendar bookings (small and large) for 2024
  2. I cross referenced popular drinks during event times
  3. Sales performance during event times
  4. Who the host was (we need to really make sure we make every host a member to make this better)
  5. Event time
  6. type of event (need to capture this way better eg: 40th Birthday)
  7. location in the bar - and any insights that could possibly have higher revenue based on the location of the event and the effect of the nights overall sales
  8. amount of people (need to capture this better)
  9. deposit paid if any
  10. hosts spending data on the time of event if they are a member,
  11. Whole bar revenue during event,
  12. Peak sales time for the night ,
  13. Compared all data to the avg revenue for that month