慧谷培训 >>> 特色技术课 >>> Cognos 数据管理与企业数据课程介绍   
    搜索课程
搜索:
选项:
 在线咨询    最新课表
    推荐课程
  优惠组合课程
思科官方授权CCNA+CCDA双证班10.
思科官方授权CCNA+CCNP培训只需4.
思科+微软黄金组合3900元
最有价值的网管课程6500元
信息安全技术认证培训
MCSE2012&全球IT认证金牌课程
  Cisco(思科)
思科官方授权CCNA培训
思科官方授权CCNP培训
思科官方授权CCIE培训系统
全国独家Cisco官方售前培训班
思科官方授权CCSP培训
  政府补贴
政府补贴中高级计算机程序设计员Java
Office政府补贴
  微软/Linux
微软MCSE认证/server2012
MCSE2003企业定制
红帽认证工程师(RHCE7)
微软官方MCITP 2008
  Office认证培训
Word课程
Excel 2010基础入门应用
Excel中高级课程
Excel在企业管理上应用(专家级)
PowerPoint课程
Access课程
Outlook课程
  平面广告设计
Adobe平面设计师班
专业美术创意设计班
Adobe Photoshop实战应用班.
高级平面广告创意设计师
  室内设计
AutoCAD 全能
3D MAX 全能班
高级室内创意设计师
  网页设计
CSS+DIV 网页高级布局
动态网页及高级WEB开发班
资深微软认证WEB开发大师班
资深SUN Java WEB开发大师班
Adobe Flash
资深网页设计美工定向班
  影视动画制作课程
3D MAX影视动画全科班
  MAYA动漫游戏
Autodesk Maya认证班
  编程开发系列
Java初级入门SL-110
Jsp Web开发 SL314
Java模式设计OO-226
J2EE企业高级解决方案
  特色技术课
