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.

Oracle Database 11g: OLAP Essentials

Format: Formation en classe avec formateur
Autres formats:
 
 

In this course, students learn to progressively build an OLAP data model to support a wide range of business intelligence requirements. Students learn to design OLAP cubes to serve as a summary management resource for existing SQL table queries. Students also learn to leverage the power of Oracle OLAP by adding rich analytic content to your data model.

Students learn to create sophisticated reports of OLAP data by using simple SQL queries. Students also create and execute OLAP queries in SQL Developer, and Oracle Application Express (APEX). Students learn to implement cube security, including how to authorize access to cube data and methods for scoping user views of data. Finally, students learn to design OLAP cubes for performance and scalability.

Learn To:
  • Design and create an Oracle OLAP data model
  • Enable query rewrite to OLAP Cube MVs for relational summary management
  • Easily create OLAP calculations that enrich the analytic content of your data model
  • Query OLAP data using simple SQL
  • Implement cube security
  • Efficiently design cubes for performance and scalability
 
Oracle Certified Training Course   Oracle Training Savings
 

Compétences acquises
 

  • Describe OLAP concepts and terminology

  • Examine the role of Oracle OLAP within the Oracle BI / DW Platform

  • Design and create OLAP Cubes

  • Enable query rewrite to OLAP Cube MVs for summary management

  • Create OLAP calculated measures

 

  • Query stored and calculated OLAP data with simple SQL

  • Use ad hoc query and reporting tools against OLAP data

  • Implement cube security

  • Efficiently design cubes for performance and scalability

Qui peut en profiter
 

  • Business Analysts

  • Business Intelligence Developer

  • Data Warehouse Administrator

 

  • Data Warehouse Analyst

  • Data Warehouse Developer

  • Database Administrators

Préalables
 

  • Basic SQL knowledge

 

  • A basic understanding of OLAP concepts
 
Enroll For This Class
Enroll For This Class
Oracle DB PeopleSoft Hyperion Ce cours est donné par des formateurs certifiés Oracle.

Oracle University a nommé ExitCertified Partenaire de l’année 2011

Il y a une différence....découvrez-la.
Training Class Enrollment Ask A Question About This Training
Code: 11gDB-OLAP-ESSNT
Format: Formation en classe avec formateur
Durée: 3
Certifié par: Oracle
Frais d’inscription (CAD): 2,475$
Oracle University Awards ExitCertified the North American Partner of the Year Award for 2011
Recherchez des cours semblables
Cours connexes

Trier l'horaire par: 
No Course Dates Ce cours n'est pas prévu à l'horaire pour l'instant. Si vous êtes intéressé à suivre ce cours, utilisez le lien ci-dessous pour demander une date.
   
demander la date/l’emplacement demander de la formation sur place
 

Oracle Database 11g: OLAP Essentials Contenu détaillé
 
 
Examining the Role of Oracle OLAP within the Oracle BI / DW Platform
  • Oracle OLAP and the Oracle BI / DW Platform
  • Features of the Oracle OLAP Option
  • Accessing Oracle 11g OLAP data
Understanding the Dimensional Model
  • Stored and Calculated Measures
  • Dimensions
  • Hierarchies
  • Levels
  • Attributes
Building OLAP Cubes
  • Using the Cube Building Tool
  • Creating Dimensions
  • Designing Cubes
  • Creating Measures
  • Mapping to Source Data
  • Loading Data
Examining Cube-Organized Materialized Views (Cube MVs)
  • Benefits of Cube MV Summary Management
  • General Requirements for rewrite to MVs
  • Designing Cube MVs
  • Using Cube MVs
Creating Calculated Measures
  • Examining OLAP Calculation Types
  • Using the Calculation Builder
  • Creating Common Business Calculations
  • Creating Custom Calculations
 
Using SQL to Query Oracle OLAP Cubes
  • Understanding Cube Views
  • Querying OLAP Cubes: The Basics
  • Leveraging Cube Summaries
  • Applying Query Filters
  • Joining OLAP and Relational Data
Enhancing Analytic Content
  • Creating Cubes with Varying Dimensionality
  • Integrating Measures from Data with Different Dimensionality
  • Creating Forecast Measures Using OLAP DML
Using Ad Hoc Query and Reporting Tools Against OLAP Data
  • Exploring OLAP Data Using Oracle Application Express (APEX)
  • Performing Ad Hoc Query of OLAP Data Using Oracle BI Answers
  • Examining Metadata Requirements for BI Tools
Implementing Cube Security
  • Understanding Authentication Requirements
  • Authorizing Access to Cube Data
  • Examining User and Object Privileges
  • Examining Methods for Scoping User Views of Data
Designing Cubes for Performance and Scalability
  • Objectives of Performant and Scalable Design
  • Examining how Data is Stored in Oracle Cubes
  • Identifying Cube Features that Impact Performance and Scalability
  • Implementing Design Techniques for Performance and Scalability
Examining Performance Tuning
  • Describing How Cubes are Stored
  • Understand Cube Build Processing
  • Examining Balanced Configurations
  • Correcting Performance Bottlenecks


  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