Course Introduction
Download
Report
Transcript Course Introduction
Course Introduction
Copyright © 2009, Oracle. All rights reserved.
Lesson Agenda
This lesson provides an introduction to the:
• Instructor and class participants
• Training site information
• Course:
–
–
–
–
–
–
–
I-2
Audience
Prerequisites
Goal
Objectives
Methodology
Materials
Agenda
Copyright © 2009, Oracle. All rights reserved.
Instructor and Class Participants
• Who are you?
– Name
– Company
– Role
• What is your prior experience?
–
–
–
–
Business intelligence
Data warehouse design
Database design
Oracle BI applications
• How do you expect to benefit from this course?
I-3
Copyright © 2009, Oracle. All rights reserved.
Training Site Information
• Bathrooms
• Class duration and
breaks
• Telephones
• Meals and
refreshments
• Fire exits
• Questions?
I-4
Copyright © 2009, Oracle. All rights reserved.
Course Audience
This course is intended for:
• Application developers
• Applications administrators
• Business intelligence developers
• Business analysts
• Data modelers
• Database designers
• Data warehouse analysts
• Technical consultants
• Technical business analysts
I-5
Copyright © 2009, Oracle. All rights reserved.
Course Prerequisites
Recommended experience:
• Business intelligence
• Data warehouse design
• Data modeling
• Database design
• Basic SQL
I-6
Copyright © 2009, Oracle. All rights reserved.
Course Goal
To enable students to build and deploy an Oracle Business
Intelligence repository and to create, modify, and administer
Oracle Business Intelligence Interactive Dashboards
I-7
Copyright © 2009, Oracle. All rights reserved.
Course Methodology
The subject matter is delivered through:
• Lectures and slide presentations
• Software demonstrations
• Class discussions
• Hands-on practices
I-8
Copyright © 2009, Oracle. All rights reserved.
Course Materials
• Student Guide
– All slides presented during lectures
• Practice Guide
– Hands-on practices and solutions
I-9
Copyright © 2009, Oracle. All rights reserved.
Course Agenda
Day One:
• Lesson I: Course Introduction
• Lesson 1: Oracle BI Enterprise Edition: Overview
• Lesson 2: Oracle BI Enterprise Edition Architecture
• Lesson 3: Repository Basics
• Lesson 4: Building the Physical Layer of a Repository
• Lesson 5: Building the Business Model and Mapping Layer
• Lesson 6: Building the Presentation Layer
• Lesson 7: Testing and Validating a Repository
I - 10
Copyright © 2009, Oracle. All rights reserved.
Course Agenda
Day Two:
• Lesson 8: Adding Multiple Logical Table Sources
• Lesson 9: Adding Calculations to a Fact
• Lesson 10: Creating Dimension Hierarchies
• Lesson 11: Using Aggregates
• Lesson 12: Using Partitions and Fragments
I - 11
Copyright © 2009, Oracle. All rights reserved.
Course Agenda
Day Three:
• Lesson 13:
• Lesson 14:
• Lesson 15:
• Lesson 16:
• Lesson 17:
• Lesson 18:
I - 12
Using Repository Variables
Modeling Time Series Data
Localizing Oracle BI Metadata
Setting an Implicit Fact Column
Security
Cache Management
Copyright © 2009, Oracle. All rights reserved.
Course Agenda
Day Four:
• Lesson 19:
• Lesson 20:
• Lesson 21:
• Lesson 22:
• Lesson 23:
• Lesson 24:
I - 13
Enabling Usage Tracking
Multi-User Development
Working with Oracle BI Answers
Filtering Requests in Oracle BI Answers
Oracle BI Answers: Advanced Features
Building Views and Charts in Requests
Copyright © 2009, Oracle. All rights reserved.
Course Agenda
Day Five:
• Lesson 25:
• Lesson 26:
• Lesson 27:
• Lesson 28:
• Lesson 29:
• Lesson 30:
I - 14
Showing Results with Pivot Tables
Creating Oracle BI Interactive Dashboards
Configuring Oracle BI Interactive Dashboards
Customizing the Oracle BI User Interface
Administering the Presentation Catalog
Using Oracle Business Intelligence Delivers
Copyright © 2009, Oracle. All rights reserved.
Summary
This lesson provided an introduction to the:
• Instructor and class participants
• Training site information
• Course:
–
–
–
–
–
–
–
I - 15
Audience
Prerequisites
Goal
Objectives
Methodology
Materials
Agenda
Copyright © 2009, Oracle. All rights reserved.