ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
start courses and schedules education savings it certification education solutions
recherche de formation
Faites confiance à votre formation en TI   |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

InfoSphere Warehouse 9 Components  (DW352)

Format: Formation en classe avec formateur
Autres formats:
 
 

This course is designed to give you an in-depth knowledge of the components of InfoSphere Warehouse. The course will start with the SQL Warehousing Tool where, using the Design Studio, you will create both data and control flows and then deploy their work to the Warehouse Console. (There is also a two-day course, DWA52, that covers this same material.) That is followed by defining OLAP metadata after which you will deploy a cube to a Cubing Services server. (There is also a one-day course, DWB52, that covers this same material.) Finally, you will create mining flows that will invoke clustering, prediction, and association mining algorithms as well as mining flows that do unstructured text analysis. (There is also a two-day course, DWC52, that covers this same material.) This course is for those who are using IBM InfoSphere Warehouse and IBM InfoSphere Warehouse on System z.

This course is appropriate for students who are using InfoSphere Warehouse within the IBM Smart Analytics system and for students that are using IBM InfoSphere Warehouse and IBM InfoSphere Warehouse on System z independently.

Course Materials

The course materials address InfoSphere Warehouse 9.7.

Hands-On Labs

Fourteen labs are included to address InfoSphere Warehouse 9.7.

Training Path

This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education.
 
This Course is Certified By IBM   Flex Training Savings
 

Compétences acquises
 
  • Describe the components of InfoSphere Warehouse
  • Use the Design Studio to physically model tables that will be used as sources and targets for the SQL Warehousing Tool
  • Use the Design Studio to create data flows in order to move data within DB2
  • Combine data flows into control flows and deploy the control flows into the SQL Warehousing Tool runtime environment
  • Describe the different data mining algorithms supported by InfoSphere Intelligent Miner
  • Create mining flows that will create data mining models and score those models against new data
  • Use Intelligent Miner Visualizers to view data mining results
  • Use Cubing Services to create MQTs to enhance some OLAP tools’ performance
  • Extract data from an unstructured text field in order to enhance a data mining run

Qui peut en profiter
 

The advanced course is for those who will be administering one or more of the components that come with IBM InfoSphere Warehouse or IBM InfoSphere Warehouse on System z.

Préalables
 

You should be familiar with DB2.

Abstract
 

IBM Education Advantage Program eligibility:

  • Yes - IBM Education Pack - online account
 
Enroll For This Class
Enroll For This Class
DB2 Lotus Tivoli Training Class Ce cours est donné par des formateurs certifiés IBM.

À titre de partenaire en formation agréée , ExitCertified peut vous inscrire à n’importe quel cours en Amérique du Nord.

Il y a une différence. Découvrez-la
Training Class Enrollment Ask A Question About This Training
Code: DW352
Format: Formation en classe avec formateur
Durée: 5 days
Certifié par: IBM
Frais d’inscription (CAD): $contact
TrainingIndustry.com selects ExitCertified as a Top 20 IT Training Company for 2011
Recherchez des cours semblables
Cours connexes

Trier l'horaire par: 
     
Towson/Baltimore, MD Oct.29 - Nov.2.2012 course register
1 Dates Offered      
   
demander une autre date/un autre emplacement demander de la formation sur place
 

InfoSphere Warehouse 9 Components  (DW352) Contenu détaillé
 
 
InfoSphere Warehouse Components Overview
  • Describe the InfoSphere Warehouse architecture
  • List the components of InfoSphere Warehouse
  • List the different InfoSphere Warehouse editions
Design Studio
  • Describe the Eclipse platform
  • Explain how to use perspectives in the Design Studio
  • List the components of the Business Intelligence perspective
  • Explain how to customize Design Studio perspectives
Physical Data Modeling
  • Explain how to create physical data models from scratch or by reverse engineering
  • Describe how to validate the model using Analyze Model
  • Generate a DDL script to deploy your model to a database
  • Compare objects in the project to the database to generate a delta DDL script
SQL Warehousing Tool
  • Describe the use of the SQL Warehousing Tool
  • List the SQL Warehousing Tool components
  • Explain the use of data flow: Operators, Ports, and Connectors
  • List the components of a data warehouse project
  • Describe the use of variables in the SQL Warehousing Tool
  • Define a data station operator
  • Describe an Execution Plan Graph
Control Flows
  • Define a control flow
  • List the components of a control flow
  • Describe control flow ports
  • Explain how to use the control flow iterator
  • Describe the integration between SQW and DataStage
  • Explain how to import a DataStage parallel job to run in SQW
Administration Console
  • Describe the SQL Warehousing Tool deployment process
  • Explain the use of application profiles
  • List the functions of the Administration Console
  • Explain the role based security used by the Administration Console
Introduction to Cubing Services
  • Define OLAP and its position with Business Intelligence
  • Contrast different types of OLAP
  • State the benefits of OLAP
  • List the components of Cubing Services
  • Define Summary Tables as used by Cubing Services
  • Describe how Cubing Services exploits Summary Tables
  • State the benefits of using Cubing Services
Cubing Services Metadata
  • Explain how OLAP metadata is:
    • Imported into the Design Studio
    • Deployed to the InfoSphere Warehouse repository
  • List the main tasks when defining a cube model
  • Describe dimensions, levels and hierarchies
  • List the different hierarchy types
  • Define advanced measures for a cube model
