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.

Add Data Columns to the Report

On the Criteria tab, the regional manager adds the following columns:
  • Property Details/Chain Code

  • Property Details/Property

  • Dates/Business Date Calendar/Year

  • Room Details/Occupied Rooms

  • Revenue Details/Room Revenue

Add Filters to the Report

On the Criteria tab, the regional manager adds the following filters:
  • Chain Code (prompted)

  • Year (prompted)

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, select the visualization for the line-bar graph to show the Total Room Revenue Comparison with Occupied Rooms.