MicroStrategy Dynamic Enterprise Dashboards Folio BOOKSTORES
Year to Date Sales Review December 31, 2006
YEAR TO DATE SALES SUMMARY 2006 Monthly Revenue
$400,000
Revenue
Mid-Atlantic Southwest Northeast Southeast Central West Northwest South
$680,700 $545,600 $407,800 $381,200 $301,600 $291,300 $247,100 $243,900
Prentice Hall
$200,000 $100,000
DEC
SEP
OCT
NOV
JUL
AUG
JUN
APR
MAY
$0
16.9% $523,765
26.8% $830,585
26.2% $811,991 30.1% $932,859
Revenue by Region Mid-Atlantic Southwest Northeast Southeast Central West Northwest South
$3,099,200
TOP SELLING PRODUCTS (ITEM) 100 Places to Go While Still Young at Heart Foundation Analysis and Design Working with Emotional Intelligence
TOTAL
McGraw Hill
$300,000
$3,099,200
Month
Revenue by Supplier
$500,000
JAN
$149,500 $137,200 $210,400 $244,800 $353,500 $387,500 $125,800 $218,700 $225,600 $256,000 $300,100 $490,100
FEB
Revenue
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
MAR
Month
$0
$200,000
$400,000
$600,000
Bantam Books
Simon & Schuster
Supplier Detail
Sales Representative Analysis
$800,000
UNITS SOLD
UNIT PRICE
REVENUE
3,200 1,400 5,600
$552 $810 $228
$147,200 $113,400 $106,400
10,200
$1,590
$367,000
Powered by
If you can imagine it, MicroStrategy Dynamic Enterprise Dashboards let you see it
$3,850
Dental
5/1/2006
$17,275
5/10/2006
Medical
$6,400
5/15/2006
$3,515
Personal - Vacation
5/15/2006
$11,235
Medical
5/19/2006
Personal - Vacation
5/15/2006
$2,200
Dental
Field Sales
Central Region
7/5/2006
7/14/2006
Personal - Vacation
5/20/2006
$6,500
401k
Field Sales
Central Region
8/24/2006
8/31/2006
Personal - Vacation
5/31/2006
$5,300
Medical
6/5/2006
$560
Field Sales
Central Region
10/6/2006
10/23/2006
Dave Moran
Development
Central Region
7/14/2006
Hugo Martinez
IT
Central Region
Carrie Porter
Human Resources
Central Region
5/28/2006
6/5/2006
Personal - Vacation
Mike Douglas
IT
Central Region
6/22/2006
6/28/2006
Personal - Vacation
401k
0%
10%
20%
-10%
0%
10%
20%
Region
Subcategory
Revenue
Forecast
% Variance
Profit
Mid-Atlantic
Audio Equipment Cameras Computers Electronics - Miscellaneous TV’s Video Equipment Total
$58,010 $136,460 $16,065 $28,690 $35,897 $95,220 $370,372
$57,817 $110,710 $14,781 $29,723 $30,699 $85,711 $329,471
0% 23% 9% -3% 17% 11% 12%
$15,354 $37,400 $4,372 $7,853 $9,822 $26,259 $101,060
30%
Dental
6/5/2006
$1,420
Vision
6/10/2006
$2,500
Vision
Ja n 06 Feb 06 ar 06 M
06
06 06 06 06 06 06 06 06 06 l g n v ay Ju Ju Au Sep Oct No Dec M
pr
A
Audio Equipment Revenue
Cameras Revenue
Monthly
TV’s Revenue
Quarterly
Mid-Atlantic
Quarter
19.0%
30%
2006 Q4
2006 Q4
-10.7%
Southwest
19.6%
-10%
SUBCATEGORY PERFORMANCE BY 16.3%
Northwest
-5.7%
$0K
Regional Revenue Performance
-4.8%
South
15.1%
401k
Personal - Vacation
7/16/2006
5/12/2006
Gordan Leigh Shannon Bryant
Thomas Jones
8.7%
Central
-8.3%
$10K
Variance
Forecast
% Variance
$13,653 $35,352 $4,176 $7,956 $8,914 $28,060 $98,141
12% 6% 5% -1% 10% -6% 3%
Northwest
$200K
Northeast
$160K
West
$120K
Central Southeast Mid-Atlantic South
$80K $40K $0K
Southwest
06
5/1/2006
Southeast
10.0%
Revenue Forecast
06
Dental
Revenue
$437,311
2006 Q4
ec
Powered by
Medical
$6,550
South
2006 Q3
ov
$367,000
$15,230
26.6%
2006 Q2
D
$1,590
4/28/2006 4/28/2006
Northeast
-9.1%
2006 Q1
N
10,200
Dental
$0
$446,027
Electronics Miscellaneous
06
$147,200 $113,400 $106,400
Vision
$0K
06
REVENUE
$552 $810 $228
$800 $6,000
$20K
Computers
$100K
p
$800,000
UNIT PRICE
4/15/2006 4/19/2006
Northwest
TV’s
$200K
ct
$600,000
3,200 1,400 5,600
Vision
$30K
$300K
$400,000
$572,873 $545,079
O
TOTAL
$400,000
UNITS SOLD
$1,100
Video Equipment
$400K $800,000
$725,008 $654,417
Web Central
Se
$200,000
4/5/2006
$882,325
Northeast Southeast
6
12
Southwest
06
10
-15.8%
ug
8
$154
less than -5%
Profit Variance vs. Forecast
$40K
A
6
9.5%
between -5% and 10%
06
4
$ 118
more than 10%
l0
10
$130
Region
n
8
108
Poor (below the target)
$50K
Ju
6
l Good (above the target)
Revenue Variance vs. Forecast
06
Sales Representative Analysis
4
LEAVE OF ABSENCE $0
401k Vision
06
Supplier Detail
2
On target
Medical
ay
0
Avg Revenue per Customer
Status:
Medical Vision
$4,800 $2,750
Ju
East
Field Sales
100 Places to Go While Still Young at Heart Foundation Analysis and Design Working with Emotional Intelligence
$5,800 $23,000
3/31/2006 3/31/2006
M
Central
HR
Simon & Schuster
Vision
$12,568
3/1/2006 3/15/2006
Corporate
Marketing
Bantam Books
401k
$2,370
2/28/2006
06
Mid-Atlantic Southwest Northeast Southeast Central West Northwest South
$3,550
2/27/2006
$500K
pr
IT
30.1% $932,859
Revenue by Region
Regional West
Quarterly
$60K
Cameras
$600K $1,200,000
Monthly
$70K
$700K $1,085,630
A
Departmental Finance
$1,600,000
REGIONAL REVENUE HIGHLIGHTS Mid-Atlantic
06
6.6%
ec
-28.8%
9,380
D
$85
23.6%
6
-17.7%
8,091
06
26.0%
$74
10,000
06
17,000
$61
8,300
ct
64.5%
$108
Customer Count
ov
13,020
Avg Revenue per Order
401k
Audio Equipment
O
Order Count
Vision
$6,010
Transactions Per Customer
Product Revenue
Quarterly
N
Medical
$1,315
# Customers
Monthly
$800K
06
21,420
$15,625
Revenue Performance
$2,000,000
06
22,919
2/5/2006 2/1/2006 2/12/2006
Actuals (K$) Forecast (K$) Variance Status 6,179 6,365 6% 1,798 1,708 5%
Revenue Profit
06
-5.7%
l0
-1.1%
34,047
p
24.4%
40.9%
ug
-0.4%
22,800
Ju
24.2%
32,122
Se
-11.3%
24.1%
26,661
Electronics
Profit Margin
A
EMPLOYEE COMPENSATION CLAIMS
26.2% $811,991
$3,099,200
$ 352,001
20.0%
Units Sold
Profit
06
DEC
NOV
JUL
OCT
JUN
SEP
AUG
JAN
FEB
APR
16.9% $523,765
26.8% $830,585
$0
34.8%
Margin
Dental
2/15/2006
$100,000
$ 231,740
Profit
Dental
$3,000
Category
USA
Revenue
b
Dec
$ 312,376
Medical
$7,875
MOVIES REVENUE QUARTERLY TRENDS
ar
Nov
$ 346,737
$18,250
1/31/2006
ELECTRONICS
FINANCIAL HIGHLIGHTS
Fe
Oct
-10.3%
M
Sep
% change from TM LY
06
Aug
$ 1,445,116
06
Jul
This Month LY
35.4%
n
Jun
% change from LM
$ 957,865
Ju
May
Last Month
$ 1,296,667
06
Apr
This Month
$ 1,387,434
06
Mar
Target
Revenue
06
Feb
Operational KPIs
1/20/2006
$0M Jan
Trend
b
Prentice Hall
$200,000
Status
1/31/2006
$5M
McGraw Hill
$300,000
Vison 401k
ay
$400,000
$1,600 $3,450
n
$1.5M
BOOKS
SELECT CATEGORY
1/1/2006 1/7/2006
ar
Revenue by Supplier
$1M
TOP SELLING PRODUCTS (ITEM)
Country
Benefit Costs
Total
M
$680,700 $545,600 $407,800 $381,200 $301,600 $291,300 $247,100 $243,900
Vision
n
Mid-Atlantic Southwest Northeast Southeast Central West Northwest South
Dental
2006 Budget
Ja
Revenue
CATEGORY SALES AND PROFITABILITY
December 2006
pr
Monthly Revenue
$3,099,200
Month
2006 Actual
$2M
$500,000
MAY
$149,500 $137,200 $210,400 $244,800 $353,500 $387,500 $125,800 $218,700 $225,600 $256,000 $300,100 $490,100
MAR
Revenue
OPERATIONAL PERFORMANCE SCORECARD
A
Medical
2005 Actual
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Powered by
Ja
EMPLOYEE CLAIMS
YEAR TO DATE SALES SUMMARY 2006 Month
PRODUCT PERFORMANCE
Human Resources Dashboard - Benefits Last Updated on 12/31/06
December 31, 2006
Fe
Year to Date Sales Review
M
Folio BOOKSTORES
Mid-Atlantic Revenue
If you can imagine it, MicroStrategy Dynamic Enterprise Dashboards let you see it
Customer Segmentation and Profitability
Customer Analysis
Human Resources Analysis Select a Quarter
Acquisition, Attrition, and Retention Performance Summary:
Demographics Selector Gender
Male
<<
Female Lost Owner
Marital Status
Single
Married
Divorced
Lifetime Value
High
Medium
Low
High School
Undergraduate
Graduate
Education Age Range
< 21
Income Range
for each category
New Active Acquisition Customers Customers Rate
278 100
21-40
0-20K
Number of Customers
Use the Demographics
41-60
21K-40K
41K-60K
300
500
Oct 2006 Nov 2006 Dec 2006
120
3
1 Top Categories
Acquisition and Attrition by Quarter Acquisition Rate
Movies 39%
Attrition Rate
25%
Carole Vorndran
9/26/2006
$47.64
8/22/2006
$35.40
2/3/2006
15%
Melanie Searles Monica Neptune Mai Normandin Iris Vaughn
1/14/2006 12/15/2005
$54.20
1/9/2006
$66.09
8/12/2006
$127.27
8/17/2006
Q4
Iris Zeller
Q3
6/29/2003
Q2
2/3/2006
$84.34
2006
11/23/2005
$120.23
Q1
7/12/2006
$32.86
Conrad Hughes Jan Taylor
2006
$29.87
Detyne Ferber
0% 2006
5%
2006
Enzo Cutting
$86.79 $104.86
$139.06
10/26/2005
Carole Robison
$93.73
10/8/2005
Amanda Vince
$28.32
9/16/2005
2.7
6%
Acquisition Rate
2006 Q2
2006 Q3
Average Revenue Per Customer
< 21
$50
$0
Retention Rate
1,299 1,333 1,363
97.00% 96.85% 97.07%
Quarterly Retention Plan 1400
2%
1200
2% 1%
Lost Customers Attrition Rate
1%
8
Income Range
60%
800
Retained Customers Retention Rate
600
40%
0
0%
2006 Q1
2006 Q2
2006 Q3
2006 Q4
20%
200 0
0%
2006 Q1
2006 Q2
2006 Q3
21-40
$100
41-60
$58
Profit $
0 - 20K
$41,183.10
$298.43
$686.39
$2,428.18
$54,498.44
$465.80
$1,028.27
$3,538.64
40K - 60K
$23,178.17
$246.58
$551.86
$1,406.37
60K - 80K
$51,844.68
$518.45
$1,205.69
$3,091.98
$23,783.53
$247.75
$540.53
2006 Q4
#
%
20
21%
Hiring
62
82%
Departures
20
100%
Voluntary
16
80%
4
20%
New - 5 Years experience
Trend
8%
70
7%
60
6%
50
5%
40
4%
30
3%
20
2% 1%
44
74%
32
52%
10
Vacant Positions
10
13%
0
9
90%
#: Number of Employees
$46,635.75
$376.09
$790.44
$2,960.92
$33,312.13
$350.65
$812.49
$1,717.86
40K - 60K
$49,186.10
$341.57
$768.53
$2,762.07
60K - 80K
$37,477.31
$312.31
$749.55
$2,324.83
> 80K
$23,826.98
$187.61
$458.21
$1,375.57
0 - 20K
$44,158.71
$304.54
$679.36
$3,219.34
20K - 40K
$55,093.39
$326.00
$734.58
$3,345.29
40K - 60K
$43,422.04
$269.70
$578.96
$2,455.90
60K - 80K
$43,336.86
$390.42
$866.74
$2,736.80
> 80K
$33,851.87
$266.55
$573.76
$2,136.33
Customer Support Analysis
2006 Q1
2006 Q2 Departures
%: % of Total Employees
2006 Q3
2006 Q4
Employees
2007 Q1
0%
Northeast $352,381 (12%) Southeast $414,246 (13%)
Trade Shows $443,999 (14%)
Magazines $597,556 (19%)
Bundling $140,931 (4%)
Mid-Atlantic $637,301 (20%)
Central $22,305 (7%)
Web Banners $1,806,142 (57%)
South $254,920 (8%)
Northwest $955,952 (30%)
Other $77,325 (2%) Direct Mail $38,318 (1%)
$300,000
Hires by Recruitment Source
$250,000
Hires by Education Level
$200,000
0 - 20K
25%
23.0% 20.6%
22.1% 16.0%
Advertisement
28%
60K - 80K
17%
Internal Referral
4 - Year College
11%
Better Opportunity
Reasons
50%
Head Hunter
28%
28%
Other
Master’s Degree
1715
7.63%
1837
Central
167
8.51%
1645
South
165
8.06%
1742
Southeast
125
5.98%
Southwest
144
7.15%
Online
147
7.29%
Northeast
148
7.66%
$50,000
Total Cases Opened this Month: 1,182
Top 5 Engineers with Highest Case Load (This Month)
Feb 06
Mar 06
Revenue
Apr 06
May 06
Jun 06
Jul 06
Aug 06
Sept 06
Oct 06
Marketing Cost Powered by
Nov 06
Dec 06
1764 1730 1717 148
Mark O’Dea
Normal
High
Top 5 Customers with Highest # of Critical Cases Currently Open WebMarker Inc.
Kim Marshalls
Westminster Corp
Total Cases Closed this Month: 329
Dakota Knowles
PowerNet Solutions
Total Engineers: 87
Shannon LeGros
Jose Martinez
Markham Tech Pearson Comm. 0
20
40
60
80
100
120
0
2
Cases
YTD
New Customers (This Month)
$0 Jan 06
Powered by
Total # Cases Open: 2,164
YTD Case Load
MTD Case Load
Low
New Customers (YTD): 59
$150,000
2 - Year College
50%
> 80K
Document Author: John Smith
39%
$100,000
25% Personal
40K - 60K
18.4%
Relocation
20K - 40K
6.25%
162
Case Load: 180
Printed Collateral $77,415 (2%)
Attrition Rate
2006 Q3
Reasons for Departure
Increase in Case Load vs TMLY
124
Monthly Case Load
Northwest
Total Marketing Expenses
Southwest $318,650 (10%)
(as of Dec. 12, 2006)
Cases Opened (This Month)
Region
United States
Mid-Atlantic
80
Female Hires Offers Out
Finance Country
(All)
Revenue vs. Marketing Cost Customer Distribution by Income Range
$1,479.12
0 - 20K 20K - 40K
Document Execution Time: 12/29/2006 9:48:25 AM
Attrition
SELECT QUARTER Revenue per Customer $
Manufacturing Product Category
Compensation Summary
Note: % Lost to All Lost is calculated as # Lost Customers at the month level divided by # Lost Customers in the analyzed period.
Avg Transaction Size $
20K - 40K
> 80K
$75
Revenue $
Sales
2006 (YTD)
Regional Marketing Expenses
KPIs
Non-voluntary
80%
1000
400 0%
4
2006 Q4
100%
Customer Analysis by Age Range and Income Range Age Range
$25
Active Customers
1,260 1,291 1,323
16
0%
2006 Q1
Retained Customers
28.00% 32.00% 40.00%
12
2%
0
% Lost to All Lost
0.54% 0.60% 0.73%
20
Note: % New to All New is calculated as # New Customers at the month level divided by # New Customers in the analyzed period.
Most Recent Transaction
$78.14
Dominick Oneill Hector Pelino
Books 28%
Revenue
Cleatus Kristick
20%
10%
5
List of Customers Customers
New Customers
4%
40
Attrition Rate
24
8%
60
4
1,299 1,333 1,363
28
10%
20
Electronics 33%
7 8 10
Attrition/Hiring Summary
Retention
Quarterly Attrition Trend
80
> 80 2
Lost Active Customers Customers
32.23% 34.71% 33.06%
12%
100
> 80K
% New to All New
3.00% 3.15% 2.93%
140
Other
61K-80K
1,299 1,333 1,363
Quarterly Acquisition Trend
Average Number of Transactions Per Customer
61-80
39 42 40
Headcount Summary
0.62% Attrition Rate, and 96.99% Retention Rate Attrition
Marketing
Time Period 2003
Q4 2006
Attrition Rate
Active Renter
3.01% Acquisition Rate, Acquisition
selector to specify values
Status Household Type
HR
Cross-sell Analysis
Year-to-date Analysis
Quarterly Customer Analysis for Q4 2006
# of Employees
Quarterly Analysis
Customer Analysis Summary 2006
1. GlobalTech Corporation 2. Spire Communications, Inc. 3. Creations Software and Firmware Solutions 4. Chain Bridge Financial Corporation 5. BlueNation Technology Concepts 6. Cocoa Brands, Inc.
Last Year
Support Level Bronze Gold Platinum Gold Bronze Platinum
4
6
8 12010
12
Cases
Total Open Cases
Open Critical Cases
Top 5 Most Frequently Accessed Technical Notes 1. #2463 How to Log Into the MicroStrategy Web Interface 2. #7846 Changing Your Project’s Name 3. #9867 Streamline Your Metadata Objects 4. #9267 How to Best Manage Narrowcast Server 5. #1837 The Benefits of Command Manager
14
Dynamic Enterprise Dashboards
A Dynamically Integrated View of All Corporate Data
A New Caliber of Information Dashboards
MicroStrategy’s Dynamic Enterprise Dashboards enable business users to intuitively flip through many different MicroStrategy Dynamic Enterprise Dashboards deliver a new caliber of information dashboards. MicroStrategy combined state-of-the-art data visualization and interactivity with its industrial-strength business intelligence platform to create
perspectives of corporate performance without ever leaving the dashboard, allowing them to quickly and easily identify problems and diagnose root causes. Dashboard designers can combine data from a variety of data sources onto a single dashboard, providing the user with multi-disciplined, multi-dimensional performance feedback on every dashboard.
dashboards that yield greater business insight and are usable by more people than ever before. Dashboards provide easyto-use access to enterprise data and help organizations track performance and optimize decision-making. At-aglance, executives, managers, and business users can immediately
understand
their
organization’s
health
through a range of insightful data visualizations such as key performance indicators (KPIs), tables, graphs, trend indicators,
Visually Engaging Dashboards By incorporating Adobe® Flash®, MicroStrategy dashboards offer innovative new ways for users of all skill levels to derive insight from their data. The dashboards are highly responsive to users, providing a wide range of information views and increased information exploration options through the unique features of Flash. MicroStrategy Flexible Rendering Architecture lets each user determine whether a dashboard or report is best presented in thin-client AJAX mode or interactive Flash mode.
gauges, heat maps, and many more. MicroStrategy’s Dynamic Enterprise Dashboards help align organizations through common goals and common metrics, where each person can see his contribution to achieving overall company performance.
Portable, Self-contained Dashboards Flash rendering allows MicroStrategy users to create self-contained dashboards that include full interactivity, visualization functionality, and data content. Users can interact with their dashboards on planes, present their dashboards in meetings, or analyze corporate performance at any location regardless of network connection availability.
State-of-the-Art Data Visualization and Interactivity Delivered on the MicroStrategy Industrial-strength Business Intelligence Platform
Deeper Business Insight via Advanced Visualizations
An Integral Component of the MicroStrategy 8 Platform
MicroStrategy includes a new library of advanced visualization “widgets” built using the Adobe® FlexTM Builder TM 2 Integrated Development Environment (IDE) for Flash. These visualization “widgets” enable
MicroStrategy’s modular and Service Oriented Architecture
dashboards to express data in much more meaningful ways than is possible with traditional graph types.
(SOA) has allowed MicroStrategy’s new dashboard functionality
The rich and interactive nature of Flash can express relationships that are not possible with static graphs,
to be seamlessly integrated with its reporting, OLAP, ad-hoc,
such as allowing business users to view time-series data as graphical ‘movies’ that give deeper insight
and proactive alerting functionality. MicroStrategy’s Dynamic
into business trends. Users can rewind and fast forward through the time series and even pause the movie
Enterprise Dashboards inherit the industrial-strength attributes
to drill-down to get more detail on areas of interest.
of the MicroStrategy 8 business intelligence platform, including enterprise scalability, pervasive security, and powerful administration, allowing MicroStrategy dashboards to easily serve
100% Extensible, Allowing Users to Incorporate Any Data Visualization They Can Imagine
thousands of users. With automatic personalization and security, a single dashboard can be cascaded throughout an enterprise with each user seeing only their slice of the enterprise
For this release, MicroStrategy delivers an extension to the Adobe Flex Builder 2 IDE, which allows MicroStrategy customers to extend their MicroStrategy visualization library in any direction. Using Adobe Flex Builder 2 and the MicroStrategy SDK, users can create any new Flex-based visualization widget they
and the data that they are allowed to see. MicroStrategy’s dashboards use firewall-friendly DHTML, so that dashboards can safely be shared beyond corporate walls.
can imagine and insert it into their MicroStrategy visualization library. Customers can also use the Adobe Flex Builder extension to insert 3rd party Flex-based widgets into their MicroStrategy visualization library.
Empowering Business Users to Build Their Own Personal Dashboards MicroStrategy Dynamic Enterprise Dashboards allow business users to create their own personal dashboards. Using MicroStrategy’s zero-footprint WYSIWYG (what-you-see-is-what-you-get) Web interface, business users can create dashboards using simple drag and drop actions. No longer does the IT department need to create all dashboards for the business; users can now build the dashboards they want, increasing the use and adoption of business intelligence systems.
Create Boardroom Quality Dashboards
Folio BOOKSTORES
Month Mid-Atlantic Southwest Northeast Southeast Central West Northwest South
Monthly Revenue
$400,000
McGraw Hill
$300,000
Prentice Hall
$200,000 $100,000
DEC
NOV
SEP
OCT
JUL
AUG
APR
JUN
$0
16.9% $523,765
26.8% $830,585
•
• Scatter
•
•
Bar Pie • Line • Area • Bubble • Gauge • Box-plot • Histogram
Polar Stock • 3D Surface • Funnel • Pareto • Gantt • Radar •
26.2% $811,991 30.1% $932,859
Revenue by Region
Revenue $680,700 $545,600 $407,800 $381,200 $301,600 $291,300 $247,100 $243,900
Revenue by Supplier
$500,000
Mid-Atlantic Southwest Northeast Southeast Central West Northwest South
$3,099,200
TOP SELLING PRODUCTS (ITEM) 100 Places to Go While Still Young at Heart Foundation Analysis and Design Working with Emotional Intelligence
TOTAL
Clearly display important facts using one of the hundreds of chart styles and variations
MAY
$149,500 $137,200 $210,400 $244,800 $353,500 $387,500 $125,800 $218,700 $225,600 $256,000 $300,100 $490,100
MAR
Revenue
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
JAN
Month
$3,099,200
Present data in cross-tabular format giving users full analytical capabilities to sort, pivot, and add new calculations
December 31, 2006
YEAR TO DATE SALES SUMMARY 2006
FEB
Rich color formatting provides an elegant display both in print and on-screen
Year to Date Sales Review
$0
$200,000
$400,000
$600,000
Bantam Books
Simon & Schuster
Supplier Detail
Sales Representative Analysis
$800,000
UNITS SOLD
UNIT PRICE
REVENUE
3,200 1,400 5,600
$552 $810 $228
$147,200 $113,400 $106,400
10,200
$1,590
$367,000
Powered by
Establish user workflow by providing links to other useful dashboards, reports, and analysis
Folio BOOKSTORES
Year to Date Sales Review December 31, 2006
YEAR TO DATE SALES SUMMARY 2006
$400,000
Revenue
Mid-Atlantic Southwest Northeast Southeast Central West Northwest South
$680,700 $545,600 $407,800 $381,200 $301,600 $291,300 $247,100 $243,900
Prentice Hall
$200,000 $100,000
DEC
NOV
OCT
SEP
AUG
JUL
JUN
MAY
$0
16.9% $523,765
26.8% $830,585
26.2% $811,991 30.1% $932,859
Revenue by Region Mid-Atlantic Southwest Northeast Southeast Central West Northwest South
$3,099,200
TOP SELLING PRODUCTS (ITEM) 100 Places to Go While Still Young at Heart Foundation Analysis and Design Working with Emotional Intelligence
TOTAL
McGraw Hill
$300,000
$3,099,200
Month
Revenue by Supplier
$500,000
APR
$149,500 $137,200 $210,400 $244,800 $353,500 $387,500 $125,800 $218,700 $225,600 $256,000 $300,100 $490,100
MAR
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Monthly Revenue
FEB
Revenue
JAN
Month
$0
$200,000
$400,000
$600,000
Bantam Books
Simon & Schuster
Supplier Detail
Sales Representative Analysis
$800,000
UNITS SOLD
UNIT PRICE
REVENUE
3,200 1,400 5,600
$552 $810 $228
$147,200 $113,400 $106,400
10,200
$1,590
$367,000
Powered by
Design any Dashboard Imaginable
Human Resources Dashboard - Benefits
Powered by
Last Updated on 12/31/06
Create aesthetically pleasing dashboards that spark user interest EMPLOYEE CLAIMS
Medical
2005 Actual
2006 Actual
Dental
Vision
2006 Budget
$2M $1.5M $1M
Bevels Color gradients • Transparency • 3D • Bezier curve lines •
$1,600
Vison
1/7/2006
$3,450
401k
1/20/2006
$18,250
Medical
1/31/2006
$7,875
Dental Dental
1/31/2006
$3,000
2/5/2006
$15,625
$0M
2/1/2006
$1,315
Vision
2/12/2006
$6,010
401k
2/15/2006
$3,550
401k
2/27/2006
$2,370
Vision
2/28/2006
$12,568
3/1/2006
$5,800
3/15/2006
$23,000
3/31/2006
$4,800
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
EMPLOYEE COMPENSATION CLAIMS
•
1/1/2006
$5M Jan
Format graphs and data with professional design features such as:
Benefit Costs
Total
Departmental
Regional
Finance
West
IT Marketing HR
0
2
4
6
8
10
Medical
Medical Vision Medical 401k
3/31/2006
$2,750
Vision
Corporate
4/5/2006
$1,100
Vision
Central
4/15/2006
$800
Vision
4/19/2006
$6,000
Dental
4/28/2006
$15,230
Medical
4/28/2006
$6,550
Dental
5/1/2006
$3,850
Dental
5/1/2006
$17,275
Medical
5/10/2006
$6,400
401k 401k
East
Field Sales
4
6
8
10
LEAVE OF ABSENCE
12
Choose from a True Color palette to match corporate standards and create any color desired
Thomas Jones
Field Sales
Central Region
10/6/2006
10/23/2006
Personal - Vacation
5/15/2006
$3,515
Dave Moran
Development
Central Region
7/14/2006
7/16/2006
Personal - Vacation
5/15/2006
$11,235
Medical
Hugo Martinez
IT
Central Region
5/12/2006
5/19/2006
Personal - Vacation
5/15/2006
$2,200
Dental
Gordan Leigh
Field Sales
Central Region
7/5/2006
7/14/2006
Personal - Vacation
5/20/2006
$6,500
401k
Shannon Bryant
Field Sales
Central Region
8/24/2006
8/31/2006
Personal - Vacation
5/31/2006
$5,300
Carrie Porter
Human Resources
Central Region
5/28/2006
6/5/2006
Personal - Vacation
6/5/2006
$560
Dental
Mike Douglas
IT
Central Region
6/22/2006
6/28/2006
Personal - Vacation
6/5/2006
$1,420
Vision
6/10/2006
$2,500
Vision
Medical
Display large amounts of detailed information in a clear and concise format
Layout dashboard sections for quick analytical consumption using design features such as: Drop shadows Rounded edges • Images • Geometric shapes and lines • Color gradients • Transparency • Borders • •
Human Resources Dashboard - Benefits
Powered by
Last Updated on 12/31/06
EMPLOYEE CLAIMS
Medical
2005 Actual
2006 Actual
Dental
Vision
2006 Budget
$2M $1.5M $1M $5M $0M Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
EMPLOYEE COMPENSATION CLAIMS Departmental
Regional
Finance
West
IT Marketing HR
0
2
4
6
8
10
1/1/2006
$1,600
Vison
1/7/2006
$3,450
401k
1/20/2006
$18,250
Medical
1/31/2006
$7,875
Dental
1/31/2006
$3,000
Dental
2/5/2006
$15,625
Medical
2/1/2006
$1,315
Vision
2/12/2006
$6,010
401k
2/15/2006
$3,550
401k
2/27/2006
$2,370
Vision
2/28/2006
$12,568
3/1/2006
$5,800
3/15/2006
$23,000
3/31/2006
$4,800
Medical Vision Medical 401k
3/31/2006
$2,750
Vision
Corporate
4/5/2006
$1,100
Vision
Central
4/15/2006
$800
Vision
4/19/2006
$6,000
Dental
4/28/2006
$15,230
Medical
East
Field Sales
Benefit Costs
Total
4
6
8
10
LEAVE OF ABSENCE
12
4/28/2006
$6,550
Dental
5/1/2006
$3,850
Dental
5/1/2006
$17,275
Medical
5/10/2006
$6,400
401k 401k
Thomas Jones
Field Sales
Central Region
10/6/2006
10/23/2006
Personal - Vacation
5/15/2006
$3,515
Dave Moran
Development
Central Region
7/14/2006
7/16/2006
Personal - Vacation
5/15/2006
$11,235
Medical
Hugo Martinez
IT
Central Region
5/12/2006
5/19/2006
Personal - Vacation
5/15/2006
$2,200
Dental
Gordan Leigh
Field Sales
Central Region
7/5/2006
7/14/2006
Personal - Vacation
5/20/2006
$6,500
401k
Shannon Bryant
Field Sales
Central Region
8/24/2006
8/31/2006
Personal - Vacation
5/31/2006
$5,300
Medical
Carrie Porter
Human Resources
Central Region
5/28/2006
6/5/2006
Personal - Vacation
6/5/2006
$560
Dental
Mike Douglas
IT
Central Region
6/22/2006
6/28/2006
Personal - Vacation
6/5/2006
$1,420
Vision
6/10/2006
$2,500
Vision
Turn Insight Into Action Using Thresholds and Indicators
OPERATIONAL PERFORMANCE SCORECARD
Highlight trends and evaluate overall status using indicators
Status
Trend
Operational KPIs
Target
Revenue
This Month
Last Month
% change from LM
This Month LY
$ 1,387,434
$ 1,296,667
$ 957,865
35.4%
$ 1,445,116
-10.3%
Profit
On target
$ 346,737
$ 312,376
$ 231,740
34.8%
$ 352,001
-11.3%
20.0%
24.1%
24.2%
-0.4%
24.4%
-1.1%
Units Sold
26,661
32,122
22,800
40.9%
34,047
-5.7%
Order Count
22,919
21,420
13,020
64.5%
17,000
26.0% -28.8%
Avg Revenue per Order
$108
$61
$74
-17.7%
$85
Customer Count
8,300
10,000
8,091
23.6%
9,380
6.6%
108
$130
$ 118
9.5%
$154
-15.8%
l Good (above the target)
Revenue Variance vs. Forecast
more than 10%
between -5% and 10%
Region
Central
less than -5%
Northwest
-5.7% 19.6%
0%
10%
26.6%
20%
30%
Compare performance to forecast instantly with easy-to-understand variance graphs
8.7% -4.8%
South
15.1%
Emphasize metric performance compared to designated threshold values and conditions
Profit Variance vs. Forecast
Southeast
10.0% -8.3%
10
Poor (below the target)
Northeast
-9.1%
Drill to detailed reports to identify and determine root causes
-10%
% change from TM LY
Margin
Avg Revenue per Customer
Status:
December 2006
16.3% -10.7%
Southwest
19.0%
-10%
0%
10%
20%
30%
OPERATIONAL PERFORMANCE SCORECARD
Status
Trend
Operational KPIs
Target
Revenue
This Month
Last Month
% change from LM
This Month LY
$ 1,387,434
$ 1,296,667
$ 957,865
35.4%
$ 1,445,116
-10.3%
$ 346,737
$ 312,376
$ 231,740
34.8%
$ 352,001
-11.3% -1.1%
Profit
On target
20.0%
24.1%
24.2%
-0.4%
24.4%
Units Sold
26,661
32,122
22,800
40.9%
34,047
-5.7%
Order Count
22,919
21,420
13,020
64.5%
17,000
26.0% -28.8%
Avg Revenue per Order
$108
$61
$74
-17.7%
$85
Customer Count
8,300
10,000
8,091
23.6%
9,380
6.6%
108
$130
$ 118
9.5%
$154
-15.8%
l Good (above the target)
Revenue Variance vs. Forecast
Poor (below the target)
more than 10%
between -5% and 10%
Region
less than -5%
Profit Variance vs. Forecast
Northeast
-9.1%
Central
-8.3%
Northwest
-5.7% 19.6%
10%
20%
8.7% -4.8%
South
15.1%
0%
26.6%
Southeast
10.0%
-10%
% change from TM LY
Margin
Avg Revenue per Customer
Status:
December 2006
30%
16.3% -10.7%
Southwest
19.0%
-10%
0%
10%
20%
30%
11
Consolidate Information Into One Dashboard
Human Resources Analysis
Use tab formatting to separate complementary information for easy navigation within a single dashboard
Headcount Summary
Attrition/Hiring Summary
KPIs
#
%
76
100%
70
Part-time
3
4%
60
Full-time
73
96%
Planned Headcount
77
99%
International employees
17
22%
30
Tentured (> 6 months)
16
79%
20
Working experience > 5y
56
74%
10
Non-managers
42
55%
Female
39
51%
Headcount
#: Number of Employees
Encapsulate an entire subject area in each tabbed layer without overwhelming the user
Compensation Summary
Trend
80
50 40
0
Feb 06 Mar 06 Apr 06 May 06 Jun 06 Jul 06 Aug 06 Sep 06 Oct 06 Nov 06 Dec 06 Jan 07 Feb 07
%: % of Total Employees
Department Summary
Employees
Region Summary
* Current month vs. same month last year
Headcount FTE Employees % Total
Sales Customer Support Marketing Finance HR Information Systems Technical Consulting Technical Support Quality Assurance Program Management Research and Development Total
10.5 4.0 10.0 10.5 4.0 3.0 17.0 3.0 3.0 7.0 2.5 74.5
11 14.5% 4 5.3% 10 13.2% 11 14.5% 4 5.3% 3 3.9% 17 22.4% 3 3.8% 3 3.9% 7 9.2% 3 3.8% 76 100.0%
Planned Headcount
IN
OUT
Hires Transfers 7 3 9 7 5 7 12 5 1 1 5 62
2 3 1
Change
Departures Transfers 5 1
4 4 3
1 2 5 3
4 3 2 1 2
1 6 3 3
1 18
1 1 20
2 26
Net
%
0 1 7 3 2 1 13 3 1 0 3 34
0.0% 25.0% 70.0% 27.3% 50.0% 33.3% 76.5% 100.0% 33.3% 0.0% 100.0% 44.7%
Powered by
Human Resources Analysis
Human Resources Analysis Attrition/Hiring Summary
KPIs
%
20
21%
Hiring
62
82%
Departures
20
100%
Voluntary
16
80%
4
20%
44
74%
Non-voluntary New - 5 Years experience
Trend
80
8%
70
7%
60
6%
50
5%
40
4%
30
3%
20
2% 1%
Female Hires
32
52%
10
Vacant Positions
10
13%
0
9
90%
Offers Out
#: Number of Employees
SELECT QUARTER
Headcount Summary
2006 Q1
2006 Q2 Departures
%: % of Total Employees
2006 Q3
2006 Q4
Employees
25%
%
100%
3,783
75%
Bonus
780
15%
1,800K 1,600K 1,400K 1,200K
482
10%
1,000K
4,737
106%
800K
39
51%
Employee Cost
4
12%
Company Cost
29
88%
Vacation Liabilities
42
1%
Overtime
99
2%
Awards Planned Compensation Benefits Participants (#)
K$: Thousands of dollars
600K 400K 200K 0K
Relocation
Advertisement
28%
17%
Internal Referral
4 - Year College
11%
Reasons
Head Hunter
28%
28%
Other
Master’s Degree
39%
2 - Year College
50%
Average Salary
$120,000
Sales
$800,917
20.2%
61,609
$100,000
Customer Support
$236,750
6.0%
47,350
Marketing
$527,917
13.3%
65,990
Finance
$607,333
15.4%
67,481
HR
$275,083
7.0%
68,771
Information Systems
$179,333
4.5%
29,889
Technical Consulting
$558,833
14.1%
37,256
Technical Support
$86,250
2.2%
21,563
Quality Assurance
$45,917
1.2%
22,958
Total
2006 Q2
Regular Bonus
2006 Q3
2006 Q4
Other Monetary Awards
2007 Q1
Non-Monetary Awards
Quarterly Trends for Department – Customer Support
% Total
Research and Development
Powered by
2006 Q1
%: % of Total
Compensation Cost
Department
Hires by Education Level
Program Management
12
Trend
Compensation by DEPARTMENT (2006)
Hires by Recruitment Source
25% Personal 50%
0%
K$
5,044
Salary
Compensation Cost
Compensation Summary
Base Salary
Attrition Rate
2006 Q3
Reasons for Departure
Better Opportunity
2007 Q1
Attrition/Hiring Summary
KPIs
Attrition Rate
#
Attrition
Compensation Summary
# of Employees
Headcount Summary
$544,167
13.8%
90,694
$93,750
2.4%
23,438
$3,956,250
100.0%
$52,056
*Select Department to display quarterly trends on right graph
$80,000
Total Cost
$60,000
Salaries
$40,000
Bonus + Awards
$20,000 $0
2006 Q1
2006 Q2
2006 Q3
Powered by
2006 Q4
Human Resources Analysis Attrition/Hiring Summary
KPIs
%
Attrition
21%
Hiring
62
82%
Departures
20
100%
Voluntary
16
80%
4
20%
Non-voluntary
Trend
80
8%
70
7%
60
6%
50
5%
40
4%
30
3%
44
74%
20
2%
Female Hires
32
52%
10
1%
Vacant Positions
10
13%
0
9
90%
New - 5 Years experience
Offers Out
#: Number of Employees
SELECT QUARTER
2006 Q1
2006 Q2 Departures
%: % of Total Employees
2006 Q3
2006 Q4
Employees
0%
Attrition Rate
2006 Q3
Reasons for Departure 25%
Hires by Recruitment Source
Relocation
Advertisement
28%
17%
Internal Referral
Hires by Education Level 4 - Year College
11%
25% Personal Better Opportunity
2007 Q1
Attrition Rate
# 20
Compensation Summary
# of Employees
Headcount Summary
Reasons
50%
Head Hunter
28%
28%
Other
Master’s Degree
39%
2 - Year College
50%
Powered by
13
Flip Through Layers of Information Quickly
PRODUCT PERFORMANCE Category
USA
Revenue
Profit
Profit Margin
Revenue Performance
Monthly
Transactions Per Customer
Product Revenue
Quarterly
Audio Equipment
Monthly
$60K
Cameras
$600K $500K
$50K $40K
Video Equipment
$400K
$30K
$300K
$20K
TV’s
$200K
$10K
Computers
$0K
Ja n 0 Fe 6 b 0 M 6 ar 06
$100K 06
06 ec
ov N
Electronics Miscellaneous
D
06
06 p
ct O
Se
6
06
l0
ug A
Ju
06
06 n
ay M
Ju
06
06 pr
A
06 06 06 06 06 06 06 06 06 ay un Jul ug ep ct ov ec J M O N S A D
pr
A
Audio Equipment Revenue
Cameras Revenue
Northwest
$200K
Northeast
$160K
West
$120K
Southwest
Mid-Atlantic Revenue
ec
06
06
D
O
ct
06
06 p Se
06 A
ug
6 l0 Ju
06 n Ju
06 ay M
A
pr
06
06 ar M
b
06
$0K Fe
South
$40K
06
Mid-Atlantic
Quarterly
Select parameters within each section to focus the analysis in specific areas n
Southeast
Flip through business metrics to change the focus of the dashboard
TV’s Revenue
$80K
Ja
Central
Monthly
ov
ar M
b
n
06
06
$0K
Regional Revenue Performance
14
Quarterly
$70K
$700K
Fe
Radio buttons • Check boxes • Drop down menus • Sliders • List boxes •
# Customers
$800K
Ja
Change the context of data displayed using a wide range of selectors that are “wired” to one or many sections on the dashboard. Some of these selectors include:
Choose business dimensions to control the context of every subsequent dashboard section and calculation
Electronics
N
Country
PRODUCT PERFORMANCE Category
USA
Revenue
Profit
Electronics
Profit Margin
Revenue Performance
# Customers
Monthly
Transactions Per Customer
Product Revenue
Quarterly
Audio Equipment
$800K
Monthly
Quarterly
$70K
$700K
$60K
Cameras
$600K $500K
$50K $40K
Video Equipment
$400K
$30K
$300K
$20K
TV’s
$200K
$10K
Computers
$0K
Ja n 0 Fe 6 b 0 M 6 ar 06
$100K
ec
06
06
Electronics Miscellaneous
D
ov
06 N
O
ct
p
06
06
Se
6
ug
06
l0
A
Ju
n
06
Ju
ay M
pr
06
06 A
06 06 06 06 06 06 06 06 06 ay un Jul ug ep ct ov ec J M O N S A D
pr
A
Audio Equipment Revenue
Cameras Revenue
Regional Revenue Performance Northwest
$200K
Northeast
$160K
West
$120K
Southwest
ec
06
06
D
O
ct
06
06 p Se
06 A
ug
6 l0 Ju
06 n Ju
06 M
ay
06 pr A
M
ar
06
06 b Fe
South
$0K 06
Mid-Atlantic
Quarterly
$40K
n
Southeast
TV’s Revenue
$80K
Ja
Central
Monthly
ov
ar M
b Fe
Ja
n
06
06
$0K
N
Country
Mid-Atlantic Revenue
15
Include Sophisticated Analytics
Customer Analysis Summary 2006 Segment the analysis along any business dimension, updating all the graphs and tables in the dashboard
Demographics Selector Gender
Male
Female
Status
Active
Lost
Household Type
Renter
Owner
Marital Status
Single
Married
Divorced
Lifetime Value
High
Medium
Low
High School
Undergraduate
Graduate
Education Age Range Income Range
<<
Number of Customers
Use the Demographics selector to specify values for each category
278 100
300
Average Number of Transactions Per Customer Other
< 21
21-40
41-60
61-80
> 80
0-20K
21K-40K
41K-60K
61K-80K
> 80K
3 2
4
1
Acquisition Rate Electronics 33%
Movies 39%
•
20%
•
16
Attrition Rate
25%
Customers
$78.14
9/26/2006
$47.64
8/22/2006
Dominick Oneill
$35.40
2/3/2006
Hector Pelino
$86.79
1/14/2006
$104.86
12/15/2005
Q4
Q3
2006
Q2
2006
0% Q1
Books 28%
$54.20
1/9/2006
$66.09
8/12/2006
Iris Vaughn
$127.27
8/17/2006
Enzo Cutting
$29.87
7/12/2006
Detyne Ferber
$32.86
11/23/2005
Conrad Hughes
$120.23
2/3/2006
Jan Taylor
$84.34
6/29/2003
Iris Zeller
$139.06
10/26/2005
Carole Robison
$93.73
10/8/2005
Amanda Vince
$28.32
9/16/2005
Showcase key metrics with intuitive visualizations such as: •
2.7
Average Revenue Per Customer
$50 $25
$75
$0
$100
$58
Gauges
• Thermometers • Area
Charts Cylinders • Heat maps •
Most Recent Transaction
Cleatus Kristick
Mai Normandin
5%
Revenue
Carole Vorndran
Monica Neptune
10%
5
List of Customers
Melanie Searles
15%
2006
Neural Networks Cluster Algorithms • Tree Algorithms • Multi-variant Regressions • Over 200 statistical, financial, logical, and mathematical functions
Acquisition and Attrition by Quarter
2006
Incorporate sophisticated predictive and data mining metrics using:
Top Categories
500
Customer Analysis Summary 2006 Demographics Selector Gender
Male
Female
Status
Active
Lost
Household Type
Renter
Owner
Marital Status
Single
Married
Divorced
Lifetime Value
High
Medium
Low
Education
High School
Undergraduate
Graduate
Other
Age Range
< 21
21-40
41-60
61-80
> 80
0-20K
21K-40K
41K-60K
61K-80K
> 80K
Income Range
<<
Number of Customers
Use the Demographics selector to specify values for each category
278 100
300
Average Number of Transactions Per Customer
3 2
4
1 Top Categories
Acquisition and Attrition by Quarter Acquisition Rate
Electronics 33%
Movies 39%
Attrition Rate
25%
10% 5%
Q4
2006
Q3
2006
Q2
2006
Q1
0% 2006
Books 28%
Customers
Revenue
Most Recent Transaction
$78.14
9/26/2006
Cleatus Kristick
$47.64
8/22/2006
Dominick Oneill
$35.40
2/3/2006
Hector Pelino
$86.79
1/14/2006
$104.86
12/15/2005
Melanie Searles
15%
5
List of Customers
Carole Vorndran
20%
500
Monica Neptune
$54.20
1/9/2006
Mai Normandin
$66.09
8/12/2006
Iris Vaughn
$127.27
8/17/2006
Enzo Cutting
$29.87
7/12/2006
Detyne Ferber
$32.86
11/23/2005
Conrad Hughes
$120.23
2/3/2006
Jan Taylor
$84.34
6/29/2003
Iris Zeller
$139.06
10/26/2005
Carole Robison
$93.73
10/8/2005
Amanda Vince
$28.32
9/16/2005
2.7
Average Revenue Per Customer
$50 $25
$75
$0
$100
$58
17
Organize Densely-Packed Information Into Layered Dashboards
Customer Segmentation and Profitability
Customer Analysis Quarterly Analysis
View many independent dashboard pages (tabs), organized in layers, aspart of a single overall dashboard design
Cross-sell Analysis
Year-to-date Analysis
Quarterly Customer Analysis for Q4 2006
Select a Quarter
Acquisition, Attrition, and Retention Performance Summary:
3.01% Acquisition Rate,
0.62% Attrition Rate, and 96.99% Retention Rate
Acquisition
Attrition
New Active Acquisition Customers Customers Rate Oct 2006 Nov 2006 Dec 2006
39 42 40
1,299 1,333 1,363
% New to All New
3.00% 3.15% 2.93%
Lost Active Customers Customers
32.23% 34.71% 33.06%
7 8 10
Quarterly Acquisition Trend 12%
28
120
10%
24
8%
New Customers
6%
Acquisition Rate
80 60
Group sections of information using background layouts, titles, and colors
4
0%
0
2006 Q4
1,260 1,291 1,323
1,299 1,333 1,363
97.00% 96.85% 97.07%
Quarterly Retention Plan 1400
2%
1%
100%
1200
2% Lost Customers Attrition Rate 1%
80%
1000 60%
800
Retained Customers
Refine analysis area further by narrowing down the data selected
Retention Rate
600
40%
400 0% 0%
2006 Q1
Note: % New to All New is calculated as # New Customers at the month level divided by # New Customers in the analyzed period.
2006 Q2
2006 Q3
2006 Q4
20%
200 0
0%
2006 Q1
2006 Q2
2006 Q3
2006 Q4
Note: % Lost to All Lost is calculated as # Lost Customers at the month level divided by # Lost Customers in the analyzed period.
Customer Analysis by Age Range and Income Range Age Range < 21
21-40
41-60
Revenue $
Avg Transaction Size $
Revenue per Customer $
Profit $
0 - 20K
$41,183.10
$298.43
$686.39
$2,428.18
20K - 40K
$54,498.44
$465.80
$1,028.27
$3,538.64
40K - 60K
$23,178.17
$246.58
$551.86
$1,406.37
60K - 80K
$51,844.68
$518.45
$1,205.69
$3,091.98
> 80K
$23,783.53
$247.75
$540.53
$1,479.12
0 - 20K
$46,635.75
$376.09
$790.44
$2,960.92
20K - 40K
$33,312.13
$350.65
$812.49
$1,717.86
40K - 60K
$49,186.10
$341.57
$768.53
$2,762.07
60K - 80K
$37,477.31
$312.31
$749.55
$2,324.83
> 80K
$23,826.98
$187.61
$458.21
$1,375.57
0 - 20K
$44,158.71
$304.54
$679.36
$3,219.34
20K - 40K
$55,093.39
$326.00
$734.58
$3,345.29
40K - 60K
$43,422.04
$269.70
$578.96
$2,455.90
60K - 80K
$43,336.86
$390.42
$866.74
$2,736.80
> 80K
$33,851.87
$266.55
$573.76
$2,136.33
Income Range
Document Execution Time: 12/29/2006 9:48:25 AM
18
Retention Rate
28.00% 32.00% 40.00%
8
2%
2006 Q3
Active Customers
0.54% 0.60% 0.73%
12
0 2006 Q2
Retained Customers
16
20 2006 Q1
% Lost to All Lost
20
4%
40
1,299 1,333 1,363
Retention
Attrition Rate
Quarterly Attrition Trend
140
100
Choose the focus of each independent dashboard page or layer dynamically by selecting a specific analysis area
Q4 2006
Customer Distribution by Income Range 0 - 20K 23.0% 20.6%
20K - 40K
40K - 60K
18.4% 22.1% 16.0%
60K - 80K
> 80K
Document Author: John Smith
Use scrollbars to maximize dashboard real estate
Customer Segmentation and Profitability
Customer Analysis Quarterly Analysis
Cross-sell Analysis
Year-to-date Analysis
Quarterly Customer Analysis for Q4 2006
Select a Quarter
Acquisition, Attrition, and Retention Performance Summary:
3.01% Acquisition Rate,
0.62% Attrition Rate, and 96.99% Retention Rate
Acquisition
Attrition
New Active Acquisition Customers Customers Rate Oct 2006 Nov 2006 Dec 2006
39 42 40
1,299 1,333 1,363
% New to All New
3.00% 3.15% 2.93%
Lost Active Customers Customers
32.23% 34.71% 33.06%
7 8 10
Quarterly Acquisition Trend 12%
28
120
10%
24
8%
80 6%
60
20 0 2006 Q1
2006 Q2
2006 Q3
% Lost to All Lost
Retained Customers
Active Customers
Retention Rate
0.54% 0.60% 0.73%
28.00% 32.00% 40.00%
1,260 1,291 1,323
1,299 1,333 1,363
97.00% 96.85% 97.07%
Quarterly Retention Plan
1%
Lost Customers Attrition Rate
12
1%
8
2%
4
0%
0
2006 Q4
80%
1000 60%
800
Retained Customers Retention Rate
600
40%
400 0% 0%
2006 Q1
Note: % New to All New is calculated as # New Customers at the month level divided by # New Customers in the analyzed period.
100%
1200
2%
16
Acquisition Rate
1400
2%
20
New Customers
4%
40
1,299 1,333 1,363
Retention
Attrition Rate
Quarterly Attrition Trend
140
100
Q4 2006
2006 Q2
2006 Q3
2006 Q4
20%
200 0
0%
2006 Q1
2006 Q2
2006 Q3
2006 Q4
Note: % Lost to All Lost is calculated as # Lost Customers at the month level divided by # Lost Customers in the analyzed period.
Customer Analysis by Age Range and Income Range Age Range < 21
21-40
41-60
Revenue $
Avg Transaction Size $
Revenue per Customer $
Profit $
0 - 20K
$41,183.10
$298.43
$686.39
$2,428.18
20K - 40K
$54,498.44
$465.80
$1,028.27
$3,538.64
40K - 60K
$23,178.17
$246.58
$551.86
$1,406.37
60K - 80K
$51,844.68
$518.45
$1,205.69
$3,091.98
> 80K
$23,783.53
$247.75
$540.53
$1,479.12
0 - 20K
$46,635.75
$376.09
$790.44
$2,960.92
20K - 40K
$33,312.13
$350.65
$812.49
$1,717.86
40K - 60K
$49,186.10
$341.57
$768.53
$2,762.07
60K - 80K
$37,477.31
$312.31
$749.55
$2,324.83
> 80K
$23,826.98
$187.61
$458.21
$1,375.57
0 - 20K
$44,158.71
$304.54
$679.36
$3,219.34
20K - 40K
$55,093.39
$326.00
$734.58
$3,345.29
40K - 60K
$43,422.04
$269.70
$578.96
$2,455.90
60K - 80K
$43,336.86
$390.42
$866.74
$2,736.80
> 80K
$33,851.87
$266.55
$573.76
$2,136.33
Income Range
Document Execution Time: 12/29/2006 9:48:25 AM
Customer Distribution by Income Range 0 - 20K 23.0% 20.6%
20K - 40K
40K - 60K
18.4% 22.1% 16.0%
60K - 80K
> 80K
Document Author: John Smith
19
Select Data Dynamically To Focus On Specific Business Operations
Choose business line (category) to track performance
CATEGORY SALES AND PROFITABILITY
BOOKS
SELECT CATEGORY
ELECTRONICS
FINANCIAL HIGHLIGHTS Revenue Profit
MOVIES REVENUE QUARTERLY TRENDS
Actuals (K$) Forecast (K$) Variance Status 6,179 6,365 6% 1,798 1,708 5%
$2,000,000
$1,600,000
Select the business metric, “Revenue”, to further focus the dashboard analysis
REGIONAL REVENUE HIGHLIGHTS Mid-Atlantic
$1,085,630
Southwest Northeast
$654,417
Web
Northwest South
Output shown in both bar graphs is determined by the selected metric (“Revenue”)
20
$800,000
$725,008
Southeast
Central
$1,200,000
$882,325
$400,000
$572,873 $545,079
Compare actual to forecasted performance for a specific geographic region and time period
$0
$446,027
2006 Q1
2006 Q2 Revenue
$437,311
SUBCATEGORY PERFORMANCE BY
2006 Q4
2006 Q3
Revenue Forecast
2006 Q4 Variance
Mid-Atlantic
Quarter
Region
Subcategory
Revenue
Forecast
% Variance
Profit
2006 Q4
Mid-Atlantic
Audio Equipment Cameras Computers Electronics - Miscellaneous TV’s Video Equipment Total
$58,010 $136,460 $16,065 $28,690 $35,897 $95,220 $370,372
$57,817 $110,710 $14,781 $29,723 $30,699 $85,711 $329,471
0% 23% 9% -3% 17% 11% 12%
$15,354 $37,400 $4,372 $7,853 $9,822 $26,259 $101,060
Forecast $13,653 $35,352 $4,176 $7,956 $8,914 $28,060 $98,141
% Variance 12% 6% 5% -1% 10% -6% 3%
CATEGORY SALES AND PROFITABILITY
BOOKS
SELECT CATEGORY
ELECTRONICS
FINANCIAL HIGHLIGHTS Revenue Profit
MOVIES REVENUE QUARTERLY TRENDS
Actuals (K$) Forecast (K$) Variance Status 6,179 6,365 6% 1,798 1,708 5%
$2,000,000
$1,600,000
REGIONAL REVENUE HIGHLIGHTS Mid-Atlantic
$1,085,630
Southwest
$882,325
Northeast
$654,417
Web
Northwest South
$800,000
$725,008
Southeast
Central
$1,200,000
$400,000
$572,873 $545,079
$0
$446,027
2006 Q1
2006 Q2 Revenue
$437,311
SUBCATEGORY PERFORMANCE BY
2006 Q4
2006 Q3
Revenue Forecast
2006 Q4 Variance
Mid-Atlantic
Quarter
Region
Subcategory
Revenue
Forecast
% Variance
Profit
2006 Q4
Mid-Atlantic
Audio Equipment Cameras Computers Electronics - Miscellaneous TV’s Video Equipment Total
$58,010 $136,460 $16,065 $28,690 $35,897 $95,220 $370,372
$57,817 $110,710 $14,781 $29,723 $30,699 $85,711 $329,471
0% 23% 9% -3% 17% 11% 12%
$15,354 $37,400 $4,372 $7,853 $9,822 $26,259 $101,060
Forecast $13,653 $35,352 $4,176 $7,956 $8,914 $28,060 $98,141
% Variance 12% 6% 5% -1% 10% -6% 3%
21
Visualize Business Performance From Any Data Source
HR
Marketing
Sales
Time Period 2003
View data from all aspects of your business in a single dashboard regardless of the data source Relational databases Multi-dimensional databases such as Microsoft® Analysis Services, SAP® BW, and Hyperion® Essbase® • ERP systems • Flat files • •
2006 (YTD)
Manufacturing Product Category
United States
Total Marketing Expenses
Southwest $318,650 (10%)
Southeast $414,246 (13%)
Country
(All)
Regional Marketing Expenses Northeast $352,381 (12%)
Finance
Trade Shows $443,999 (14%)
Magazines $597,556 (19%)
Bundling $140,931 (4%)
Mid-Atlantic $637,301 (20%)
Central $22,305 (7%)
Web Banners $1,806,142 (57%)
South $254,920 (8%)
Northwest $955,952 (30%)
Printed Collateral $77,415 (2%) Other $77,325 (2%) Direct Mail $38,318 (1%)
Revenue vs. Marketing Cost $300,000 $250,000 $200,000 $150,000 $100,000 $50,000 $0 Jan 06
Feb 06
Mar 06
Revenue
Apr 06
May 06
Jun 06
Jul 06
Aug 06
Sept 06
Oct 06
Marketing Cost Powered by
22
Nov 06
Dec 06
Adjust the desired time frame with a user-friendly slider to increase or decrease the overall time selected
HR
Marketing
Sales
Time Period 2003
2006 (YTD)
Manufacturing Product Category
United States
Total Marketing Expenses
Southwest $318,650 (10%)
Southeast $414,246 (13%)
Country
(All)
Regional Marketing Expenses Northeast $352,381 (12%)
Finance
Trade Shows $443,999 (14%)
Magazines $597,556 (19%)
Bundling $140,931 (4%)
Mid-Atlantic $637,301 (20%)
Central $22,305 (7%)
Other $77,325 (2%)
Web Banners $1,806,142 (57%)
South $254,920 (8%)
Northwest $955,952 (30%)
Printed Collateral $77,415 (2%)
Direct Mail $38,318 (1%)
Revenue vs. Marketing Cost $300,000 $250,000 $200,000 $150,000 $100,000 $50,000 $0 Jan 06
Feb 06
Mar 06
Revenue
Apr 06
May 06
Jun 06
Jul 06
Aug 06
Sept 06
Oct 06
Nov 06
Dec 06
Marketing Cost Powered by
23
Control and Monitor Financial Performance
Financial Analysis Income Statement
Monitor all key financial statements in one dashboard
Balance Sheet
Cash Flow December 31, 2006
North America Actual
Income Statement
Budget
$
% Variance
$
% Variance
$274,019,456
$284,605,278
(3.72%)
$270,365,083
1.35%
Total Revenues
$274,019,456
$284,605,278
(3.72%)
$270,365,083
1.35%
Cost of Revenues Gross Profit
($2,638)
($41,016)
(93.57%)
($2,297)
$274,022,094
$284,646,294
(3.73%)
$270,367,380
1.35%
$7,275,120
$7,203,242
1.00%
$7,317,291
(0.58%)
$75,693,698
$75,367,401
0.43%
$75,491,800
0.27%
($15,959,425)
($15,838,407)
0.76%
($12,576,955)
26.89%
Sales and Marketing Research and Development General and Administrative Depreciation and Amortization
$222,871
Total Operating Expenses
Select a line item to show detailed data below
Forecast
$
Revenues
Operating Income
$201,529
10.59%
$67,232,264
$66,952,884
0.42%
$70,433,655
(4.55%)
$206,789,831
$217,693,410
(5.01%)
$199,933,725
3.43%
($53,274)
($54,250)
(1.80%)
($52,695)
1.10%
Interest Income or Expense Gain/Loss on Investments
$220,647
$64,027,237
Financing Income/Expense Income Before Taxes Income Taxes Net Income
1.01%
14.85%
$61,589,340
3.96%
$63,973,963
$62,836,490
1.81%
$61,536,645
3.96%
$270,763,794
$280,529,900
$62,890,740
(3.48%)
1.81%
$261,470,370
3.55%
$34,652,402
$37,480,045
(7.54%)
$33,985,270
1.96%
$236,111,392
$243,049,855
(2.85%)
$227,485,100
3.79%
Detailed Data $60M
Total Operating Expenses
$50M
2006
GAAP Category Code
2006 Q1
2006 Q2
2006 Q3
2006 Q4
Total
$40M
General and Administration
$
(2,189,318)
$
(3,268,757) $
(5,588,653)
$
(4,912,698)
$
(15,959,425)
$30M
Research and Development
$
17,493,498
$
19,452,330 $
18,692,411
$
20,055,459
$
75,693,698
$20M
Sales and Marketing
$
1,793,783
$
1,440,374 $
1,556,394
$
2,484,570
$
7,275,120
Amortization of Intangible Assets
$
55,718
$
55,718 $
55,718
$
55,718
$
222,871
Total
$
17,153,681
$ 17,679,665 $
14,715,870
$
17,683,049 $
67,232,264
$10M $0M 2006 Q1
2006 Q2
Actual Amount
24
Format specific line items to signify importance and improve readability
2006 Q3
2006 Q4
Plan Amount
Sensitive data is automatically secured so that each user accesses only his or her appropriate information
Financial Analysis Income Statement
Balance Sheet
Cash Flow December 31, 2006
North America Actual
Income Statement
Forecast
$
Budget
$
% Variance
$
% Variance
Revenues
$274,019,456
$284,605,278
(3.72%)
$270,365,083
1.35%
Total Revenues
$274,019,456
$284,605,278
(3.72%)
$270,365,083
1.35% 14.85%
Cost of Revenues Gross Profit
($2,638)
($41,016)
(93.57%)
($2,297)
$274,022,094
$284,646,294
(3.73%)
$270,367,380
1.35%
$7,275,120
$7,203,242
1.00%
$7,317,291
(0.58%)
$75,693,698
$75,367,401
0.43%
$75,491,800
0.27%
($15,959,425)
($15,838,407)
0.76%
($12,576,955)
26.89%
Sales and Marketing Research and Development General and Administrative Depreciation and Amortization Total Operating Expenses Operating Income
$222,871
$220,647
1.01%
$201,529
10.59%
$67,232,264
$66,952,884
0.42%
$70,433,655
(4.55%)
$206,789,831
$217,693,410
(5.01%)
$199,933,725
3.43%
($53,274)
($54,250)
(1.80%)
($52,695)
1.10%
Interest Income or Expense Gain/Loss on Investments
$64,027,237
$62,890,740
1.81%
$61,589,340
3.96%
Financing Income/Expense
$63,973,963
$62,836,490
1.81%
$61,536,645
3.96%
$270,763,794
$280,529,900
(3.48%)
$261,470,370
3.55%
$34,652,402
$37,480,045
(7.54%)
$33,985,270
1.96%
$236,111,392
$243,049,855
(2.85%)
$227,485,100
3.79%
Income Before Taxes Income Taxes Net Income
Detailed Data $60M
Total Operating Expenses
$50M
2006
GAAP Category Code
2006 Q1
2006 Q2
2006 Q3
2006 Q4
Total
$40M
General and Administration
$
(2,189,318)
$
(3,268,757) $
(5,588,653)
$
(4,912,698)
$
(15,959,425)
$30M
Research and Development
$
17,493,498
$
19,452,330 $
18,692,411
$
20,055,459
$
75,693,698
$20M
Sales and Marketing
$
1,793,783
$
1,440,374 $
1,556,394
$
2,484,570
$
7,275,120
Amortization of Intangible Assets
$
55,718
$
55,718 $
55,718
$
55,718
$
222,871
Total
$
17,153,681
$ 17,679,665 $
14,715,870
$
17,683,049 $
67,232,264
$10M $0M 2006 Q1
2006 Q2
Actual Amount
2006 Q3
2006 Q4
Plan Amount
25
Magnify Data to Instantly View Fine-grained Detail
Enlarge thumbnail graphs (or tables) to see more detail and mouse-over data points to see actual values
Control table and graph output based on map selection 26
Visualize data using maps
27
Simplify Workflow With Interactive Context Controls
Sales Management Dashboard
Territory Overview (Quarter to Date)
United States
Align the organization with dashboards that show each manager’s contribution to overall company goals (tab 1)
Individual Account Representatives
Opportunity Value by Close Probability
Sales Statistics Metrics
Click on a section of the graph to view the associated opportunities.
$300,000
Closed Revenue
$650,000
Target Quota
$2,250,000
% Quota Achieved (Current)
10%
28.89%
Current Revenue Projection = Closed + Weighted Projection vs. Quota % Quota Achieved vs. Revenue Projection
$575,000
20%
$200,000
30%
Opportunities with Close Probability of 10%
$955,000
Click on a graph value and initiate a context change in other tables or graphs on the dashboard
(1,295,000) 42.44%
Open Opportunities
5
Opportunities with close probability of 10%
2
Opportunities with close probability of 20%
2
Opportunities with close probability of 80%
1
<< select an opportunity to view the account history
Account
Opportunity
Sales Representative
Opportunity Estimated Close Date
IBC - Corporate
Partner (Others) Lead
Erin Dull
2/14/2007
$125,000
First Bank of Boston - Corporate
Internal (Others)
Gerald Blubaugh
3/11/2007
$175,000
Total
Click on a table value to adjust output within associated detail tables
Opportunity Size
$300,000
Purchase History for First Bank of Boston - Corporate Company
Industry
Product Group
Product
Quarter
First Bank of Boston
Banking and Insurance
Server
AdVent Commerce Content Server AdVent Web Deziner 3.0 Advent - SDK Advent SI
2006 2006 2006 2006
Client Services
Total
Q3 Q3 Q3 Q3
Opportunity Size $100,000 $25,000 $25,000 $25,000
Powered by
Sales Management Dashboard
United States
$175,000
Territory Overview (Quarter to Date)
Individual Account Representatives
Actual Revenue vs Quota
Align the organization with dashboards that show each individual’s contribution to overall company goals (tab 2)
Select an Account Rep
Closed Revenue vs. Quota to Date 500K
(All) Constance Imes
400K
Danny Leavitt
300K
Enzo Kellaway
Anthony Vanderwerff
0K
Select a data element to show the detailed performance Closed Revenue
Refine displayed data by selecting specific filtering criteria
Q1 2005
Q2 2005
200K
Q4 2005
Q1 2006
Q2 2006
Q3 2006
Target Quote
2006 Q1
2006 Q2
2006 Q3
Table
Q4 2006
Revenue
2006 Q4
WEIGHTED VALUE
$80,000
Graph
Company
Opportunity
Advanced Chip Corporation
15% off all products
$200,000
Account
Opportunity Est. Close Opportunity Close Date Probability Size
AstroPharm. Plc
Request for Information - Lead
$150,000
AOP - Corporate
1/30/2007
20%
$100,000
Bev Vanderbilt Inc.
Sys Integrator (Others) - Lead
$100,000
Division - Corporate
1/26/2007
20%
$150,000
Child with Togys Corp
10% off Servers
$150,000
IBC - Corporate
2/14/2007
10%
J.D. Soft and Company
Internal (Marketing)
$225,000
First Bank of Boston - Corp
3/11/2007
10%
Total
$825,000
Total
$125,000 $175,000 $550,000
Powered by
28
Actual Revenue
115K
Current Open Opportunities Q3 2005
250K
200K 200K
100K
Josh Hadley
(All)
260K 250K
250K
200K
Gordon Cutting
Sales Management Dashboard
Territory Overview (Quarter to Date)
United States
Individual Account Representatives
Opportunity Value by Close Probability
Sales Statistics Metrics
Click on a section of the graph to view the associated opportunities.
$300,000
Closed Revenue
$650,000
Target Quota
10%
$2,250,000
% Quota Achieved (Current)
28.89%
Current Revenue Projection = Closed + Weighted
$955,000
Projection vs. Quota
(1,295,000)
% Quota Achieved vs. Revenue Projection
$575,000
20% 30%
$200,000
Opportunities with Close Probability of 10%
42.44%
Open Opportunities
5
Opportunities with close probability of 10%
2
Opportunities with close probability of 20%
2
Opportunities with close probability of 80%
1
<< select an opportunity to view the account history
Account
Opportunity
Sales Representative
Opportunity Estimated Close Date
IBC - Corporate
Partner (Others) Lead
Erin Dull
2/14/2007
First Bank of Boston - Corporate
Internal (Others)
Gerald Blubaugh
3/11/2007
Opportunity Size $125,000 $175,000
Total
$300,000
Purchase History for First Bank of Boston - Corporate Company
Industry
Product Group
Product
Quarter
First Bank of Boston
Banking and Insurance
Server
AdVent Commerce Content Server AdVent Web Deziner 3.0 Advent - SDK Advent SI
2006 2006 2006 2006
Client Services
Total
Q3 Q3 Q3 Q3
Opportunity Size $100,000 $25,000 $25,000 $25,000
Powered by
$175,000
29
Revenue Cost of Revenue R&D Gross Profit Selling Costs General and Admin Total Operating Expenses IBIT Interest Income / Expense Taxes Analysis IncomeIncome Statement Net Income
$6,000
$13,529 $6,878 $2,193 $4,459 $1,450 $2,554 $4,003 $455 $82 $145 $310
$5,000 $4,000
Conduct Scenario Analysis For Greater Operational Insight $3,000 $2,000 $1,000 $0 ($1,000) ($2,000) 2006 Q1
2006 $13,529 $6,878 $2,193 $4,459 $1,450 $2,554+100% $4,003 $455+10% $82 $145 27,059 $310+100%
Pro-forma Analysis
Pro-forma Analysis 0
0 +100%
27,059
0
30
$0 ($1,000) ($2,000) 2006 Q1
0
$4,459 +15% -18,142
2,899
0
+100%
$4,341 -18,142
+100% +10%
5,107
27,059
2006 Q4
IBIT
Income Before Interest & Taxes $-135 -26,148
27,059
Net Income $-92 -27,059
27,059
Total SG&A Expenses 27,059
Income Before Interest & Taxes
$4,476
0
$455 -26,148
8,007 Interest Expenses & Taxes 27,059 Net Income $310 -27,059
$-43
-13,529
5,107
Reset Data 27,059
13,529
Total SG&A Expenses
2,899 0
2006 Q3
Revenue
Gross Profit
+10%
+100%
+15%
2006 Q2
+100%
$2,8094,386 0
0
General & Admin
$1,000
+20%
$1,450
$2,554
$2,000
+100%
General0 & Admin
-100%
$3,000
Gross Profit
13,756
-100%
-100%
0
+15% $1,667
0
Import any custom or third party analytical “widget”
$4,000
4,386
+100%
0
$5,000
+20%
+10%
-100%
$2,193
Selling Costs
IBIT
$6,000
+100%
$2,631
0
$6,878 Selling Costs Cost of Revenue 0 -100%
+15%
13,756
0
$13,529 0 -100%
0
0 -100%
R&D
0
$7,910
Cost of Revenue
R&D
2006 Q4
Revenue Trends
Metrics Revenue Cost of Revenue R&D Gross Profit Selling Costs -100% General and Admin Total Operating Expenses IBIT Revenue $14,882 Interest Income / Expense 0 Income Taxes -100% Net Income
Revenue
2006 Q3
Revenue
Tech2World.com
-100%
2006 Q2
$4,003 0
8,007
Interest Expenses & Taxes $145 -13,529
Reset Data 13,529
Use What-If Analysis sliders to understand the impact of changes in key metrics
Income Statement Analysis Tech2World.com
Revenue Trends
Metrics Revenue Cost of Revenue R&D Gross Profit Selling Costs General and Admin Total Operating Expenses IBIT Interest Income / Expense Income Taxes Net Income
2006 $13,529 $6,878 $2,193 $4,459 $1,450 $2,554 $4,003 $455 $82 $145 $310
$6,000 $5,000 $4,000 $3,000 $2,000 $1,000 $0 ($1,000) ($2,000) 2006 Q1
2006 Q2
2006 Q3
Revenue
2006 Q4
IBIT
Pro-forma Analysis -100%
Revenue
0
$14,882 0 -100%
+10%
27,059 0
$7,910
Cost of Revenue
13,756
-100%
0
$2,631 0
$1,667
27,059
+100%
Income Before Interest & Taxes $-135 -26,148
27,059
$-92
$2,809
0
+100% +10%
5,107
27,059
Total SG&A Expenses
2,899
-100%
Net Income -27,059
+100%
+15%
0
0
$4,341 -18,142
4,386
-100%
General & Admin
Gross Profit
+20%
0
Selling Costs
+100%
+15%
0
R&D
+100%
$4,476 0
8,007
Interest Expenses & Taxes $-43 -13,529
Reset Data 13,529
31
Promote Data-Driven Decisions with Advanced Visualizations
Customer Support Analysis
Cases Opened (This Month)
Increase in Case Load vs TMLY
124
6.25%
1715
162
7.63%
1837
Central
167
8.51%
1645
South
165
8.06%
1742
Southeast
125
5.98%
1764
Southwest
144
7.15%
1730
Online
147
7.29%
1717
Northeast
148
7.66%
Region
Monthly Case Load
Northwest
Use space-saving “sparklines” to show trends over time
(as of Dec. 12, 2006)
Case Load: 180
Mid-Atlantic
Total # Cases Open: 2,164 Total Cases Opened this Month: 1,182
Top 5 Engineers with Highest Case Load (This Month) Mark O’Dea
WebMarker Inc. Westminster Corp
Total Cases Closed this Month: 329
Dakota Knowles
PowerNet Solutions
Jose Martinez
Markham Tech
Total Engineers: 87
Shannon LeGros
Pearson Comm.
View all KPIs in summary format
20
40
60
80
100
120
0
2
Cases
YTD
New Customers (This Month) 1. 2. 3. 4. 5. 6.
32
0
Normal
GlobalTech Corporation Spire Communications, Inc. Creations Software and Firmware Solutions Chain Bridge Financial Corporation BlueNation Technology Concepts Cocoa Brands, Inc.
Bronze Gold Platinum Gold Bronze Platinum
4
6
8 12010
12
Cases
Last Year
Support Level
High
Top 5 Customers with Highest # of Critical Cases Currently Open
Kim Marshalls
New Customers (YTD): 59
Compare key measures to target values or qualitative indicators
148
Low
Obtain actual values with mouse-overs
YTD Case Load
MTD Case Load
Total Open Cases
Open Critical Cases
Top 5 Most Frequently Accessed Technical Notes 1. 2. 3. 4. 5.
#2463 #7846 #9867 #9267 #1837
How to Log Into the MicroStrategy Web Interface Changing Your Project’s Name Streamline Your Metadata Objects How to Best Manage Narrowcast Server The Benefits of Command Manager
14
Customer Support Analysis
(as of Dec. 12, 2006)
Cases Opened (This Month)
Increase in Case Load vs TMLY
124
6.25%
1715
162
7.63%
1837
Central
167
8.51%
1645
South
165
8.06%
1742
Southeast
125
5.98%
1764
Southwest
144
7.15%
1730
Online
147
7.29%
1717
Northeast
148
7.66%
148
Region
Monthly Case Load
Northwest
Case Load: 180
Mid-Atlantic
Low
Total # Cases Open: 2,164 Total Cases Opened this Month: 1,182
Top 5 Engineers with Highest Case Load (This Month)
WebMarker Inc.
Kim Marshalls
Westminster Corp
Total Cases Closed this Month: 329
Dakota Knowles
PowerNet Solutions
Jose Martinez
Markham Tech
Total Engineers: 87
Shannon LeGros
Pearson Comm. 0
40
60
80
100
120
0
2
Cases
YTD
New Customers (This Month) 1. 2. 3. 4. 5. 6.
20
Normal
GlobalTech Corporation Spire Communications, Inc. Creations Software and Firmware Solutions Chain Bridge Financial Corporation BlueNation Technology Concepts Cocoa Brands, Inc.
Bronze Gold Platinum Gold Bronze Platinum
4
6
8 12010
12
14
Cases
Last Year
Support Level
High
Top 5 Customers with Highest # of Critical Cases Currently Open
Mark O’Dea
New Customers (YTD): 59
YTD Case Load
MTD Case Load
Total Open Cases
Open Critical Cases
Top 5 Most Frequently Accessed Technical Notes 1. 2. 3. 4. 5.
#2463 #7846 #9867 #9267 #1837
How to Log Into the MicroStrategy Web Interface Changing Your Project’s Name Streamline Your Metadata Objects How to Best Manage Narrowcast Server The Benefits of Command Manager
33
Visualize and Predict Future Outcome
REVENUE PERFORMANCE FORECAST POLICY TYPE REGION
LIFE
AUTO Revenue Prediction: $24,984 Month: 280000Dec 2007
24000
240000
20000
Southeast
160000
12000
120000
8000
80000
4000
40000
0
Jan 2005 Oct 2005
0
Jul 2006 Apr 2007
320000
28000
280000 240000
16000 12000
12000
4000 0
Jan 2005 Oct 2005 Jul 2006 Apr 2007
8000
40000
4000
0
0
7000
80000
4000 2000
Jan 2005 Oct 2005 Jul 2006 Apr 2007
0
12000 8000 4000 0
Jan 2005 Oct 2005 Jul 2006 Apr 2007
6000
6000
5000
5000
4000
4000
3000
3000
2000
2000
1000
1000
6000
South
60000
5000 4000
40000
3000 2000
20000
1000 0
0
Jan 2005 Oct 2005
34
Jul 2006 Apr 2007
Jan 2005 Oct 2005 Jul 2006 Apr 2007
0
Jan 2005 Oct 2005 Jul 2006 Apr 2007
Pack dense amounts of data into a clear, elegant dashboard
Jan 2005 Oct 2005 Jul 2006 Apr 2007
16000
12000
8000
6000
20000
160000
Jan 2005 Oct 2005 Jul 2006 Apr 2007
10000
20000
0
Jul 2006 Apr 2007
12000
24000
4000
Jan 2005 Oct 2005
16000
8000 8000
16000
80000
HAZARD 14000
16000
200000
120000
8000
Easily compare actual values (shown in gray) to the forecasted values (in blue)
Jan 2005 Oct 2005 Jul 2006 Apr 2007
32000
24000
Central
20000
200000
16000
Extrapolate forecast from current performance
HOME
0
Jan 2005 Oct 2005 Jul 2006 Apr 2007
Gain rapid insight into business trends
REVENUE PERFORMANCE FORECAST POLICY TYPE REGION
LIFE
AUTO Revenue Prediction: $24,984 Month: 280000Dec 2007
24000
240000
20000
160000
12000
120000
8000
40000
0
0
Central
Jul 2006 Apr 2007
Jan 2005 Oct 2005 Jul 2006 Apr 2007
32000
320000
28000
280000
24000
240000
16000 12000
0
Jan 2005 Oct 2005 Jul 2006 Apr 2007
8000 7000
0
Jan 2005 Oct 2005 Jul 2006 Apr 2007
80000
12000 10000
6000 4000 2000 0
Jan 2005 Oct 2005 Jul 2006 Apr 2007
24000
20000
20000
16000
12000
0
Jul 2006 Apr 2007
4000
160000
40000
16000
8000 8000
16000
80000
4000
Jan 2005 Oct 2005
12000
200000
120000
8000
HAZARD 14000
16000
80000
4000
Jan 2005 Oct 2005
20000
200000
16000
Southeast
HOME
8000 4000 0
Jan 2005 Oct 2005 Jul 2006 Apr 2007
12000 8000 4000 0
Jan 2005 Oct 2005 Jul 2006 Apr 2007
6000
6000
5000
5000
4000
4000
3000
3000
2000
2000
1000
1000
6000
South
60000
5000 4000
40000
3000 2000
20000
1000 0
0
Jan 2005 Oct 2005
Jul 2006 Apr 2007
Jan 2005 Oct 2005 Jul 2006 Apr 2007
0
Jan 2005 Oct 2005 Jul 2006 Apr 2007
0
Jan 2005 Oct 2005 Jul 2006 Apr 2007
35
Copyright Notice: Copyright © 2007 MicroStrategy Incorporated, 1861 International Drive, McLean, VA, 22102 USA. All Rights Reserved. The material presented herein is based on information we consider reliable. We do not represent that it is accurate and complete. No person should consider our distribution of this material as making any representation or warranty with respect to such material and should not rely solely upon it as such.
This product is patented. One or more of the following patents may apply to the product sold herein: U.S. Patent Nos. 6,154,766, 6,173,310, 6,260,050, 6,263,051, 6,269,393, 6,279,033, 6,501,832, 6,567,796, 6,587,547, 6,606,596, 6,658,093, 6,658,432, 6,662,195, 6,671,715, 6,691,100, 6,694,316, 6,697,808, 6,704,723, 6,707,889, 6,741,980, 6,765,997, 6,768,788, 6,772,137, 6,788,768, 6,792,086, 6,798,867, 6,801,910, 6,820,073, 6,829,334, 6,836,537, 6,850,603, 6,859,798, 6,873,693, 6,885,734, 6,888,929, 6,895,084, 6,940,953, 6,964,012, 6,977,992, 6,996,568, 6,996,569, 7,003,512, 7,010,518, 7,016,480, 7,020,251, 7,039,165, 7,082,422 and 7,113,993. Other patent applications are pending.
Trademarks: MicroStrategy, MicroStrategy 6, MicroStrategy 7, MicroStrategy 7i, MicroStrategy 7i Evaluation Edition, MicroStrategy 7i Olap Services, MicroStrategy 8, MicroStrategy Evaluation Edition, MicroStrategy Administrator, MicroStrategy Agent, MicroStrategy Architect, MicroStrategy BI Developer Kit, MicroStrategy Broadcast Server, MicroStrategy Broadcaster, MicroStrategy Broadcaster Server, MicroStrategy Business Intelligence Platform, MicroStrategy Consulting, MicroStrategy CRM Applications, MicroStrategy Customer Analyzer, MicroStrategy Desktop, MicroStrategy Desktop Analyst, MicroStrategy Desktop Designer, MicroStrategy eCRM 7, MicroStrategy Education, MicroStrategy eTrainer, MicroStrategy Executive, MicroStrategy Infocenter, MicroStrategy Intelligence Server,MicroStrategy Intelligence Server Universal Edition, MicroStrategy MDX Adapter, MicroStrategy Narrowcast Server, MicroStrategy Objects, MicroStrategy OLAP Provider, MicroStrategy SDK, MicroStrategy Support, MicroStrategy Telecaster, MicroStrategy Transactor, MicroStrategy Web, MicroStrategy Web Business Analyzer, MicroStrategy World, Alarm, Alarm.com, Alert.com, Angel, Angel.com, Application Development and Sophisticated Analysis, Best In Business Intelligence, Centralized Application Management, Changing The Way Government Looks At Information, DSSArchitect, DSS Broadcaster, DSS Broadcaster Server, DSS Office, DSSServer, DSS Subscriber, DSS Telecaster, DSSWeb, eBroadcaster, eCaster, eStrategy, eTelecaster, Information Like Water, Insight Is Everything, Intelligence Through Every Phone, Your Telephone Just Got Smarter, Intelligence To Every Decision Maker, Intelligent E-Business, IWAPU, Personal Intelligence Network, Personalized Intelligence Portal, Query Tone, Quickstrike, Rapid Application Development, Strategy.com, Telepath, Telepath Intelligence, Telepath Intelligence (and Design), The E-Business Intelligence Platform, The Foundation For Intelligent E-Business, The Integrated Business Intelligence Platform Built For The Enterprise, The Intelligence Company, The Platform For Intelligent E-Business, The Power Of Intelligent eBusiness, The Power Of Intelligent E-Business, The Scalable Business Intelligence Platform Built For The Internet, Industrial-Strength Business Intelligence, Office Intelligence, MicroStrategy Office, MicroStrategy Report Services, MicroStrategy Web MMT, MicroStrategy Web Services and Pixel Perfect are all registered trademarks or trademarks of MicroStrategy Incorporated. All other products are trademarks of their respective holders. Specifications subject to change without notice. MicroStrategy is not responsible for errors or omissions. MicroStrategy makes no warranties or commitments concerning the availability of future products or versions that may be planned or under development.
www.microstrategy.com
COLL-0674 0107