ࡱ> JI+( h/ 0DTimes New Roman()bbv 0b( 0DMonotype Sorts()bbv 0b( 0ff .  @n?" dd@  @@`` 0%J     c $ 4[CYLaUinf*Q@8y g46d6dv 0bppp@ <4!d!d` 0b*b<4dddd` 0b*buʚ;2Nʚ;:2___PPT9/ 0? %c&"Task Force on Reporting Strategies#"<Information SourcesHUEG PAG Membership 2002-2003 (Reporting and Student) HUEG 2002/2003 Reporting and Analysis Track  Student Emphasis Colleagues b6? 6 ? Information SourcestUniversity of Wisconsin (Kathy Luker, Consultant in the Office of Quality Improvement) College of Lake County (Nancy McNerney, Asst VP for Institution Effectiveness and Planning) Trinity College (Gwen Stengel, Technology Solutions Specialist) University of Alberta (Bill Cairns, Dir Information Development) Indiana University (Cheryl Stine, Office of VP Information Tec) >QLInformation SourcesUniversity of Kansas (Ryan Cherland, Dir of Univ Information Management/Assoc Dir of Inst Research) University of Minnesota (Shelly Diers, Assoc Dir Information Solutions) PAG link to shared data models http://www.trincoll.edu/~gstengel/t SNUniversity of WisconsinLive with SA for three years, first PS package and began at Madison campus Early adapter, thought PS would come with reports, wrong Query tool wasn t a solution, couldn t run against production systemUniversity of WisconsinPrior to PS had 10 years of experience with data warehouse First year live in PS, didn t have any reports After first year, redesigned warehouse views to PS structure, populated with PS data End user committee developed and enhanced views to meet user needs University of WisconsinNow have developed web site distribution of data info based on security Brioquery and MicroSoft Access Next project, retention data views back to 1985 Wish list of data view projects Quote   PeopleSoft is a transaction system, not a reporting system >H  a 2 College of Lake County*Live with SA since 2000 Restricted by budget, no reporting plan, community college Quote   If we can t get the students into the system, no use trying to count Created huge extract files (200 data items per student) Used SPSS as tool to get data out, good for 90% of reports  College of Lake CountyZPeopleSoft product  RDS  same as extract file, no history data, cost, some problems, not supported by PS DePaul, Minnesota and Cornell have had success with data warehouse  Trinity CollegeUses Cognos reporting tool, see session at the HUEG TCDART  Trinity College Data Analysis Reporting Tool Cognos PowerPlay module also used at Northwestern and Georgetown More information at http://tcdart.trincoll.edu b_LUniversity of AlbertaToo complex to report from Peoplesoft, 6,000+ tables, transaction system Decided to separate data for reporting from the base system Purchased PeopleSoft s Reporting Data Service (RDS) and the Operational Data Store as well as other packages, ninth institution to purchase them Due to budget constraints, have not progressed very far with RDS , j  University of AlbertaCurrently using Cognos DecisionStream as the ETL tool (extraction-transformation-loading) to populate their data mart Using Cognos PowerPlay and Impromptu for web and desktop clients Recommends Cognos, but also thinks Brio is goodbW 6  University of AlbertaPeopleSoft is moving toward a solution, new Enterprise Performance Management, now called Enterprise Data Warehouse Quote   we need to free the data from the shackles of the OLTP systems so that we can play with it   Indiana UniversityOnly Admissions in production, using Oracle pl/spl scripts to build tables for reporting Tables are also available for data extracts via an IU written web application Recently purchased PeopleSoft RDS, installing next month Will use RDS tables as their data warehouse reporting tables, adding their own security and customizations Will continue to use SQR for reporting tool until can purchase ad-hoc reporting tool ,/  University of KansasCurrently live with Admissions, student records going live in March, 8.0 Legacy used DEMIS (Department Executive Management Information System) DEMIS system has web front end with datamarts underneath HR and Finance have moved to datamarts , (  University of Kansas"For student, purchased PS RDS, gives a good start to creating datamarts Will continue to use DEMIS for web front end and reporting, extracting with RDS Using RDS structure, will add column for census data and rebuild historical information, don t need to reinvent structure> University of KansasPeopleSoft RDS - $120,000, Cognos DecisionStream - $20,000, hardware, installation time three weeks, and have to do customizations RDS is a good start, saves time, but your cost is buying the mapping,  gets the job done $ University of Minnesota+http://dw.umn.edu/ Home grown web interface!0Summary observations%Reporting should not be done against the production instance, nor against a copy if at all possible A datamart or data warehouse has been the route of choice for successful institution reporting Web interfaces for distributed reporting PeopleSoft RDS for possible mapping assistance, but costs,f } / Questions?     ` 333WcL+᷷Ҫ` 333WcL+᷷Ҫ` 999>?" dd@2?l2d@ " d@ ` n?" dd@   @@``@n?" dd@  @@``PR    @ ` ` p>> ~v(    s *a   T Click to edit Master title style! !   c $c   RClick to edit Master text styles Second level Third level Fourth level Fifth level!     S  c $h ``  ^* 2  c $n `   `*(2  c $r `   `*(2B  ZD8cjB  s *Ui޽h ? 333WcL+Ҫ  Serene  ` )(      B CE,F    : C  @   `8j   s *D5 p 5 T Click to edit Master title style! !  c $PG5  `   5 W#Click to edit Master subtitle style$ $  c $K5 `` 5 ^* 2Wc  c $O5 `  5 `*(2Wc  c $S5 `  5 `*(2WcB  s *Ui޽h ? 333WcL+Ҫ  g_ L(  Lr L S     L 0 X  y3February 6, 2003 Student Administration Laura Stoll*48P23jB L BDԔB L s *Ui޽h ? 333WcL+Ҫ  0 $(  r   S 3   r   S L4I   B  s *Ui޽h ? 333WcL+Ҫ  @( c@@K@ l  C 8   r  S P9  H  0޽h ? 333WcL+Ҫ  P(  l  C  @   l  C \F  H  0޽h ? 333WcL+Ҫ  `(  l  C J   l  C R  H  0޽h ? 333WcL+Ҫ  p (   l  C ,X   l  C X  H  0޽h ? 333WcL+Ҫ  `(  `l ` C 0]   l ` C ]  H ` 0޽h ? 333WcL+Ҫ  $(  $l $ C \b   l $ C c  H $ 0޽h ? 333WcL+Ҫ  ((  (l ( C `g   l ( C h  H ( 0޽h ? 333WcL+Ҫ  ,(  ,l , C p<   l , C m  H , 0޽h ? 333WcL+Ҫ  x(  xl x C 4q   l x C q  H x 0޽h ? 333WcL+Ҫ  0(  0l 0 C Py   l 0 C  z  H 0 0޽h ? 333WcL+Ҫ  4(  4l 4 C T~   l 4 C   H 4 0޽h ? 333WcL+Ҫ  8(  8l 8 C    l 8 C d  H 8 0޽h ? 333WcL+Ҫ  @(  @l @ C    l @ C h  H @ 0޽h ? 333WcL+Ҫ  D(  Dl D C    l D C d  H D 0޽h ? 333WcL+Ҫ   (  l  C    l  C   H  0޽h ? 333WcL+Ҫ  0(  l  C \   l  C   H  0޽h ? 333WcL+Ҫ  @(  l  C    l  C t  H  0޽h ? 333WcL+Ҫ^  Pl( @r@ ll l C  0   B l s *Ui޽h ? 333WcL+Ҫrp0+4h=N?CDHJtL4PRSUW: F4_PTNY4At[T] ` Oh+'0 px $ D P \ ht|Gonzaga University vs. Doe Laura StollLC:\Program Files\Microsoft Office\Templates\Presentation Designs\SERENE.POT Laura Stoll36rMicrosoft PowerPointoso@Oߨy@PyJQ@#@䞨GLg  (& &&#TNPP2OMi & TNPP &&TNPP    Ui- "-- !-- "---)yPP-- - @Times New Roman- .2 Task Force on 1$'-'$$'(. .2 Task Force on 1$'-'$$'(. .%2 Reporting Strategies5$(')',$$'$. .%2 Reporting Strategies5$(')',$$'$.--yP-- @Times New Roman- .2 February 6, 2003    . .2 February 6, 2003    . .(2 ^Student Administration   . .(2 ]Student Administration   . .2  Laura Stoll  . .2  Laura Stoll  .&:<U-- $FFFJvJvF $OHF@>HFQ $nHvQHv@--&--"System-&TNPP & ՜.+,0    GOn-screen ShowuUMR6aX Times New RomanMonotype SortsSerene#Task Force on Reporting StrategiesInformation SourcesInformation SourcesInformation SourcesUniversity of WisconsinUniversity of WisconsinUniversity of WisconsinCollege of Lake CountyCollege of Lake CountyTrinity CollegeUniversity of AlbertaUniversity of AlbertaUniversity of AlbertaIndiana UniversityUniversity of KansasUniversity of KansasUniversity of KansasUniversity of MinnesotaSummary observations Questions?  Fonts UsedDesign Template Slide Titles#_a 5Laura StollLaura Stoll  !"#$%&'()*+,-./02345678:;<=>?@BCDEFGHKRoot EntrydO)Current UserASummaryInformation(1PowerPoint Document(6aDocumentSummaryInformation89