Oracle Business Intelligence Enterprise Edition Plus, also termed OBIEE, is Oracle Corporation's set of business intelligence tools consisting of former Siebel Systems business intelligence and Hyperion Solutions business intelligence offerings.
Oracle Business Intelligence Foundation Suite (OBIEE+ and Essbase) is a complete, open, and architecturally unified business intelligence solution for the enterprise that delivers capabilities for reporting, ad hoc query and analysis, OLAP, dashboards, and scorecards. All enterprise data sources, as well as metrics, calculations, definitions, and hierarchies are managed in a Common Enterprise Information Model, providing users with accurate and consistent insight, regardless of where the information is consumed. Users can access and interact with information in multiple ways, including web-based interactive dashboards, collaboration workspaces, search bars, ERP andCRM applications, mobile devices, and Microsoft Office applications.
Revanth Technologies provides the Best OBIEE online training from India with real time experts and with real time concepts. We provide for both individuals and Corporate companies. Our Training focused on real-time working process and Methods.
In the Course duration we will cover
Repository Basics
Working with Oracle BI Answers
Mail id : revanthonlinetraining@gmail.com
For more details please visit http://www.revanthtechnologies.com/obiee-online-training-from-india.php
Oracle Business Intelligence Foundation Suite (OBIEE+ and Essbase) is a complete, open, and architecturally unified business intelligence solution for the enterprise that delivers capabilities for reporting, ad hoc query and analysis, OLAP, dashboards, and scorecards. All enterprise data sources, as well as metrics, calculations, definitions, and hierarchies are managed in a Common Enterprise Information Model, providing users with accurate and consistent insight, regardless of where the information is consumed. Users can access and interact with information in multiple ways, including web-based interactive dashboards, collaboration workspaces, search bars, ERP andCRM applications, mobile devices, and Microsoft Office applications.
Revanth Technologies provides the Best OBIEE online training from India with real time experts and with real time concepts. We provide for both individuals and Corporate companies. Our Training focused on real-time working process and Methods.
In the Course duration we will cover
OBIEE Online Training Course Duration - 40hrs
Data warehousing overview- Basics of Data Warehousing
- What is OLTP and OLAP?
- Difference between OLTP and OLAP
- Advantages of OLAP
- What is Data Marts and ODS?
- Introduction to Dimensional Modeling
- What are Facts and Dimensions?
- Star schema and Snowflake schema
- What is Business Intelligence
- Where BI tools are Used
- Why the Oracle Business Intelligence
- Advantages
- Architecture, Components
- Clients - Answers, Delivers, Dashboards and Web administration,
- Servers- Oracle BI server, Presentation, Scheduler server
Repository Basics
- What is Meta data?
- Creating a Repository using BI Administration Tool
- Physical, Business Model and Mapping, and presentation layers
- Properties of repository objects
- Objects of Physical Layer
- DSN for a data sources
- Build physical layer
- Objects of BMM layer
- Building Business model (creating logical tables, columns, joins)
- Creating simple measures
- Objects of presentation layer
- Properties of the presentation layer
- Build presentation layer
- Checking repository consistency
- Checking Global Consistency
- Inspecting Oracle Answers inspecting SQL
- Inspecting log files(Nqquery.log,NQSserver.log)
- De-normalizing tables structures in database design
- Adding multiple sources to existing logical tables source
- Adding second table sources
- Calculation measures on the basis of physical and logical columns
- Using Calculation wizard
- Creating dimensional hierarchies
- Use level based measures
- Create Rank and Share measures
- Importing Aggregated Tables into Repository
- Modeling aggregate tables to speed processing
- Identifying reasons to segment data
- Techniques to model partitions
- Value based partitioning
- Presentation Variables
- Repository variables
- Session variables
- Initialization Blocks
- Overview on Multiuser Environment (MUD)
- How to create projects in MUD
- Checkout and checkin of projects
- Types of SCDS
- Using of time series functions
- Purposes of extension tables
- Modeling extension tables for fact and dimensions
- Security at object and data level
- Creating users and User groups
- Assigning permissions to users
- Setting Query limits and timing restrictions
- Authenticating using an external database
- Purge cache and event handling tables
- Making the table cacheable
- Setting of cache in NQSCONFIG.INI file
Working with Oracle BI Answers
- Building Busines Requests usiing Answers
- Adding filters to Business requests
- Adding Column Filter Prompts in Answers
- Views and charts in requests
- Creating dashboard pages using report requests
- Creating dashboard prompts
- Configuring guided navigation links
- Adding content to dashboard
- Conditional links and conditional section
- Using catalog management to maintain web catalog
- Creating catalog groups, issuing privileges etc
- Configuring delivery devices
- Add delivery profiles
- Build Oracle alerts
- Create ibots
- Configuring Oracle scheduler database
- Configuring of Event poll tables
- BI Applications/ Pre-Built RPO
- ETL Integration using DAC
- BI Publisher
Mail id : revanthonlinetraining@gmail.com
For more details please visit http://www.revanthtechnologies.com/obiee-online-training-from-india.php
