OBIEE Training-ASTS Training

1
ASTS Training

• OBIEE Training

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
2
ABOUT OBIEE ONLINE TRAINING

• Oracle Business Intelligence Enterprise Edition
  (OBIEE) is a business intelligence system for the
  enterprise that delivers abilities for reporting,
  ad hoc query and analysis, online analytical
  processing (OLAP), dashboards, and scorecards. It
  is a comprehensive set of tools for data analysis
  and Data Warehousing. OBIEE is a comprehensive
  suite of enterprise BI products that delivers a
  full range of analysis and reporting capabilities
  along with a unified, highly scalable and modern
  architecture.

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
3
ABOUT INSTRUCTOR

• OBIEE Online Training is provided by a real time
  consultant. The experience acquired by our
  trainer on OBIEE, is promisingly helpful to the
  corporate trainees. Our instructors are experts
  in the implementation and support projects.
   ASTS always works on real time
  scenarios. OBIEE is extremely useful for the
  professionals to handle the projects easily in
  the IT industry.

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
4
PREREQUISITES

• Graduates/Post Graduates are eligible.
• Essential knowledge of the Oracle technology
  stack, especially data warehouse (Database, Data
  Warehouse, OLAP, Data Mining, Warehouse Builder,
  Business Intelligence EE).
• Basic SQL.

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
5
TERMS AND CONDITIONS

• We will Provide Supporting to resolve Student
  practical Issues.
• We will provide server Access and 100 Lab
  Facility.
• Resume Preparation.
• Interview Questions Answers.
• We will conduct mock interviews. Student also
  gets 100 supporting before and after getting
  job.

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
6
OBIEE ONLINE TRAINING CONTENT

• 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?

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
7
OBIEE ONLINE TRAINING CONTENT

• Dimensional Modeling Overview
• Introduction to Dimensional Modeling
• What are Facts and Dimensions?
• Star schema and Snowflake schema

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
8
OBIEE ONLINE TRAINING CONTENT

• Introduction To Business Intelligence
• What is Business Intelligence
• Where BI tools are Used
• Why the Oracle Business Intelligence
• Advantages
• Architecture, Components
• Clients Answers, Delivers, Dashboards

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
9
OBIEE ONLINE TRAINING CONTENT

• Server ArchitectureRepository Basics
• What is Meta data?
• Creating a Repository using BI Administration
  Tool
• Physical, Business Model and Mapping, and
  presentation layers
• Properties of repository objects

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
10
OBIEE ONLINE TRAINING CONTENT

• Building Physical Layer Of A Repository
• Objects of Physical Layer
• DSN for a data sources
• Build physical layer

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
11
OBIEE ONLINE TRAINING CONTENT

• Building Business Model Mapping Layer
• Objects of BMM layer
• Building Business model (creating logical tables,
  columns, joins)
• Creating simple measures

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
12
OBIEE ONLINE TRAINING CONTENT

• Building Presentation Layer
• Objects of presentation layer
• Properties of the presentation layer
• Build presentation layer

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
13
OBIEE ONLINE TRAINING CONTENT

• Testing And Validating Repository
• Checking repository consistency
• Checking Global Consistency
• Inspecting Oracle Answers inspecting SQL
• Inspecting log files(Nqquery.log,NQSserver.log)

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
14
OBIEE ONLINE TRAINING CONTENT

• Adding Multiple Sources To Dimension
• De-normalizing tables structures in database
  design
• Adding multiple sources to existing logical
  tables source
• Adding second table sources

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
15
OBIEE ONLINE TRAINING CONTENT

• Adding Calculations To Fact
• Calculation measures on the basis of physical and
  logical columns
• Using Calculation wizard

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
16
OBIEE ONLINE TRAINING CONTENT

• Creating Dimensional Hierarchies And Level Based
  Measures
• Creating dimensional hierarchies
• Use level based measures
• Create Rank and Share measures

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
17
OBIEE ONLINE TRAINING CONTENT

• Using Aggregation
• Importing Aggregated Tables into Repository
• Modeling aggregate tables to speed processing

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
18
OBIEE ONLINE TRAINING CONTENT

• Using Variables
• Presentation Variables
• Repository variables
• Session variables
• Initialization Blocks

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
19
OBIEE ONLINE TRAINING CONTENT

• Multiuser Environment (MUD)
• Overview on Multiuser Environment (MUD)
• How to create projects in MUD
• Checkout and checkin of projects

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
20
OBIEE ONLINE TRAINING CONTENT

• Modeling Time Series Data
• Types of SCDS
• Using of time series functions

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
21
OBIEE ONLINE TRAINING CONTENT

• Modeling Extension Tables
• Purposes of extension tables
• Modeling extension tables for fact and dimensions
• Oracle BI Security
• Security at object and data level
• Creating users and User groups
• Assigning permissions to users

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
22
OBIEE ONLINE TRAINING CONTENT

• Modeling Extension Tables
• Setting Query limits and timing restrictions
• Authenticating using an external database
• Cache management
• Purge cache and event handling tables
• Making the table cacheable
• Setting of cache in NQSCONFIG.INI file
• Oracle BI Presentation services

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
23
OBIEE ONLINE TRAINING CONTENT

• Modeling Extension Tables
• 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 Oracle Intelligence Dashboards
• Creating dashboard pages using report requests

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com
24
CONTACT US

• Street       Venkatasai EnclaveCity
            Nizampet, KukatpallyCountry
     Hyderabad-500090. India

Call 9603704766 E-mail contact_at_astsonlinetra
ining.com www.aststraining.com