Obiee+ Dac+ Bi Apps Online Training & Job Support

[training4u]

[center][color=#0000ff][b]Email: ravitejaobiee@gmail com[/b][/color][/center]


[center][color=#0000ff][b]Contact No:+91-88 61 20 1149[/b][/color][/center]


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


[b]Build Repositories: [/b]
[b]Course Objectives:[/b]


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

[b]Course Topics: [/b]

[b]Repository Basics [/b]


[indent=1]• Oracle BI architecture components[/indent]


[indent=1]• Repository structure, features, and functions[/indent]


[indent=1]• Using the OracleBI Administration Tool[/indent]


[indent=1]• Creating a repository[/indent]


[indent=1]• Loading a repository into Oracle BI Server memory[/indent]

[b]Building the Physical Layer of a Repository [/b]

[indent=1]• Importing data sources[/indent]


[indent=1]• Setting up connection pool properties[/indent]


[indent=1]• Defining keys and joins[/indent]


[indent=1]• Examining physical layer object properties[/indent]


[indent=1]• Creating alias and select tables[/indent]

[b]Building the Business Model and Mapping Layer of a Repository[/b]


[indent=1]• Building a business model[/indent]


[indent=1]• Building logical tables, columns, and sources[/indent]


[indent=1]• Defining logical joins[/indent]


[indent=1]• Building measures[/indent]


[indent=1]• Examining business model object properties[/indent]

[b]Building the Presentation Layer of a Repository [/b]

[indent=1]• Exploring Presentation layer objects[/indent]


[indent=1]• Creating Presentation layer objects[/indent]


[indent=1]• Modifying Presentation layer objects[/indent]


[indent=1]• Examining Presentation layer object properties[/indent]

[b]Adding Multiple Logical Table Sources [/b]

[indent=1]• Adding multiple logical table sources to a logical table[/indent]


[indent=1]• Specifying logical content[/indent]

[b]Adding Calculations to a Fact Table [/b]

[indent=1]• Creating new calculation measures based on existing logical columns[/indent]


[indent=1]• Creating new calculation measures based on physical columns[/indent]


[indent=1]• Creating new calculation measures using the Calculation Wizard[/indent]

[b]Creating Dimension Hierarchies and Level-Based Measures [/b]

[indent=1]• Creating dimension hierarchies[/indent]


[indent=1]• Creating level-based measures[/indent]


[indent=1]• Creating share measures[/indent]


[indent=1]• Creating rank measures[/indent]

[b]Using Aggregates [/b]

[indent=1]• Purpose of aggregate tables in dimensional modelling[/indent]


[indent=1]• Modelling aggregate tables to improve query performance[/indent]


[indent=1]• Testing aggregate navigation[/indent]


[indent=1]• Using the Aggregate Persistence Wizard[/indent]

[b]Modelling Time Series Data [/b]

[indent=1]• Using time comparisons in business analysis[/indent]


[indent=1]• Using Oracle BI time series functions to model time series data[/indent]

[b]Using Repository Variables [/b]

[indent=1]• Session variables[/indent]


[indent=1]• Repository variables[/indent]


[indent=1]• Initialization blocks[/indent]


[indent=1]• Using the Variable Manager[/indent]


[indent=1]• Using dynamic repository variables as filters[/indent]


[indent=1]·Presentation Variable[/indent]

[b]Security [/b]

[indent=1]• Creating users and groups[/indent]


[indent=1]• Setting permissions for users and groups[/indent]


[indent=1]• Authenticating using a external database[/indent]


[indent=1]• Authenticating using database authentication[/indent]

[b]Cache Management [/b]

[indent=1]• Restricting tables as non-cacheable[/indent]


[indent=1]• Using Cache Manager[/indent]


[indent=1]• Inspecting cache reports[/indent]


[indent=1]• Purging cache entries[/indent]


[indent=1]• Modifying cache parameters and options[/indent]


[indent=1]• Seeding the cache[/indent]

[b]Multi-user Development [/b]

[indent=1]• Setting up a multi-user development environment[/indent]


[indent=1]• Developing a repository using multiple developers[/indent]


[indent=1]• Tracking development project history[/indent]

[b]Create Reports and Dashboards [/b]
[b]Course Objectives:[/b]

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

[b]Course Topics: [/b]
[b]Working with Oracle Business Intelligence Answers [/b]

[indent=1]• Introduction to Oracle BI Answers[/indent]


[indent=1]• Working with requests in Oracle BI Answers[/indent]


[indent=1]• Using advanced formatting[/indent]

[b]Filtering Requests in Oracle Business Intelligence Answers [/b]

[indent=1]• Introduction to filters in Answers[/indent]


[indent=1]• Adding filter prompts to requests[/indent]


[indent=1]• Using saved requests as filters[/indent]

[b]Oracle Business Intelligence Answers: Advanced Features [/b]

[indent=1]• Combining request criteria using set operations[/indent]


[indent=1]• Executing direct database requests[/indent]


[indent=1]• Editing logical SQL generated by a request[/indent]

[b]Showing Results with Pivot Tables [/b]

[indent=1]• Introduction to pivot tables[/indent]


[indent=1]• Formatting pivot tables[/indent]


[indent=1]• Setting aggregation rules and building formulas[/indent]

[b]Building Views and Charts in Requests [/b]

[indent=1]• Introduction to Answers views and charts[/indent]


[indent=1]• Creating and editing charts[/indent]


[indent=1]• Performing common view tasks[/indent]

[b]Showing Results with Gauge Views [/b]

[indent=1]• Introduction to Gauge views[/indent]


[indent=1]• Working with Gauge views[/indent]

[b]Creating Oracle Business Intelligence Interactive Dashboards [/b]

[indent=1]• Introduction to Interactive Dashboards and pages[/indent]


[indent=1]• Dashboard Editor UI elements[/indent]


[indent=1]• Composing dashboard elements[/indent]

[b]Configuring Oracle Business Intelligence Interactive Dashboards [/b]

[indent=1]• Types of dashboard content[/indent]


[indent=1]• Embedding content in Interactive Dashboards[/indent]


[indent=1]• Using bookmark links to distribute and save Interactive Dashboards[/indent]

[b]Configuring Guided Navigation Links [/b]

[indent=1]• Building guided navigation with static links[/indent]


[indent=1]• 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]• Introduction to Oracle BI Delivers[/indent]


[indent=1]• Configuring delivery devices[/indent]


[indent=1]• Adding delivery profiles[/indent]


[indent=1]• Building alerts[/indent]


[indent=1]• Introduction to Oracle BI Scheduler[/indent]