A Easier Road to Useful Information

1
A Easier Road to Useful Information

• August 11, 2003

2
Who am I?

• Kathy Luker - Office of Quality Improvement
• Project Coordinator

3
Agenda

• Why a Query Library?
• End-User Driven Query Development
• End-User Driven Data View Development
• Roll-out across the Enterprise
• (UW-System)
• Question/Answer

4
Why a Query Library?

• The Problem
• The Opportunity
• The Solution
• Concept
• Issues
• Infrastructure
• Human
• Technical
• Query Library Tour

5
The Problem

• We had no reports!
• Legacy Student Administration System was gone
• 4000 reports
• Developed / paid for over 20 years
• New Student Administration System
• No delivered reports
• No viable reporting mechanism
• We had (almost) no budget!

6
The Opportunity

• Effect End-User Driven Reporting
• Culture Change
• From
• Centrally-generated reports
• School/College reporting silos
• To
• End-User responsibility model
• School/College cooperation

7
The Concept

• Leverage Existing Resources
• Data Warehouse Infrastructure
• End-User Query Development
• Generalize Queries
• Distribute Queries to the Masses

8
Query Development Process

• Identification
• Categorization
• Prioritization
• New Reports, Change Requests
• Specification
• Content, Organization
• Development
• Review / Approval
• Inclusion

9
Query Library - the Human Infrastructure
Categorization
Query Library Committee
Prioritization
Standards Development/Review
Release Decision
Vision
Drive
Coordination
Facilitation
Identification
Specification
Development
Review
DoIT
Technical Support
Documentation
Academic Units
10
Data View Development Process
11
Data View Development Process

• Functional Requirements Process
  http//axle.doit.wisc.edu/rwl/DNCHome.html
• Data Dictionary http//substitute.doit.wisc.edu/i
  a/home.cfm

12
Process Overview
Query
Catalog
Web Browser
Query
Student
Human Resource
Financial
Student
Web Browser
Query
Human Resource
Financial
Campus Network
13
Query Library
Card Catalog
Your Computer
Help Documents
Query
Brio Insight
Web Browser
Brio On-Demand Server
SQLNET
Query Repository
Brio Insight
Data Warehouse
SQLNET
Oracle Data Views
14
Tour of Query Library

• Library

15
Agenda

• End-User Driven Query Development
• What does an end-user look like?
• What do useful reports look like?

16
What do I need to know to do my job?

• Timetable audits for planning and pre-publication
• Course enrollments daily and historical
• Course Administration
• Course rosters email addresses
• Course profiles who are my students?
• Grade distributions
• Who are our majors?
• How do I contact Chemistry alumni?
• Individual student advising information
• Curriculum input - student performance/scheduling

17
Using Student Data

• Lists of prospects mailing labels, advisees,
  course rosters, majors
• Pivots enrollment updates, college level
  summaries
• Charts Course profiles, grade distributions,
  Historical trends
• Planning, modeling, improve business practices
• Dashboards/analytics

18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
(No Transcript)
23
(No Transcript)
24
List Reports

• Chemistry majors
• Applicants for Special programs/courses
• Mailing labels
• Course rosters for Profs TAs
• Honors students
• Students on probation
• Advisees, Alumni, Special Groups

25
(No Transcript)
26
(No Transcript)
27
(No Transcript)
28
(No Transcript)
29
(No Transcript)
30
(No Transcript)
31
Pivot Reports

• Close-out reports
• By course
• By department
• Enrollment Updates
• Summary counts by category
• Advisees by Advisor
• Admission Updates
• SOAR Attendees/Anticipated

32
(No Transcript)
33
(No Transcript)
34
(No Transcript)
35
(No Transcript)
36
(No Transcript)
37
Chart Reports

• Current Courses
• Course Profiles
• Grade Distributions
• Historical Trends
• Grade Inflation
• Enrollment Trends
• Minority retention
• Staffing levels

38
(No Transcript)
39
(No Transcript)
40
(No Transcript)
41
(No Transcript)
42
(No Transcript)
43
Grade Inflation??

• By Course
• By Instructor
• By Department
• Guidelines for new faculty

44
Grade Distribution by Course
45
Grade Distribution History for Several Courses
46
GPA by Department 10 year study
47
Degree History by Department
48
UW Undergrad Enrollment in Chemistry
49
Improving Business Practices

• TA Evaluation Review
• Readily available advising profile
• Academic overview
• Demographic/individual background
• Actions probation, holds, etc.
• Special groups athletics, honors
• Advisor name review

50
(No Transcript)
51
(No Transcript)
52
Planning vs Reacting

• Getting ready for next years cohort
• Curriculum development incorporating
• Student prior course history
• With respect to course schedule
• Performance vs student attributes

53
New Freshman Attribute Comparisons
54
(No Transcript)
55
(No Transcript)
56
(No Transcript)
57
(No Transcript)
58
Intro Chemistry Advising RubricChem 109
Performance (GPA)
59
Credits to Graduation - UGRAD
60
Dashboards

• Summarize data for decision makers
• Highlight out-of-range data
• Ease of use and customization
• High-level overview drill-down capabilities
• Up-to-date analytic capability

61
Summary

• Much (student) data is available
• BrioQuery presents simple user interface
• Sub-query or Multi-query results in single report
• Multi charts in single report
• IES interactive reports
• Brio Insight available across campus as web
  plug-in
• Query Library makes it easy for everyone to
• Utilize validated query
• Employ sophisticated query without high learning
  curve
• Queries are generalized for their unit
• Business Intelligence approach works.
  . in academic environments

62
Project Agenda

• Roll-out across the Enterprise
• (UW-System)
• FASTAR
• Brio 6.6 implementation for 13 UW campuses
• Home of UW-System Query Library
• Training Issues

63
Agenda

• Question/Answer

64
For more info.

• Kathy Luker project management
• kluker_at_mail.bascom.wisc.edu
• Gery Essenmacher department examples
• essenmacher_at_chem.wisc.edu
• Query Library
• http//wiscinfo.doit.wisc.edu/querylibrary/

65
Other key members at UW-Madison

• Ellen Jacobson LS Sociology Department
• Query Authors
• Bill Olson and Colleen Morshauser - DoIT
• Query Technical Design
• Scott Manley, Pam Allen and Kay Steiner - DoIT
• Data Warehouse Management
• David Hart UW System
• Technical Coordination
• Randy Lambrecht
• Brio Consultant

66
Perspective

• Reactive approach to using data
• You can observe a lot by watching
• Proactive approach to using data
• If you dont know where youre going, you might
  not get there