DASHBOARDS, FORMULAS AND PIVOT TABLES: WHAT ARE THEY AND WHY YOU NEED TO KNOW
Excel is a problem-solving tool that every hospitality professional, and especially those working in gaming, needs to not just understand, but be proficient at.
Take dashboards for instance. The purpose of a dashboard is to provide real-time results by aggregating and extracting value. They work by connecting your gaming, POS and other business systems, via API (application programming interfaces) to pull all that information into one place for a greater understanding of your business. They can also be used to manipulate data so the information is in a more accessible format. Dashboards help with project management, customer service, retail management, financial forecasting and much more.
Some of the key benefits of dashboards include:
- Giving you greater insights and visibility into your gaming floor, and how that integrates into the greater business as a whole.
- Dashboards allow you to measure your performance and like the famous American business consultant and author Pere Drucker said: “If you can’t measure it, you can’t improve it.”
- Setting up an effective dashboard can save you hours of time each month – and we all know how precious that is in this industry!
Then we come to Pivot Tables, possibly one of the most powerful yet intimidating features in Excel. Pivot tables allow you to quickly summarise and analyse large amounts of data in lists and tables–independent of the original data layout in your spreadsheet–by dragging and dropping columns to different rows, columns, or summary positions.
If you want to take control of your data, find the answers to the tough questions about your gaming floor, learn how to create automated processes that will help you save time and create real and timely intelligence, then an advanced Excel course may be just what you need.
Bulls Eye have developed a two-day intensive Excel workshop, specifically designed for gaming professionals, that will show you
- how to create a dashboard for club professional
- how to spend more time analysing the data and less time processing it
- how to manage multiple worksheets with pivot tables
……. plus, a whole lot more.
The workshop ideal for Gaming Managers and aspiring Gaming Managers who want to get more out of their data. It’s also a perfect course for Analysts, Supervisors, VIP Hosts and Licensees, as well as CEO’s, Secretary Managers and Marketing & Loyalty Managers.
Run in conjunction with the CMAA (the successful completion of any of the 1-day workshops provide credit towards the CMAA GAMING SERVICE MANAGEMENT EXCELLENCE) the workshops will be run in Sydney and Brisbane in March.
Seats are filling fast, so BOOK NOW!
Sydney
Monday 6th March Advanced Excel for Club Professionals
Tuesday 7th March Creating Dashboards for Club Professionals
Location Level 10, 10 Barrack St, Sydney (5 mins from Wynyard station)
Times 9am to 430pm, Price $395 per day + GST
Brisbane
Thursday 9th March Advanced Excel for Club Professionals
Friday 10th March Creating Dashboards for Club Professionals
Location Level 11, 300 Adelaide St, Brisbane (5 mins from Central station)
For detailed information about the workshops and bookings click here >>
