Download - 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