Visual Studio TFS
VB.NET 开发编程
微软.net开发实战培训
C#技术基础课程
SQLserver 实现和维护
SQLserver 商业智能
Exchange2010 管理实战
Exchange 2007 管理实战
MOSS 2013(sharepoint.
MOSS 2013(sharepoint.
Lotus Notes企业应用
Oracle OCP 数据库管理开发实战
VMware vSphere实战 VCP
IOS精英直通车班
IOS核心速成班
Windows 8桌面支持专家
互联网前端开发工程师(html5+JS)
安卓Android开发实训营
  小型机系统管理
HP-Unix系统及网络管理I
AIX 6 Basics AU13
大型机操作系统
Solaris 操作系统网络管理
  工业设计
CATIA V5/V6 造型设计实战应用
Pro/E 3/4/5/6 模具设计实战.
Pro/E 3/4/5/6 钣金设计实战
UG NX 5/6/7造型设计实战应用
UG NX 5/6/7模具设计实战
UG NX 8.0 数控加工实战应用
SolidWorks 实战应用
  软件测试专业培训
软件测试提高班
软件测试就业班
  企业管理课程
人力资源管理师二级
企业培训师二级
有效沟通技巧实战培训
  IT英语
IT英语,IT职业英语
暂无小分类
  大数据
   
    广告课程
  >>> Cognos 数据管理与企业数据开班介绍
课程周期: 4天 培训费用: 10000 元
使用教材: 指定教材 教材费用: 不含教材费和考试费
学员收益: 技术提升,熟练应用
咨询电话: 021-64472947、13122257700  64470100   
  >>> Cognos 数据管理与企业数据最近开班
编 号 上课地点 学习时段 开课时间 在线报名


现在报名预约此课程

  >>>  Cognos 数据管理与企业数据详细介绍

Course: Cognos Data Manager: Build Data Marts with Enterprise Data (V10.1) B5180CN
Durations:4
Fees:10000RMB

Outline
1、Getting Started
 Identify the purpose of Cognos Data Manager
 Define data warehousing and its key underlying concepts
 Identify how Data Manager creates data warehouses
 Examine the Data Manager architecture and user interface

2、Create a Catalog
 Examine the purpose and contents of Data Manager catalogs
 Create a catalog
 Define connections to source and target data
 Access data using SQLTerm
 Configure flat data source files using SQLTXT

3、Create Hierarchies
 Examine the role of the dimensional framework in Data Manager
 Examine hierarchies and their data sources
 Identify how to create hierarchies from the columns of one table, the rows of one table, and from multiple tables
 Test and view hierarchies
 Create a hierarchy of static date values
 Handle weeks in a date hierarchy

4、Create Basic Builds
 Examine Data Manager builds and build-related terminology
 Create a dimension build using the Dimension Build wizard
 Create a fact build using the Fact Build wizard
 Test and execute a fact build
 Document a catalog
 Create catalog schema

5、Create Derivations
 Examine derivations
 Apply operators and functions to derivations
 Examine the derivation timing model
 Add derivations to a fact build

6、Create Conformed Dimensions
 Examine conformed dimensions and their advantages
 Design conformed dimensions
 Create conformed dimensions
 Create data integrity lookups that use conformed dimensions

7、Customize Reference Structures
 Create hierarchies manually using different approaches
 Examine the features of a hierarchy
 Examine literals
 Set data access for hierarchy levels
 Examine static and dynamic members
 Examine fostering
 Use derivations in a hierarchy

8、Process Dimensional History and Late Arriving Facts
 Examine slowly changing dimensions (SCDs)
 Use surrogate keys in SCDs
 Manage type 1 and type 2 changes to dimensional data
 Load historical data for a dimension
 Examine late arriving facts
 Process late arriving facts in a fact build

9、Transform Data Using Lookups and Derived Dimensions
 Identify when to use lookups
 Identify the requirements for a lookup
 Create a translation lookup
 Create an optional lookup
 Add derived dimensions to fact builds

10、Customize Data Delivery
 Configure fact and dimension delivery modules
 Create indexes on fact and dimension tables
 Update fact data using keys

11、Customize Fact Data Processing
 Filter fact data
 Merge duplicate fact data
 Examine fact data integrity checking
 Reject fact data

12、Aggregate, Filter, and Partition Fact Data
 Aggregate fact data
 Examine aggregate rules
 Vertically restrict fact data
 Horizontally restrict fact data
 Partition fact data

13、Implement Job Control
 Examine where job control fits into the data warehouse lifecycle
 Create a JobStream
 Add, link, and reposition nodes
 Execute a JobStream and view the results

14、Automate Functionality Using Commands
 Differentiate between the Command Line Interface (CLI) and Data Manager Designer
 Identify common commands
 Use commands in a batch file
 Examine variables

15、Customize Functionality with User-Defined Functions and Variables
 Examine user defined functions (UDFs)
 Create an internal UDF
 Create a user-defined variable

16、Process Unbalanced Hierarchical Data
 Examine balanced, unbalanced, and ragged hierarchies
 Add a recursive level to a hierarchy
 Identify ways to balance a hierarchy and delivered flattened data
 Examine circular references

17、Pivot Fact Data
 Examine pivoting
 Use the single pivot technique
 Use the advanced pivot technique
 Examine reverse pivoting

18、Resolve Data Quality Issues
 Identify data quality and cleansing issues
 Handle fostered and unmatched members
 Perform debugging using SQLTerm and functions
 Assess the quality of output data

19、Troubleshoot and Tune the Data Manager Environment
 Use build logging to ensure that data marts are being loaded properly
 Perform dimension breaking
 Manage memory and resources
 Export DDL statements

20、Organize and Package Data Manager Components
 Export and import components using packages
 Search for components in a catalog using Navigator

21、Integrate with Cognos BI
 Examine Cognos BI
 Identify the role of metadata dimensions, metadata collections, and metadata stars
 Export Data Manager metadata to XML
 Import Data Manager XML into Framework Manager
 Use Data Manager metadata with Cognos BI
 Publish a data movement task to Cognos Connection

22、End-to-End Workshop

23、Entity-Relationship Model of the GO_Demo Database (Optional)

24、Work in a Multi-Developer Environment (Optional)
 Examine collaborative development support
 Examine the source code repository
 Examine the component dependency model
 Identify planning considerations

25、Standardizing Dimensions and Facts Exercise (Optional)

26、Review of Data Manager Essentials (Optional)
 Data warehouse design
 The purpose of Data Manager components
 Development steps in Data Manager to create data marts
 Track dimensional changes and late arriving facts
 

  >>> 这个课程我有问题向老师咨询
姓 名: 慧谷联络,不对外公布
电 话: 慧谷联络,不对外公布
邮 件: 慧谷回复提问,不对外公布
问 题:
验 证:  
 
 
查看Cognos 数据管理与企业数据最新开班时间    
最新课表 学院优势 学院新闻 授权证书 交通地图 师资力量 教学环境 分校地址 实验申请 证书查询 成绩查询 联系我们 

上海慧谷职业技能培训中心  徐汇区乐山路33号2号楼4楼  
报名热线:021-64076538   64470100   54510150   64482972
Q Q:56823   MSN:xiangyin2005@hotmail.com   Email:train@withub.org
Copyright© 2006—2008 All Right Reserved  IP/ICP备案:沪ICP备09071445号
劳动局认证批准文号:沪劳保技(2003)34号    教育局认证批准文号:徐教社(2005)310号