Hotel Report Tutorial: Regional Managers Property Performance

This topic provides an example walkthrough of how a regional manager can design and create an analysis report to address a business need.

Identify the Data Shown by the Report

A regional manager wants a visualized comparison of property revenue and performance across all properties in the region. To determine the data to be shown by the report, the regional manager conceptualizes the information needs and decides that for each property, the report should include:

• The total room revenue.

• The total number of occupied rooms.

Identify the Subject Areas

Identify the subject areas that contain the columns and attributes required for the report. In this example, the Statistics-Managers Report subject area contains every column required for creating this report.

Figure 19-12 Statistics-Managers Report Columns

Add Data Columns to the Report

On the Criteria tab, the regional manager adds the following columns:

• Property Details/Chain Code

• Property Details/Property

• Calendar Period/Year

• Room Details/Occupied Rooms

• Revenue Details/Room Revenue

Figure 19-13 Selected Columns for the Property Performance Report

Add Filters to the Report

On the Criteria tab, the regional manager adds the following filters:

• Chain Code (prompted)

• Year (prompted)

Figure 19-14 Selected Filters for the Property Performance Report

Add Visualizations to the Report

On the Results tab, the regional manager begins adding and configuring the report layout and style. To set up a line-bar graph to show the Total Room Revenue Comparison with Occupied Rooms, the regional manager maps the data columns as shown in the following image:

Figure 19-15 Total Room Revenue Comparison with Occupied Rooms Graph Customization