-
Call Us:
+91 769-409-5404
-
Call Us:
+1 678-701-4914
+91 769-409-5404
+1 678-701-4914
This training program is designed to prepare the students for OBIEE11g Data Modeling, BI Publisher, Reporting and Dashboard Building. This course provides step-by-step procedures for building and verifying the three layers of an Oracle BI repository. Students begin by using the Oracle BI Administration Tool to construct a simple repository to address a fictitious companys business requirements. This course also provides step-by-step instructions for creating Oracle BI analyses and dashboards, which compose business intelligence applications.
Live presentation of theory, demonstration of tool, features & tasks
We are connecting Online via Goto Meeting
Get practice environment for practical & hands-on Training curriculum has been designed by real-time industry professionals & real-time scenarios training pattern
Learn as per day-wise & customized schedule with discussions & lab exercises included
One to one or Batch-wise interactive demonstration of a tool, features and 100% practical classes
World-class learning material & case studies for the course
Completely customizable course content & schedule as per convenience
Certification guidance provided if necessary
OBIEE 12c Repository Reporting Dashboard BI Publisher Reports Training
OBIEE 12c Repository Reporting Dashboard BI Publisher Reports
* Exploring Oracle BI architecture components
* Exploring a repository's structure, features, and functions
* Using the Oracle BI Administration Tool
* Creating a repository
* Loading a repository into Oracle BI Server
* Installing the BI Client software
* Importing data sources
* Setting up Connection Pool properties
* Defining keys and joins
* Examining physical layer object properties
* Creating alias tables
* Printing the physical layer diagram
* Building a business model
* Building logical tables, columns, and sources
* Defining logical joins
* Building measures
* Examining business model object properties
* Printing the business model and mapping layer diagram
* Exploring presentation layer objects
* Creating presentation layer objects
* Modifying presentation layer objects
* Examining presentation layer object properties
* Nesting presentation tables
* Controlling presentation layer object visibility
* Checking repository consistency
* Turning on logging
* Uploading the repository through Enterprise Manager
* Executing analyses to test the repository
* Inspecting the query log
* Adding multiple logical table sources to a logical table
* Specifying logical content
* Creating new calculation measures based on logical columns
* Creating new calculation measures based on physical columns
* Creating new calculation measures using the Calculation Wizard
* Creating measures using functions
* Creating logical dimension hierarchies
* Creating level-based measures
* Creating share measures
* Creating dimension-specific aggregation rules
* Creating presentation hierarchies
* Creating parent-child hierarchies
* Creating ragged and skipped-level hierarchies
* Creating the usage tracking tables
* 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
* Using Model Check Manager
* Modeling aggregate tables to improve query performance
* Using the Aggregate Persistence Wizard
* Testing aggregate navigation
* Setting the number of elements in a hierarchy
* Creating session variables
* Creating repository variables
* Creating initialization blocks
* Using the Variable Manager
* Using dynamic repository variables as filters
* Using time comparisons in business analysis
* Using Oracle BI time series functions to model time series data
Modeling Many-to-Many Relationships
* Using bridge tables to resolve many-to-many relationships between dimension tables and fact tables
* Ensuring the correct results for dimension-only queries
* Selecting a predetermined fact table source
* Specifying a default join path between dimension tables
* Importing a multidimensional data source into a repository
* Incorporating horizintal federation into a business model
* Incorporating vertical federation into a business model
* Adding Essbase measures to a relational model
* Displaying data from multidimensional sources in Oracle BI analyses and dashboards
* Exploring Oracle BI default security settings
* Creating users and groups
* Creating application roles
* Setting up object permissions
* Setting row-level security (data filters)
* Setting query limits and timing restrictions
* Restricting tables as non-cacheable
* Using Cache Manager
* Inspecting cache reports
* Purging cache entries
* Modifying cache parameters and options
* Seeding the cache
* Introduction to Oracle BI EE
* Oracle BI 12c Architecture
* Oracle BI 12c Highlights
* Introduction to Oracle BI Analysis Editor
* Oracle BI column types
* Working with analyses in Oracle BI
* Adding basic formatting
* Setting analysis properties
* Using advanced formatting
* Introduction to filters and selections
* Creating, editing, and grouping filters
* Adding prompts to analyses
* Dynamic filtering
* Using saved analyses as filters
* Creating selection steps
* Creating groups
* Creating calculated items
* Creating direct database analysis requests
* Including advanced SQL clauses in your analysis
* Introduction to views, graphs, and editors
* Working with views in Compound Layouts
* Creating and editing graphs
* Performing common view tasks
* 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
* Building calculations and displaying running sums
* Creating simple and advanced trellis views
* Creating performance tile views
* Working other view types like Treemap and Heat Matrix
* Linking master-detail views
* Oracle spatial components
* Managing map data
* Creating and editing Map views
* Interacting with map views
* Other applications and points of integration for map views
* Creating and editing dashboards
* Using the Dashboard Builder
* Exploring dashboard object properties and options
* Publishing dashboard pages
* Creating personal customizations and using other page options
* Exploring types of dashboard content
* Embedding content in dashboards
* Understanding variables
* Adding a named dashboard prompt to a dashboard
* Adding a hidden named dashboard prompt to a dashboard
* Creating additional prompt page and setting page preferences
* Adding variable prompts to a dashboard
* Objects and components of Oracle Scorecard and Strategy Management
* Key Performance Indicator (KPI) overview
* Scorecard document types
* Creating scorecards and KPIs
* Creating scorecard documents
* Editing scorecards and KPIs
* Creating Visual Analyzer Projects
* Adding and rearranging the Visualizations
* BI Ask
* Data Mashups
* Working with Views in Smart View Clients
* Customizing BI data in MS Office
* Copying and pasting views between Smart View clients
* Inserting BI views in to Smart View clients
* Creating and publishing views using the View Designer
* Federating data from multiple data sources
* Downloading and using the Oracle BI mobile application
* Navigating the Oracle BI mobile application
* Working with favorites and local content
* Working with BI content
* Oracle BI Mobile Security Toolkit
* Oracle BI and catalog security overview
* Managing security using roles
* Understanding security inheritance
* Setting object permissions
* Setting system privileges
* Archiving catalog items
* Working with Oracle BI Briefing Books
* Direct Database Analysis Overview
* Changing Direct Database Analysis Privileges
* Creating and Executing a Direct Database Analysis
o Oracle BI Publisher: Business Document Requirements
o Functions of Reporting Systems
o Oracle BI Publisher Paradigm
o End-to-End View and Salient Features of BI Publisher
o Opening and viewing a Predefined Report
o Creating a BI Publisher Report Based on Oracle Database
o Editing the Properties of a Report
o Describe the components of Oracle BI Publisher
o Describe the architecture of Oracle BI Publisher
o Describe the Oracle BI Publisher Underlying Technology
Question: Can I attend the Demo session before enrollment?
Answer: Yes, you may attend the Demo class before enrollment for training Quality Evaluation. You can also Interact with a trainer as one to one session for a specific requirement or discussion
Question: Can you schedule the training based upon my availability?
Answer: Yes, we need to discuss it with a trainer, accordingly, we can schedule training at a convenient time.
Question: How I can pay for the course?
Answer: You can pay the fee or enroll yourself via payment gateway through the course page, make an online payment using various options.
Question: What if I missed any class?
Answer: BISP has a missing class policy. If you missed any session, we will be sharing a recorded session. However, you may retake whole training multiple times within 6 month period but the trainer is the same.
Question: Is there any live project training along with regular training?
Answer: Our training curriculum includes real-time scenarios and lives project working module & the trainer explains every topic with examples. If you have any issue or you are stuck in any scenario the trainer will explain end-to-end.
Question: What about certification preparation and guidance?
Answer: BISP technical faculty assist & guide you completely for certification and preparation. We ensure you will get certified easily after our training.
Question: Who is the trainer & about his experience?
Answer: All our trainers are working professionals and industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo We also ensure that only those trainers with a high alumni rating continue to train for us.
Question: Do you provide Job support?
Answer: Yes, we provide Job support services, but the cost structure is different and fixed. For more details: Just give us a call at: +91 769-409-5404 & +1 678-701-4914 You can also write to us: support@bisptrainings.com
Question: What if I have more queries and doubts?
Answer: Just give us call at : +91 769-409-5404 & +1 678-701-4914 You can also write to us: support@bisptrainings.com
Question: How Fee Refund Policy works?
Answer: Please refer the link for refund policy: https://www.bisptrainings.com/Refund-Policy
Certification demonstrates your dedication, motivation and technical knowledge on a specific platform. Having a certification shows that you not only possess comprehensive knowledge of that technology but you also care enough about your own career to spend the time and money to get the certification.
We are welcoming our Students or professionals to participate in our professional online courses. We are offering great variety of online training programs and professional courses that you can always find as desired. After the completion of training program they will receive a certificate from BISP. As a Certified professional you can apply that knowledge in your future profession and enjoy with better salaries & career prospects.
