Obiee 11G Online Training

[training4u]

[center][b]OBIEE 10g/ 11g[/b][/center]

[b]Build Repositories: [/b]
[b]Course Objectives: [/b]
[indent=1.275]• Use time series functions to support historical time comparison analyses[/indent]
[indent=1.275]• Build the Physical, Business Model and Mapping, and Presentation layers of a repository[/indent]
[indent=1.275]• Build simple and calculated measures for a fact table[/indent]
[indent=1.275]• Create dimension hierarchies and level-based measures[/indent]
[indent=1.275]• Model aggregate tables to speed query processing[/indent]
[indent=1.275]• Use variables to streamline administrative tasks and modify metadata content dynamically[/indent]
[indent=1.275]• Set up security to authenticate users and assign appropriate permissions and privileges[/indent]
[indent=1.275]• Apply cache management techniques to maintain and enhance query performance[/indent]
[indent=1.275]• Set up a multi-user development environment[/indent]

[b]Course Topics: [/b]

[b]Repository Basics [/b]
[indent=1.275]• Oracle BI architecture components[/indent]
[indent=1.275]• Repository structure, features, and functions[/indent]
[indent=1.275]• Using the OracleBI Administration Tool[/indent]
[indent=1.275]• Creating a repository[/indent]
[indent=1.275]• Loading a repository into Oracle BI Server memory[/indent]

[b]Building the Physical Layer of a Repository [/b]
[indent=1.275]• Importing data sources[/indent]
[indent=1.275]• Setting up connection pool properties[/indent]
[indent=1.275]• Defining keys and joins[/indent]
[indent=1.275]• Examining physical layer object properties[/indent]
[indent=1.275]• Creating alias and select tables[/indent]

[indent=1.275][b]Building the Business Model and Mapping Layer of a Repository [/b][/indent]
[indent=1.275]• Building a business model[/indent]
[indent=1.275]• Building logical tables, columns, and sources[/indent]
[indent=1.275]• Defining logical joins[/indent]
[indent=1.275]• Building measures[/indent]
[indent=1.275]• Examining business model object properties[/indent]

[b]Building the Presentation Layer of a Repository [/b]
[indent=1.275]• Exploring Presentation layer objects[/indent]
[indent=1.275]• Creating Presentation layer objects[/indent]
[indent=1.275]• Modifying Presentation layer objects[/indent]
[indent=1.275]• Examining Presentation layer object properties[/indent]


[b]Adding Multiple Logical Table Sources [/b]
[indent=1.275]• Adding multiple logical table sources to a logical table[/indent]
[indent=1.275]• Specifying logical content[/indent]

[b]Adding Calculations to a Fact Table [/b]
[indent=1.275]• Creating new calculation measures based on existing logical columns[/indent]
[indent=1.275]• Creating new calculation measures based on physical columns[/indent]
[indent=1.275]• Creating new calculation measures using the Calculation Wizard[/indent]

[b]Creating Dimension Hierarchies and Level-Based Measures [/b]
[indent=1.275]• Creating dimension hierarchies[/indent]
[indent=1.275]• Creating level-based measures[/indent]
[indent=1.275]• Creating share measures[/indent]
[indent=1.275]• Creating rank measures[/indent]

[b]Using Aggregates [/b]
[indent=1.275]• Purpose of aggregate tables in dimensional modelling[/indent]
[indent=1.275]• Modelling aggregate tables to improve query performance[/indent]
[indent=1.275]• Testing aggregate navigation[/indent]
[indent=1.275]• Using the Aggregate Persistence Wizard[/indent]
[b]Modelling Time Series Data [/b]
[indent=1.275]• Using time comparisons in business analysis[/indent]
[indent=1.275]• Using Oracle BI time series functions to model time series data[/indent]

[b]Using Repository Variables [/b]
[indent=1.275]• Session variables[/indent]
[indent=1.275]• Repository variables[/indent]
[indent=1.275]• Initialization blocks[/indent]
[indent=1.275]• Using the Variable Manager[/indent]
[indent=1.275]• Using dynamic repository variables as filters[/indent]
[indent=1.775]· Presentation Variable[/indent]

[b]Security [/b]
[indent=1.275]• Creating users and groups[/indent]
[indent=1.275]• Setting permissions for users and groups[/indent]
[indent=1.275]• Authenticating using a external database[/indent]
[indent=1.275]• Authenticating using database authentication[/indent]
[b]Cache Management [/b]
[indent=1.275]• Restricting tables as non-cacheable[/indent]
[indent=1.275]• Using Cache Manager[/indent]
[indent=1.275]• Inspecting cache reports[/indent]
[indent=1.275]• Purging cache entries[/indent]
[indent=1.275]• Modifying cache parameters and options[/indent]
[indent=1.275]• Seeding the cache[/indent]

