Oracle 12C Online Training by QuontraSolutions

1
OBIEE Online Training By Quontra
Solutions
TRAINING PLACEMENT
PROGRAM www.QuontraSolutions.co.uk Emailinfo_at_quon
trasolutions.co.uk Call Us 44(0)-20-3734-1498
To request free demo session please mail us
at info_at_quontrasolutions.co.uk 
2
Our Differentiators

• DURATION4-5 Weeks or 40-45 Sessions
• Valuable insights into persistent business
  problems, real-world scenarios, industry specific
  requirements.
• Competitively priced Package (includes Training
  Material Domain Training Resume Preparation
  Mock Interviews Job Marketing)
• Weekend, Morning and Evening batches are
  available
• Pre-Placement Guidance and Interview Sessions
  with Sr. level consultants
• Faster time-to-market advantage using best
  practices of job marketing.
• Lowest fee Package ( includes Training
  Material Domain Training Resume Preparation
  Mock Interviews Job Marketing).

3

• Course Details
• In this course, you will build the fundamental
  understanding of BI reporting using the Oracle
  Business Intelligence Reporting. OBIEE training
  model includes all the technical procedures
  required to facilitate data modeling and other
  data related activities which also covers
  advanced topics like security model, multi user
  development environment.
• Training type  Online
• FREE DEMO CLASSES AVAILABLE
• Duration 5Weeks Batch Timings 
  Morning, Evening and Weekend batches available

OBIEE Online Training Course
4
What will you learn?

• In-depth understanding of Data Warehousing and
  Data Collection Concepts
• Understand the core functionality of OBIEE
• Create High-end Complex Business Reports using
  OBIEE
• Different views and charts on BI Presentation
  Server
• Repository Basics
• Building different Layer of a Repository
• Understand about exceptional OBIEE user friendly
  and highly processed Dashboards
• Creating extensive and efficient reports using
  Oracle BI Publisher
• Collect, present and deliver data in a timely and
  organized fashion

FREE DEMO CLASSES
5

• In order to make yourself a true professional you
  need to always keep updating your skillset at par
  with the market requirement, that is where
  quontra solutions explores the opportunities for
  you to get the best available training from the
  industry experts in the various technologies that
  are available in the market, the need to fulfil
  the supply and demand chart is very much a need
  in todays scenario.
• Training Features
• Intensive Training with friendly Course Material
• Access to Audio/Video Recordings of training
  sessions
• 8-10 years of Experienced Industry Certified
  Instructors
• Expert guidance and mentoring during after
  training and also on job
• Based on performance and experience, the best
  Salary packages with flexible hourly() options
• Assisting you in finding a Real time project
  experience if needed after finishing of training
• Pre-Placement Guidance and Interview Sessions
  with Sr. level consultants
• Aggressive marketing on each Individual Candidate
  for best job market rates
• Post On-Job Support

6

• OBIEE Online Training
• DURATION 4-5Weeks or 35-40 Sessions
• Prerequisites
• Dimensional modeling
• Basic SQL
• Data warehouse design
• Database design
• Target Audience
• Business Intelligence Developer
• Data Warehouse Administrator
• Business Analysts
• Data Warehouse Analyst
• Data Modelers
• Reports Developer
• Data Warehouse Developer
• Application Developers

7

• Course Content
•  Oracle Business Intelligence (OBIEE)
• OBI ARCHITECTURE
• Clients
• OBI Presentation Services
• OBI Server
• OBI Repository (.rpd)
• Data Sources
• OBI COMPONENTS
• OBI Administration Tool
• OBI Answers
• Intelligence dashboards
• REPOSITORY BASICS
• Oracle Business Analysis Warehouse
• DAC and Informatica Server
• Informatica Server ETL

8

• Sample Request Processing
• Using the Oracle BI Administration Tool
• Repository Directory
• Repository Files ( Initialization files and log
  files)
• Informatica Server ETL Loading a repository into
  Oracle BI Server memory
