[634] in I/T Delivery
Re: Warehouse - October 2001
daemon@ATHENA.MIT.EDU (Mary Weisse)
Thu Nov 15 12:46:32 2001
Message-Id: <4.3.2.7.2.20011115124550.01739ea8@hesiod>
Date: Thu, 15 Nov 2001 12:46:52 -0500
To: delivery@mit.edu
From: Mary Weisse <mca@MIT.EDU>
Cc: thorne@mit.edu
In-Reply-To: <5.0.2.1.2.20010905152853.02743ea0@hesiod>
Mime-Version: 1.0
Content-Type: multipart/alternative;
boundary="=====================_10595495==_.ALT"
--=====================_10595495==_.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed
Team Name: Data Warehouse
Team Leader: Scott Thorne
Report Date: October 2001
URL: http://web.mit.edu/warehouse/
This month's accomplishments (October 2001)
- Rolled out Freshman Admissions.
- Analyzed and completed initial Design for Student Payroll.
- Implemented and Tested HR/Benefits design.
- Created HR/Benefits reports.
- Completed HR/Benefits MIT Medical extract.
- Completed initial budget for FY 2003 for Data Warehouse and Java Team.
- Presented "Intro to the Data Warehouse" at the IT Partners
meeting 10/25/2001.
- Presented "Data Warehouse In-Depth" at the IT Partners
meeting 10/25/2001.
- Provided one-on-one Brio/DW training to Eva Huang (Dean Student
Life Office).
- Began working with the Financial Aid office to give then a better
understanding of the DW.
- Duplicated the directory structure form old Planning Office NT
Server on the AAUDE Machine.
- Began to rollout "New Major Construction Costs" system to
Facilities Financial Administrators.
- Begin loading AAUDE data into the AAUDE Data Warehouse.
- Worked with the Provost's Office to create a Student Enrollment Y
Report.
- Continued working on the Sloan Revenue Sharing Project.
- Cleaned test warehouse machine and began to create the new
directory structures for AAUDE.
- Tested transfer of files from old Planning Office NT Server on the
AAUDE Machine.
- Modified perl software for nightly loads on TAJ to load new
environment variable needed for Oracle 8.1 access.
- Created new "person" related view for Lab Management.
- Loaded most recent space datainto warehouse.
- Updated Web Hits data to correctly recognize access by Netscape
version 6 and to count Windows 2000 hits separately from Windows NT.
Next Month's Plans (November 2001)
- Continue prototype of MIT Card Office (building access data) data.
- Complete the directory structures, copy all existing data from old
server; turn the AAUDE machine over to the AAUDE group.
- Continue working with the Financial Aid office to give then a
better understanding of the DW.
- Create HR/Benefits Tufts Medical extract.
- Create HR/Benefits Benefits Office extracts.
- Create additional HR/Benefits reports.
- Begin working with Mike Lieberman in Facilities to move their Excel
spreadsheets into their Access database.
- Train a second Facilities financial person in use of the "Major
Construction Costs system" - Access Database piece.
- Begin working on documentation for the Facilities financial
administrators and the person who will be training the project managers to
use the "Major Construction Costs system", this includes both the Access
Database piece and the BrioQuery piece.
- Continue working on the Sloan Revenue Sharing Project.
- Start to research web-based products.
- Continue loading AAUDE data into the AAUDE Data Warehouse.
- Create the President's Report using Brio and the DW for the
Financial Aid Office.
- Begin to analyze and design the Federal Work Study data for the
Financial Aid Office.
- Create the advertisement for new DW programmer/analyst position.
- Begin training Admissions Office in use of BrioQuery and Admissions
data in the DW.
- Set up new user ids on AAUDE to support ftp access.
- Complete transition of AAUDE FTP service from old Planning Office
NT Server to AAUDE machine.
- Upgrade Oracle version on ORCA from 7.3 to 8.1.6.
- Implement Sales Order system to support Tech Review, phase II.
- Support FSS/CAO in SAP Integration Testing.
- Re-design Project WBS Hierarchy table to allow for more levels in
the hierarchy.
Issues
- Prototype of MIT Card Office (building access data) data put on
hold pending available DW resource.
Training
- Maija Ahlquist
How to say no to a customer - 10/5/2001
- Huey Chan
How to say no to a customer - 10/5/2001
- Mary Weisse
Gartner Symposium 10/08/2001 10/12/2001
Conveying Respect, Interest, and Concern -
10/17/2001
- Elena Zhitnikov
How to say no to a customer - 10/5/2001
--=====================_10595495==_.ALT
Content-Type: text/html; charset="us-ascii"
<html>
<font size=4><b>Team Name</b>: Data Warehouse<br>
<b>Team Leader:</b> Scott Thorne<br>
<b>Report Date:</b> October 2001<br>
<b>URL:</b>
</font><a href="http://web.mit.edu/warehouse/" eudora="autourl"><font size=4 color="#0000FF"><u>http://web.mit.edu/warehouse/</a><br>
<br>
<br>
</u></font><font size=4><b>This month's accomplishments (October 2001)<br>
<br>
</b></font><font face="Times New Roman, Times">-<x-tab> </x-tab></font>Rolled out Freshman Admissions. <br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Analyzed and completed initial Design for Student Payroll.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Implemented and Tested HR/Benefits design.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Created HR/Benefits reports.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Completed HR/Benefits MIT Medical extract.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Completed initial budget for FY 2003 for Data Warehouse and Java Team.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Presented “Intro to the Data Warehouse” at the IT Partners meeting 10/25/2001.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Presented “Data Warehouse In-Depth” at the IT Partners meeting 10/25/2001.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Provided one-on-one Brio/DW training to Eva Huang (Dean Student Life Office).<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Began working with the Financial Aid office to give then a better understanding of the DW.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Duplicated the directory structure form old Planning Office NT Server on the AAUDE Machine.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Began to rollout “New Major Construction Costs” system to Facilities Financial Administrators.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Begin loading AAUDE data into the AAUDE Data Warehouse.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Worked with the Provost’s Office to create a Student Enrollment Y Report.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Continued working on the Sloan Revenue Sharing Project.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Cleaned test warehouse machine and began to create the new directory structures for AAUDE.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Tested transfer of files from old Planning Office NT Server on the AAUDE Machine. <br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Modified perl software for nightly loads on TAJ to load new environment variable needed for Oracle 8.1 access. <br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Created new "person" related view for Lab Management.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Loaded most recent space datainto warehouse. <br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Updated Web Hits data to correctly recognize access by Netscape version 6 and to count Windows 2000 hits separately from Windows NT. <br>
<br>
<br>
<br>
<font size=4><b>Next Month's Plans (November 2001)<br>
<br>
</b></font><font face="Times New Roman, Times">-<x-tab> </x-tab></font>Continue prototype of MIT Card Office (building access data) data.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Complete the directory structures, copy all existing data from old server; turn the AAUDE machine over to the AAUDE group. <br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Continue working with the Financial Aid office to give then a better understanding of the DW.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Create HR/Benefits Tufts Medical extract.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Create HR/Benefits Benefits Office extracts.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Create additional HR/Benefits reports.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Begin working with Mike Lieberman in Facilities to move their Excel spreadsheets into their Access database.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Train a second Facilities financial person in use of the “Major Construction Costs system” - Access Database piece.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Begin working on documentation for the Facilities financial administrators and the person who will be training the project managers to use the “Major Construction Costs system”, this includes both the Access Database piece and the BrioQuery piece. <br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Continue working on the Sloan Revenue Sharing Project.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Start to research web-based products.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Continue loading AAUDE data into the AAUDE Data Warehouse.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Create the President's Report using Brio and the DW for the Financial Aid Office.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Begin to analyze and design the Federal Work Study data for the Financial Aid Office.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Create the advertisement for new DW programmer/analyst position.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Begin training Admissions Office in use of BrioQuery and Admissions data in the DW.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Set up new user ids on AAUDE to support ftp access. <br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Complete transition of AAUDE FTP service from old Planning Office NT Server to AAUDE machine. <br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Upgrade Oracle version on ORCA from 7.3 to 8.1.6. <br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Implement Sales Order system to support Tech Review, phase II.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Support FSS/CAO in SAP Integration Testing.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Re-design Project WBS Hierarchy table to allow for more levels in the hierarchy.<br>
<br>
<br>
<br>
<br>
<br>
<br>
<font size=4><b>Issues<br>
<br>
</b></font><font face="Times New Roman, Times">-<x-tab> </x-tab></font>Prototype of MIT Card Office (building access data) data put on hold pending available DW resource. <br>
<br>
<br>
<br>
<font size=4><b>Training<br>
<br>
</b></font><font face="Times New Roman, Times">-<x-tab> </x-tab></font><u>Maija Ahlquist<br>
</u><x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>How to say no to a customer - 10/5/2001<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font><u>Huey Chan<br>
</u><x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>How to say no to a customer - 10/5/2001<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font><u>Mary Weisse<br>
</u><x-tab> </x-tab> <x-tab> </x-tab>Gartner Symposium 10/08/2001 10/12/2001<br>
<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>Conveying Respect, Interest, and Concern<x-tab> </x-tab>- 10/17/2001<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font><u>Elena Zhitnikov</u>
<dl>
<dd><x-tab> </x-tab>How to say no to a customer - 10/5/2001
</dl><br>
</html>
--=====================_10595495==_.ALT--
