peakindicators bi apps student information analytics draft

8/10/2019 Peakindicators Bi Apps Student Information Analytics Draft

1/66

Peak Indicators

BI Apps - Student Information Analytics

BI Apps & ODI

24thSep 2013


2/66

Peak Indicators Limited 2

Agenda

BI Apps

Student Information Analytics

Quickstart:

1. Peakindicators Overview

2. BI Apps Overview

3. BI Apps Student Information Analytics

4. BI Apps Student Information Analytics Quickstart Approach

5. BI Apps Release 11.1.1.7.1

6. BI Apps Student Information Analytics Training

7. BI Apps Student Information Analytics Support

8. Q&A


3/66


OverviewPeakindicators

Incorporated September 2008

Primary Focus

Expert Services

OBI EE Technical Training

Fixed Price Implementations for BI Applications

End User Adoption

Typical Employee Profile:

Senior Architects min five years OBI EE experience

Multiple project experience

Multiple Sectors experience

Previously worked for Oracle and/or Siebel BI Practices

Recognised OBI EE and BI Apps Experts

How We Stand With Oracle

Oracle Gold Partner

Oracle Approved Education Centre

Partner and regular contributor to UKOUG


4/66


5/66


Sample ProjectsPeakindicators

Here is a sample of prior Oracle BI Applications project experience for just 3 ofour Senior Architects:

Antony Heljula

Credit Suisse

Reckitt Benckiser Thomson Reuters Verizon (MCI) BT Syntegra Astra Zeneca Nuon De Telegraaf SKF Brakes Brothers

Matt Harte

Health Protection Agency

National Trust Plasan Toshiba Rural Payments Agency Uponor Viasala VisaCal Dairy Crest Polpharma An Post

David Hall

nPower

Verizon (MCI) Royal Mail Westpac BT Pfizer J&J Health Care Commission (UK) Inland Revenue (NZ) Dept. Comm. Service (Aus)


6/66


BI Apps

Overview


7/66 Peak Indicators Limited 7

OverviewBI Apps

New and Enhanced Oracle Business Intelligence Applications Help Organizations Extract StrategicInsights from Business Data

Increases Visibility and Intelligence by Extending Data Access & Expanding Existing Applications

Oracle Student Information Analytics provides academic institutions with best-in-class reporting andanalytic capabilities to increase faculty, staff and student productivity; streamline operations andinstitutional advancement; and ensure student success.

With pre-built analytics tailored to help higher education institutions match up resources with studentneeds, maximize student recruiting efforts, shorten time-to-graduation, improve retention rates, identifysuccessful and unsuccessful courses and optimize faculty workloads.

Oracle BI Applications (BI Apps) is a complete data-warehouse solution based on the Oracle BI EnterpriseEdition product suite

BI Apps enables organisations to rapidly deploy an end-to-end analytics solution providing acomprehensive and rich set of Business Intelligence dashboards

To speed adoption and time-to-value, Oracle Student Information Analytics provides source-specific

business adapters for Oracles PeopleSoft Campus Solutions and supports third-party solutions throughuniversal adapters.

BI Apps is designed so that it can be tailored to suit an organisations own individual reporting needs

Leveraging Oracle Data Integrator, Oracle GoldenGate, and new setup and configuration utilities, theapplications can be implemented faster, with reduced costs and improved real-time reporting.



Assured User Adoption, Rapid ROI, Reduced TCOBI Apps

Build from Scratch

with Traditional BI Tools

Oracle Analytic Applications

Prebuilt Business Adapters forOracle, PeopleSoft, Siebel, SAP,others

Prebuilt DW design, adapts to your

EDW

Role-based dashboards andthousands of pre-defined metrics

Easy to use, easy to adapt

Weeks or Months

Back-endETL and

Mapping

DW Design

Define Metrics& Dashboards

Back-endETL andMapping

DW Design

Define Metrics& Dashboards

Training / Roll-out

Training / Rollout

Months or Years

Peakindicators BI AppsQuickstart

approach:

Assured User Adoption Rapid ROI Lower TCO

