About Course
OBIEE Course Description
Sun trainings OBIEE training makes you an expert in building the applications by leveraging capabilities of Building Physical Layer Of A Repository, Testing And Validating Repository, Oracle BI Presentation Services, Server Architecture and etc. This course also includes how to create Dimensional Hierarchies And Level .
Course Name: OBIEE Online Training
faculty:Real time Experience
Frequently Asked Questions
- You will never miss a class at Suntrainings! You can choose either of the two options:
- 1. You can go through the recorded session of the missed class and the class presentation that are available for online viewing through the LMS.
- 2. You can attend the missed session, in any other live batch. Please note, access to the course material will be available for lifetime once you have enrolled into the course.
- Sun Trainings is committed to provide you an awesome learning experience through world-class content and best-in-class instructors.
- We will create an ecosystem through this training, that will enable you to convert opportunities into job offers by presenting your skills at the time of an interview. We can assist you in resume building and also share important interview questions once you are done with the training. However, please understand that we are not into job placements.
- We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrolment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in the class.
- All instructors at Sun Trainings are senior industry practitioners with minimum 10 - 12 years of relevant IT experience. They are subject matter experts who trained by Sun Trainings to provide impeccable learning experience to all our global users.
- You can Call us at +91 9642434362 OR Email us at contact@suntrainings.com. We shall be glad to assist you.
OBIEE Course Curriculum
- 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
- 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
- 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
Trainer Information
- Trainer has 15+ years of experience in IT industry.
