Databases Reference
In-Depth Information
General Merchandise Inc. BI Portal
YTD Budget Comparison
Revenue by Region
Group
Actual
Budget
Variance
AA
$87,030
$88,771
2%
Western
Region
10%
National
Accounts
6%
BB
$149,195
$159,638
7%
CC
$74,597
$75,343
1%
DD
$111,896
$107,420
−
4%
Eastern
Region
28%
Southeast
Region
21%
EE
$273,524
$265,318
−
3%
FF
$161,628
$163,244
1%
GG
$49,732
$48,737
−
2%
HH
$111,896
$105,182
−
6%
II
$87,030
$84,419
−
3%
Midwest
Region
35%
JJ
$136,762
$138,130
1%
Revise Forecast
Vendor Purchasing
Check Industry News
Zippy Manufacturing
Worldwide Stuff
Warm Homes
Sales Rep Performance
Top 10 Sales Reps YTD Sales
Sports Galore
Shoes Shoes Shoes
Patriotic Gear
Rank
Sales Rep
YTD Sales
1
Mark Emerson
$5,938.37
Pack Your Bags Travel
2
Ralph Polovich
$4,948.64
Office and School Inc.
3
Patricia Pete
$3,958.91
Making Good Stuff
4
Ryan Bernard
$3,629.00
5
Michael Stevens
$3,299.09
$2,969.18
Fill Your Pantry
6
Leah Barns
Everything Entertainment
7
Debbie Meadows
$2,969.18
Enviro Electronics
8
William Watts
$2,639.27
Dream Homes
9
Kate Mitchell
$1,649.55
10
Barbara Hand
$989.73
Clothes For All
Applicances
$0
$10,000
$20,000
$30,000
Sales
Year Ago September
September
Figure 11-3
Sample BI portal
Charts or graphs:
These are another common type of data presentation.
These may be bar charts, pie charts, line graphs, or scatter charts. A
graphical display of results helps to easily identify anomalies and outliers.
This can help you to quickly hone in on areas for further research.
Maps:
These are another visual method to quickly convey data. They
may be color-coded based upon selected data or bars may rise from
the geography to indicate the value of the business measurement. For
example, maps can be colored or coded to highlight concentrations of
customers or to indicate areas where insured property is located.
Scorecards:
These are the display of key performance measures in a
''report card'' manner. These key measures are calculated and compared
to target values as a means of determining how well the organization
