Michiel DelpeutDelpeut@cns.nl

www.cns.nl

General Introduction:

DataWarehouse Explorer

Agenda

1. CNS: Vision2. DWE: Scope of Solution3. DWE: Solution Components4. CNS: Company Profile

1. CNS Vision

Vision: BI Dominates IT Priorities

Source: Gartner, 2009

1. Business Intelligence

2. Enterprise Applications (ERP, CRM, and others)3. Servers and Storage Technologies (Virtualization)4. Legacy Application Modernization5. Collaboration Technologies6. Networking, Voice and Data Communication7. Technical Infrastructure8. Security Technologies9. Service Oriented Applications and Architecture10.Document Management

Vision: BI covers your Business Issues

Source: Gartner, 2009

BI related1. Business Process Improvement2. Reducing Enterprise Costs3. Improving Enterprise Workforce Effectiveness

4. Attracting New Customers

5. Increasing the Use of Information/Analytics6. Creating New Products or Services (Innovation)

7. Targeting Customers and Markets More Effectively8. Managing Change Initiatives9. Expanding Current Customer Initiatives10.Expanding Into New Markets and Geographies

Decision makers want multiple questions addressed; Questions are not one-dimensional but multi-dimensional

one-dimension

How much has our company spent on staff costs; And how much is this divided per Month or per Quarter;how much at Maintenance, divided per Company Division;in comparison with the plan of this year, but also last year; and what are the expectations for next year?

multi-dimensional

Vision: OLAP Analysis crucial part of BI:

Vision: Required BI/OLAP Solution

Operational ITConsume

CreateAct

End Users BI AnalystManager

Critical factor not to collect but to disclose data:Solution Criteria: User Friendly – Affordable - Scalable;Provide ability to Consume, Create, and Act on reports.

ActCreateConsume

CreateConsume

Act

BOCognos

Hyperion

MS Reporting ServicesCrystal Reports

ExcelStandard Reporting

Acceptance

Custom Solutions

Vision: DWE Portal designed to meet market requirements

2. DWE – Application Scope

Solution: What does DWE provide?

• BI Solution: Completely Integrated Analytics & Reporting

• Intuitive BI solution : Consume, Create, and Act

• Ad Hoc Analytics, Standard Reporting, KPI Visualization, Report Scheduling, Dashboards

• Solid and affordable investment

• Web-Client or through Desktop

• Rich support for SQL Server AS

Solution: Solution Architecture

InformationModel

Sources SQLMS AS

DWE PortalDWE Client

ETL/DWHDWH/OLAP

DatabasesDatamarts

BI: Analytics & Reporting

– Most Intuitive BI Solution

– No Training Required – Simplicity of Installation

– Easy To Maintain & Manage

– Affordable & Transparent Costs

– Speed of Processing & Analysis

Solution: What makes DWE unique?

3. DWE : Solution Components

Components: DataWarehouse Explorer

Drag &

Drop

Recognizable Office 2007 Ribbon

Fast business insight obtained

QualitativeGraphics & Charting

Components: DWE Geo-Integration

New: Integration of DWE with Mapping Technology:

Use Colors to Highlight Relative Value or Trends

Use Graphic Size to Analyze Relative Value

Components: DWE Portal

Portal Functions:

• Repository: Central & Intuitive Report Location

• Access: Fully Thin Point of Access to Reports;

• Web Server: Very Light Deployment of DWE client;

• Scheduling: Distribution Scheduling of Reports

• Security: Defining Access to Portal and Data

4. CNS: Company Profile

• Dutch Company founded in 1994• 15 years experience international DWH projects• Dutch market leader in real estate sector • Microsoft Gold Certified ISV Partner

Mission: Deliver the most intuitive BI solution for market Expand international partner & customer presence

CNS: History & Mission

EMEA:– Netherlands– UK– Germany– Austria– Switzerland – Italy– Spain– Sweden– Israel

AMERICAS:– Canada– USA

– Mexico– Costa Rica– Guatemala– Brazil – Peru– Venezuela

CNS: Providing global presence…

EMEA:– Netherlands– UK– Germany– Austria– Switzerland – Denmark– Spain– Italy– Russia

AMERICAS:– USA– Canada

– Argentina– Brazil– Costa Rica– Guatemala

DWE installed across the globe…

CNS: Active across all industries:

Maritime Services

Defense Export Services Organization