[b]Multi-user Development [/b]
[indent=1.275]• Setting up a multi-user development environment[/indent]
[indent=1.275]• Developing a repository using multiple developers[/indent]
[indent=1.275]• Tracking development project history[/indent]



[b][u]Create Reports and Dashboards [/u][/b]
[b]Course Objectives: [/b]
[indent=1.275]• Create and modify Business Intelligence requests using Oracle Business Intelligence Answers[/indent]
[indent=1.275]• Combine request criteria using set operations and execute direct database requests[/indent]
[indent=1.275]• Work with views to display request information[/indent]
[indent=1.275]• Create and modify Interactive Dashboards[/indent]
[indent=1.275]• Create guided navigation links within Interactive Dashboards[/indent]
[indent=1.275]• Use Oracle Business Intelligence Delivers to configure, schedule, and deliver personalized alerts to Interactive Dashboards using iBots[/indent]
[indent=1.275]• Perform administrative tasks related to the development and configuration of Interactive Dashboards[/indent]
[indent=1.275]• Customize the Oracle BI Presentation Services user interface[/indent]
[indent=1.275]• Work with Oracle BI Presentation Services content in Microsoft Office applications[/indent]
[indent=1.275]• Build Oracle BI Publisher reports based on Answers requests and BI metadata subject areas[/indent]
[indent=1.275]• Integrate Oracle BI Publisher reports in Interactive Dashboards[/indent]
[indent=1.275]• Employ recommended design principles and best practices[/indent]
[indent=1.275][b]. [/b]Set Operators[/indent]


[b]Course Topics: [/b]
[b]Working with Oracle Business Intelligence Answers [/b]
[indent=1.275]• Introduction to Oracle BI Answers[/indent]
[indent=1.275]• Working with requests in Oracle BI Answers[/indent]
[indent=1.275]• Using advanced formatting[/indent]

[b]Filtering Requests in Oracle Business Intelligence Answers [/b]
[indent=1.275]• Introduction to filters in Answers[/indent]
[indent=1.275]• Adding filter prompts to requests[/indent]
[indent=1.275]• Using saved requests as filters[/indent]

[b]Oracle Business Intelligence Answers: Advanced Features [/b]
[indent=1.275]• Combining request criteria using set operations[/indent]
[indent=1.275]• Executing direct database requests[/indent]
[indent=1.275]• Editing logical SQL generated by a request[/indent]
[b]Showing Results with Pivot Tables [/b]
[indent=1.275]• Introduction to pivot tables[/indent]
[indent=1.275]• Formatting pivot tables[/indent]
[indent=1.275]• Setting aggregation rules and building formulas[/indent]




[b]Building Views and Charts in Requests [/b]
[indent=1.275]• Introduction to Answers views and charts[/indent]
[indent=1.275]• Creating and editing charts[/indent]
[indent=1.275]• Performing common view tasks[/indent]

[b]Showing Results with Gauge Views [/b]
[indent=1.275]• Introduction to Gauge views[/indent]
[indent=1.275]• Working with Gauge views[/indent]

[b]Creating Oracle Business Intelligence Interactive Dashboards [/b]
[indent=1.275]• Introduction to Interactive Dashboards and pages[/indent]
[indent=1.275]• Dashboard Editor UI elements[/indent]
[indent=1.275]• Composing dashboard elements[/indent]

[b]Configuring Oracle Business Intelligence Interactive Dashboards [/b]
[indent=1.275]• Types of dashboard content[/indent]
[indent=1.275]• Embedding content in Interactive Dashboards[/indent]
[indent=1.275]• Using bookmark links to distribute and save Interactive Dashboards[/indent]


[b]Configuring Guided Navigation Links [/b]
[indent=1.275]• Building guided navigation with static links[/indent]
[indent=1.275]• Building guided navigation with conditional links and sections[/indent]


[b] Using Oracle Business Intelligence Publisher [/b]
• Introduction to Oracle BI Publisher
• Creating a BI Publisher report from the BI Server
[b]Using Oracle Business Intelligence Delivers [/b]
[indent=1.275]• Introduction to Oracle BI Delivers[/indent]
[indent=1.275]• Configuring delivery devices[/indent]
[indent=1.275]• Adding delivery profiles[/indent]
[indent=1.275]• Building alerts[/indent]
[indent=1.275]• Introduction to Oracle BI Scheduler[/indent]

