Oracle Business Intelligence Enterprise Edition: OBIEE
2.9 (18 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,418 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle Business Intelligence Enterprise Edition: OBIEE to your Wishlist.

Add to Wishlist

Oracle Business Intelligence Enterprise Edition: OBIEE

Learn the most robust set of reporting, querying, analytic, OLAP, dashboard, and scorecard funtionality available today.
2.9 (18 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,418 students enrolled
Created by Jigar Vora
Last updated 11/2014
English
Current price: $10 Original price: $25 Discount: 60% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • To learn Advanced topics of Data analyis
  • To gain knowledge about OBIEE tool
View Curriculum
Requirements
  • basic knowledge of SQL or my sql or Oracle
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.

Who is the target audience?
  • people with sound logic
  • People intrested in improving knowledge of data analytics
Students Who Viewed This Course Also Viewed
Curriculum For This Course
37 Lectures
03:51:31
+
Introduction to OBIEE
2 Lectures 17:33
+
Repository Basics
3 Lectures 17:22
Importing a Schema
04:40

Creating ODBC Data Source
04:15

Creating Physical Joins
08:27
+
Building Business Model & Mapping and Presentation layer
5 Lectures 30:01
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

Comparing Physical - BMM and Presentation layer
Building Presentation Layer
02:21
+
Testing and validation of repository
4 Lectures 14:32
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
+
Adding Calculations to a Fact Table
7 Lectures 40:51
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
+
Query , Reporting and Presentation
9 Lectures 37:54
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
+
Dashboards
6 Lectures 05:50
Creating Interactive Dashboards
37 pages

Create Interactive Dashboards
02:41

Creating Dashboard prompts
03:09


OBIEE Security Doc
3 pages

Loop Back Adapter Installation
1 page
+
Conclusion
1 Lecture 06:28
About the Instructor
Jigar Vora
3.5 Average rating
359 Reviews
22,427 Students
8 Courses
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.