OBIEE Training with Real Time Project

 OBIEE Training with Real Time Project

About OBIEE:

Oracle Business Intelligence Enterprise Edition 11g (OBIEE) is an unrivaled and comprehensive business intelligence and analytics platform that delivers a full variety of capabilities—including interactive dashboards, unstructured search and collaboration, ad hoc queries, enterprise and financial reporting, scorecard and strategy management, business process invocation, mobile analytics, notifications and alerts,  integrated systems management.

About OBIEE training:

Our obiee trainers are oracle business intelligence (OBIEE) certified Consultant and experienced working professionals with hands on real time OBIEE project knowledge. OBIEE Online Training classes by real time working experienced expert on exclusive OBIEE 12c version with hands on guidance we provide excellence Online Training in OBIEE from the real time consultant in the Project based Scenarios.

We have designed our obiee course content based on our student’s requirement to achieve career goal. OBIEE online trainer will provide you all possible interview questions with answers and take a preliminary interview to put up your confidence. We also provide you OBIEE job support if you get any issues in the real time.

 Prerequisite of OBIEE:

Basic SQL Knowledge and Database is enough to learn OBIEE.

 Course Content:

INTRODUCTION TO DWH CONCEPTS
		Day 1
1	OLTP Vs OLAP
2	Data warehouse Architecture
3	Data warehouse Vs Data Mart
4	ETL
5	Measures, Fact, Dimensions
6	Schema
7	Star Schema
8	Snowflake Schema
9	Dimension Hierarchy
10	Slowly Changing Dimension
11	Type 1
12	Type 2
13	Type 3
14	Data Modelling
15	Fact Less fact table
16	Junk Dimension
17	Data Ware House Tools
18	Confirm Dimension
Oracle SQL
		Day 2
1	How to create schema's
2	How to Import Data (Sample)
3	How to Export Date (Sample
4	How to Grant Permissions
5	How to add new connections in Database
6	How to create tables and columns
7	Some Basic SQL Commands
ORACLE BUSINESS INTELLIGENCE – REPOSITORY		Day 3
1	Repository Basics
2	Oracle BI architecture components
3	Repository structure, features, and functions
4	Using the OracleBI Administration Tool
5	Creating a repository
6	Building the Physical Layer of a Repository	Day 4
7	Importing data sources, Tables and Columns
8	Setting up connection pool properties
9	Defining keys and joins
10	Examining physical layer object properties
11	Creating alias and select tables
12	Loading a repository into Oracle BI Server memory
13	Building the Business Model and Mapping Layer of a Repository	Day 5
14	Building a business model
15	Building logical tables, columns, and sources
16	Defining logical joins
17	Building measures
18	Examining business model object properties
19	Building the Presentation Layer of a Repository	Day 6
20	Exploring Presentation layer objects
21	Creating Presentation layer objects
22	Modifying Presentation layer objects
23	Examining Presentation layer object properties
24	Testing and Validating a Repository
25	Checking repository consistency
26	Turning on logging	Day 7
27	Testing a repository using Oracle BI Answers
28	Inspecting the query log
29	Adding Multiple Logical Table Sources	Day 8
30	Adding multiple logical table sources to a logical table
31	Specifying logical content
32	Adding Calculations to a Fact Table	Day 9
33	Creating new calculation measures based on existing logical columns
34	Creating new calculation measures based on physical columns
35	Using Aggregates
37	Creating Dimension Hierarchies and Level-Based Measures	Day10
38	Creating dimension hierarchies
39	Creating level-based measures
40	Modeling Time Series Data
41	Using time comparisons in business analysis
43	Purpose of aggregate tables in dimensional modeling	Day11
44	Modeling aggregate tables to improve query performance
45	Testing aggregate navigation
47	Using Partitions and Fragments	Day12
48	Purpose for segmenting data into partitions and fragments
50	Use of Joins Like Complex Join, Inner Join, Left Outer Join, Right Outer Join, Full Outer Join.	Day13
51	Initialization Blocks and Variables.
52	Repository Utilities
53	calculation by using calculation wizard
55	All Types of Functions in BMM Layer	Day 14
56	Rename and Re-Arrange Wizard
58	Building Views	Day15
59	Multiple use of Alias Table
60	Modelling Bridge Table
62	Cache Management	Day16
63	Implicit Fact Column
64	Creating Hierarchy in Presentation Layer
65	Event Pooling
	Usage Tracking
67	About EM	Day17
68	About Console
69	Path Location
70	Log Files
71	Configuration Files
	Oracle BI Answer Side (Catalog)	Day18
75	Catalog Manager Options
76	Migrations
77	Introduction to Oracle BI Answers	Day 19
78	Working with requests in Oracle BI Answers
79	How to access Subject Areas
80	Basic Reporting
81	Formating	Day20
82	Filters
83	Using advanced formatting
84	Filtering Requests in Oracle Business Intelligence Answers
85	Introduction to filters in Answers
86	Adding filter prompts to requests
87	Using saved requests as filters
88	Types of View	Day 21
89	Oracle Business Intelligence Answers: Advanced Features	Day 22
90	Combining request criteria using set operations
91	Executing direct database requests
92	Building Views and Charts in Requests	Day 23
93	Introduction to Answers views and charts
94	Creating and editing charts
95	Performing common view tasks
96	Showing Results with Gauge Views
97	Introduction to Gauge views
98	Working with Gauge views
99	Showing Results with Pivot Tables
100	Introduction to pivot tables
101	Formatting pivot tables
102	Setting aggregation rules and building formulas	Day 24
103	Creating Oracle Business Intelligence Interactive Dashboards
104	Introduction to Interactive Dashboards and pages
105	Dashboard Editor UI elements
106	Composing dashboard elements
107	Types of dashboard content
108	Using Prompts	Day 25
109	Scope of the Prompt
110	Presentation Variable and Uses
111	Request Variable
112	Combine Request	Day 26
113	Direct Database Request
114	Customizing the Oracle Business Intelligence User Interface	Day27
115	Making configuration changes using the instance config file
116	Configuring Guided Navigation Links
117	Building guided navigation with static links
118	Building guided navigation with conditional links and sections
119	Administering the Oracle Business Intelligence Presentation Catalog
120	Maintaining the Oracle BI Presentation Catalog
121	Managing security
122	Understanding security inheritance	Day 28
123	Permission types - Object Level Security/Data Level Security
124	Setting permissions using the Manage Catalog screen
125	Creating users and groups
126	Setting permissions for users and groups
127	Setting query limits and timing restrictions
128	Introduction to Oracle BI Scheduler	Day 29
129	Using BI Deliver
130	Configuration of Scheduler Service
131	Creating & scheduling iBots
132	Using Repository Variables	Day 30
133	Session variables
134	Repository variables
135	Initialization blocks
136	Using dynamic repository variables as filters
137	Setting filters to personalize information	Day 31
138	Cache Management
139	Inspecting cache reports
140	Purging cache entries
141	Modifying cache parameters and options
142	Seeding the cache
143	Creating selection steps	Day 32
144	Creating groups
145	Creating calculated items
146	Including advanced SQL clauses in your analysis
147	Providing Real Time Scenarios on RPD and Answer Side.	Day 33
148	Interview Perspectives

 
www.chennaiacademmy.com

Kindly contact us

Seetha

Technical consultant

9500092050

boundtechsolutions@gmail.com

Click Here to Register for Free Demo