All modules / Data, Excel & Analysis
Module 004 · Go deeper
Answers you can defend, and a report that rebuilds itself
Duration
4 hours
Format
Half day, on-site
Audience
Anyone who builds or reads the same report every month
About the module
Every hotel runs on spreadsheets: occupancy and RevPAR by month, channel performance, F&B covers, guest scores. Getting a decision out of one takes hours, and rebuilding the same report every month takes hours more. This workshop covers both jobs, individually, on a real hotel workbook or one from your own property: interrogating the numbers until you have an answer you can defend, then building the report that produces itself. Each half closes on what you can connect next, from the systems that feed the spreadsheet to the tools that do this work for you.
Who it is for
Anyone who builds or reads the same report every month, across revenue, finance, operations, F&B and front office, from the people who prepare the numbers to the leaders who act on them.
Learning objective
Use AI to interrogate a hotel spreadsheet and reach a defensible decision, automate the report you rebuild every month, and judge which data sources and tools are worth connecting next.
Bring this module to your team
Tell us who would be in the room and what they work on. We will suggest how to run it, on its own or with other modules.
What you will do
Frame a data question: why it matters, what to find out, and what a good answer looks like
Prepare a hotel workbook so AI reads it correctly, with guest data handled properly
Interrogate occupancy, RevPAR, channel and guest-feedback data in plain language
Catch the five ways AI gets a number wrong, before that number reaches a decision
Turn a finding into a one-page recommendation with its confidence stated
Automate the processing behind a recurring report: cleaning, joining and aggregating raw exports
Build and stress-test a report that rebuilds itself, then hand it to someone else
Judge which systems and tools are worth connecting, and when a spreadsheet has outgrown the job
Lessons
2 parts · 4 hours in total
Section 004-1 · 120 min
AI-Assisted Data Analysis
Watch a plain-language question about a hotel workbook produce a confident, well-formatted, wrong answer, then take it apart. Each stage is taught, demonstrated live on the same workbook, then run by each participant on a question of their own, through Frame, Prepare, Analyse, Check and Deliver. Closes on the tools that read a spreadsheet directly and the exports your PMS, RMS and POS will already give you.
You leave with: A verified one-page recommendation on a question from your own property, the five-stage workflow that produced it, and a shortlist of data worth pulling next.
Section 004-2 · 90 min
AI-Assisted Report Automation
Start from a finished, automated hotel report, then take it apart and build your own. Four stages, each taught and then run on a report you actually produce: Plan, Process, Present, and Schedule & Test, with the cleaning, joining and aggregating written as a plain-English recipe that AI runs every month. Closes on the ladder from an AI recipe to the same recipe in Excel or a database to a live connection, and on the tools that do this natively.
You leave with: An automated version of your most repetitive report, tested against a messy file, with handover notes so someone else can run it.
What you leave with
A data workflow you can repeat
Frame, Prepare, Analyse, Check and Deliver, with a prompt for each stage and a review built to break a wrong number before it reaches a decision.
A decision-ready one-pager from your own numbers
Built in the session on a question from your property, with the finding, the recommendation and the confidence stated.
A report that rebuilds itself
Your most repetitive report, with its data processing automated, tested against a messy file, and written up so a colleague can run it without you.
A map of what to connect next
Which of your systems will feed the spreadsheet, which tools do this work natively, and the point at which the job belongs in a reporting tool instead.
How we tailor it
Run on the organisation’s own reports and workbooks, with a prepared hotel pack for anyone without data to hand.
The report automated is one the team already rebuilds by hand every month.
The next connections discussed are the systems the property already runs.
Included in
Packages
Included
Example programmes
Included
Included
Included
Next step
Plan Data, Excel & Analysis for your team
Every module is a half day on-site, fitted to your AI tools, your documents and your policy before it runs. Or email singapore@horwathhtl.com.
Upcoming dates. Public dates to be announced. Contact us to arrange a workshop for your team.