Tuesday 23 September 2014

Best OBIEE Online and Classroom Training in Hyderabad (India)

RS Training OBIEE Training :



Course name : OBIEE 24*7 technical support
faculty : Realtime experience 
Rs Trainings is a brand and providing quality online and offline trainings to students in world wide.We are giving best online training on OBIEE
Highlights in our training service:
Every faculty has Real Time experiance .Trained Resources placed in countries like Australia, USA, UK, JAPAN, SWEDEN etc.Any critical issues faced by resource resolved using Teamviewer, webex.Supporting the resource with Top 100 Interview questions.Resume built in best corporate standards according to the job description.We will market the resume for top technolgy countries.After each week a status exam is conducted.offline online trainings are conducted everyday.Weekend trainings for job goers.flexible timings in accordance with the resource comfortability.If version related to any Tool is upgraded. We will send the upgraded information via email.we will develop the Aquintance with Production,development and testing environments.Real time scenarios covered accross Software Development Life Cycle.for every 10 hours One hour catered to resolve the doubts.Explaining bugs and critical issues and development activities 24*7 technical supports sevices.
Course 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?
Dimensional Modeling Overview
• Introduction to Dimensional Modeling
• What are Facts and Dimensions?
• Star schema and Snowflake schema
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 and Web administration,
• Servers- Oracle BI server, Presentation, Scheduler server
Server Architecture
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
Building Physical Layer of a Repository
• Objects of Physical Layer
• DSN for a data sources
• Build physical layer
Building business Model mapping layer
• Objects of BMM layer
• Building Business model (creating logical tables, columns, joins)
• Creating simple measures
Building presentation layer
• Objects of presentation layer
• Properties of the presentation layer
• Build presentation layer
Testing and validating Repository
• Checking repository consistency
• Checking Global Consistency
• Inspecting Oracle Answers inspecting SQL
• Inspecting log files(Nqquery.log,NQSserver.log)
Adding multiple sources to dimension
• De-normalizing tables structures in database design
• Adding multiple sources to existing logical tables source
• Adding second table sources
Adding calculations to fact
• Calculation measures on the basis of physical and logical columns
• Using Calculation wizard
Creating dimensional hierarchies and level based measures
• Creating dimensional hierarchies
• Use level based measures
• Create Rank and Share measures
Using aggregation
• Importing Aggregated Tables into Repository
• Modeling aggregate tables to speed processing
Using variables
• Presentation Variables
• Repository variables
• Session variables
• Initialization Blocks
Multiuser Environment (MUD)
• Overview on Multiuser Environment (MUD)
• How to create projects in MUD
• Checkout and checkin of projects
Modeling time series data
• Types of SCDS
• Using of time series functions
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
• 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
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
• Creating dashboard prompts
• Configuring guided navigation links
• Adding content to dashboard
• Conditional links and conditional section
Administering OBI Presentation Catalog
• Using catalog management to maintain web catalog
• Creating catalog groups, issuing privileges etc

Wednesday 3 September 2014

OBIEE TRAINING FOR ONLINE & CLASS ROOM


OBIEE - Oracle Business Intelligence Enterprise Edition

        Designed for scalability, reliability, and performance, Oracle Business Intelligence Enterprise Edition 11delivers contextual, relevant and actionable insight to everyone in an organisation, resulting in improved decision-making, better-informed actions, and more efficient business processes. Oracle also provides the industry’s only multi-sourced BI applications, as well as market-leading performance management applications that are powered by this BI platform.


OBIEE Data-warehousing Design Process Inception Phase
  1. Configuring an Oracle or DB2 or MS Sql Server database for use as a data warehouse
  2. Designing the Warehouse if the Warehouse supports more than one LOB the Data Modeler can come up with a Physical warehouse design based on Conformed Bus Architecture with conformed dimensions & Conformed facts which allow the IT to reuse the Data sets across the Business.
  3. Managing Schema objects such as Tables, Concurrent programs, Sequences, Schema, Disks, Views, Indexes & Materialized Views
  4. Managing & Maintaining the User Streams, ETL Process using an ETL tool or a Push Pull concurrent program code to Leverage operational data resemblance
  5. Managing change data capture using tools like CA -7 or Siebel DAC & more
  6. Creating Metadata repository, BMM Layer Meta data repository, User Authentication & Authorization Strategy through OBIEE or LDAP or Data base authentication.
  7. Backing up the data base & Performing recovery & leveraging fault tolerance


             Oracle Business Intelligence Enterprise Edition 11g (OBIEE) is a comprehensive business intelligence platform that delivers a full range of capabilities - including interactive dashboards, ad hoc queries, notifications and alerts, enterprise and financial reporting, scorecard and strategy management, business process invocation, search and collaboration, mobile, integrated systems management and more. OBIEE 11g is based on a proven web service-oriented unified architecture that integrates with an organization’s existing information technology (IT) infrastructure for the lowest total cost of ownership (TCO) and highest return on investment (ROI). 

OBIEE FEATURE AND BENEFIT 

FeatureBenefit
Interactive Dashboards
Provides fully interactive dashboards and reports with a rich variety of visualizations
Self-serve Interactive Reporting
Enables business users to create new analyses from scratch or modify existing analyses without any help from IT
Enterprise Reporting
Allows the creation of highly formatted templates, reports, and documents such as flash reports, checks, and more
Proactive Detection and Alerts
Provides a powerful, near-real- time, multi-step alert engine that can trigger workflows based on business events and notify stakeholders via their preferred medium and channel
Actionable Intelligence
Turns insights into actions by providing the ability to invoke business processes from within the business intelligence dashboards and reports
Microsoft Office Integration
Enables users to embed up-to-the-minute corporate data in Microsoft PowerPoint, Word, and Excel documents
Spatial Intelligence via Map-based Visualizations
Allows users to visualize their analytics data using maps, bringing the intuitiveness of spatial visualizations to the world of business intelligence






RS TRAININGS: Interactive training from Technological mavens to groom learners into technological aces.
RS TRAININGS is an outstanding ONLINE IT TRAINING and CLASSROOM IT TRAINING institute with State of Art infrastructure led by the finest trainers in the market. We offer Online training to the learners in all parts of the world with the implementation of modern technologies like Gotomeeting and WebEx.
Our trainers are Domain experts with a proven experience of at least a decade in the real time environment. We believe in the policy that “Learning is the virtue of success in life”. The flexible course curriculum designed at RS TRAININGS will be up to date in the technological race and be able to cater the requirement of both fresher’s and Professionals. Be it Corporate training or Online Training or Classroom Training for Hadoop,RS TRAININGS is elite and provides accomplished training services to cater the client need.