Source: Patricia Seybold Research, Gartner, Merrill Lynch, Oracle Analysis



ArchitectureBI Apps

Oracle BI EE

ETLODI 11g /

V7.9.x DAC / Informatica)

SiebelCRM

PeopleSoftOracle

Applications

BI Apps Warehouse

OtherDatabase

......

100s of pre-built dashboards and reports

Role-based and personalised

1000s of KPIs / MetricsSecurity (role based data-visibility)

10s of Star-SchemasConformed DimensionsMulti-platform support

Modularised Extract / LoadHighly Parallelised and scalableSupport for multi-target / multi-sourceTuned for Full and Incremental ETL

Pre-built change capture and extractroutines specific to OLTP type andversionUniversal Adapters supportDesigned for minimal OLTP impact

ODIs new

architecture

eliminates

the need for

a stand-

alone ETL

server



Increased Analytic Capabilities

How can I improve Student Retention and define Student Successacross the Institution?

How do I measure student access, degree attainment and cost ofeducation?

How do I simultaneously minimize cost of graduation and ensure

consistently high quality of education? How do I meet the demands of new learning methods?

How can I provide adequate funding to maintain quality, improveaccess, and increase student success?

How can I effectively manage student billing, collections and financial

aid?

How can I reduce the decision cycle for admissions?

How can I manage the wait lists and enrollments efficiently?

Providing Insight & Driving Organisational Success



Metrics - Answer Business Process Questions

Subject Areas

Recruitment andAdmissions

Admission Application& Status

Admissions Funnel

External Academic

Summary & Test Scores Applicants,

Applications, Status

RecruitmentPerformance

Student Records

Academic Plan &Progress

Academic ProgramDetail

Class Enrolment,Instructor & MeetingPattern

Courses & Enrollments

Institutional Summaries& DemographicAnalysis

Student Financials

Payment Details

Charges & Payments

Aging

Student Credit History

Transaction Details



BANNER STUDENT INFORMATION SYSTEMMap to Source tables

Use of Universal Adapters Flexible & Performant

goremal gtvsdax

gurfeed

saraatt

saradap

sarappd

scbcrky

scbcrse

scrgmod

scrlevl

sfbetrm

stvmedi

stvnatn

stvrdef

sfrstcr sgbstdn

sgrsatt

shbcatt

shbcrmy

shrcatt

shrccmt

shrdgmr

shrgrde

shrrdef

shrtckg

stvresd

stvrmst

stvrsts

shrtckl shrtckn

shrttrm

sirasgn

slbbldg

slbrdef

smrprle

sorhsch

sortest

spbpers

spraddr

stvsbgi

stvstyp

stvterm

spriden sprmedi

sprtele

ssbsect

stvastd

stvatts

stvatyp

stvbldg

stvcert

stvcnty

stvcoll

swbidtl

swbitqy

szracsc

stvdegc stvdegs

stvdept

stvdisa

stvests

stvethn

stvgrst

stvhond

stvhonr

stvlevl

stvmajr

szracsh

szracsi

szracsm

szracss szradap

szrbgpa

szrexse

szrmgat

szrpatt

szrstrp

szvecls

szvexse

szvmgdo

szvsoec

tbbcont

tbbcprf

tbbcstu

Engineered to Support Diverse Source Data Environments!



OLTP Physical Complexity - Modelling 3NF ConsiderationsBusiness Model must appear as if everything is coming from a data warehouse!

Requirements Gathering

Mapping the Physical tables - What are the Dimensions / Facts / Hierarchies / Content levels

Combined Fact/Dim Tables 3NF schema, you typically just get one table that contains both the Dimensions and Facts

Time Dimension

There is NONE!

Snow-Flaking

Combine multiple tables into the same Logical Table Source in the Business Model

Parent-Child Hierarchies Self-Joins and Parent-Child Hierarchies occur when you have the same physical table joining to

itself (via aliases)

Aliases

to prevent circular joins and multiple possible join paths

Logical Keys

3NF tables will often join together on multiple columns (and possibly have more complex join

criteria)

