- [Alt + 0] - Startseite
- [Alt + 1] - Navigation
- [Alt + 2] - Inhalt
- Kontakt - [Alt + 3]
- [Alt + 4] - Sitemap
- [Alt + 5] - Suche
Login
Recherche
Panier
Lieu, date, inscription
Durée : 5 jours (D53149GC11)
Trivadis vous propose cette formation exclusivement au sein de votre entreprise. C’est avec plaisir que nous vous conseillons personnellement à ce sujet.
Vous pouvez nous joindre par e-mail à l'adresse training@trivadis.com ou en composant le 0800 87 48 23 47. Veuillez remplir les champs suivants et nous vous contacterons dans les plus brefs délais
Oracle BI Suite EE 10g R3: Build Repositories Ed 1.1
(D53149GC11): This course provides step-by-step procedures for building and verifying the three layers of an Oracle BI repository. Students begin by using the Oracle BI Server Administration Tool to construct a simple repository to address a fictitious company's business requirements. Students import schemas, design and build logical business models, and expose these to users in Oracle BI Answers. In the process of constructing the repository, they learn how to build physical and logical joins, simple measures, and calculation measures.
Students also learn how to validate their work by building queries and verifying query results using Oracle BI Answers and the query log.
Students then extend the initial repository and learn how to model more complex business requirements, such as dimension hierarchies, multiple logical table sources, aggregate tables, partitions, and time series data. Students also learn how to implement OracleBI Server security, manage OracleBI Server cache, set up a multi-user development environment, and use Administration Tool wizards and utilities to manage, maintain, and enhance repositories. Finally, students are exposed to more advanced topics, such as implicit fact columns, bridge and helper tables, usage tracking, optimizing query performance, and multilingual environments.
Public visé
- Businessanalytics
- Data warehouse-administrators
- Data warehouse-analytics
Objectifs
- Use the Oracle BI Administration Tool to build, manage, and maintain an Oracle BI repository
- Build a dimensional business model to address business intelligence requirements
- Use Oracle BI Answers to build and execute queries to test and verify a dimensional business model
- Use the Oracle BI Administration Tool to administer Oracle BI Server
Contenu du cours
- Repository Basics
- Building the Physical Layer of a Repository
- Building the Business Model and Mapping Layer of a Repository
- Building the Presentation Layer of a Repository
- Testing and Validating a Repository
- Adding Multiple Logical Table Sources
- Adding Calculations to a Fact Table
- Creating Dimension Hierarchies and Level-Based Measures
- Using Aggregates
- Using Partitions and Fragments
- Using Repository Variables
- Modeling Time Series Data
- Modeling Many-to-Many Relationships
- Configuring Oracle Business Intelligence data and metadata to support multilingual environments
- Integrating Third-Party Reporting Tools with Oracle BI Server
- Creating Repositories Using Multidimensional Data Sources
- Security
- Cache Management
- Setting Up and Administering Usage Tracking
- Multi-user Development
- Using Administration Tool wizards and utilities to manage, maintain, and enhance repositories
Conditions préalables
- Dimensional modeling
- Basic SQL
- Data warehouse design
- Database design
