Duration: 30 Days
Course Topics: ANSWERS & DASHBOARDS
Total Course Duration: 30 hours (Daily one hour)
Working with Oracle Business Intelligence Answers
Filtering Requests in Oracle Business Intelligence Answers
Views and Charts in Requests
Showing Results with Pivot tables
Creating Interactive Dashboards
Configuring Interactive Dashboards
Customizing the Oracle Business Intelligence User Interface
Configuring Guided Navigation Links
Administering Oracle Business Intelligence Presentation Catalog
Using Oracle Business Intelligence Delivers
Interactive Dashboard Design Principles and Best Practices
Repository Basics
Building the Physical Layer of a Repository
Building the Business Model and Mapping Layer of a Repository
Building logical tables, columns, and sources
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
Security
Cache Management
Purging cache entries
Setting Up and Administering Usage Tracking
Strategies
Administration Tool wizards and utilities to manage, maintain, and enhance repositories
---------------------------------or---------------------------------------------
---------------------------------------------------
---------------------------------------------------
------------------------------------------
DW - ETL Informatica & OBIEE Course Contents
Page 1 of 4
Proprietary and Confidential
Duration : 10 Weekends (Sat & Sun : 4 Hours E
ach Day)
No. Of Hours : 80 Hours.
Oracle Concepts ( 10.0g )
1. Oracle Objects
2. DDL Statements
3. DML Statements
4. TCS Statements
5. Joins
6. Sub Query
7. Correlated Sub Query
8. Oracle Analytical functions
9. Views, Materialized views
10. PL/SQL
Datawarehouse Concepts
1. Data Warehouse
2. Data Mart
3. OLAP VS OLTP
4. Data Warehouse Architecture (Basic)
5. Data Warehouse Architecture (with a Staging Area
)
6. Dimensional Modeling
7. Star Schema
8. Snowflake Schema
9. Dimension
10. Fact
11. Slowly Changing Dimension
12. Hierarchy
13. Confirmed Dimension
14. Fact less Fact
15. Summary / Aggregations table
!6. Change Data capture
E T L Informatica Power Center 8.1
1. Power Center Components
a) Designer
b) Repository Manager
c) Workflow Manager
d) Workflow Monitor
2. Informatica Concepts and O
verview
a) Informatica Architecture.
b) Source Qualifier
DW- ETL Informatica and OBIEE COURSE CONTENTS
---------------------------------------------------
---------------------------------------------------
------------------------------------------
DW - ETL Informatica & OBIEE Course Contents
Page 2 of 4
Proprietary and Confidential
c) Target Qualifier
d) Transformations
e) Mappings
f) Mapplets
g) Sessions
h) Tasks
3. Sources
a) Working with relational Sources
b) Working with Flat Files
4. Targets
a) Working with Relational Targets
b) Working with Flat file Targets
5. Transformations
a) Expression
b) Lookup
c) Sequence Generator
d) Filter
e) Joiner
f) Sorter
g) Procedural
h) Router
i) Aggregator
j) Active and Passive Transformations
k) Update Strategy
l) Data Concatenation
m) Debugging Mappings
6. Mappings & Mapplets
a) Mapping Variables & Parameters
b) Creating Cubes & Dimensions
c) Working with Mapping Wizards
7. Workflow Manger
a) Server Architecture
b) Workflows, Worklets & Sessions
c) Tasks, Assignments, Events, Command etc,
8. Performance Tuning
a) Informatica Tuning (Source, target, mapping & S
ession)
b) Oracle Tuning (Indexes, MV, Explain plan, Tkpro
f & SQL Hints)
9. Project - Case Study
10. Project - Review and Assignment
Distributed systems Scheduling tools:
•
Autosys
•
Autosys
Vs
Informatica Scheduler.
---------------------------------------------------
---------------------------------------------------
------------------------------------------
DW - ETL Informatica & OBIEE Course Contents
Page 3 of 4
Proprietary and Confidential
OBIEE 10.1.3.3.3.
OBIEE 10.1.3.3.3 is a client-server tool for report
ing and analyzing data. The following
subjects are covered:
1. OBIEE 10.1.3.3.3 Installation
2. Concept of Dimensional Modelling
a) Star Schema
b) Snow Flake
c) Fact Table
d) Dimensional Table
3
. OBIEE Architecture
I. Components of OBIEE
a) Oracle BI Presenation Server
b) Oracle BI Server
c) Pop Chart Server
d) Oracle BI Scheduler
e) Admin Tool
4. Different Versions Of Oracle BI and Attributes
5. Oracle BI User Interface
a. Answers
b. Dashboards
c. Views
d. Prompts
e. Variables
f. User and Groups
g. Previllages
h. GoNav
6.
Oracle BI Admin Tool
I. Message flow from Browser to Data warehouse
I. Physical Layer
a) Importing Physical Tables
b) Creation of Physical Joins
c) Configuring Connection Pools
d) Exploring Views
II. Logical Layer
a) Creation of Business Model
b) Creation of Logical Facts
c) Creation of Dimensions
d) Creation of Dimension Hierarchies/Levels
e) Creation of Measures
f) Aggregation Navigation
g) Fragmentation Content & WHERE clause
http://www.eoktechnologies.com/DWIS_EOK.pdf
---------------------------------------------------
----------
No comments:
Post a Comment