Over the next three days I will share 3 free APIs that you can tap into to get data that you can use to make you RM analysis more robust. In this video I explain what an API is and how to automate the process of extracting weather data from http://openweathermap.org/ into Excel using Web Queries. This video is from a free webinar I conducted last year on data APIs for RM. Many RMS systems charge you to get this data but I will show you how to get it for free.
You can sign up for this API here and you can also learn how to create an API call URL for your city. Be sure to sign up below for blog updates so that you can get part 2 and 3 of this series and announcements about future free webinars. Next API will be for exchange rates.
Note: Some of you may be unable to access public APIs because of a corporate firewall setting. Be sure to consult with your IT team if the process shown here does not work for you.
To learn more about useful Excel tricks for RM, consider our inexpensive Excel for Hotel Data Analysis course.
Don't Miss the Next Revenue Discovery Insight. Subscribe Now
Robert Hernandez, Statistical Analysis and Data Mining for Revenue Growth Robert is an expert in the field of mathematical Hotel Optimization and Analytics. He has spent the last 17 years building data-driven forecasting and optimization models for companies in over 20 different industries, from tech to tourism. Robert possesses a very unique skill set including cross-disciplinary experience, advanced mathematical and analytics skills, data transformation, industry-specific knowledge and business-process improvement expertise. Robert began his career at the Walt Disney Company in Revenue Planning. Read More+