Databases Reference
In-Depth Information
Besides these requirements, there is a need to further analyze the data. While
the workshop and interviews weren't conclusive about the exact analytics
requirements (they rarely are), there was consensus that at least the following
areas should be investigated:
• Trend analysis of the number of flights, transported passengers, freight, and
mail through time
• Top 10 routes based on the number of flights, enplaned passengers, freight,
and mail
• The number of passengers versus available seats (Load Factor %) across
flight types
• The relationship between transported passengers, mail, and the number
of flights
In addition, the current metrics currently shown on the
Dashboard
sheet should be
moved to the new analysis section.
It was also decided that the following two reports should be available:
• Aggregated flights per month
• KPIs per carrier
Creating the Analysis sheet
The first sheet we will create is the
Analysis
sheet; as the current
Dashboard
sheet
already contains a few of the metrics that we want on that sheet, first, let's change the
name of the sheet from
Dashboard
to
Analysis
:
4.
Right-click anywhere on the sheet workspace and choose
Properties
.
5.
Navigate to the
General
tab and enter
Analysis
in the
Title
input field.
6.
Click on
OK
to close the
Sheet Properties
dialog.
While we're at it, rename the
Main
sheet to
Associations
. This sheet will help
users to find associations on the data across many different fields. We might need to
reposition the listboxes to fit our new layout.