copyright 2007, information builders. slide 1 banner reporting foundation dan haug account executive...

Post on 13-Jan-2016

214 Views

Category:

Documents

0 Downloads

Preview:

Click to see full reader

TRANSCRIPT

Copyright 2007, Information Builders. Slide 1

Banner ReportingBanner ReportingFoundation Foundation

Dan HaugDan HaugAccount Executive

SE Public Sector & Higher Education

Copyright 2007, Information Builders. Slide 2

New Public Sector & Higher Ed Team

Dan Haug – Public Sector Account Executive – Daniel_Haug@ibi.com or (407) 221-7354

Ellen Osbourne – Public Sector Account Executive – Ellen_Osbourne@ibi.com or (919) 754-0133

Jeff Humphries – Public Sector Technical Manager – Jeffrey_Humphries@ibi.com or (678) 595-3333

Donna Hipp – Public Sector Sales Engineer – Donna_Hipp@ibi.com or (678) 595-3333

Copyright 2007, Information Builders. Slide 3

WebFOCUS for WebFOCUS for SunGard HE BannerSunGard HE Banner

Our Typical Pitch…Our Typical Pitch…

Copyright 2007, Information Builders. Slide 4

WebFOCUS Provides Reporting Capability Here

How Does WebFOCUS Supplement Banner?SunGard HE Reporting Maturity Model

Level 1 Level 2 Level 4 Level 5

BaselineBaseline ReportsReports

CustomCustomReportsReports

Self-ServiceSelf-ServiceReportingReporting

•Ad-HocAd-Hoc

AnalyticalAnalyticalReportingReporting

•Historical TrendsHistorical Trends•ForecastingForecasting

InstitutionalInstitutionalPerformancePerformanceManagementManagement

•Process ImprovementProcess Improvement•Dashboard/ScorecardDashboard/Scorecard•Analytical Analytical ApplicationsApplications

Level 3

Copyright 2007, Information Builders. Slide 5

BannerTables

Object Access

CRMSystems

Legacy Data

StudentID Card system

Management

Employees

Partners

Customers

Direct Drill-Throughfor Detail

EDW

ODS

Zero Latency, Real Time Access

Banner

Approaches to Data Access

Copyright 2007, Information Builders. Slide 6

Turns Data Into InformationTurns Data Into Information

WebFOCUS Business Intelligence PlatformOne Platform For All Users and Applications

Meets the Needs of the Entire Campus

BANNERODSEDW

OracleSQL Server

ExcelAccess

Legacy &Historical

Data

Data MartsWarehouse

CubesWeb Services

StudentsParentsAlumni

VendorsBusiness

UsersAnalysts

Management PowerUsers

Developers

BUSINESS INTELLIGENCE PLATFORM

Copyright 2007, Information Builders. Slide 8

This is Great…This is Great…But Our Customers Need But Our Customers Need

a Solution – Not a Tool!a Solution – Not a Tool!

Copyright 2007, Information Builders. Slide 9

Copyright 2007, Information Builders. Slide 10

BI Center of Excellence: A partnership between IBI and FAU

Benefits: Establishing a COE that defines BI

standards to support FAU’s goals for information management

Beta test site for new WebFOCUS releases

Input on new product development for higher education solutions

Single, common user interface Best practices model that will pay

dividends in future BI projects by FAU departmental and technical staff

Integrated business intelligence throughout all departments

Copyright 2007, Information Builders. Slide 11

FAU Dedicated Resource to WebFOCUS

Carol Sashi

Business Intelligence Technology Services (BITS) sashi@fau.edu (561) 297-3156

Florida Atlantic University 777 Glades Road Building CM Room 195 Boca Raton, FL 33431-0991

Copyright 2007, Information Builders. Slide 12

Copyright 2007, Information Builders. Slide 13

Joint Strategy Sessions

IBI and Carol Scheduled Interviews with End Users from Various Departments Across the Campus to Collect Reporting Requirements

