video1.0<iframe src="https://www.loom.com/embed/861a290d9380496abe6a423cfdde6f94" frameborder="0" width="1280" height="960" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>9601280Loomhttps://www.loom.com9601280https://cdn.loom.com/sessions/thumbnails/861a290d9380496abe6a423cfdde6f94-42da2212e45886c6.gif288.604983In this tutorial, we’ll walk you through building a custom query from scratch to perform a period-over-period comparison of key performance indicators, specifically focusing on accommodation revenue from a portfolio perspective. You’ll learn how to select the right data topic, utilize AI-assisted tools to populate and customize your query with essential fields, and set up year-over-year comparisons using appropriate filters and date ranges. Additionally, we’ll show you how to add variance calculations to highlight performance differences and format your data for clear and easy understanding. By the end of the video, you’ll have a comprehensive query that effectively tracks and analyzes your portfolio’s performance, empowering you to make informed decisions with confidence.