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