From DataExpress to Actuate

1
FromDataExpresstoActuate
2
The DataExpress PictureNOW

• Each college has its own DataExpress catalog
  stored in the GEN group/Pnnn account.

• Colleges cannot access each others DataExpress
  catalogs.

3
The DataExpress PictureNOW
4
The DataExpress PictureNOW

• A single DataExpress catalog contains hundreds or
  thousands of procedures.

• As of December 1, 2003 there are 21,709
  DataExpress procedures system-wide.

5
The DataExpress PictureNOW

• Many procedures in a single catalog are similar
  in data structure with minor differences. For
  example, a class roster with Room Number or a
  class roster with Student Address.

• Similarly, DataExpress procedures at one college
  are much the same as DataExpress procedures at
  other colleges.

6
D a t a E x p r e s s P r o c e d u r e s
The DataExpress PictureNOW
Grade Course-Title
Room-Loc
Stu-Address
Start-Time
7
The Actuate PictureFUTURE

• Colleges will share a larger central repository
  of reports from which to meet their ad hoc query
  needs.

• Colleges can access each others queries and
  reports if posted publicly.

• Duplication of effort is expected to be reduced
  dramatically across the system.

8
A c t u a t e V i ews
The Actuate PictureFUTURE
CENTRAL REPOSITORY
ROSTER Info Object Item-Num Course-ID Instr-Name
Stu-Name SID
Start-Time
Room-Loc
Stu-Address
Grade
Course-Title
9
The Actuate PictureFUTURE
10
How Do We Get There?

• Step 1 Eliminate from consideration DX
  procedures not used from July to December unless
  college identified as quarterly or annual report.
  

• Step 2 Set aside Financial Aid related DX
  procedures for later consideration (due to
  changes in FAS).

• Step 3 Set aside DX procedures accessing
  dictionary defined KSAM/MPE files as these files
  must first be redeveloped.

• Step 4 Set aside procedures accessing user
  created files (commonly referred to as
  multi-pass). This will require a more complex and
  individual review.

• Step 5 Compress remaining 12,000/- DataExpress
  data structures into common views prioritized by
  system-wide usage. Result is 3,077 data
  structure views.

11
UPDATE
12
Timelines

• July, 2003 Approximately 120,000/- DX
  procedures system-wide.

• August, 2003 Colleges identify used
  procedures and reduce number to 19,599.

• November, 2003 CIS takes snapshot of DX
  procedures system-wide. Total count 21,709.

• December, 2003 After initial analysis 3,077
  common views are found.

• December, 2003 CIS and Train the Trainers
  receive Actuate development training.

• December, 2003 Redesign and development begins.

13
Timelines (approximate)

• February, 2004 (ITC Meeting) Develop a
  system-wide Actuate training plan.

• March-April, 2004 Sample Actuate Reports
  available for Colleges to view.

• May, 2004 Train the Trainer 2 group gets end
  user Actuate Training.

• ?, 2004 Actuate Training begins for college
  staff.

• June, 2004 Phase 1B sample database is ready
  for colleges to use and begin developing their
  own Actuate queries.

• April-June, 2005 Implementation!

14
College Input

• How do we categorize groups of trainees?
• Expert perhaps needing development licenses and
  training.
• Power User needs to get to a large and varied
  amount of data and provide output in creative
  ways.
• Frequent User uses database reporting tools
  daily, but generally ok with canned reports.
• Basic User a once-in-a-while report writing
  visitor that just needs the bare minimum
  exposure.

• Other??