Outer-Joins

Outer-joins are slow for performance

Disable Caching

Cache strategy - stale cache

Optimising

Which source table will be given a higher priority?

Avoid these complexities

with BI APPS!!



Product Tiers

Components

The Middleware (BI and ETL) tier a WebLogic domain andassociated system components, comprising BI componentsdelivered as part of OBIEE 11.1.1.7 (including Essbase and relatedapplications) as one managed server, and another managed servercontaining ODI Java components, including three new BI Apps-

related ones; Configuration Manager

Functional Setup Manager

ODI Load Plan Generator

The Database (DW and Repositories) tier for the time-being,

Oracle only, and comprising a data warehouse schema (staging +performance layer), and a repository database containing theOBIEE repository schemas plus new ones to hold the ODI repositoryand other ETL/configuration metadata used for configuring yoursystem.



Configuration ManagerSystem Setups, Data Load Parameters, Load plans, preferences & monitoring ofETL

Oracle BI Applications Configuration Manager performs system-wide setup tasks such as defining sources, selecting BI Appsmodules and performing other, one-only tasks similar to the Setupfeature in the DAC Console.



Configuration ManagerSet up the source database ODI topology entry, & push to the ODI masterrepository

Setting up a new BI Apps system involves using the Configuration

Manager to define the connections through to the various sourcesystems, then select the BI Apps modules (Student InformationAnalytics, for example, and then the various subject areas within it)that you wish to implement

You can then view theexecution steps and outcome

either in ODI Console

(embedded within

Configuration Manager), or

over at ODI Studio, using the

Operator navigator



Functional Setup ManagerEmpowersbusiness users to manage their changing business needs inless time and at lower cost

Used to list out, and track progress against, the various tasks

required to configure the BI Applications modules, or Offerings,that you selected in the Configuration Manager

Plan Install

Configure

Implement

Export & Import

Transact

Maintain



Oracle Data Integrator

ETL tool of Choice?

The new release of Oracle Business Intelligence (BI) Applications11g, Release 11.1.1.7.1 has been designed to add new in-memoryanalytic applications, significantly expand functional content acrossexisting front and back-office Oracle BI Applications, re-architectthe solution to leverage the power of Oracle Data Integrator and,

introduce new out-of-the-box tools to increase productivity anddrive down Total Cost of Ownership (TCO).

E-LT Transformation vs. E-T-L

Best in class for Performance, Scalability, Availability

Lightweight Deployment for Lowering TCO

Faster time-to-value through Declarative Design Heterogeneous, Open and Standards-based



Skillset

Have you got other Sources using ODI

The ODI Repository for Oracle BI Applications comprises two repositories:

Master Repository. Topology of resources, security, version management. A

master repository is usually associated with multiple work repositories, but

work repositories are always attached to a single Master repository

Work Repository. Contains data models, projects, load plans and scenarios.

This is the development and execution repository.



ODI Load Plan Generator

Load Plan Generator works behind the scenes to build new loadplans in a similar way to the Execution Plan Build feature in theDAC

Packages in ODI perform the same role as Informatica workflows in earlier releases of the BIApps, and each package runs some steps to refresh variables, work out if its doing a full orincremental load, and then call the relevant ODI interface. Interfaces in ODI for the BI Apps

typically load from other temporary interfaces, with these temporary interfaces performing therole of maplets in the Informatica version of the BI Apps

Individual packages are then assembled using the Load Plan Generator, which also gets installedinto ODI Studio as a plug-in so you can develop new data loading routines away from the fullproduction setup. These load plans are then visible from within ODI Studio (whether they weregenerated there, or from Configuration Manager), and like all ODI 11g load plans you can view theoutcome of each load plan instance run, also restart it if this feature is enabled


21/66



Overview


22/66


OverviewBI Apps Student Information Analytics

Pre-Built Metrics

Operational

Level Metrics

Strategic Level

Metrics

Student

Population

Retentioncount

Graduation

Count

Degrees

Awarded

Applicant toAdmit Ratio

