Welcome to Online Training from India
OBIEE Online Training from India
OBIEE Online Training Course Content
Course Duration : 40 Hrs
Data warehousing overview
Repository Basics
Working with Oracle BI Answers
- 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
- 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
We are providing OBIEE Online Training from Hyderabad India. We are one of best Institute to provide High Quality OBIEE online training all over India. If you are staying in Hyderabad, Bangalore, Chennai, Pune, Delhi, USA, UK, Australia, Singapore etc. and unable to attend regular class room training programs then contact our training institute for information on online training. For more details on OBIEE Online Training please call to 9290971883, / 9247461324, or drop a mail to revanthonlinetraining@gmail.com
OBIEE online training institute address : B1, 3rd Floor, Eureka Court, Near Image Hospital, Ameerpet, Hyderabad, India