首页 考试吧论坛 Exam8视线 考试商城 网络课程 模拟考试 考友录 实用文档 求职招聘 论文下载
2011中考 | 2011高考 | 2012考研 | 考研培训 | 在职研 | 自学考试 | 成人高考 | 法律硕士 | MBA考试
MPA考试 | 中科院
四六级 | 职称英语 | 商务英语 | 公共英语 | 托福 | 雅思 | 专四专八 | 口译笔译 | 博思 | GRE GMAT
新概念英语 | 成人英语三级 | 申硕英语 | 攻硕英语 | 职称日语 | 日语学习 | 法语 | 德语 | 韩语
计算机等级考试 | 软件水平考试 | 职称计算机 | 微软认证 | 思科认证 | Oracle认证 | Linux认证
华为认证 | Java认证
公务员 | 报关员 | 银行从业资格 | 证券从业资格 | 期货从业资格 | 司法考试 | 法律顾问 | 导游资格
报检员 | 教师资格 | 社会工作者 | 外销员 | 国际商务师 | 跟单员 | 单证员 | 物流师 | 价格鉴证师
人力资源 | 管理咨询师考试 | 秘书资格 | 心理咨询师考试 | 出版专业资格 | 广告师职业水平
驾驶员 | 网络编辑
卫生资格 | 执业医师 | 执业药师 | 执业护士
会计从业资格考试会计证) | 经济师 | 会计职称 | 注册会计师 | 审计师 | 注册税务师
注册资产评估师 | 高级会计师 | ACCA | 统计师 | 精算师 | 理财规划师 | 国际内审师
一级建造师 | 二级建造师 | 造价工程师 | 造价员 | 咨询工程师 | 监理工程师 | 安全工程师
质量工程师 | 物业管理师 | 招标师 | 结构工程师 | 建筑师 | 房地产估价师 | 土地估价师 | 岩土师
设备监理师 | 房地产经纪人 | 投资项目管理师 | 土地登记代理人 | 环境影响评价师 | 环保工程师
城市规划师 | 公路监理师 | 公路造价师 | 安全评价师 | 电气工程师 | 注册测绘师 | 注册计量师
缤纷校园 | 实用文档 | 英语学习 | 作文大全 | 求职招聘 | 论文下载 | 访谈 | 游戏
您现在的位置: 考试吧(Exam8.com) > 软件水平考试 > 计算机专业英语 > 正文

How To Do a Data Warehouse Assessment (And Why)



  Organization

  This decomposition also provides an excellent framework to specify and communicate the potential scope of the assessment project, and the range of its expected deliverables. Gaps, risks, constraints, opportunities, and resulting recommendations may be identified for each of these areas.

Figure 1: Decomposing the Data Warehouse

  Business Needs Assessment includes an analysis of the underlying business drivers and objectives and overall context of business need that has been established for the data warehouse. In an assessment the objective is not to perform the analysis. It is to determine the degree of analysis that has been done, and to identify any business analysis gaps and their impacts. In some instances no business needs analysis has been done. In these cases some high level identification and ranking of business information needs is an essential part of the assessment; necessary for the assessment to have any meaningful context in which gap analysis is performed and recommendations are developed. When business needs have been defined, the assessment process examines the approach to capturing business requirements, their completeness and organization, the priorities of the requirements, and alignment of the data warehouse release strategy and deliverables to the needs. In conjunction with the Technical Architecture Assessment (see below) it considers how effectively front-end tools are applied.

  The following key questions are among those that a business needs assessment may address:

  Have business drivers and objectives been identified?

  Have business requirements been documented?

  Do the requirements align with business drivers and objectives? Do they focus on strategies that respond to the drivers?

  Do the information needs identify and target the enabling of specific business processes and tactics?

  Do the information needs identify the key performance indicators (business metrics) and business perspectives (dimensions, descriptive attributes) needed to measure, analyze, and optimize the targeted business processes?

  Do they identify the roles to be supported, their number and distribution?

  Do they identify the frequency and volume of reporting and analytical needs?

  Information Architecture Assessment includes an analysis of logical data structures, their feasibility, completeness, documentation, and fit to business requirements. Information architecture assessment also includes analysis of data sourcing and transformation, the methods and assumptions applied, and validation of mappings to business requirements. Metadata, as part of the information architecture, is examined with respect completeness of metadata being tracked, user metadata requirements, and approaches to management of the metadata. A review of metadata tools is undertaken in conjunction with the Technical Architecture Assessment (see below).

  Key questions addressed by information architecture assessment include:

  Are the information requirements modeled?

  Do they map to and support the identified business requirements?

  Have they been considered in context of the broader enterprise?

  Have key data life cycles have been traced and documented? (to identify correct points and periodicity of data capture and associated business rules)

  Are data transformations fully documented?

  Have user and operational metadata needs been identified? Is a metadata strategy to meet these needs identified and implemented?

  Have data quality issues have been identified and addressed? Do users trust the data being delivered?

  Do the users understand what data is available, what the data is, and how to use it?

  Can users get to, manipulate, and analyze the data when and in form needed?(overlaps with technical architecture benchmarks)

  Does data access and analysis clearly add business value and meet business needs?

  Is the underlying data architecture flexible and extensible? Can it support multiple analytical needs? Does it readily allow for integration of new data?

  Technical Architecture Assessment looks at current hardware, software and network infrastructure, and examines physical database designs. Technical architecture assessment seeks to identify any technical risks or constraints with regard to performance, maintenance, scalability, data distribution, disaster recovery, and sizing. This assessment also seeks to identify opportunity to leverage the value of existing technical resources. Effective use of tools, and their overall fit to the business and technical environments is examined, including extraction and transformation, cleansing, database performance tuning, modeling, metadata management, querying, multidimensional analysis, web enabling tools.

更多软考资料请访问:考试吧软件水平考试栏目

希望与更多网友交流,请进入考试吧软件水平考试论坛

上一页  1 2 3 4 5 6 7 8 9 下一页
文章责编:ak47  
看了本文的网友还看了
·计算机英语因特网(中英对照)  (2007-6-21 8:35:31)
·常见网址英文缩写的含义汇编表  (2007-6-21 11:33:47)
·计算机专业英语名词解释大汇总  (2007-1-25 11:39:39)
·E-mail地址中的符号@是什么意思  (2007-1-25 11:32:20)
·了解到底什么是多媒体  (2007-1-25 11:29:34)
·A range of grid-related questions  (2007-1-25 11:26:39)
文章搜索
软件水平考试栏目导航
版权声明:如果软件水平考试网所转载内容不慎侵犯了您的权益,请与我们联系800@exam8.com,我们将会及时处理。如转载本软件水平考试网内容,请注明出处。