Training : TRN 201 : Oracle BI EE 10g “Bootcamp”
Overview : This course is designed for customers and Oracle partners who wish to quickly train up a team of developers so that they can deliver an end-to-end Oracle BI EE system. Over five intensive days, it covers all that you will need to know to deliver an initial Oracle BI EE reporting system, and assumes no prior knowledge up-front.
The final day consists of a workshop where delegates will build on the knowledge they have gained to built a complete system based on an outline specification provided by the instructror. This unique approach gives delegates the chance to practice their skills away from step-by-step instructions and ensures that they are capable of delivering their own Oracle BI EE system.
Duration : 5 Days
Course Delivery : Instructor-led with labs, on-site at customer location
Who Should Attend : Developers, consultants, project managers, technical leads, DBAs
Prerequisites : None
Detailed Course Agenda :
Day 1
1. Introduction to Oracle BI EE
2. Installation and Configuration
- Installing OBIEE 10g
- Configuring OBIEE 10g (scheduler etc)
3. Oracle BI Server and the Semantic Model
- Architecture
- Oracle BI Components In-Depth
- Modeling Relational Data Sources
- Incorporating additional data sources
- Creating basic calculations
- Creating time-series calculations
- Creating dimensions
- Creating presentation models
- Aliases, and Modeling flat structures (files, single tables)
Day 2
4. Oracle BI Server Security
- Security overview and options
- Setting up filters using security manager
- LDAP security integration
- Presentation Model filters
5. Advanced Oracle BI Server Administration
- Basic Caching
- Aggregates & Aggregate Persistence Wizard
- Variables
- Usage Tracking
6. Modeling Essbase Multi-Dimensional Sources
- Essbase Multi-dimensional (OLAP) overview
- Importing Essbase data into BI Administrator
- Combining Essbase and Relational Data
Day 3
7. Creating Basic Requests and Views
- Dashboard and Answers Overview
- Creating table views
- Creating totals and subtotals
- Filters and prompts
- Title views and icons
- Working with the compound view
8. Creating Advanced Requests and Views
- Adding charts
- Adding Gauges
- Briefing Books
- Microsoft Office Integration
- Column Selectors
- View Selectors
- Formatting & Conditional Formatting
- Navigation between reports
9. Creating Interactive Dashboards
- Dashboard Overview
- Adding requests to the dashboard
- Adding dashboard prompts
- Guided analytics and conditional display of requests
- Dashboard customization
- Creating multiple pages
- Dashboard security
Day 4
10. BI Publisher Development & BI EE Integration
- BI Publisher overview
- Creating report definitions against OBIEE data
- Defining report templates
- Publishing reports to BI Publisher Enterprise
- Integrating BI Publisher with the dashboard
11. Delivers, Alerting and Report Distribution
- Introduction to Delivers
- Scheduling a report
- Creating an alert
12. OBIEE Software Configuration Management
- Initial Migration from Development to Production
- Subsequent Migrations from Development to Production
- Content Accelerator Framework
- Version Control using Subversion
- Multiuser Development
Day 5
13. OBIEE Workshop
- Model the OBIEE Semantic Layer
- Map in source data from multiple databases
- Apply calculations
- Define aggregates and level-based measures
- Apply security
- Create answers reports
- Create BI Publisher reports
- Create dashboard
- Set up caching
- Set up alerts and report distribution
- Add to source control system
To book this course for your organization, or for more information, contact training@rittmanmead.com for more details.