Applications

Received

Applications

Accepted

Receivable

outstanding from

Students

Average GPA

Class

Enrollment

Waitlist

Application Count

by Status

Grade Points

Application in

Waitlist

% Chg Year Ago

Enroll Count

Application

Evaluation Count

Year Ago Average

GPA

Student to

Instructor Ratio

Year Ago Encumbered

Amount

GL Assessment

amount

Assignment

Percentage

Week Workload

Hours

Assignment

FTE%

Action

Level Metrics

These metrics are housed within the Oracle Business Intelligence Applications

repository. They are used in the pre-built analyses, and / or are available for

customers to use via Oracle Answers in building new analyses or extending existing

analyses

Business Function:

Sample Decision Workflow


23/66

23Oracle Student Information Analytics

Application Content

BusinessObjectives /

Issues

Gain

Insights

Take

Action Target recruiting efforts to expedite applications

processing

Is the conversion ratio of Prospects to Enrollees

trending up?

Review Admissions Funnel for Prospects, Applicants,Admissions, Confirmations and Enrollment.

Optimize Recruiting Effectiveness

DrilltoDet

ail

Is there a delay in processing and confirming

admissions?

Does Recruiter / center performance vary by Region,

Recruiting category etc?

Drill to applications pending confirmation and

recruiters below the target levels

Recruiting andAdmissions

Role:Director of Admissions

Objectives: 1) Optimize

RecruitingEffectiveness

2) ResolveBottlenecks

Sample Decision WorkflowRecruiting and Admissions


24/66


Overview Subject AreasBI Apps Student Information Analytics

Admission Application

Admission ApplicationSnapshot

Admission Funnel

Admission ApplicationEvaluation

Admission Application

Status External Test Scores

External Test ScoreSnapshot

External AcademicSummary

External AcademicSummary Snapshot

Student Recruiting

Student Response

Transfer Credit

Snapshot

Academic Class

Academic PlanSummary

Academic ProgramDetail

Class Enrolment

Class instructor Class Meeting Pattern

Enrolment Requests

Institution Summary

Student Degrees

Term Enrolment

Student Credit History

Payment Details

Payments and ChargesCross Reference

Transaction Details


25/66


ComponentsBI Apps Student Information Analytics

Pre-mapped metadata, with 100s of pre-builtcalculations and metrics across 17 SubjectAreas

Presentation Layer

Logical BusinessModel

Physical Sources

3

Prebuilt ETL to extract data from over 3,000operational tables and load it into the DW,

sourced from Oracle, Siebel, PSFT, JDE andothers.

2

Prebuilt warehouse with more than 9 star-schemas designed for analysis and reporting

on Student Information Analytics

1

A best practice library of over 270 Reportsand alerts across GL, AP, AR and Profitability

Dashboards

4



Sample Star Schema

Student Admission Application Status

This contains data on the application status changes and theeffective dates

Student Admission

Application Status

Program Status

Academic Sub-

PlanAction Reason

Academic Career

Academic

Program

Academic

Institution

Program Action

Person

Campus

Academic

Level

Academic

Load

Academic Plan

It is called a Star-Schema because the joins (Foreign Keys) between the tables

form a relationship diagram that resembles a star:

central Fact surrounded by one or more Dimensions

Always 1:M between Dimension: Fact

Facts only join to Dimensions, Dimension only join to Facts

S S d I f i A l i R i


27/66


Support Student Information Analytic Requirements

Multi Source ETL

SourceSystems

PeopleSoft CampusSolutions

Intermediary Table

Non-Oracle Sources Export to Flat File Staging Table

Warehouse Table

The Oracle Database has specific optimisation techniques for querying Star-Schemas

(referred to as Star Transformation)

Star-schemas can be easily optimised for reporting against large data-volumes (e.g.

creating aggregate tables or materialized views)

Star-Schema data structures facilitate the expansion of the Data-Warehouse by

adding additional Fact tables which can share common Dimensions already present


28/66



Quickstart Approach


29/66


ApproachBI Apps Student Information Analytics - Quickstart