[training4u]

Email : ravitejaobiee@gmail com
Contact No : +91 BLACK LISTED


[b]Build Repositories: [/b]
[b]Course Objectives: [/b]
[indent=1.275]• Use time series functions to support historical time comparison analyses[/indent]
[indent=1.275]• Build the Physical, Business Model and Mapping, and Presentation layers of a repository[/indent]
[indent=1.275]• Build simple and calculated measures for a fact table[/indent]
[indent=1.275]• Create dimension hierarchies and level-based measures[/indent]
[indent=1.275]• Model aggregate tables to speed query processing[/indent]
[indent=1.275]• Use variables to streamline administrative tasks and modify metadata content dynamically[/indent]
[indent=1.275]• Set up security to authenticate users and assign appropriate permissions and privileges[/indent]
[indent=1.275]• Apply cache management techniques to maintain and enhance query performance[/indent]
[indent=1.275]• Set up a multi-user development environment[/indent]

[b]Course Topics: [/b]

[b]Repository Basics [/b]
[indent=1.275]• Oracle BI architecture components[/indent]
[indent=1.275]• Repository structure, features, and functions[/indent]
[indent=1.275]• Using the OracleBI Administration Tool[/indent]
[indent=1.275]• Creating a repository[/indent]
[indent=1.275]• Loading a repository into Oracle BI Server memory[/indent]

[b]Building the Physical Layer of a Repository [/b]
[indent=1.275]• Importing data sources[/indent]
[indent=1.275]• Setting up connection pool properties[/indent]
[indent=1.275]• Defining keys and joins[/indent]
[indent=1.275]• Examining physical layer object properties[/indent]
[indent=1.275]• Creating alias and select tables[/indent]

[indent=1.275][b]Building the Business Model and Mapping Layer of a Repository [/b][/indent]
[indent=1.275]• Building a business model[/indent]
[indent=1.275]• Building logical tables, columns, and sources[/indent]
[indent=1.275]• Defining logical joins[/indent]
[indent=1.275]• Building measures[/indent]
[indent=1.275]• Examining business model object properties[/indent]

[b]Building the Presentation Layer of a Repository [/b]
[indent=1.275]• Exploring Presentation layer objects[/indent]
[indent=1.275]• Creating Presentation layer objects[/indent]
[indent=1.275]• Modifying Presentation layer objects[/indent]
[indent=1.275]• Examining Presentation layer object properties[/indent]


[b]Adding Multiple Logical Table Sources [/b]
[indent=1.275]• Adding multiple logical table sources to a logical table[/indent]
[indent=1.275]• Specifying logical content[/indent]

[b]Adding Calculations to a Fact Table [/b]
[indent=1.275]• Creating new calculation measures based on existing logical columns[/indent]
[indent=1.275]• Creating new calculation measures based on physical columns[/indent]
[indent=1.275]• Creating new calculation measures using the Calculation Wizard[/indent]

[b]Creating Dimension Hierarchies and Level-Based Measures [/b]
[indent=1.275]• Creating dimension hierarchies[/indent]
[indent=1.275]• Creating level-based measures[/indent]
[indent=1.275]• Creating share measures[/indent]
[indent=1.275]• Creating rank measures[/indent]


[b]Using Aggregates [/b]
[indent=1.275]• Purpose of aggregate tables in dimensional modelling[/indent]
[indent=1.275]• Modelling aggregate tables to improve query performance[/indent]
[indent=1.275]• Testing aggregate navigation[/indent]
[indent=1.275]• Using the Aggregate Persistence Wizard[/indent]
[b]Modelling Time Series Data [/b]
[indent=1.275]• Using time comparisons in business analysis[/indent]
[indent=1.275]• Using Oracle BI time series functions to model time series data[/indent]

[b]Using Repository Variables [/b]
[indent=1.275]• Session variables[/indent]
[indent=1.275]• Repository variables[/indent]
[indent=1.275]• Initialization blocks[/indent]
[indent=1.275]• Using the Variable Manager[/indent]
[indent=1.275]• Using dynamic repository variables as filters[/indent]
[indent=1.775]· Presentation Variable[/indent]

[b]Security [/b]
[indent=1.275]• Creating users and groups[/indent]
[indent=1.275]• Setting permissions for users and groups[/indent]
[indent=1.275]• Authenticating using a external database[/indent]
[indent=1.275]• Authenticating using database authentication[/indent]
[b]Cache Management [/b]
[indent=1.275]• Restricting tables as non-cacheable[/indent]
[indent=1.275]• Using Cache Manager[/indent]
[indent=1.275]• Inspecting cache reports[/indent]
[indent=1.275]• Purging cache entries[/indent]
[indent=1.275]• Modifying cache parameters and options[/indent]
[indent=1.275]• Seeding the cache[/indent]