Leveraged ODS Handbook – Chapter 4 – Outlining Recommended Report Templates

Copyright 2007, Information Builders. Slide 14

Banner Reporting Foundation

The WebFOCUS Reporting Foundations for ODS & Banner give you a jumpstart for these modules: Student Finance Human Resources

A complete end user reporting solution A single dynamic dashboard for all departments Customizable tabs with common look & feel for all

reporting templates Security that leverages the Banner ID

Copyright 2007, Information Builders. Slide 15

Copyright 2007, Information Builders. Slide 16

SecuritySecurity

Copyright 2007, Information Builders. Slide 17

Banner Reporting Foundation Security

Access to the Dashboard Oracle DBMS Security

Access to Tabs Can Only See Contents of

Tab if Permitted to See Template(s) Assigned to Tab

Access to Template Set by Developer

PublicHiddenNamed UserBanner Object

Copyright 2007, Information Builders. Slide 18

ODS Metadata TabODS Metadata Tab

Copyright 2007, Information Builders. Slide 19

Copyright 2007, Information Builders. Slide 20

Copyright 2007, Information Builders. Slide 21

Copyright 2007, Information Builders. Slide 22

Student TabStudent Tab

Copyright 2007, Information Builders. Slide 23

Student Tab

The Reporting Foundation for Banner Student includes reporting templates such as:

Admissions statistics Enrollment reports Registration details Publication-quality enrollment summary Non-zero balance report for accounts receivable

Copyright 2007, Information Builders. Slide 24

Copyright 2007, Information Builders. Slide 25

Copyright 2007, Information Builders. Slide 26

Finance TabFinance Tab

Copyright 2007, Information Builders. Slide 27

Finance Tab

The Reporting Foundation for Banner Finance includes reporting templates such as:

Budget reports General ledger Operating ledger Balance Sheet Grants

Copyright 2007, Information Builders. Slide 28

Copyright 2007, Information Builders. Slide 29

Copyright 2007, Information Builders. Slide 30

Human ResourcesHuman ResourcesTabTab

Copyright 2007, Information Builders. Slide 31

Human Resources Tab

The Reporting Foundation for Banner HR includes reporting templates such as:

Employee Position Statistics Benefit Deductions Terminations Equal Employment Opportunity (EEO) report Appraisals

Copyright 2007, Information Builders. Slide 32

Copyright 2007, Information Builders. Slide 33

Other TemplatesOther Templates

Copyright 2007, Information Builders. Slide 34

Copyright 2007, Information Builders. Slide 35

Copyright 2007, Information Builders. Slide 36

Ok… How Do YouOk… How Do YouBuild Them?Build Them?

Report Template Report Template GeneratorGenerator

Copyright 2007, Information Builders. Slide 37

Copyright 2007, Information Builders. Slide 38

Copyright 2007, Information Builders. Slide 39

Copyright 2007, Information Builders. Slide 40

Copyright 2007, Information Builders. Slide 41

Copyright 2007, Information Builders. Slide 42

Copyright 2007, Information Builders. Slide 43

Copyright 2007, Information Builders. Slide 44

Report Template Generator

Copyright 2007, Information Builders. Slide 45

Copyright 2007, Information Builders. Slide 46

Public DashboardPublic Dashboard

Copyright 2007, Information Builders. Slide 47

Copyright 2007, Information Builders. Slide 48

Copyright 2007, Information Builders. Slide 49

Summary

The WebFOCUS Reporting Foundation for ODS & Banner gives you a jumpstart for these modules:

Student Finance Human Resources

Dynamic dashboard reporting, featuring templates that leverage Banner security

The equation for success: Dynamic sorts Drilldown reporting Easy navigation Quick installation+ Zero training  --------------------------------------------------------------- TIME SAVINGS FOR FUNCTIONAL USERS!

Copyright 2007, Information Builders. Slide 50

So Who Wants It??So Who Wants It??

top related