Peak Indicators offer an attractive package to enable you to speedily deploy acomplete Student Information Analytics Quickstart

The Student Information Analytics Quickstart offering is a fixed-price,rapid deployment package that leverages best practices derived from our

combined knowledge and experience of both Oracle Financials and Oracle BIApplications


30/66


DurationBI Apps Student Information Analytics - Quickstart

In just 8 weeks, members of your Academic community will have access topersonalised, easy-to-use, best practice metrics tailored to their respectiveroles

These metrics will provide for timely, relevant and actionable insights

derived from information stored in the underlying BI ApplicationsWarehouse

Completing this first phase of a Oracle BI Applications deployment willestablish a best-practices foundation for continued analytics developmentacross your enterprise


31/66


Implementation PrinciplesBI Apps Student Information Analytics - Quickstart

Peak Indicators implementation approach has been developed on theprinciples of:

Ensuring the local team become self sufficient as early aspossible

Satisfying the customer through early and continuous deliveryof valuable BI

Accommodating changing requirements focused on drivingbusiness improvements

Delivering frequent enhancements to BI Reporting, from a

couple of weeks to a few months

Business & development team working closely together


32/66


Implementation ServicesBI Apps Student Information Analytics - Quickstart

Peak Indicators are keen to support clients in the

most effective way in their implementation of OracleBI Enterprise Edition and Oracle BI Applications.Our focus is to ensure that clients have access tonecessary skilled resources so that they can rapidlydeploy successful BI applications.

Therefore the approach we recommend is focusedaround rapidly building the necessary skills andknowledge so the customer becomes self sufficientas quickly possible.

In order to achieve this we would recommend thefollowing 6 step plan focused on training andmentoring of the key members of the customersbusiness and IT teams


33/66


6 Stages To Successful OBIEE DevelopmentBI Apps Student Information Analytics - Quickstart

Train

1. OBI EE

Technical BootCamp &

OBI EE BI AppsBootcamp

Install

2. Install &Populate BIApplication(HR Analytics)

Requirements

3. ReviewContent

4. PrioritiseRequirements

Development

5.Development

6. Unit Testing

Deployment

Planning

Migrate toUAT

UAT

Deploy to Live

On goingSupport

ExpertServices


34/66


Implementation ApproachBI Apps Student Information Analytics - Quickstart

Deployment

Cycle

DeployLive

UAT

Migrateto UAT

Planning

Development

Cycle

Review &

Req.Capture

Play back

Develop &Unit Test

Prioritise &Select

Phase 1Delivers.

High LevelDesign

Install

BI AppsInitial Load


35/66




36/66



Development

Cycle

Review &

Req.Capture

Play back

Develop &Unit Test

Prioritise &Select

Phase 1Delivers.

High LevelDesign

Install

BI Apps

Initial Load

Phase Outputs

Instal l & Initial Load Customised Instal l Guide

Review & Reqs Capture Requirements Document

High Level Design Source Target MappingDocument

Prioritised Deliverables Quickstart Prioritised

Deliverables

Development Updated OBI RPD file

Updated Informatica

Mappings

Updated OBI EE Webcat

Unit Testing Unit Testing XLS


37/66


Package DetailsBI Apps Student Information Analytics - Quickstart

Duration: 8 weeks

Price: Contact Tony Cassidy

Products: Oracle BI Applications Student Information Analytics

Oracle BI Enterprise Edition

Users: Up to 3 user groups, single language

Application Configuration:

Extend two dimension tables with up to 30 simple field extensions from the Oracle ApplicationOLTP tables

Extend with 1 new Fact or Dimension table 2 existing Dashboards tailored to suit Customers needs

16 new reports across the 2 Intelligence Dashboards (includes drill-down reports)

Implementation of performance strategies leveraging aggregate awareness and caching

Authentication: Out of the box security (based on Oracle Applications Model)

d f l k


38/66


ResourcesBI Apps Student Information Analytics - Quickstart

Customer Resources Project Manager (40%)

Business Process Expert (40%)

