Datasheet

Each box in this dashboard layout mockup represents a component on the
dashboard and its approximate position. The questions within each box
provide a sense of the types of data required to create the measures for the
dashboard.
Catalog the required data sources
When you have the list of measures that need to be included on the dash-
board, it’s important to take a tally of the available systems to determine if
the data required to produce those measures are available. Ask yourself the
following questions:
 Do you have access to the data sources necessary?
 How often are those data sources refreshed?
 Who owns and maintains those data sources?
 What are the processes to get the data from those resources?
 Does the data even exist?
What is the overall trend for the last two years?
Which are the
top 10 months?
What is the % breakout of service offering?
Which are the
bottom 10 months?
What is the quarterly
trend for Tent
Campers?
What is the
current month’s
revenue by
service
offering?
What is the quarterly
trend for RV
Camper?
What is the quarterly
trend for Backcountry
Campers?
What is last
year’s
average
revenue by
service
offereing?
What is the
variance
between
average
revenue
last year
and the
current
month’s
revenue?
What is the quarterly
trend for Concessioner
Lodging?
Figure 1-3:
Each box in
this
dashboard
layout
mockup
represents a
component
and the type
of data
required to
create the
measures.
14
Part I: Making the Move to Dashboards
05_228142 ch01.qxp 1/24/08 9:17 PM Page 14