[b]Multi-user Development [/b]
[indent=1.275]• Setting up a multi-user development environment[/indent]
[indent=1.275]• Developing a repository using multiple developers[/indent]
[indent=1.275]• Tracking development project history[/indent]



[b][u]Create Reports and Dashboards [/u][/b]
[b]Course Objectives: [/b]
[indent=1.275]• Create and modify Business Intelligence requests using Oracle Business Intelligence Answers[/indent]
[indent=1.275]• Combine request criteria using set operations and execute direct database requests[/indent]
[indent=1.275]• Work with views to display request information[/indent]
[indent=1.275]• Create and modify Interactive Dashboards[/indent]
[indent=1.275]• Create guided navigation links within Interactive Dashboards[/indent]
[indent=1.275]• Use Oracle Business Intelligence Delivers to configure, schedule, and deliver personalized alerts to Interactive Dashboards using iBots[/indent]
[indent=1.275]• Perform administrative tasks related to the development and configuration of Interactive Dashboards[/indent]
[indent=1.275]• Customize the Oracle BI Presentation Services user interface[/indent]
[indent=1.275]• Work with Oracle BI Presentation Services content in Microsoft Office applications[/indent]
[indent=1.275]• Build Oracle BI Publisher reports based on Answers requests and BI metadata subject areas[/indent]
[indent=1.275]• Integrate Oracle BI Publisher reports in Interactive Dashboards[/indent]
[indent=1.275]• Employ recommended design principles and best practices[/indent]
[indent=1.275][b]. [/b]Set Operators[/indent]


[b]Course Topics: [/b]
[b]Working with Oracle Business Intelligence Answers [/b]
[indent=1.275]• Introduction to Oracle BI Answers[/indent]
[indent=1.275]• Working with requests in Oracle BI Answers[/indent]
[indent=1.275]• Using advanced formatting[/indent]

[b]Filtering Requests in Oracle Business Intelligence Answers [/b]
[indent=1.275]• Introduction to filters in Answers[/indent]
[indent=1.275]• Adding filter prompts to requests[/indent]
[indent=1.275]• Using saved requests as filters[/indent]

[b]Oracle Business Intelligence Answers: Advanced Features [/b]
[indent=1.275]• Combining request criteria using set operations[/indent]
[indent=1.275]• Executing direct database requests[/indent]
[indent=1.275]• Editing logical SQL generated by a request[/indent]
[b]Showing Results with Pivot Tables [/b]
[indent=1.275]• Introduction to pivot tables[/indent]
[indent=1.275]• Formatting pivot tables[/indent]
[indent=1.275]• Setting aggregation rules and building formulas[/indent]




[b]Building Views and Charts in Requests [/b]
[indent=1.275]• Introduction to Answers views and charts[/indent]
[indent=1.275]• Creating and editing charts[/indent]
[indent=1.275]• Performing common view tasks[/indent]

[b]Showing Results with Gauge Views [/b]
[indent=1.275]• Introduction to Gauge views[/indent]
[indent=1.275]• Working with Gauge views[/indent]

[b]Creating Oracle Business Intelligence Interactive Dashboards [/b]
[indent=1.275]• Introduction to Interactive Dashboards and pages[/indent]
[indent=1.275]• Dashboard Editor UI elements[/indent]
[indent=1.275]• Composing dashboard elements[/indent]

[b]Configuring Oracle Business Intelligence Interactive Dashboards [/b]
[indent=1.275]• Types of dashboard content[/indent]
[indent=1.275]• Embedding content in Interactive Dashboards[/indent]
[indent=1.275]• Using bookmark links to distribute and save Interactive Dashboards[/indent]


[b]Configuring Guided Navigation Links [/b]
[indent=1.275]• Building guided navigation with static links[/indent]
[indent=1.275]• Building guided navigation with conditional links and sections[/indent]


[b] Using Oracle Business Intelligence Publisher [/b]
• Introduction to Oracle BI Publisher
• Creating a BI Publisher report from the BI Server
[b]Using Oracle Business Intelligence Delivers [/b]
[indent=1.275]• Introduction to Oracle BI Delivers[/indent]
[indent=1.275]• Configuring delivery devices[/indent]
[indent=1.275]• Adding delivery profiles[/indent]
[indent=1.275]• Building alerts[/indent]
[indent=1.275]• Introduction to Oracle BI Scheduler[/indent]