Oracle Business Intelligence Enterprise Edition: OBIEE

Learn the most robust set of reporting, querying, analytic, OLAP, dashboard, and scorecard funtionality available today.
2.9 (15 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,385 students enrolled
$25
Take This Course
  • Lectures 37
  • Contents Video: 3 hours
    Other: 1 hour
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2013 English

Course Description

The following course is about OBIEE:

Oracle Business Intelligence Foundation Suite (OBIEE+ and ESSBASE) is a complete, open, and architecturally unified Business Intellegence system for the enterprise that delivers abilities for reporting, adhoc query and analysis, Online Analytical Processing(OLAP), dashboards, and scorecards. All enterprise data sources, as well as metrics, calculations, definitions, and hierarchies are managed in a Common Enterprise Information Model, providing users with accurate and consistent insight, regardless of where the information is consumed. Users can access and interact with information in multiple ways, including web-based interactive dashboards, collaboration workspaces, search bars, ERP and CRM applications, mobile devices, and Microsoft Office applications.

The course covers topics from how to create a basic repository in Oracle to how to create entire Dashboard for reporting services.

I personally recommend to go over each video atleat 2 times and practice each step to get mastery in OBIEE. The entire course can be covered in 4 hours.

Note: Entire Course is structured in a way to cover the basic to advanced functions performed by a reporting analyst using Oracle business intellegence tool. The course also covers topics related to Admin functions in brief.

we will cover the Admin function in a seperate video series.

I recommend this course to anyone who is looking to get advanced knowledge in the field of data analytics or reporting analysis. OBIEE is a comprehensive tool appreciated by industry experts for reporting adhoc queries and presenting the facts in a presentable way to the management.

Details About the Instructor:

Swathi: has 8 plus years of classroom and online training Experience in Informatica, SQL and UNIX. She has excellent knowledge in Data ware Housing Concepts and RDBMS. Currently working as a freelance consultant for Informatica development since last 4 years.

What are the requirements?

  • basic knowledge of SQL or my sql or Oracle

What am I going to get from this course?

  • To learn Advanced topics of Data analyis
  • To gain knowledge about OBIEE tool

What is the target audience?

  • people with sound logic
  • People intrested in improving knowledge of data analytics

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to OBIEE
Introduction and Why OBIEE
Preview
17:33
Introduction
Preview
10 pages
Section 2: Repository Basics
Importing a Schema
04:40
Creating ODBC Data Source
04:15
Creating Physical Joins
08:27
Section 3: Building Business Model & Mapping and Presentation layer
Creating Logical Tables, Columns & Joins in BMM layer
06:34
Rename Business Model Objects & Delete Unnecessary objects
07:18
Building Dimension Hierarchies
08:33
Concept Star Schema VS Snow Flake Schema
05:15
02:21
Comparing Physical - BMM and Presentation layer
Section 4: Testing and validation of repository
Run Consistency Check
01:09
Enable Query Logging
06:29
Execute Query using BI Answers
03:44
Use query Log to verify Queries
03:10
Section 5: Adding Calculations to a Fact Table
Creating a New Measure
09:29
Creating a Calculation Measures in BI Answers
02:23
Creating a Calculation Measures using Logical Columns
03:43
Creating a Calculation Measures using Physical Columns
05:20
Creating a Calculation Measures using Calculation Wizard
07:33
Initialization Block for Session Variable part 1
07:03
Initialization Block for Session Variable part 2
05:20
Section 6: Query , Reporting and Presentation
Adding ODBC DSN
03:01
Import Data From Excel using ODBC
03:46
Excecute Direct Database request
03:45
Creating Query and using Filters
06:41
Adding Subtotals and Formatting results
04:53
Creating a Chart
05:47
Using Pivot Tables
04:07
Column Selector
03:10
View Selector
02:44
Section 7: Dashboards
Creating Interactive Dashboards
37 pages
Create Interactive Dashboards
02:41
Creating Dashboard prompts
03:09
OBIEE 11g installation Doc
Preview
10 pages
OBIEE Security Doc
3 pages
Loop Back Adapter Installation
1 page
Section 8: Conclusion
What Next:
Preview
06:28

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Jigar Vora, Planning Manager at Panasonic

I have a degree of Masters in Computer science and currently work as a Planning manager in the field of Logistics for a $10 billion dollar company.

I have number of years of experience working with Directors and Vice Presidents of companies presenting them alternate solutions to optimize their supply chain network.

I also own a consulting firm Aarya Global Services currently providing consulting services for supply chain network planning and Optimization to various companies.

Ready to start learning?
Take This Course