Cloud

O SpecGold OracleBusIntApps7 clr

 Gcloud

 

   Call us now 

  Manchester Office

  +44 (0) 8450 940 998

 

  

 

Oracle 11g/12c BI Advanced Modelling

Summary

This course first looks at the new architecture in BI 11g/12c and then demonstrates how to use the Oracle BI 11g/12c Administration tool to create BI metadata models that underpin the Dashboards and Analysis.  We provide instructions, demonstrations and advanced "hands on" workshops.  The target audience are Designers and Administrators who will build the information model to support the business. Badv

Objectives

  • Create repositories using the Administration Tool
  • Build Physical, Business and Presentation layers
  • Import schemas from multiple physical data sources
  • Design and build logical business models (star schemas)
  • Modelling 3rd Normal Form
  • Build dimension hierarchies and aggregate tables
  • Build level based and time series measures
  • Create session and repository variables
  • Implement business rules and calculations
  • Model Fragmentation from multiple data sources
  • Manage security authentication and authorisation
  • Present information to end users in subject areas
  • Deployment using the Weblogic Application Server