archive-edu.com » EDU » A » ANDREWS.EDU

Total: 45

Choose link from "Titles, links and description words view":

Or switch to "Titles and links view".
  • David Heise: Leadership, Data Warehousing, courses on MIS, IT Management
    my GuestBook or send me Subscribe to changes in Directory of Data Warehousing in Higher Education View My Stats Visitors since 23 Jun 1997 The views and opinions expressed in these pages are strictly my own Andrews University in no

    Original URL path: http://dheise.andrews.edu/ (2013-06-13)
    Open archived version from archive

  • Data Warehousing at Andrews University
    Warehousing in Higher Education Regenerate the directory Andrews University The Data Warehouse Committees DW Steering Committee Minutes Key Performance Indicators Papers Presentations What is Data Warehousing Data Warehousing Dictionary Data Warehouse Elements to Evaluate TDWI Project Charter Framework TDWI Methodology Outline SCT Summit 99 Presentation PowerPoint Avondale College Data Warehouse Project Presentation on Avondale College Project PowerPoint Citations Data Warehousing The Ultimate Gudie to Corporate Business Intelligence p33 Listing of

    Original URL path: http://dheise.andrews.edu/dw/index.htm (2013-06-13)
    Open archived version from archive

  • Classes I have taught
    Systems Avondale College MT216 Sem 1 2007 Management Information Systems Avondale College CPTR561 Fall 2002 Group Programming Project I BSAD556 Fall 2002 Management Information Systems Trinidad CPTR562 Spring 2002 Group Programming Project II CPTR561 Fall 2001 Group Programming Project I BSAD556 Summer 2001 Management Information Systems Taiwan CPTR562 Spring 2001 Group Programming Project II CPTR561 Fall 2000 Group Programming Project I BSAD556 October 2000 Management Information Systems Trinidad CPTR562 Spring

    Original URL path: http://dheise.andrews.edu/courses/index.htm (2013-06-13)
    Open archived version from archive

  • David's Guestbook Input Form
    in bold are required First Name Last Name Email Address Note A confirmation email will be sent to this address You must respond before your entry will be recorded URL City State Country Comments Preview entry No preview View current

    Original URL path: http://dheise.andrews.edu/code/gbform.asp (2013-06-13)
    Open archived version from archive

  • Collapsible Bookmarks
    Paddle http www kayaksydney com au maxpages Bridge Paddle the great outdoors Ton O Fun Welcome Turon Gates Accommodation Capertee NSW Australia HumorStories Ant and contact lens an inspirational rock climbing story Unproven Computer Stupidities Father s Love Letter Main Page Ogling Breasts Makes Men Live Longer The Dilbert Zone The Road Less Traveled Milk Change Growth Quotes Change Growth Quotations Change Growth Sayings Wisdom Quotes NetworkForChange Miscellaneous Anne McCaffrey s Pern BarnesandNoble com The World s Largest Bookseller Online Common Errors in English Computer Virus Myths home page David Heise Studying Social Interaction Digital Daily Welcome IRS Edvin Tela Telephone Ron Vyhmeister s home page Ryan Heise US State Department Services Consular Affairs Lottery Welcome to Amazon com Books Earth s Biggest Bookstore Multimedia Groups of happybirthday MIDI pages MP3 com Classical Princess Saturn s Midi Homepage Non Anime page RealPlayer Home Page The Cyber Hymnal the midi world archive The SDA Digital Hymnal Music 4barsrest com brass band news information and shopping CLASSICAL MUSIC ARCHIVES CLASSICAL MUSIC CLASSICAL MUSIC ARCHIVES Handel Fanfare for Christmas Day SATB Sheet Music Free Christmas Sheet Music Christmas Carols Christmas Songs Free Music Directory Free sheet music directory free scores com God s Gospel Free Gospel MIDI New MIDIs Gospel MIDI Music Handel s Messiah MIDIs HNH Naxos Classicals http www angelfire com mo NeverKnowWhat ChristmasMidis html Hymnals Timeless Truths 168 Calvin Hymnary Project In A Monastery Garden at Musicroom com Sheet Music for Musicians Search Results mfiles free midi files to download classical original and other music styles mfiles free music files and notes Sheet Music MIDI and MP3 Michelle s Midi Archive Music Glossary M Tevfik Dorak Music Index Musicnotes com Mutopia Project partitions gratuites My Tribute CD New Christmas Music Old Time Gospel Midi Partitions gratuites pour trompette brass Praise and Worship Sheet Music Direct 100 Digital Sheet Music Sheet Music Plus Handel Search Results Sibelius Download Southern Ohio Music Company Brass Sheet Music The Maine Music Box The Silvis Woodshed The Woodshed Christmas Midi Files Trumpet Ensemble sheet music UR Research ESM Sibley Music Library UR Research Home Virginia Tech Multimedia Music Dictionary Virtual Sheet Music Classical Sheet Music Downloads Whisperings Solo Piano Radio You Raise Me Up video code video by Westlife VideoCodeZone com your source for music video codes ZEPHYR MUSIC Pty Ltd Printed Music Retailers Sydney Nature Australian Geographic Discovery Online Earth and Moon Viewer Fernwood Botanical Garden and Nature Preserve Harry s Practice on AOL7 Hitrax http www wrc wa gov au public waterfacts 6 algal blooms water facts6 pdf MtbREVIEW com Trail Reviews Orangatan Cleaner PBS Online St Joseph County Parks St Mary s Nature Trail Zootopia In Pursuit of the Perfect Zoo Real Estate Calculators Stamp Duty moneymanager com au Mt Cotton 101262379 Real Estate Australia Property for sale lease and rent online Australia wide realestate ninemsn com au Welcome to RealNet Recipes GMA Recipes Index from WCHS TV8 Veggies Unite Shells George s Seashells Underwater World Shopping Bing Lee Online Buy in Australia Compare prices Price Comparison Australia Discovery Online Shopping Welcome to NetBuyer SIRDS General questions PC Stereogram Generating Programs LIST Tax Guide Investing Property moneymanager com au Investment essentials Property Investment in Australia Maximise your investments in real estate and rental property TV sat receiver world com IDD CI44 Sensor Plus Software Settings und Patches für Humax 5400 und andere Digitalreceiver Strong Technologies Welcome to HUMAX Australia Welcome to IMSDUBAI Veggie Tales Welcome to BigIdea com Wedding Music Library Wedding Music Guide 3 0 WedAlert Wedding Songs Ceremony Australian Organ Donor Register Registration Caring For our Natural Resources Water Weeds found in NSW Wetlands Gloucester Shire Council Management info com IP Address to Latitude Longitude Maleny SHS Home Page Mount Gravatt High School Olympics The World of Croquet Leadership Mgmt Comps 2a Change International Schools Conference Dates Strategic Planning 0Columbia University Strategic Initiatives Program 0IU Information Technology Strategic Plan 0OIT Report Executive Budget Group Strategic IT Issues 1999 to 2004 0STRATEGIC PLAN Carnegie Mellon University Strategic Planning Process graphs Carnegie Mellon University Strategic Planning Process enTarga Strategic Planning Faith Popcorn s Website Institute for the Future Is Your Company Mistake Friendly Murdoch University Information Technology Strategic Plan Official Megatrends Web Site Index page for John Naisbitt and Patricia Aburdene Organized Change Decisions to Make Before Organizational Change Strategic Initiatives Strategic Planning Resources Management Consulting Net Links Strategy is for the Young The Meeting I Never Miss Welcome to the Hudson Institute Home Page Welcome Policies Information Technology Services Services Strategic Planning 5b Qualitative Research EDRM 605 Introduction to Qualitative Research Qualitative Research Shirley s Samples Qualitative Research U of Saskatchewan Qualitative Research WebQuest Research Methods Knowledge Base Shirley Freed Research Leadership SmartLeadership Developing the Smart Leader Within You Leadership in the 21st Century Articles by Margot Cairnes Leadership Research Center Wyncom Lessons in Leadership Advanced Statistics Experimental Design and Response Surface Methodology RSM Experimental Design and Taguchi Response surface methodology 6b ALPS Teaching for Understanding Home ALPS The Thinking Classroom Home Amazon com buying info Thinking Connections Learning to Think and Thinking to Learn Business Thinking Meta Model Challenging the tactical intelligence of the gifted Creating a Culture of Thinking by David Perkins Dispositional Aspects of Intelligence Dispositional side III Feeling Tones GA002 Chapter 11 Thinking and Perception HGSE Faculty Profiles Faculty Profile HGSE News Breakthrough Thinking and the Eureka Effect An Interview with Professor David Perkins http hea www harvard edu ECT Inquiry inquiry2text html IT WS Project based Learning Readings Lessons in shaping intellectual character csmonitor com On Line Resources Project Zero Principal Investigators David Perkins Project Zero Principal Investigators Ron Ritchhart Project Zero Principal Investigators Shari Tishman Project Zero Research Projects Innovating with Intelligence Project Zero Research Projects Patterns of Thinking Project Zero Research Projects The Creative Classrooms Project Thinking Dispositions 6d Emotional Intelligence Emotional Intelligence EQ Emotional intelligence What you don t know may cost both you and your company Emotions and Emotional Intelligence EQ bn com Executive EQ Emotional Intelligence in Leadership and Organizations EQ

    Original URL path: http://dheise.andrews.edu/bookmarks/bookm1js.htm (2013-06-13)
    Open archived version from archive

  • Data Warehousing in Higher Education
    Date Last Updated Harvard University http www harvard edu Data Warehouse URL No non intranet available yet Subject Areas AD Development Advancement coming FI Accounts Payable OracleApps Budgeting OracleApps General Ledger OracleApps Purchasing OracleApps HR Human Resources PeopleSoft Payroll PeopleSoft ST Student Information OT Catering Services coming Grant Management Database Oracle 8 1 6 9 2 0 2 ETL Tool Informatica BCV of OraApps 10 7 NCA OLTP some custom ksh scripts w either imp exp or SQL Loader for legacy and limited denormalization PL SQL scripts Data Modeling Tool Oracle Designer MetaData Tool Oracle Designer Query Tool Standard Oracle Reports Brio Query custom web front end Ad Hoc Brio Query Powerbuilder InfoMaker 6 0 7 0 some Access Paradox other Oracle8 native Schema Type Financials ODS actually OLTP clone via BCV HR ODS Financials star schema Server OS Solaris Contacts Bill Brickman HDW Data Administrator 617 496 8471 bill brickman at harvard edu Ian Wall HDW Practice Manager 617 495 1061 ian wall at harvard edu Other Comments Future initiatives to be based primarily on Informatica as ETL Brio as Query Tool 9i as RDBMS Date Last Updated 6 Feb 2012 6 32 43 AM Indiana University http www indiana edu Data Warehouse URL http www indiana edu dss Subject Areas AC Course in progress Library Student Credit Hours in progress EN Admissions Enrollment in progress Recruiting in progress Student Profiles in progress FA Financial Aid in progress FI Finance HR Human Resources Payroll ST Student in progress Database Oracle 9 2 03 ETL Tool Informatica Data Modeling Tool Combination of tools MetaData Tool Combination of tools Query Tool We have developed a web based enterprise reporting application known as Indiana University s Information Environment IUIE This application allows for viewing of frozen formatted reports selecting sections of frozen reports for viewing extraction of raw data from the underlying Data Warehouse execution of parameter driven queries written in SQR Schema Type Denormalized data structures beginning to develop dimensional models Server OS Unix running on an IBM SP Frame Contacts Rebecca Gribble Acting Manager Decision Support Services 812 855 7288 rgribble at indiana edu Other Comments Date Last Updated 9 Aug 2005 4 48 39 PM Indiana University Of Pennsylvania Data Warehouse URL Subject Areas AC Course Scheduling Student Credit Hours EN Enrollment FI General Ledger HR Human Resources Payroll ST Student Demographics Student Registration OT Facilities Property Space Utilization Database Oracle ETL Tool Data Modeling Tool MetaData Tool Query Tool MS Access Cognos Schema Type Server OS Solaris Contacts Bill Balint Technology Services Coordinator 724 357 7864 wsbalint at iup edu Dan Kuta Senior Database Administrator 724 357 2887 djkuta at iup edu Other Comments Date Last Updated 1 Nov 2004 7 42 54 AM Ithaca College http www ithaca edu Data Warehouse URL http vail ithaca edu argus Subject Areas AD Alumni We are using our BI portal primarily to post PDF docs Alumni Development Development Advancement FI Accounts Payable Budgeting General Ledger Purchasing HR Human Resources Database Oracle 8i ETL Tool Oracle Warehouse Builder Data Modeling Tool Oracle Designer MetaData Tool Query Tool Oracle Discoverer SQL Navigator Oracle Reports Schema Type Server OS Win NT 2000 Contacts Marco Cestaro Data Warehouse Administrator 607 274 1000 mcestaro at ithaca edu Other Comments Date Last Updated 15 Dec 2004 5 02 28 PM Jaypee Institute of information technology http jiit ac in Data Warehouse URL Subject Areas AC Research Database ETL Tool Data Modeling Tool MetaData Tool Query Tool Schema Type Server OS Contacts Monika Garg Garg Lecturer 0120 2400986 monika garg at jiit ac in Other Comments Date Last Updated 5 Sep 2005 4 09 31 AM Kasetsart University http www ku ac th Data Warehouse URL Subject Areas Database ETL Tool Data Modeling Tool MetaData Tool Query Tool Schema Type Server OS Contacts Other Comments Date Last Updated 26 Oct 2007 12 53 11 AM Kasetsart University http www ku ac th Data Warehouse URL Subject Areas Database ETL Tool Data Modeling Tool MetaData Tool Query Tool Schema Type Server OS Contacts Kalayaphat Udomsin kalayaphat at gmail com Other Comments Date Last Updated 26 Oct 2007 12 52 37 AM KCTCS Kentucky Community Technical College System http www kctcs edu Data Warehouse URL N A Subject Areas Database Oracle 11g RAC on OEL Oracle Enterprise Linux ETL Tool Cognos Data Manager Microsoft SQL Server 2000 RDM Websphere Ascential DataStage Oracle 11g RAC for the EPM data warehouse ODI Oracle Data Integrator Data Modeling Tool Microsoft Visio Pencil Paper MetaData Tool Ascential MetaStage ODI Oracle Data Integrator and or Excel Query Tool OBIEE 10g and OBIEE 11g suite BI Answers BI Interactive Dashboards BI Publisher and BI Briefing Books Oracle Discoverer PS Query Crystal nVision SQR MS Access Quest Toad for Oracle SAS SPSS Oracle SQL Developer Oracle SQL Plus Not necessary in this order Focus is using OBIEE for all reporting with DSS implementation and remove reporting from the OLTP systems Schema Type Denormalized tables Dimensional and Star Schema Server OS DB OEL Ascential Data Stage Windows Server OEL Cognos Data Manager Windows Server OEL Contacts Thomas Burgess Lead Administrative Systems Engineer 859 256 3228 Thomas Burgess at kctcs edu Jim Phillips System Director Information Management 859 256 3337 jim phillips at kctcs edu Other Comments o Decision Support System DSS Data Warehouse using Oracle 11g RAC OBIEE 10g moving to OBIEE 11g in 2012 Fusion Intelligence and PeopleSoft EPM as the data warehouse and SAS SPSS for statistical reporting By July 2012 we will be on EPM 9 1 EPM is delievered with Ascential DataStage ETL v7 5 and v8 5 which includes ETL jobs to load many source tables from CS HR and FS OLTP environments o Former reporting solution PeopleSoft RDM using SQL Server 2000 RDBMS Windows2003 Cognos Data Manager ETL Impromptu and Impromptu Web Reports IWR which we plan to de support by July 2012 with all RDM structures migrated into PeopleSoft EPM until the EPM Campus Solutions CSW matures over time Most former RDM reports are available within the OBIEE suite of tools o KCTCS includes 28 colleges with 60 campuses that operate in 16 seamless districts KCTCS enrolls 110 000 students in credit courses and touches nearly 500 000 people a year through credit and non credit education and training options KCTCS colleges change lives by providing accessible and affordable education and training through academic and technical associate degrees diploma and certificate programs in occupational fields pre baccalaureate education adult continuing and developmental education customized training for business and industry and distance learning Date Last Updated 20 Apr 2012 12 08 00 PM Loma Linda University http www llu edu Data Warehouse URL Subject Areas EN Admissions Enrollment Recruiting Student Profiles FA Financial Aid Database SQL Server ETL Tool Enterprise Manager Data Modeling Tool MetaData Tool Query Tool MS Reporting Services Schema Type Server OS Windows Contacts DP Harris Vice Chancellor for IS and CIO dpharris at llu edu Mike Scofield nmscofield at llu edu Other Comments Date Last Updated 30 Aug 2004 7 44 32 PM Lone Star College System www lonestar edu Data Warehouse URL Subject Areas AC Research Database ETL Tool Data Modeling Tool MetaData Tool Query Tool Schema Type Server OS Contacts Daniel Dean Sr Analyst daniel h dean at lonestar edu Siobhan Fleming Associate Vice Chancellor Research Institutiona sifleming at lonestar edu Other Comments Date Last Updated 14 Jan 2010 10 26 24 PM MIT http www mit edu Data Warehouse URL http web mit edu warehouse Subject Areas AC Awards FI Finance Purchasing HR Human Resources no payroll yet ST Student Information basic OT Keys Space Utilization Web Usage Database Oracle 7 3 4 ETL Tool Our own process Data Modeling Tool MetaData Tool Query Tool Brio Schema Type Star Schemas as much as possible Server OS Contacts Scott Thorne Data Warehouse Administrator 617 253 2978 thorne at mit edu Other Comments Date Last Updated Nevada System of Higher Education http system nevada edu Data Warehouse URL Subject Areas FI Finance HR Human Resources ST Student Information OT Campus Directory Database Oracle 10g ETL Tool cobol pl sql Data Modeling Tool Designer pencil and paper MetaData Tool Query Tool Custom interface Oracle Discoverer Schema Type Student star schema Human Resources star schema Financial denormalized ODS Server OS Unix Contacts Ginger Holladay Houston Director Information and Application Services Ginger at nshe nevada edu Other Comments Date Last Updated 23 May 2007 2 34 12 PM North Carolina Central University http web nccu edu index htm Data Warehouse URL http web nccu edu index htm Subject Areas AC Course In progress Curriculum Faculty Loads In progess Other Student Credit Hours AD Alumni Development in progress EN Admissions Admissions Graduate Admissions Undergraduate Enrollment Other Student Profiles FA Financial Aid in progress Other in progress FI Budgeting Phase III Other Phase III HR Human Resources Phase II Other Phase II ST Degrees Graduation Majors Other Student Student Demographics Student Information OT Facilities Property Phase IV Other Space Utilization Phase IV Database SAS and Oracle ETL Tool Custom SAS code SAS Warehouse Administrator Data Modeling Tool MetaData Tool SAS Data Warehouse Administrator Query Tool SAS MDDB Report Viewer custom applications written SAS Schema Type Extract files Server OS Windows 2000 Contacts Della Nicholson Data Warehouse Manager 530 7538 dnicholson at wpo nccu edu Other Comments Date Last Updated 7 Apr 2004 3 07 01 PM North Dakota University System http www nodak edu Data Warehouse URL None available yet Subject Areas FI Finance General Ledger Purchasing HR Human Resources Payroll ST Student Database Oracle 8i ETL Tool Flat file extracts from ADABAS using Natural and COBOL Transformation and load using Oracle Data Mart Suite Data Modeling Tool Designer component of Oracle Data Mart Suite MetaData Tool Designer component of Oracle Data Mart Suite Query Tool Oracle Express and SQL code Schema Type Star schema Oracle tables and fact tables Server OS Contacts Mike Pytlik 701 231 8119 Mick Pytlik at ndus nodak edu Other Comments Date Last Updated Northeastern University http www northeastern edu Data Warehouse URL N A Subject Areas EN Enrollment HR Human Resources some Database PeopleSoft DB2 UDB various legacy ETL Tool SQR code Data Modeling Tool SQR code MetaData Tool Query Tool BrioQuery 6 Schema Type It depends Server OS Contacts Dennis Noonan 617 373 4158 noonan at acs neu edu Other Comments Date Last Updated Ohio University http www ohiou edu Data Warehouse URL www ohiou edu datawarehouse Subject Areas EN Admissions FA Financial Aid ST Student Accounts Student Records Database Oracle 8 1 7 4 50 ETL Tool Cobol SQL Loader Data Modeling Tool none MetaData Tool none Query Tool SQL Access BrioQuery Crystal Reports Schema Type Extract files and some Star schemas Server OS IBM 390 MVS Contacts Laura Dalton Data Warehouse and Data Base Administrator 740 597 1881 daltonl at ohiou edu Other Comments Date Last Updated 15 Sep 2003 3 05 16 PM Oklahoma State University http www okstate edu Data Warehouse URL Internal use only Subject Areas FI Finance HR Human Resources ST Student Information Database DB2 MVS NT ETL Tool Cobol Focus and DPROPR Data Modeling Tool Homegrown MetaData Tool Homegrown Query Tool Web Focus MS Access Excel and other ODBC enabled tools Schema Type Extract Files and some Star Server OS MVS and NT Contacts Mike Kerntke 405 744 9314 asdxmhk at okstate edu Other Comments Date Last Updated 20 Nov 2000 12 00 00 AM Oregon State University http www orst edu Data Warehouse URL http www orst edu dept computing warehouse Subject Areas AD Public Relations FA Financial Aid FI Accounts Payable Finance HR Human Resources ST Student Database Oracle 9 ETL Tool Home grown processes Data Modeling Tool Paper Pencil and Hummingbird BI Admin MetaData Tool Query Tool Hummingbird BI Query Schema Type Quasi Relational Stars Snowflakes Extract Files or Star Schemas Server OS Compaq Open VMS Contacts Catherine Williams Central Computing Director 541 737 2718 Catherine Williams at oregonstate edu Other Comments Date Last Updated 15 Sep 2003 1 03 19 PM Penn State University http www psu edu Data Warehouse URL https ais its psu edu DATAWARE index html Subject Areas EN Admissions FI Finance HR Human Resources ST Student Transcripts Database MS SQL 2000 ETL Tool Mainframe data is extracted using Natural programs which contain the business logic These files are then FTPed to the Data Warehouse Data Modeling Tool MetaData Tool Query Tool MS Access Excel Impromptu SAS FileMaker Pro Schema Type Denormalized Relational Server OS Windows 2000 Contacts Karen Schultz Director Information Technical Services 814 863 5424 kls2 at psu edu Pete Dawson Manager Information Services 814 863 3637 pdawson at psu edu Yvonne Riley Data Warehouse Consultant 814 777 0964 YRiley at psu edu Other Comments Date Last Updated 19 Sep 2003 8 08 38 AM Pennsylvania State System of Higher Education http www sytecpa org Data Warehouse URL TBA Subject Areas AD Alumni Development EN Admissions Enrollment FA Financial Aid FI Finance HR Human Resources ST Student Banner People Soft SAP SCT IA Legacy Mainframes Database MS SQL 2000 ETL Tool MS DTS Data Modeling Tool SQL Server MetaData Tool Query Tool Cognos Suite Schema Type Server OS Windows 2000 Advanced Server Contacts Lisa Castellino lcastellino at sytecpa org Sonya Bennett sbennett at sytecpa org Rich Laychock rlaychock at sytecpa org Other Comments Date Last Updated 23 Sep 2003 4 55 40 PM Princeton University http www princeton edu main Data Warehouse URL http web princeton edu sites datamall Subject Areas EN Admissions Graduate Admissions Undergraduate Recruiting FA Financial Aid FI Accounts Payable Finance General Ledger Revenue HR Human Resources Labor Distribution Other Faculty ST Graduation Majors Student Student Demographics Student Information Student Registration Test Scores OT Campus Directory Facilities Property Grant Management Housing Services Telephone Billing Database Oracle ETL Tool Cognos Decision Stream Data Manager Data Modeling Tool ERWIN Visio MetaData Tool Query Tool Cognos ReportNet Cognos 8 Schema Type Some Star schema some denormalized tables Server OS Sun Unix Solaris Contacts Ted Bross Associate Director Administrative Information Ser 609 258 1569 tbross at princeton edu Other Comments Date Last Updated 23 May 2007 1 31 43 PM Purdue University http www purdue edu Data Warehouse URL http www adpc purdue edu DSS Subject Areas FI Finance HR Human Resources ST Student Database Oracle ETL Tool Mainframe data is translated with COBOL programs to create load data The load data is FTPed and then loaded with Oracle load utilities Data Modeling Tool None Kimball Fact Dimension modeling technique is followed MetaData Tool Query Tool BrioQuery for ad hoc clients there are a couple of web based front ends to PL SQL procedures for specific reporting needs Schema Type Star schemas are presented to ad hoc clients as data models stored in BrioQuery repositories Server OS Contacts Clifton Ivy 765 494 9683 clif at purdue edu Other Comments Date Last Updated Rensselaer Polytechnic Institute http www rpi edu Data Warehouse URL http www rpi edu datawarehouse Subject Areas AC Sponsored Programs Student Advising Student Credit Hours EN Enrollment FA Financial Aid Graduate FInancial Aid tied to reserach financial administration Other Undergraduate financial aid FI Budgeting Finance General Ledger Revenue HR Human Resources Labor Distribution Other estimated future labor expenditures Payroll ST Majors Student Demographics Student Fees OT Grant Management Security Database Oracle 8i ETL Tool PowerCenter from Informatica Data Modeling Tool Powerplug Erwin component of Informatica MetaData Tool Powerplug Erwin component of Informatica Query Tool Brio Enterprise Schema Type Star Schema Server OS Unix Contacts Ora Fish Project Manager 518 276 2213 fisho2 at rpi edu Other Comments Date Last Updated 16 Sep 2003 5 01 16 PM Rhode Island College http www ric edu Data Warehouse URL Subject Areas AC Awards Course Curriculum Faculty Loads EN Admissions Admissions Graduate Admissions Undergraduate Enrollment Student Profiles FA Financial Aid FI Accounts Payable Budgeting Finance General Ledger Purchasing Revenue HR Human Resources Payroll ST Assessment Degrees Graduation Majors Student Database Microsoft SQL 2000 ETL Tool In the evaluation process Data Modeling Tool In the evaluation process MetaData Tool In the evaluation process Query Tool SQR Microsoft Query Analyzer Crystal Schema Type In the process of evaluating and building a data warehouse Some existing extracted files some from the previous mainframe system some from the existing PeopleSoft system Server OS Windows 2000 Contacts Bin Yu Interim MIS Director 401 456 8160 byu at ric edu Other Comments Fax 401 456 8199 Date Last Updated 15 Sep 2003 9 26 54 AM Saint Francis Seminary http www sfs edu Data Warehouse URL Subject Areas AC Curriculum AD Development Advancement EN Enrollment FA Financial Aid ST Transcripts Database Relational Database ETL Tool Visio Data Modeling Tool SQL MetaData Tool SQL Query Tool SQL Schema Type Server OS Novell Linux Unix Win2000 Contacts Sarita Herrera Information Systems Administrator 414 747 6402 sherrera at sfs edu Other Comments Date Last Updated 20 Jun 2005 4 36 29 PM South Orange County Community College District www socccd edu Data Warehouse URL Subject Areas Database SQL Server DBMS ETL Tool SQL Server Integration Services Data Modeling Tool MetaData Tool Query Tool SQL Server Reporting Services Analysis Services SharePoint Server and PerformancePoint Schema Type student and enrollment data marts are integrated and share common dimensions such as student section etc Server OS Contacts Denice Inciong Director Research and Planning 949 823 0085 dinciong at socccd edu Other Comments Date Last Updated 31 Jan 2010 3 14 24 PM Stanford University http www stanford edu Data Warehouse URL http www db stanford edu warehousing index html Subject Areas AC Course PeopleSoft Student System Faculty Loads Custom data collection AD Alumni Development not in the DW maintained by Office of Dev EN Enrollment PeopleSoft FA Financial Aid PeoplSoft FI Budgeting Hyperion Planning Finance Oracle Financials for all accounting Other OutLook Soft for Financial Statements HR Human Resources PeopleSoft Labor Distribution Oracle Financials Payroll PeopleSoft ST Student PeopleSoft Student OT Grant Management Pre Award Legacy locally developed Database Oracle ETL Tool PowerCenter by Informatica Data Modeling Tool Visio Erwin MetaData Tool none yet Query Tool Business Objects and Hyperion Intelligence Schema Type Star Schema Server OS Sun Solaris Contacts Melanie Purdy Director Data Management and Reporting 650 725 8928 mpurdy at stanford edu Vik Kawatra Lead Data Warehouse 650 724 3797 vkawatra at stanford edu Other Comments Date Last Updated 28 Feb 2005 10 05 44 AM Syracuse University http www syr edu Data Warehouse URL http www is syr edu DOCS datawh index htm Subject Areas AD Alumni Development Client Server EN Admissions Client Server Recruiting Client Server FA Financial Aid Mainframe FI Accounts Payable Client Server General Ledger Mainframe Purchasing Client Server HR Human Resources Client Server Payroll Client Server ST Student Accounts Mainframe Student Records Client Server OT Athletics Mainframe Campus Directory Client Server Catering Services Mainframe Housing Services Mainframe Database Sybase 11 ETL Tool Mainframe source developed in house Client Server source Informix Ardent DataStage Data Modeling Tool Silverrun MetaData Tool Silverrun Query Tool Supported BrioQuery Brio Repository Broadcast Server some clients use MS Access and SAS Schema Type Both extract files and star schema clients access data via Sybase views Server OS AIX 4 3 Contacts Natalie Vincent Data Warehouse Coordinator 315 443 2357 nvincent at syr edu Other Comments Fax 315 443 2376 Date Last Updated Texas A M University System http www tamu edu Data Warehouse URL Not Yet on Web Subject Areas AC Faculty Loads EN Enrollment FI Budgeting Finance HR Human Resources Payroll ST Graduation Student Information OT Space Utilization Database Teradata ETL Tool None Natural extracts and Teradata utilities for loading and transformation MLOAD and BTEQ Data Modeling Tool ERWin MetaData Tool ERWin Query Tool Business Objects WebIntelligence and Queryman Schema Type Business Objects Universes logical groupings of objects in business terms Advanced users can access 3NF views Server OS Unix Contacts Matt Brown 409 458 6115 mbrown at sagomail tamu edu Other Comments Fax 409 458 7896 Date Last Updated Trinity College http www trincoll edu Data Warehouse URL http tcdart trincoll edu about tech htm Subject Areas AD Development Advancement PeopleSoft FI Finance PeopleSoft Database Microsoft SQL ETL Tool Cognos Decision Stream SQL Code Data Modeling Tool Microsoft Visio MetaData Tool Microsoft Visio Query Tool Cognos PowerPlay Impromptu Schema Type Star Schemas Server OS Microsoft 2000 Contacts Gwen Stengel Technology Solutions Specialist 860 297 4267 gwen stengel at trincoll edu Other Comments Date Last Updated 15 Sep 2003 3 06 13 PM Tufts University http www tufts edu Data Warehouse URL Subject Areas AC Course Student Credit Hours AD Alumni Development Advancement EN Admissions Undergraduate Enrollment Student Profiles ST Degrees Graduation Majors Student Demographics Student Fees Student Records Student Registration OT Facilities Property Grant Management Telephone Billing Database Oracle 10G ETL Tool pl sql sql loader Business Objects Data Integrator Data Modeling Tool ER Studio MetaData Tool MS Access Excel Query Tool Business Objects Web intelligence Schema Type Star Schema Server OS AIX Contacts May Chang Enterprise Data Manager 617 627 4349 may chang at tufts edu Other Comments Date Last Updated 14 Mar 2011 1 01 50 PM University of Akron http www uakron edu Data Warehouse URL Not on Web Subject Areas ST Student Records Database DB2 on MVS ETL Tool Custom JCL and easytrieve code Data Modeling Tool ERWIN MetaData Tool ERWIN Query Tool BRIO Schema Type Star Schemas Server OS Contacts Scott Miller 330 972 8685 scott58 at uakron edu Other Comments Date Last Updated University of Arizona http www arizona edu Data Warehouse URL Intranet on campus access only exception are passworded Office URL is http iwo arizona edu Subject Areas AC Student Advising We have a web site for this using our standard student data Student Credit Hours Back to 1993 teaching data to 1995 that is reasonably good EN Admissions We have some in ODS but no reports yet in data warehouse Admissions Undergraduate Enrollment Student Profiles FA Financial Aid Just getting this in our ODS from new FA system FI Accounts Payable Budgeting Finance granularity to the account object code level Fixed Assets General Ledger Purchasing Revenue HR Human Resources granularity to the person fund sources Payroll ST Degrees Majors Student Demographics granularity to the student program course instructor OT Grant Management Have in ODS plus some user queries Space Utilization granularity to the room but with problems Peer data Database Oracle RDB owned by Oracle formerly owned by Digital Equipment Corporation used in both the Operational Data Store ETL Tool Locally developed processes Data Modeling Tool Oracle and SQL Server Tools MetaData Tool InfoLibrarian Query Tool Web browser Apache PHP RDB BrioQuery MSAccess SQL Schema Type Most users see the University of Arizona organization structure in outline format from the Data Warehouse Using a web browser they select the part of the University that they want the data summarized entire institution Provost college department program or particular department number They get results as a web page HTML document or a spreadsheet tab separated file for direct manipulation with a spreadsheet program Table structures inside the database start at the raw as harvested level and range up the scale to what most folks call star schemas The Operational Data Store represents a daily snapshot of the transaction systems and is accessible via the above query tools Server OS HP VMS Contacts Bob Cooper bcooper1 at email arizona edu John Wilson jlwilson at email arizona edu Other Comments We maintain a separate organizational structure program and data to overcome the limited number of levels and different roll ups in HR and Financial Systems and Student data Also remaps most history to the current organizational structure program and unit names etc Date Last Updated 23 May 2007 6 16 41 PM University of California Los Angeles http www ucla edu Data Warehouse URL http www qdb ucla edu Subject Areas AC Research FI Budgeting Finance Purchasing HR Human Resources Payroll ST Student Information OT Security Database SQL Server ETL Tool Informatica PowerCenter Data Modeling Tool Erwin MetaData Tool Erwin Query Tool Hummingbird Bi Query Microsoft Access Excel Crystal Reports Homegrown web application Schema Type Third normal relational converting to Star Schemas Server OS NT Contacts Donna Capraro 310 206 1624 donnacap at ucla edu Other Comments Date Last Updated 1 Oct 2001 12 00 00 AM University of California San Diego http www ucsd edu Data Warehouse URL http www act ucsd edu act 1dataw html Subject Areas AC Awards AD Development Advancement EN Admissions Admissions Undergraduate Enrollment Student Profiles FA Financial Aid FI Accounts Payable Budgeting General Ledger Purchasing HR Human Resources Labor Distribution Payroll ST Degrees Majors Student Student Information OT Campus Directory Grant Management Database Sybase ETL Tool Home grown cobol perl Beginning use of Informatica Data Modeling Tool PowerDesigner MetaData Tool PowerDesigner Query Tool Custom Web Browsers MS Access Excel Crystal Reports Schema Type Third normal form entity relationship moving towards dimensional models Server OS Unix Contacts Barbara Connolly 858 534 9777 bconnolly at ucsd edu Lori Barry 858 534 8830 lbarry at ucsd edu Other Comments Date Last Updated 15 Sep 2003 7 15 18 PM University of California Santa Cruz http www ucsc edu Data Warehouse URL http planning ucsc edu dwh Subject Areas AC Course Faculty Loads Student Credit Hours EN Enrollment Student Profiles FI Budgeting Finance General Ledger Revenue HR Human Resources Payroll ST Degrees Graduation Majors Student Student Demographics Student Registration Test Scores OT Facilities Property Space Utilization Database Oracle ETL Tool PL SQL looking into Oracle s Data Warehouse Builder Data Modeling Tool Erwin MetaData Tool Business Objects Designer Query Tool Business Objects Reporter Schema Type various Server OS Sun Solaris Contacts Christi Bengard Asst Director of Data Management 831 459 3323 cbengard at ucsc edu Kimberly Register Data Management Coordinator 831 459 5837 kimberly register at adm ucsc edu Jeanne Whitney Data Warehouse programmer 831 459 5363 jwhitney at ucsc edu Other Comments Date Last Updated 25 Sep 2003 3 44 52 PM University of California Irvine www uci edu Data Warehouse URL datawarehouse uci edu Subject Areas Database MySQL MS SQL Server ETL Tool Jasper ETL Data Modeling Tool ERWIN MetaData Tool Home Grown Query Tool Home Grown Schema Type Relational Server OS UNIX Contacts Valerie Jones Data Warehouse Project Lead vjones at uci edu Tammy Phan Data Warehoues Operational Manager tamdangp at uci edu Other Comments Date Last Updated 14 Oct 2009 5 27 14 PM University of California Santa Cruz http www ucsc edu Data Warehouse URL http planning ucsc edu datamgmt Subject Areas AC Curriculum Faculty Loads Scheduling EN Enrollment FI Budgeting HR Human Resources Payroll ST Degrees Graduation Majors Student Demographics Student Information Database ETL Tool Data Modeling Tool MetaData Tool Query Tool Schema Type Server OS Contacts Georgina Chang Administrative Analyst 831 459 5607 gchang at ucsc edu Other Comments Date Last Updated 16 Oct 2009 11 54 39 AM University of Cincinnati http www uc edu Data Warehouse URL http www ucit uc edu access data warehouse asp Subject Areas HR Human Resources ST Student Information Database DB2 UDB ETL Tool COBOL or NATURAL extractions with fast loads from mainframe to warehouse through high speed channels Data Modeling Tool VISIO ERWIN MetaData Tool VISIO ERWIN Query Tool Hummingbird BI Query and BI Web MS Access Visual Basic Visual Fox Pro Cold Fusion PowerBuilder for application access SAS for analysis Schema Type Relational tables available through BI QUery graphical models Views resemble data marts and are tailored for administrative and departmental access Server OS Linux Contacts Mark Young 513 558 3209 Mark Young at uc edu Other Comments Date Last Updated 15 Sep 2003 9 37 21 AM University of Connecticut http www uconn edu Data Warehouse URL http vm uconn edu wwwmis dwhome html Subject Areas FI Finance HR Human Resources some ST Student basic Database S 390 DB2 v4 1 ETL Tool 100 SQL w utilities iterative staging interim final aggregate designs Data Modeling Tool Homegrown MetaData Tool Homegrown Query Tool BrioQuery Brio Enterprise Schema Type Star Schemas Server OS Contacts Peter Weinstein Team Leader Data Warehouse Services 860 486 0832 Peter Weinstein at uconn edu Scott Coopee Senior Associate to the Vice Chancellor for Information Services 860 486 3132 Scott Coopee at Uconn Edu Other Comments Date Last Updated 22 Sep 2003 9 35 25 PM University of Hawaii http hawaii edu Data Warehouse URL Subject Areas Database Oracle ETL Tool Oracle Warehouse Builder Data Modeling Tool Erwin MetaData Tool Query Tool Schema Type Server OS Solaris 10 Contacts Richard Kohnke rkohnke at hawaii edu Other Comments Date Last Updated 4 Dec 2008 7 20 25 PM University of Idaho http www uidaho edu Data Warehouse URL Subject Areas Database ETL Tool Data Modeling Tool MetaData Tool Query Tool Schema Type Server OS Contacts Judy Jack Programmer Analyst Human Resource Services 208 885 3633 judyj at uidaho edu Dianne Town det at uidaho edu Other Comments Date Last Updated University of Illinois http www uillinois edu Data Warehouse URL http www ds uillinois edu Subject Areas EN Admissions Recruiting FA Financial Aid FI Finance HR Human Resources future ST Student future Student Demographics Database Oracle ETL Tool Informatica Data Modeling Tool Erwin MetaData Tool Query Tool Business Objects Schema Type Server OS Unix Contacts Linda Bair 217 244 6419 lbair at uillinois edu Other Comments Deploying concurrently with SCT Banner system over next few years Date Last Updated University of Kansas http www ku edu Data Warehouse URL http www ku edu vcinfo Subject Areas FI Finance HR Human Resources Payroll ST Student Records PeopleSoft Database Oracle core DW SAS ODS Datamarts adhoc access ETL Tool Oracle Warehouse Builder SAS Warehouse Administrator Data Modeling Tool Select SE MetaData Tool Query Tool SAS web accessible reporting file creation ad hoc access Schema Type Third normal form entity relationship moving towards dimensional models Server OS Sun Solaris UNIX Contacts Ryan Cherland rcherland at ku edu Cheryl Pace Assistant Director Information Services Grace Schroer gschroer at ku edu Other Comments Date Last Updated 1 Oct 2001 12 00 00 AM University of Maryland http www umd edu Data Warehouse URL http www oit umd edu DataAdmin Subject Areas AC Faculty Loads EN Admissions FA Financial Aid FI Budgeting Finance HR Human Resources Payroll ST Student Demographics Student Records Student Registration OT Facilities Property Grant Management and contracts Other Metadata Organizational Units Database Oracle 8 1 7 4 ETL Tool Multiple Extract Methods Cobol Ideal Sql Plus SQL Loader Data Modeling Tool ERwin MetaData Tool In house application Oracle Java Query Tool Hyperion Performance Suite 8 3 Toad Schema Type Denormalized Relational Server OS RS 6000 SP running AIX 4 3 3 Data Win2003 Query Contacts Lori Kasamatsu Office of Data Administration 301 405 1713 lkasamat at umd edu Barbara Hope Director Data Administration 301 405 6819 bhope at umd edu Irina Sokolov DBA 301 405 1713 isokol at umd edu Other Comments Date Last Updated 30 May 2007 9 39 35 AM University of Miami http www miami edu Data Warehouse URL N A Subject Areas AC Course Enrollment Management System Curriculum Enrollment Management System Sponsored Programs AD Other Campaign Reporting EN Admissions Graduate Admissions Undergraduate Enrollment Recruiting FA Financial Aid FI Finance Purchasing HR Human Resources Labor Distribution ST Graduation Majors Student Demographics Student Records OT Facilities Property in design Database DB 2 Z OS ETL Tool COBOL to start Data Modeling Tool DB Artisan Erwin MetaData Tool DB Artisan Erwin Query Tool MicroStrategy Schema Type Primarily Star schemas Server OS NT Query OS 390 Data Contacts Daniel Thomas Project Manager 305 284 5113 dan thomas at miami edu Other Comments Fax 305 284 4753 Date Last Updated 14 Sep 2003 4 25 48 PM University of Michigan http www umich edu Data Warehouse URL http www bi umich edu Subject Areas AC Other Instructional Activity AD Alumni Development EN Admissions Recruiting FA Financial Aid FI Budgeting General Ledger Other Accounts Receivable Purchasing HR Human Resources Other Time and Labor Benefits Payroll ST Other Student Financials Third Week Counts Student Retention and Completion Student Records OT Facilities Property Other Utilities and Plant Research Proposal Management Research Regulatory Compliance Space Utilization including classrooms Database Oracle and SQL Server ETL Tool Transitioning to Informatica currently homegrown using SQR C Pro C SQL Loader PL I SSIS and others Data Modeling Tool Transitioning to ER Studio Data Architect currently Visio MetaData Tool Transitioning to Informatica Metadata Manager currently Microsoft Word Excel Query Tool BusinessObjects WebIntelligence and a homegrown Net application Architecture allows end users to query using any SQL based tool Schema Type Denormalized Relational star schemas cubes SSAS Server OS AIX for Oracle Windows for SQL Server and BusinessObjects Contacts Holly Nielsen Assistant Director of Business Intelligence 734 647 7685 hnielsen at umich edu Laura Bollettino 734 763 9870 laurab at umich edu Mary Jane Shand 734 647 7442 mjshand at umich edu Angela Yoon 734 647 8199 angelay at umich edu Other Comments Date Last Updated 2 Feb 2010 9 28 30 AM University of Minnesota http www umn edu Data Warehouse URL http dw umn edu Subject Areas AC Course EN Admissions Enrollment FA Financial Aid FI Finance General Ledger Inventory HR Human Resources Payroll ST Student Student Accounts OT Facilities Property Database Oracle 10g ETL Tool Informatica PowerCenter Data Modeling Tool Excel used for table specs ERwin MetaData Tool Home grown web interface Query Tool Home grown web interface Schema Type Denormalized Relational Server OS Sun Solaris Contacts Joe Sullivan 612 624 8236 j sull1 at umn edu John Kellogg Data Contact 612 625 3387 j kell at umn edu Other Comments Fax 612 626 8745 Date Last Updated 20 Nov 2006 8 41 53 AM University of Nebraska http www mit edu Data Warehouse URL http www nulook uneb edu Subject Areas Database ETL Tool Data Modeling Tool MetaData Tool Query Tool Schema Type Server OS Contacts Randy Goldenstein Data Warehouse Team Leader 402 472 7627 rgoldenstein at uneb edu Other Comments Date Last Updated University of Nevada Reno http www unr edu Data Warehouse URL Only available to UNR personnel Subject Areas AC Scheduling FI Finance HR Human Resources Payroll ST Student Information in process OT Campus Directory Telephone Billing Database Oracle 8 044 ETL Tool Focus DBUTIL ftp SQL Loader Data Modeling Tool N A MetaData Tool N A Query Tool For Analytic Users anything supported by ODBC primarily Access Excel and Fox pro For Informational Users the web We ve developed a web based application using Power Builder called CAIS Campus Advanced Information System CAIS provides standard inquires standard reports and graphs and custom inquiries whereby a user can specify which columns they want to include in the output and the selection criterion to use Many of the results of these queries and reports can be opened in an Excel spreadsheet on the users machine Schema Type Oracle Tables and Denormalized Fact Tables Server OS Contacts Jim McKinney DBA jim mckinney at vpaf unr edu LeRoy Palinsky Project Leader 775 784 1798 leroy palinsky at vpaf unr edu Other Comments Date Last Updated University of New Mexico http www unm edu Data Warehouse URL http www unm edu cirt dwhpage DHWHome htm Subject Areas Database Oracle 9i ETL Tool Oracle Warehouse Builder OWB Data Modeling Tool OWB MetaData Tool Query Tool Hyperion Performance Suite SQR Oracle Reports Schema Type SCT s Operational Data Store De normalized tables Server OS AIIX UNIX Contacts Other Comments Date Last Updated 8 Nov 2004 10 52 47 AM University of New Mexico http www unm edu Data Warehouse URL http www unm edu cirt dwhpage DHWHome htm Subject Areas EN Admissions Recruiting FA Financial Aid ST Student Information Database Oracle 8I ETL Tool Cobol and Sas extracts and uploads Data Modeling Tool Designer MetaData Tool Query Tool Discoverer Microsoft Access Schema Type ERDs and Normalized tables Server OS AIX RS6000 UNIX Contacts Barbara Pfaff Applications Manager 505 277 8064 bpfaff at unm edu Other

    Original URL path: http://dheise.andrews.edu/dw/DWData.htm (2013-06-13)
    Open archived version from archive

  • Data Warehousing at Avondale College
    University There are a nujmber of ways to view the Avondale College Data Warehouse Project The report itself DWReport doc 597KB DWReport zip 169KB ACDWTOC html PowerPoint slides DWPresPP ppt 300KB DWPresPP zip 240KB Handout DWPresHO doc 903KB DWPresHO zip

    Original URL path: http://dheise.andrews.edu/dw/Avondale/ACDW.html (2013-06-13)
    Open archived version from archive

  • TWDI Conference Links
    solutions report writers servers Organization Category Anubis data modelling Beggs Heidt consulting Brio Technology business intelligence Broadbase Business Objects business intelligence Cognos Inc D2K Data Generation Art Conroy consulting DataChallenge Inc Benchmarking DataWing Consulting Services J D Welch consulting Dynamic Information Systems Corporation business intelligence Hummingbird Communicatons business intelligence Informatica Information Advantage Innovative Systems Inc Intelligent Solutions Johathan G Geiger Claudia Imhoff Lowell Fryman consulting ISL Decision Systems Inc data

    Original URL path: http://dheise.andrews.edu/dw/DWLinks/TDWILinks.html (2013-06-13)
    Open archived version from archive



  •