• Creating a repository
• Connection Pool
• Repository Modes ( ONLINE and OFFLINE )
• Physical Layer
• Business Model Mapping Layer
• Presentation Layer
• Presentation Catalogs, Folders and Columns
• Error Messages
• Note All Training will be on BI Sample
  Schema.

9

• BUILDING THE PHYSICAL LAYER OF A REPOSITORY
• Defining an ODBC System DSN
• Setting up connection pool properties
• Importing data sources ( Physical Schema )
• Verifying the import
• Defining physical keys and joins
• Creating alias and select tables
• BUILDING THE BUSINESS MODEL AND MAPPING LAYER OF
  A REPOSITORY
• Creating the logical business model
• Creating the logical tables, columns, and
  sources
• Defining logical joins
• Adding Calculation to a Fact Table
• Building measures
• BUILDING THE PRESENTATION LAYER OF A REPOSITORY
• Creating a new Presentation Catalog
• Modifying Presentation layer objects
• Rename tables

10

• TESTING AND VALIDATING A REPOSITORY
• Checking repository consistency
• Defining a repository in the initialization
  file
• Testing a repository using Oracle BI Answers
• Message Severity
• Viewing Server Logs
• BUILDING THE PHYSICAL LAYER OF A REPOSITORY
• Defining an ODBC System DSN
• Setting up connection pool properties
• Importing data sources ( Physical Schema )
• Verifying the import
• Defining physical keys and joins
• Creating alias and select tables

11

• BUILDING THE BUSINESS MODEL AND MAPPING LAYER OF
  A REPOSITORY
• Creating the logical business model
• Creating the logical tables, columns, and
  sources
• Defining logical joins
• Adding Calculation to a Fact Table
• Building measures
• BUILDING THE PRESENTATION LAYER OF A REPOSITORY
• Creating a new Presentation Catalog
• Modifying Presentation layer objects
• Rename tables
• Reorder Table

12

• TESTING AND VALIDATING A REPOSITORY
• Checking repository consistency
• Defining a repository in the initialization
  file
• Adding Multiple Logical Table Sources
• Adding multiple logical table sources to a
  logical table
• Specifying logical content
• ADDING MULTIPLE LOGICAL TABLE SOURCES
• Adding multiple logical table sources to a
  logical table
• Specifying logical content
• ADDING CALCULATIONS TO A FACT TABLE
• Creating new calculation measures based on
  existing logical columns
• Creating new calculation measures based on
  physical columns
• Creating new calculation measures using the
  Calculation Wizar

13

• CREATING DIMENSION HIERARCHIES AND LEVEL-BASED
  MEASURES
• Creating dimension hierarchies
• Creating level-based measures
• CREATING USING AGGREGATES
• Purpose of aggregate tables in dimensional
  modeling
• Modeling aggregate tables to improve query
  performance
• Testing aggregate navigation
• Using Initialization Blocks Repository
  Variables
• Creating Dynamic Repository Variables
• EXECUTE DIRECT DATABASE REQUESTS
• Accessing database directly

14

• CREATING TIME SERIES MEASURES
• Using time comparisons in business analysis
• Using Oracle BI time series functions to
  model time series data
• CREATING DIMENSION HIERARCHIES AND LEVEL-BASED
  MEASURES
• Creating dimension hierarchies
• Creating level-based measures
• Providing Security for Groups Users
• ANSWERS (REPORTS)
• WORKING WITH ORACLE BUSINESS INTELLIGENCE ANSWERS
• Introduction to Oracle BI Answers
• Working with requests in Oracle BI Answers
• Using advanced formatting
• Creating report Level Hierarchy

15

• FILTERING REQUESTS IN ORACLE BUSINESS
  INTELLIGENCE ANSWERS
• Introduction to filters in Answers
• Adding filter prompts to requests
• Using saved requests as filters
• BUILDING VIEWS AND CHARTS IN REQUESTS
• Creating and editing charts
• Performing common view tasks
• Creating a Narrative View
• Creating a column Selector
• SHOWING RESULTS WITH PIVOT TABLES
• Introduction to pivot tables
• Formatting pivot tables
• Setting aggregation rules and building
  formulas

16
Thank You