OBIEE classroom/online with job oriented best coaching in Sandsys with live projects by Real-Time experts and low fees.
Course Name OBIEE
SOFTCOPY OF MATERIAL AND SOFTWARES
REAL-TIME PROJECT WITH EXPLANATION
          100% JOB ASSURANCE

CONTENT

Oracle BI Enterprise Edition (sometimes simply referred to as Oracle Business Intelligence) provides a full range of business intelligence capabilities that allow you to:
• Collect up-to-date data from your organization
• Present the data in easy-to-understand formats (such as tables and graphs)
• Deliver data in a timely fashion to the employees in your organization
These capabilities enable your organization to make better decisions, take informed actions, and implement more-efficient business processes.
OBIEE COURSE STRUCTURE
DATAWAREHOUSING CONCEPTS:
• Data Modeling (Schemas, FACTS and DIMENSIONS)
• Slowly Changing Dimensions
• Metadata
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
• Sample Request Processing
• Using the OracleBI Administration Tool
• Repository Directory
• Repository Files ( Initialization files and log files)
• Informatica Server ETLLoading 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.
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
• Reorder Table
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
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