Loading Course Schedule...
PT10132
Summary
By the end of this course, participants will have learned about:Introduction and DefinitionSources, Transformations and Targets( Architecture )Data Extraction, Data Transformations and Data Loading( Data Acquisition Process )Data Warehousing ApproachesStaging Area, Metadata, Repository and Data MartDifferences between OLTP and OLAP( DSS ) SystemsOperational Data Store( ODS )Business IntelligenceStar Schema Design & Confirmed Dimension, Fact less Fact Table, Types of FactsSlowly Changing Dimensions( SCD)
Prerequisites
There are no prerequisites for this class.
Duration
5 Days/Lecture & Lab
Topics
- OBI Architecture
- OBI Components
- 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
- Adding Calculations to a Fact Table
- Creating Dimension Hierarchies and Level-Based Measures
- Creating & Using Aggregates
- Using Initialization Blocks Repository Variables
- Creating Dynamic Repository Variables
- Execute Direct Database Requests
- Creating Time series Measures
- Providing Security for Groups & Users
- Working with Oracle Business Intelligence Answers
- Filtering Requests in Oracle Business Intelligence Answers
- Building Views and Charts in Requests
- Showing Results with Pivot Tables
- Creating Oracle Business Intelligence Interactive Dashboards