Kurz: Oracle BI 11g R1: Build Repositories

Kurz je určen pro ...

Audience

• Application Developers
• Business Analysts
• Business Intelligence Developer
• Data Modelers
• Data Warehouse Administrator
• Data Warehouse Analyst
• Reports Developer
• Technical Consultant

Lektoři kurzu

Lektoři z firmy: DataScript s.r.o.

[Kurz] Program kurzu (obsah přednášky/semináře/rekvalifikace/studia) ...

Goals

• Build and run analyses to test and validate a repository
• Build simple and calculated measures for a fact table
• Create logical dimension hierarchies and level-based measures
• Check the model and then model aggregate tables to speed query processing
• Model partitions and fragments to improve application performance and usability
• Use variables to streamline administrative tasks and modify metadata content dynamically
• Use time series functions to support historical time comparison analyses
• Set up security to authenticate users and assign appropriate permissions and privileges
• Build the Physical, Business Model and Mapping, and Presentation layers of a repository
• Apply cache management techniques to maintain and enhance query performance
• Set up query logging for testing and debugging
• Set up a multiuser development environment
• Use the Administration Tool wizards and utilities to manage, maintain, and enha
  *
  • Build and run analyses to test and validate a repository
  • Build simple and calculated measures for a fact table
  • Create logical dimension hierarchies and level-based measures
  • Check the model and then model aggregate tables to speed query processing
  • Model partitions and fragments to improve application performance and usability
  • Use variables to streamline administrative tasks and modify metadata content dynamically
  • Use time series functions to support historical time comparison analyses
  • Set up security to authenticate users and assign appropriate permissions and privileges
  • Build the Physical, Business Model and Mapping, and Presentation layers of a repository
  • Apply cache management techniques to maintain and enhance query performance
  • Set up query logging for testing and debugging
  • Set up a multiuser development environment
  • Use the Administration Tool wizards and utilities to manage, maintain, and enhance repositories
  • Enable usage tracking to track queries and database usage, and improve query performance
  • Perform a patch merge in a development-to-production scenario
  • Describe Exalytics machine and the Summary Advisor tool used in the machine
  
  
  Outline Read the entire course outline for more details. Prerequisites Required Prerequisites:
  • Knowledge on Basic SQL
  • Knowledge on Data warehouse design
  • Knowledge on Dimensional modeling
  Suggested Prerequisites:
  • Oracle BI 11g R1: Create Analyses and Dashboards
  Previous courses
  • Oracle BI 11g R1: Create Analyses and Dashboards
  
  
  

[Kurz] Cíl školení / poznámka ke kurzu...

[Školení] Další popis kurzu (úroveň, minimální znalosti, informace o cenách kurzu) ...

Prerequisites Required Prerequisites:

• Knowledge on Basic SQL
• Knowledge on Data warehouse design
• Knowledge on Dimensional modeling

• Oracle BI 11g R1: Create Analyses and Dashboards