Cubing Services Security and Virtual Cubes
  • Describe Cubing Services concept of virtual cubes
  • Explain how to create a virtual cube
  • Give examples of where a virtual cube is appropriate
  • Explain how to merge members in a virtual cube
  • List the objects that make up the Cubing Services security model
  • Describe the Cubing Services security model lifecycle
  • Explain the resolution when there are conflicting access and deny policies for a user
Cubing Services Administration
  • Describe the Cubing Services architecture
  • List some examples of cube server configuration parameters
  • List the cube deployment criteria
  • Describe the action that takes place when queries are made against a cube server
  • Describe some tools used to query a cube via a Cubing Services cube server
 
Cubing Services Optimization Advisor
  • State the benefits of using Summary Tables
  • Compare SQL used to create different Summary Tables
  • Use Optimization Advisor to generate Summary Table scripts
A Data Mining Foundation
  • Define data mining
  • Distinguish between verification-driven and discovery-driven analysis
  • Discuss where data mining can be applied
  • Describe the key elements for a successful data mining project
  • Describe the purposes and uses of a data mining process
  • State six steps in a data mining process
An Introduction to InfoSphere Intelligent Miner
  • Describe the components of InfoSphere Intelligent Miner
  • List the different model types supported by InfoSphere Intelligent Miner Modeling
  • Describe how InfoSphere Intelligent Miner Scoring is used
  • Explain how to inspect your data using different distributions: Univariate, Bivariate, and Multivariate
  • Describe how to execute a mining flow
  • Discuss how to generate a Java class from a mining flow
InfoSphere Intelligent Miner Supported Mining Techniques
  • Describe the Cluster function used in InfoSphere Intelligent Miner Modeling
  • Describe the Classification function used in InfoSphere Intelligent Miner Modeling
  • Describe the Regression function used in InfoSphere Intelligent Miner Modeling
  • Describe the Associations function used in InfoSphere Intelligent Miner Modeling
  • Describe the Sequential Rule function used in InfoSphere Intelligent Miner modeling
  • Describe the Time Series Analyisi function used in InfoSphere Intelligent Miner modeling
Unstructured Text Analytics
  • Describe the regular expression extraction capabilities of InfoSphere Warehouse
  • Describe how the frequent terms analysis capabilities of the Design Studio can aid in creating a dictionary
  • Describe how list base information extraction can be used to enhance a data mining run
Agenda
 
Day 1
  • Welcome
  • Unit 1: InfoSphere Warehouse Components Overview
  • Unit 2: Design Studio
  • Exercise for Design Studio
  • Unit 3: Data Modeling
  • Exercise for Data Modeling
  • Unit 4: SQL Warehouse Tool
Day 2
  • Exercise for SQL Warehouse Tool
  • Unit 5: Control Flows
  • Exercise for Control Flows
  • Unit 6: Administration Console
  • Exercise for Administration Console
Day 3
  • Unit 7: Introduction to Cubing Services
  • Unit 8: Cubing Services Metadata
  • Exercise for Cubing Services Metadata
  • Unit 9: Cubing Services Administration
  • Exercise for Cubing Services Administration
Day 4
  • Unit 10: Cubing Services Optimization Advisor
  • Exercise for Optimization Advisor
  • Unit 11: A Data Mining Foundation
  • Unit 12: An Introduction to InfoSphere Intelligent Miner
  • Unit 13: InfoSphere Intelligent Miner Supported Mining Techniques
  • Topic 1: Clustering Functions
  • Exercise for Clustering
  • Topic 2:Predictive Models
Day 5
  • Unit 13: InfoSphere Intelligent Miner Supported Mining Techniques (Continued)
  • Exercise for Prediction
  • Topic 3: Associations and Sequential Rule
  • Exercise for Associations and Sequential Rule
  • Unit 14: Unstructured Text Analysis


  ExitCertified is your Authorized IT Training Partner  
  Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source.

Il y a une différence. Apprenez directement de la source.		  
Training Contacts  
   
Canada United States

Formation à Montréal :: 514.876.1666
Formation à Ville de Québec :: 514.876.1666
Formation à Ottawa :: 613.232.3948
Formation à Toronto :: 416.487.3948

Formation à Vancouver :: 604.633.3948
Formation à Victoria :: 1.866.328.3948
Formation à Calgary :: 403.291.2855
Formation à Edmonton :: 780.441.3948
Formation à Regina :: 1.866.328.3948

 Formation à Sacramento :: 916.669.3970
Formation à San Francisco :: 415.975.3948
Formation à San Jose :: 408.288.3948
Formation à Las Vegas :: 1.800.803.3948
Formation à Phoenix :: 602.889.9350
À travers le monde - 613.232.3948 Des questions?
Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.
   



(c) 2012 ExitCertified Corp. Tous droits réservés.


ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :
 
Formation Sun Formation Oracle Formation Symantec Formation IBM Formation Red Hat :: Linux
Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec DB2, OS/400, Formation zSeries, s/390, iSeries, AIX SUSE, Formation RedHat
         
Formation MySQL Formation Apple Formation en gestion de projet    
Base de données MySQL Cours Apple, Formation Leopard Formation du PMI