DATA WAREHOUSE STUDENT DATA CLASS

1

• UCSD DATA WAREHOUSE OVERVIEW
• FORUM
• October 2002

University of California, San Diego Administrative
Computing and Telecommunications Data Warehouse
Team
2
Topics

• What is the Data Warehouse ?
• Why a Data Warehouse ?
• Who uses the data?
• How does the data get there?
• What data is available ?
• What about data security ?
• How do I access the data ?
• How do I find the data I need ?
• How can I learn more ?
• What does the future hold ?

3
What is the Data Warehouse?
DATA WAREHOUSE

• A read-only copy of the data in IFIS, ISIS, PPS
  
• Some departmental data is available
• Equipment Asset Management Systems
• OCGA
• Budget and Staffing
• Available to campus personnel with security
  access
• Contains historical data

4
What is the Data Warehouse?
DATA WAREHOUSE

• Used for..
• Departmental reporting
• Supplying data to the Link Family applications
• Decision support
• Populating departmental Data-Marts
• The Data Warehouse is the data, NOT the client
  tool or browser !

5
Why a Data Warehouse ?

• Departmental routine reporting needs
• Additional Ad hoc reporting
• Single reliable source of data
• Historical data otherwise not available
• Data transfer directly to your PC
• Local printing

6
Who uses the data?

• WHO HOW
• Administrative Clients The Link Family
• Dept Programmers Paradox, Access
• Decision Makers SQL Executer
• All campus QueryLink

7
How does the data get there?
IFIS ISIS PPS
DEPARTMENTAL DATA
CAMPUS SYSTEMS
DATA WAREHOUSE
UCSD DATA WAREHOUSE
8
What data is available ?
9
What data is available ?
10
What data is available ?
11
What about security ?

• Review security access with your DSA
  (departmental security administrator.)
• Financial data has very few security issues.
• Employee and Student data are more sensitive
  and have more areas that are restricted.

12
How do I access the data?

• Any Faculty or Staff with a business need
• Internet connectivity
• Data Warehouse or Mainframe account
• Departmental Security Administrator
• Access to the data is free

13
How do I access the data ?

• SQL Tools
• SQL Executer
• QueryLink
• - Client tools
• (Excel, Access,
• Brio, etc.)

UCSD Data Warehouse
14
SQL Executer

• Submits ad hoc SQL Queries
• Requires knowledge of subject data
• Requires knowing SQL to construct Queries
• Resides on the Web
• Where do I find it? On the internet link to...
• datalink.ucsd.edu or datalink or from
  Blink link to the Link Family. Click on the
  SQL Executerbutton.

15
QueryLink

• Point and click application
• Submit customized Queries
• Requires knowledge of subject data
• Does not require knowing SQL
• Resides on the Web
• Where do I find it? On the internet link to...
• datalink.ucsd.edu or datalink or from
  Blink link to the LinkFamily. Click on the
  Queries button.

16
How do I find what I need ?
http//datalink.ucsd.edu
DataLink

• Browse Data Models
• Locate Data
• Table and Column name descriptions
• Identify Relationships between Data
• Search Tool
• Standard Query Library
• SQL Executer QueryLink
• Display Refresh Data

17
How can I learn more ?

• Data Warehouse Web Resources
• Datalink Home Page
• (http//datalink.ucsd.edu)
• FORUM Presentations
• SHARECASE
• Data Warehouse Training
• ACT Help Desk (x41853)

18

How can I learn more ?
Data Warehouse Training

• Torrey Pines South - room 440
• Instructor led (Data Warehouse Team)
• Slide presentation
• Workbooks
• Step by Step instruction
• Enroll through Staff Education
• For course schedule and enrollment please go to
  Blink to link to Enrollment Central.

19
How can I learn more ?
Classes

• SQL Executer
• SQL Basics (prerequisite)
• Student Data
• QueryLink
• Employee
• Financial
• Student

20
How can I learn more ?
Focus

• Data and how it relates
• DataLink as a data resource
• SQL and QueriesSQL Executer hands-on
  exercises
• construct queries
• execute queries
• tips and hints
• Subject data classes oriented toward
  specific subject data.

21
Whats in the future ?

• Increase Client Involvement
• Improved Data Descriptions by client experts
• New and Enhanced Query Models in QueryLink
• More Data and Additional Databases
• Overdraft Reporting
• Purchasing
• Summary Data
• Archiving
• Increase Data Code Definitions
• Cross referencing data locations/descriptions

22
QUESTIONS ANSWERS
http//datalink.ucsd.edu Lori Barry ext.
48830 Barbara Connolly ext. 49777 Sandra
Duckett ext. 24076 Linda Piercy ext.
41007 Mary Wittemann ext. 23308 May Xu ext.
49771