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.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction to OBIEE|
Introduction and Why OBIEEPreview
|Section 2: Repository Basics|
Importing a Schema
Creating ODBC Data Source
Creating Physical Joins
|Section 3: Building Business Model & Mapping and Presentation layer|
Creating Logical Tables, Columns & Joins in BMM layer
Rename Business Model Objects & Delete Unnecessary objects
Building Dimension Hierarchies
Concept Star Schema VS Snow Flake Schema
|Comparing Physical - BMM and Presentation layer|
|Section 4: Testing and validation of repository|
Run Consistency Check
Enable Query Logging
Execute Query using BI Answers
Use query Log to verify Queries
|Section 5: Adding Calculations to a Fact Table|
Creating a New Measure
Creating a Calculation Measures in BI Answers
Creating a Calculation Measures using Logical Columns
Creating a Calculation Measures using Physical Columns
Creating a Calculation Measures using Calculation Wizard
Initialization Block for Session Variable part 1
Initialization Block for Session Variable part 2
|Section 6: Query , Reporting and Presentation|
Adding ODBC DSN
Import Data From Excel using ODBC
Excecute Direct Database request
Creating Query and using Filters
Adding Subtotals and Formatting results
Creating a Chart
Using Pivot Tables
|Section 7: Dashboards|
Creating Interactive Dashboards
Create Interactive Dashboards
Creating Dashboard prompts
OBIEE 11g installation DocPreview
OBIEE Security Doc
Loop Back Adapter Installation
|Section 8: Conclusion|
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.