慧谷培训 >>> 特色技术课 >>> Cognos Data课程介绍   
    搜索课程
搜索:
选项:
 在线咨询    最新课表
    推荐课程
  优惠组合课程
思科官方授权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企业高级解决方案
  特色技术课
VB.NET 开发编程
Visual Studio TFS
微软.net开发实战培训
C#技术基础课程
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 Data开班介绍
课程周期: 30小时 培训费用: 12500 元
使用教材: 送培训讲义,教学光盘 教材费用: 包含教材费
学员收益: 熟练掌握
咨询电话: 021-64472947、13122257700  64470100   
  >>> Cognos Data最近开班
编 号 上课地点 学习时段 开课时间 在线报名


现在报名预约此课程

  >>>  Cognos Data详细介绍

Cognos Data Manager: Build Data Marts with Enterprise Data (V10.1)

课程周期:30小时 
培训费用:12500 元
使用教材:培训讲义
教材费用:送培训讲义,教学光盘

咨询电话:021-64472947
学员收益:Cognos Data Manager: Build Data Marts with Enterprise Data (V10.1) is a five-day, instructor-led course that teaches participants how to move, merge, consolidate, and transform data from a range of data sources to build and maintain subject-area data marts. In the process, students will create a catalog and add connections to data sources and targets. They will also deliver fact and dimension data to a data mart through the use of builds and the dimensional framework. In addition, students will learn how to automate common functionality and handle complex data issues, such as unbalanced hierarchical structures.


一、 培训介绍
    1、30小时、培训费12500元、培训版本:COGNOS BI 10.1
    2、附送培训讲义,培训光盘,


二、 课程简介

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

End-to-End Workshop

Entity-Relationship Model of the GO_Demo Database (Optional)

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

Standardizing Dimensions and Facts Exercise (Optional)

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

三、 企业团体定制介绍
   1、可提供团体定制培训,为企业量身定做。
   2、咨询热线:021-64472947

 

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

上海慧谷职业技能培训中心  徐汇区乐山路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号