DBA / Technical Support (ad-hoc)

Projected / Peak Indicators Resources BI Consultant (100%)

BI Architect (40%)

Functional Lead (60%)


39/66


BI Apps

Release 11.1.1.7.1

BI A R l 11 1 1 1


40/66


BI Apps Release 11.1.1.7.1

Business Intelligence overview

Oracle Human Resources Analytics

Time and Labour Analytics

Payroll Analytics

Workforce Gains and Losses

Leave Accrual

Oracle Procurement & Spend Analytics

Sourcing Analytics

Oracle Supply Chain and OrderManagement Analytics

Enhanced Inventory Analysis

New Item Cost History Analysis

Oracle Student Information Analytics

Fixed Assets Analytics

Budgetary Control Analytics

Oracle Project Analytics

Resource Management Analytics

Project Subledger Reconciliation

Perspective based Dashboards

Oracle CRM Analytics

Oracle Price Analytics

Oracle Service Analytics

Oracle Sales Analytics

Significant expansion of content improves existing front and back-office Oracle BI

Applications Oracle BI Applications including: NEW Oracle Indirect Spend Planning

NEW Oracle Student Information Analytics

BI A R l


41/66


Architecture ChangesBI Apps Release 11.1.1.7.1

7.9.x versions of the BI Apps(Informatica based) BI Apps 11.1.1.7.1 (ODI based)

BI Apps Release 11 1 1 7 1


42/66


BI Apps Release 11.1.1.7.1

About E-LT Architecture

The extract and stage load step isgenerated from a combination ofthe main interface and the nestedtemporary interface. The loadtransform step is generated as aresult of the integration knowledgemodule (IKM).

Note that Oracle Database is the onlydatabase type supported for the Oracle BIApplications repository schemas and theBusiness Analytics Warehouse.

Typically, the extract-load-transform process has two main steps:

The first step is the extract and stage load step, and the second step is the loadtransform step. The first step is the extract and stage load step, and the secondstep is the load transform step.

BI A R l


43/66


ODI replacing DACBI Apps Release 11.1.1.7.1

ODI - embedded ETL Tool

ODI leveraging innovative E-LT (Extract Load andTransform) Architecture

Setup of ODI topology done viaweb-based application (OracleBI Applications Configuration

Manager) Packages in ODI perform the

same role as Informaticaworkflows in earlier releases ofBI Applications

BI A R l


44/66


Pro and Cons Architect PerspectiveBI Apps Release 11.1.1.7.1

Pros:

better integration between architectural layers

ETL tier removed (ODI as embedded tool)

introduction of Oracle Golden Gate

leveraging Oracle Essbase server - rich modelling environment with extremely fastaggregation and calculation

direct integration with Oracle E-Business Suite and Oracles PeopleSoft incorporate

established ERP business rules and constraints, allowing more realistic modellingscenarios and the creation of actionable plans

Cons:

lack of automatic upgrade path from BI Apps 7.9.x

lack of automated migration routine from Informatica to ODI (this move can be done

as a re-implementation) only Oracle database sources and targets supported

Oracle Fusion Application not supported as source

Enterprise Asset Management not supported for any source

BI A R l


45/66


Pro and Cons End User PerspectiveBI Apps Release 11.1.1.7.1

Pros:

faster application implementation

reduced costs

improved real-time reporting

incorporate established ERP business rules and constraints (Oracle Essbase),allowing more realistic modelling scenarios and the creation of actionable plans

new visualizations

improved user interface and significant data access updates allow users to easilyinteract with analytics to achieve rich insights

rapid deployment at a low cost of ownership,

Cons:

lack of automatic upgrade path from BI Apps 7.9.x

lack of automated migration routine from Informatica to ODI (this move can be doneas a re-implementation)

only Oracle database sources and targets supported

Oracle Fusion Application not supported as source

Enterprise Asset Management not supported for any source

BI A R l 11 1 1 7 1


46/66


Pro and Cons Developer PerspectiveBI Apps Release 11.1.1.7.1

