如何构建数据中心.ppt

eForce Proprietary Confidential 如何构建数据中心Data Warehousing 大纲 商业智能 – 实施案例与效益 数据仓库 – 构建过程 数据仓库 – 构建的工具与技能 数据中心 – 方案实施的步骤 商业智能 – 实施案例与效益 数据仓库 目标导向方式分析 三种解决方案 数据仓库 – 构建过程 D/W 构建的工具与技能 有否一个工具解决得了? D/W 构建的工具与技能 (数据中心解决方案)的实施步骤 Summary Superior DW, BI experience Proven DW/BI Global Delivery Model Expertise in best in class enabling technology packages Superior implementation methodology * 欢迎免费共享交流.. Alex ? * Alex Chan 陈国纬MCSE, OCP, MIS, E C Dip, Aircraft Engineer Cert.e-mail: alex@ Tel: +86Date: 2007 Dec. High 商业价值 Business Value Low High 分析的复杂性 Complexity of Analysis “有什么事情已经发生?” “What has happened?” “事情怎样发生?” “Why has it happened?” “有什么事情将会发生?” “What will happen?” 建议行动 Recommended Actions 指标 Insight 分析 Analysis 讯息 Information 数据 Data Competitive Advantage Baseline Metrics Predictive Metrics Descriptive Metrics 产品 商标 花费 客户 客户分析 销售 库存 供应商 市场 操作的数据Operational data 数据Information 决定层 Decision Maker 客户 Customer 地区 Geography 产品 Product 销售 Sales 财务 Financial 库存 Inventory 按系统或部门组 Organized by processes or tasks 按主题分组 Organized by subject 系统Operational Systems 数据仓库Data Warehouse DATA SOURCES STAGING AREA DATA WAREHOUSE DECISION SUPPORT Application Databases Packaged application/ERP Data Desktop Data External Data Web-based Data [Adapted from SunExpert Magazine, October 1998.] ______________________________________________________ INCOME ANNUAL REPORT ___ ___ ____ _____ ___ __ ___ ___ ____ _____ ___ __ ___ ___ ____ _____ ___ __ Reports EIS OLAP Statistical Financial Analysis EXTRACTION TRANSFORMING CLEANING AGGREGATION DATA WAREHOUSE DATA MARTS Informatica, Ascential Datastage ETL Tools Microstrategy, Information Advantage, Informix Metacube ROLAP Tools Oracle, Sybase, SQL Server, Informix, Red Brick Databases Cognos, Hyperion Essbase, Brio, Business Objects MOLAP Tools Seagate Info, Holos HOLAP Tools Cold Fusion 4.x, Microstrategy DSS Web, Brio On demand server, Cognos Powerplay Web,