OBIEE BEST ONLINE TRAININGS

OBIEE classroom/online with job oriented best coaching in Sandsys with live projects by Real-Time experts and low fees. Course Name OBIEE Demo Classes Morning & Evening In Week Days Venue Sandsys Technologies Address #202,green house, Beside aditya trade center, Ameerpet, Hyderabad Trainer Having 8+ years of experience MODE OF TRAINING : NORMAL TRACK FAST TRACK ONLINE DURAION : 30 DAYS 15 DAYS 30 Days DAILY SESSION : 1hr 30min 2hr 30min 1hr 30min LAB SESSION : 7AM – 9PM REAL-TIME SCENARIOS SOFTCOPY OF MATERIAL AND SOFTWARES REAL-TIME PROJECT WITH EXPLANATION 100% JOB ASSURANCE PHNO 9573408188,040-40033103 info@sandsys.net, training@sandys.net 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 • Adding Calculation to a Fact Table • Building measures BUILDING THE PRESENTATION LAYER OF A REPOSITORY • Creating a new Presentation Catalog