Developer is the one who benefits and is affected by both the architectural Pros andCons, as well as the End-User level ones. Still, there are a couple whose impact is being

felt mostly by Developers:

Pros:

New Extract Load and Transform (E-LT) technology that improves performance andreduces data integration costs, even across heterogeneous systems by pushing theprocessing required down to the typically large and powerful database servers already

in place within the enterprise

Easier application management (trough Oracle BI Applications ConfigurationManager) integrated ODI control

ODI helps to integrate data end-to-end across the full BI Applications architecture,supporting capabilities such as data-lineage which helps business users identifyreport-to-source capabilities

Oracle Business Intelligence Applications Releases


47/66


Oracle Business Intelligence Applications Releases

Release GA Date Premier

Support

Ends

Extended

Support

Ends

Sustaining

Support

Ends

Business Intelligence

Applications 7.9.0 -

7.9.4

Mar

2007

Mar

2010

Mar

2012

Indefinite


Applications 7.9.5.x

May

2008

May

2011

May

2013

Indefinite

Business IntelligenceApplications 7.9.6.0 -

7.9.6.1

Apr2009

Apr2012

Apr 2014 Indefinite


Applications 7.9.6.2

Sep

2010

Sep

2013

Sep 2015 Indefinite

Business IntelligenceApplications 7.9.6.3

May2011

May2014

May2016

Indefinite


48/66



Training

BI Apps Student Information Analytics Training


49/66


Roles in a successful BI DeploymentBI Apps Student Information Analytics Training

OBI EEDevelopment

OBIADevelopment Report

Consumers

SuperUsersOracle BI

Applications

Technical Development Team Business User



50/66


BI Apps Developer - Key TasksBI Apps Student Information Analytics Training

BI Apps Developer will be responsible for: Modifying/updating the physical, business and

presentation layers of the OBI EE Repository

Modifying/creating BI Apps dashboards andrequests in line with the initial businessrequirements.)

BI Apps Developers will be the key resources forassisting Super Users in understanding theunderlying data model and reports

BI Apps Developers will provide support to Super

Users for addressing data and reporting issues



51/66


Super Users Key TasksBI Apps Student Information Analytics Training

Super Users will be responsible for gatheringreporting requirements from wider user community

Super Users will be the key resources for developingand building local dashboards for use by their localusers.

Super Users will be responsible interfacing withtechnical resources when required

Super-Users will also act as first level support fortheir user communities in resolving issues/queries

regarding the applications being developed.

Super Users should look to contribute/input toensuring data quality/accuracy.



52/66


Proposed Training By RoleBI Apps Student Information Analytics Training



53/66


Step 1: Building Skills in OBIEEBI Apps Student Information Analytics Training

Deliverable: OBIEE Technical Boot Camp

Duration: 5 Days

Location: Customer Site

Objectives: This 5 day course provides OBI EE Developers andArchitects with valuable knowledge and hands-on

experience with advanced BI Repositorymodelling techniques plus detailed sessionsfocussing on the designing and building ofsophisticated BI Dashboards and Reports.

Attendees Maximum 15 delegates



54/66


Step 1: Building Skills in BI AppsBI Apps Student Information Analytics Training

Deliverable: OBI BI Applications Technical Boot Camp

Duration: 5 Days


Objectives: This 5 day course allows developers and architectsto gain valuable hands-on experience with all the

key technical areas relevant to a BI Applicationsimplementation including installation, executingand monitoring ETL, modelling the BI Repository,extending the solution with an additional star-

schema and integration with Peoplesoft HRApplication




55/66


Step 2: Building Super User SkillsBI Apps Student Information Analytics Training

Deliverable: OBI BI End User Training

Duration: 2 Days


Objectives: This training will provide your BI Developers,Report Builders and Business Power Users with

all the skills needed to design and buildsophisticated BI Dashboards and Reports cateringfor multiple Business areas, roles andresponsibilities




56/66


Step 3: Supporting End UsersBI Apps Student Information Analytics Training

Deliverable: Oracle BI Apps End User Training (FinancialAnalytics)

Duration: 2 Days


