UrbanPro
true

OBIEE Training

LIVE
Ongoing

Course offered by Prasad B

0 review
OBIEE Training contents 2 Sections : A: Build Repositories B. Create Dashboards & Reports

Topics Covered

Build Repository Contents Basics of Data Warehousing • What is OLTP and OLAP? • Difference between OLTP and OLAP • Dimensional table • Fact table • Confirmed Dimension. • Slowly Changing Dimension • Aggregate table • Star schema • Snowflake schema • Difference between Star & Snowflake schema. • Summary and Aggregated Table. • Hierarchy 1. Introduction to OBIEE • Oracle BI architecture components • OBIEE 10G and 11G Differences • What’s New in OBIEE 11G. 2. Repository Basics • Repository's structure, features, and functions • Using the Oracle BI Administration Tool, Creating a repository. • Loading a repository into Oracle BI Server memory. • What are the configuration files , logs • What are the main artifacts of OBIEE 3. Build Physical Layer. • Importing data sources • Setting up connection pool properties • Defining keys and joins • Examining physical layer object properties • Creating alias tables 4. Build BMM Layer. • Building a business model • Building logical tables, columns, and sources • Defining logical joins • Building measures • Examining business model object properties • How to build Hierarchy level, Aggregation Wizard. 5. Build Presentation Layer. • Exploring Presentation layer objects • Creating Presentation layer objects • Modifying Presentation layer objects • Examining Presentation layer object properties. • How to create Implicit fact table, • How to create Nested Facts in subject area 6. Testing and Validating a Repository • Checking repository consistency • Turning on logging 5. Inspecting the query log • Defining a repository in the initialization file • Testing a repository using Oracle BI Answers 7. Adding Multiple Logical Table Sources & Adding Calculations to a Fact Table • Adding multiple logical table sources to a logical table • Specifying logical content • Creating new calculation measures based on existing logical columns • Creating new calculation measures based on physical columns • Creating new calculation measures using the Calculation Wizard 9. Creating Dimension Hierarchies and Level-Based Measures • Creating dimension hierarchies • Creating level-based measures • Creating share measures • Creating rank measures 10. Using Aggregates • Purpose of aggregate tables in dimensional modeling • Modeling aggregate tables to improve query performance • Testing aggregate navigation • Using the Aggregate Persistence Wizard 11. Using Variables • Session variables • Repository variables • Initialization blocks • Using the Variable Manager • Using dynamic repository variables as filters 12. Security • Creating users and groups • Setting permissions for users and groups • Authenticating using a external database • Authenticating using database authentication • Setting query limits and timing restrictions • Setting filters to personalize information 13. Cache Management • Restricting tables as non-cacheable • Using Cache Manager • Inspecting cache reports • Purging cache entries • Modifying cache parameters and options • Seeding the cache 14. Enabling Usage Tracking • Setting up the sample usage tracking repository • Tracking and storing Oracle BI Server usage at the detailed query level • Using usage tracking statistics to optimize query performance and aggregation strategies • Analyzing usage results using Oracle BI Answers and other reporting tools 14. Multi-user Development • Setting up a multiuser development environment • Developing a repository using multiple developers • Tracking development project history 15. Patch Merge • Comparing repositories • Equalizing objects • Creating a patch • Applying a patch • Making merge decisions 16. Repository Functions • Calendar Date/Time Functions • Conversion Functions • Display Functions • Mathematics Functions • String Functions • Time-Series Functions Creating Dashboards and Reports Introduction • OBIEE Overview • User Interface • Creating Folders • Creating Reports • Formatting Administering the Presentation Catalog • Oracle BI and catalog security overview • Managing security using roles • Understanding security inheritance • Setting object permissions • Setting system privileges • Archiving catalog items Limiting and Grouping Data in Analyses • Introduction to filters and selections • Creating, editing, and grouping filters • Adding prompts to analyses • Dynamic filtering • Using saved analyses as filters • Creating groups • Creating calculated items • Creating selection steps Oracle Business Intelligence Analyses: Advanced Features • Setting analysis properties • Combining analysis criteria by using set operations • Executing direct database analyses • Editing logical SQL generated by an analysis • Creating a link to a saved analysis Working with Views and Graphs in Analyses • Introduction to views, graphs, and editors • Working with views in Compound Layouts • Creating and editing graphs • Linking master-detail views • Performing common view tasks • Working with Gauge views • Creating and editing Map views Measuring Results with Key Performance Indicators • Creating KPIs, setting trending, dimensionality, and thresholds • Creating a KPI Watch list • Changing Dimensionality for a KPI Watch list event Showing Results with Pivot Tables • Creating, arranging, and formatting a pivot table • Using hierarchical columns • Sorting in pivot tables • Setting aggregation and using totals • Showing an item's relative value

Who should attend

Audience : -OBIEE Developers / consultants. -Informatica Developers / Other ETL Developers. - Datawarehouse developers. - Report Developers.

Pre-requisites

Pre- requisite for this Training: - Basic Data warehousing concepts - None - Freshers.

What you need to bring

Your Zeal to learn new concepts

Key Takeaways

- Students will learn how to implement OBIEE solutions

About the Trainer

Prasad picture

Avg Rating

0 Reviews

0 Students

1 Courses

Prasad B

B.E

10 Years of Experience

I have 9.5 years of industry experience in data warehouse, Informatica, OBIEE, OBI Apps. I am OBI Apps ERP implementor

Students also enrolled in these courses

LIVE
4 reviews
2 Hours

Course offered by Nishant

411 reviews
LIVE
10 reviews
20 Hours

Course offered by Vinay Karnam

6 reviews
LIVE
1 review
20 Hours

Course offered by Kasyap

2 reviews
LIVE
20 Hours

Course offered by Prashant Kumar Jha

0 review

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

No Reviews yet!

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

OBIEE Training by Prasad B

Prasad picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

OBIEE Training by Prasad B

Prasad picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more