Simple STR Reporting in Tableau.
Understanding how to manipulate, and visualize this data is crucial for making informed business decisions.
What is a STR Report?
STR (Smith Travel Research) report provides critical performance data for the hospitality industry.
These reports can be Imported to your PC in various formats, including PDF, CSV, or Excel sheets.
Sections of the STR Report "this is Excel forma version"
1) Table of Contents Page
Just introduction page with STR company Information, and hyper links to navigate the report, also you have tabs for each sheet named accordingly
Second Page
YTD and Year Sections of the STR Report
The report is divided into two main sections:
Group 1: Your hotel property
Group 2: Selected properties (competitors)
Sheets in the Workbook
When you export the report, it will include multiple sheets, such as:
Table of Contents
Worksheets Tabs
YTD and Year
By Month
% Change
Moving Avg.
Day of Week
These sheets compare “Group 1” (your hotel) against “Group 2” (selected properties or competitors). Both groups are displayed under the same columns, so we need to separate them.
Step 2: Reshaping the Data
To analyze the data effectively in Tableau, you need to reshape it. There are two ways to achieve this:
Method 1: Manual Data Table Creation
Understand the Structure: The first two rows in the report contain merged cells across columns A to I.
Unmerge and Add Colum
n Names: Copy the column names and add them to each group as needed.
Separate Data by Groups:
Ensure data for Group 1 and Group 2 are in distinct columns.
Reshaped Data