Objectives: This training will provide your Financial

Community with an overview of the OracleBusiness Intelligence Student Information AnalyticsApplication. Topics covered include architecture overview,in depth overview of the reporting content available,

navigating dashboards, exporting and printing.




57/66


Step 3: Supporting End UsersBI Apps Student Information Analytics Training

Deliverable: eLearning Material

Duration: TBC


Description: Peak Indicators are experienced in developing e Learning applications (using Adobe eLearning

Suite) which provide users with access toannotated demonstrations of their developedapplications. Typically broken into chapters, eachwould address a specific areas such as:

- The anatomy of a dashboard- Navigating dashboards- Filters & Saving Selections- Exporting and Printing

Effort Typically 1.5 days per chapter


58/66



Support

BI Apps Student Information Analytics - Support


59/66


Existing ProblemBI Apps Student Information Analytics Support

During every BI implementation lifecycle there are occasions where expert assistance is required,for example:

Technical Issue Resolution

Advice on Development Best Practices

Architecture & Design Review

Release Quality Assurance

Project and Implementation Planning

Customers often struggle to obtain the right advice and assistance:

The real experts are hard to find

Consultants are already engaged on assignments

It takes time to get contractual agreement, customers dont have time to wait

Official support from Vendors is typically limited to technical issues and does not cover

reviews and general guidance on design and development best practices



60/66


The SolutionBI Apps Student Information Analytics Support

Expert Support Services from Peak Indicators provides customers with flexible and direct accessto the top Oracle BI Architects within Europe

The service is designed to provide customers with expert virtual team members, providing peace-of-mind and reducing project risks

The service will cover everything from general everyday questions to more involved tasks such as

design and architecture reviews

Peak Indicators are best placed to assist customers with Expert Support Services:

Widely regarded as having some of the top BI Architects within Europe

Highly experienced in setting up, managing and implementing BI & DW projects

Vast experience with technical troubleshooting and problem resolution

Existing relationships with Oracle Product Management/Development



61/66


CoverageBI Apps Student Information Analytics Support

Expert Support Services will cover the entire Business Intelligence and Data-Warehousing productstack:

Oracle BI Enterprise Edition (incl. SSO, Security, MapViewer)

Oracle Data-Warehouse (incl. Data-Model, Database and OLAP)

Oracle BI Applications (incl. Informatica)

The following Services are available:

Technical Issue Resolution

General Guidance on Development Best Practices

System Health-Checks

Design/Development Reviews and Recommendations

Release Quality Assurance

Project and Implementation Planning

Creating and Managing Service Requests with Oracle Support



62/66


Model / ProcessBI Apps Student Information Analytics Support

A customer contacts Expert Services Support using the following dedicated email address:[email protected]

The request for Expert Support Services will be acknowledged within 4 business hours:

Confirmation of assigned BI Architect

Estimated 1st Response Time

1st response from BI Architect/Specialist will be made within 1 business day

All subsequent communications will be responded to within 1 business day

The customer will have direct mobile and email contact with the BI Architect

mailto:[email protected]:[email protected]


63/66


CommercialsBI Apps Student Information Analytics Support

Expert Support Services can be engaged in two ways:

Remote Units of 2 hours @ 280 per unit

On-Site

Units of 8 hours @ 1250 per 8 hrs (1 working day)

Subject to BI Architect availability

Inclusive of expenses



64/66


SLAs & Quality MetricsBI Apps Student Information Analytics Support

We utilise a standard SLA and specific Quality Metrics that apply to our clients and the solutiondeployed. This can be adapted to suit additional needs.

We are committed to providing the highest levels of customer service at all times and havedeveloped a clear commitment to you

Our BI Architects have a Resolve in 1 Response target of 75%

At the end of each month, Peak Indicators will provide a report summarising the Expert SupportServices engagements during the month:

Summary of Issues and Resolutions

General Recommendations

Your Account Balance with Expert Support Services


65/66


Questions?


66/66

Helping Your Business

Intelligence Journey

peakindicators bi apps student information analytics draft

Documents