Dashboard

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Dashboard as PDF for free.

More details

  • Words: 10,486
  • Pages: 36
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

Related Documents

Dashboard
May 2020 23
Dashboard
November 2019 23
2q Dashboard
May 2020 15
Dashboard 2
June 2020 11
Psm Dashboard
May 2020 16