Excel and SQL for Hotel Data Analytics

Excel and SQL for Hotel Data Analytics
Self-Paced, Online Training Course

Turn raw PMS/POS data…

into hotel analytics in seconds.

You, the Excel Power User for your hotel.

One of the most important assets that any hospitality company can have is an Excel Power User. Everyone, regardless of the department, turns to them for answers when they have an Excel question. They are the person who is called upon by Marketing to extract and clean a customer list and by the GM to do special analysis. This is the person who can take raw information, like PMS and POS data, and turn it into beautiful, intelligent Excel reports in minutes.

There are two kinds of Microsoft Excel users in the hospitality business: Those who make neat little tables, and those who amaze their colleagues with sophisticated charts, data analysis, and seemingly magical formulas. From analysts to administrative assistants, anyone can be their hospitality company’s Excel Power User. Most important, whether you work for a major brand or an independent, all Excel Power Users have job security and career prosperity.

Why you need this training?

Excel continues to be, by far, the most popular platform for intelligence discovery and information dissemination in the hospitality business. That is why every hospitality company needs an Excel Power User. The skill set taught in this course is applicable to every department, from Engineering to Marketing to Finance to Revenue Management.

This course will turn you into the Excel Power User for any hotel. This training is for Excel users who know the basics but need to master the process of manipulating data to create advanced reports and analysis. It is the only course ever offered that uses real PMS/POS data to teach Excel tools and techniques.

“This Excel course taught me useful insights on how to look at real-live data from any PMS. Not only can I now make better use of historical data, but I can do a variety of analysis that allows me to optimize revenue. With Robert’s professional way of explaining the course material during the different modules, this became the optimal way of understanding the material and allowing me the opportunity to practice on my own.”
Nicolas Heeger, Director of Revenue Management

This training is specifically designed for hotel professionals who want to reach the Power level of Excel skills.

The failure of many Excel training courses is their inability to connect tools and techniques to on-the-job scenarios. In this course you will only work with data, examples and exercises that are hospitality industry specific. The entire course is then taught using OWL’s proprietary PMS data file. This course focuses on the tools and techniques that are required for you to be successful at manipulating raw data and converting it into actionable intelligence.

“I can’t begin to tell you how engaging your courses are. I oversee two independent hotels and I’m somewhat left to my own devices when it comes to tools and guidance. Needless to say I have a number of Excel workbooks I have built on my own by extracting PMS data and so far these courses have shed new light on how I can improve them and my thought processes.”
Mark Grossman, Area Director of Revenue Management

Learn how to turn data files or extracts from any system into valuable information. In this unique course you will learn by watching the instructor actually perform every operation step-by-step using PMS/POS data and real-life examples. Learn to extract insights that lead to innovative plans and brilliant decisions. Create reports that impress and get you noticed.

Becoming Excel Power Users right now are:

robert-hernandez

Learn from a Seasoned Hotel Data Analyst and Excel Power User

Hi I am Robert Hernandez and I want to teach you everything I know and help you avoid all of the mistakes that I have made. It took me 15 years of learning Excel the hard way and 10 years doing analysis for every department in the hotel business to become an Excel Power User in the hospitality industry. In this course I have condensed everything you need to know into 6 hours of easy training. I teach you the skills that you will use every day and don’t waste your time with stuff that is never used.

I am expert in the field of Mathematical Optimization and Analytics. I have spent the last 17 years building data-driven forecasting and optimization models, mostly in Excel, for companies in over 20 different industries, from tech to tourism. I have a very unique skill set including cross-disciplinary experience, advanced mathematical and analytics skills, data transformation, industry-specific knowledge and business-process improvement expertise. I began his career at the Walt Disney Company in Revenue Planning. Read More+

Get Excel Power User Skills
in just 9 hours

Course registration includes all modules and materials. Personalized instructor support, Certificate of completion. 100% Money-back guaranteed.

$49.00Add to cart

You will learn:

Transforming Raw Data – Importing PMS/POS/GL exports – Error Functions – Text Functions – Join and Logic Functions – Date Functions Rounding Functions
Excel_a

Great Spreadsheet Design – Data Validation – Conditional Formatting – Macros Security – Spreadsheet Reports Design Do’s and Don’ts
Excel_d

Granular Analysis of Data – Criteria Functions – Nested Functions – Lookup Functions – Array Formulas – Creating Advanced Formulas

Pivot Tables and Charts – Table Multisort – Multi-dimension and OLAP – Creating Pivot Tables – Pivot Table Calculations – Pivot Charts
Excel_c

Working with Raw Data – Relational Data – Creating Data Tables – Manipulating Data Tables – Excel Table Referencing – The IF function
Excel_b

Bringing PMS/POS Data into Excel – Working across Excel files – Get live data from a database – Get data from the web – Get data from an Excel file – Automating data retrieval

Ready to become a Power User?