Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This course covers download and installation of Oracle Business Intelligence Enterprise Edition software including additional required software. After successful installation of the software you be shown how to work with the Oracle Business Intelligence (BI) Administration Tool (188.8.131.52) to build, modify, enhance, and manage an Oracle BI repository. You will learn how to import metadata from a data source, simplify and reorganize the imported metadata into a business model, and then structure the business model for presentation to users who request business intelligence information via analyses and interactive dashboards.
Then you will be shown how to create and modify analyses with different views, and add these analyses in interactive dashboards and alerts used to deliver the notifications by using your preferred method of communication. Additionally you will learn how to use variables, master-detail linking of views and adding various reports to briefing books and editing briefing books to update content.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: DATA WAREHOUSING AND OBIEE|
Introduction and BackgroundPreview
A Brief History of Oracle Business Intelligence
In this lesson,you will be introduced to concepts of data warehousing and also the contributions made by William Inmon on the subject, and how influential those contributions have been to what we today consider as fundamental principles of data warehousing.
At the conclusion of this lesson you'll gain understanding of the different types of data warehouse architectures available and why one enterprise architects may choose to go with one architecture over the other. You will also learn about basic data warehouse architectures contrasted with architectures with a staging area.
Logical Design in Data Warehouses
Data Warehousing Schemas
Data Warehousing ObjectsPreview
About Oracle Business Intelligence Enterprise Edition 11g
An Introduction to Analyses, Dashboards, and Interactive Reporting
Oracle Business Intelligence 11g Architecture
|Section 2: DOWNLOAD AND INSTALLATION|
Instant Client Download and Configuration
Installation of Loopback AdapterPreview
Installation of Oracle Databases 11g
Install Repository Creation Utility (RCU) 11gPreview
Install Oracle Business Intelligence Enterprise Edition 11g
Post Installation Steps
|Section 3: BUILDING THE METADATA REPOSITORY|
0_Module 3 Outline and Introduction
Building the Physical Layer of a Repository
Building the Business Model and Mapping Layer of a Repository
Building the Presentation Layer of a RepositoryPreview
Testing and Validating a Repository
Managing Logical Table Sources
Creating Calculation Measures
Creating Logical Dimensions with Level-Based HierarchiesPreview
Creating Level-Based Measures
Using Aggregate Persistent Wizard
Using Initialization Blocks and VariablesPreview
Creating Time Series Measures
|Section 4: CREATING ANALYSES AND DASHBOARDS|
Module 4 Outline and Introduction
Beginning the Analytic Process
Using Formulas, Filters and Prompts
Modifying Views and Adding Pivot Tables
Working with Pivot Tables, Gauges, and Master-Detail LinkingPreview
Working with Agents
Published Reporting - BI PublisherPreview
Using Scorecards, KPIs and KPI Watchlists
Working With Briefing Books
|Section 5: INTRODUCTION TO SECURITY|
Creating Users, Groups and Catalog PermissionsPreview
Row and Column Level SecurityPreview
|Section 6: OBIEE In Oracle Linux Environment|
1. OBIEE On Oracle Linux Virtual MachinePreview
2. Download OBIEE SampleApp Files
3. Other Required Downloads
4. Installation of Other Required DownloadsPreview
5. Installation of Oracle Database 12c
6. Installation of Oracle BI Developer Client Tool
7. Installation of ODBC - Instant Client
8. How to Extract SampleApp OBIEE Downloads
9. Importing the Virtual Appliance
9.2 Starting and Shutting down OBIEE in the VM
9.3 Oracle ODBC Driver Configuration
10. Importing Dump files into Oracle Linux VirtualBox
11. Connecting the Admin Tool to the Oracle Database in LinuxPreview
12. How to Deploy the RPD in Linux Environment
Habergeons Technologies specializes in oracle software and provides business intelligence solutions and application development mainly using Oracle products.
The instructor of this course is Ian: He is a Certified Oracle Business Intelligence Implementation specialist and has worked with Oracle software including Oracle Databases, ODI and OBIEE for over 9 years on versions 9i, 10g, 11g and 12c.
We look forward to assisting you attain your learning goals.