[580] in I/T Delivery
Data Warehouse Status Report - September2001
daemon@ATHENA.MIT.EDU (Mary Weisse)
Wed Oct 3 13:17:20 2001
Message-Id: <4.3.2.7.2.20011003131752.01736bd0@hesiod>
Date: Wed, 03 Oct 2001 13:21:41 -0400
To: delivery@mit.edu
From: Mary Weisse <mca@MIT.EDU>
Cc: warehouse@mit.edu
In-Reply-To: <5.0.2.1.2.20010905151312.0273fd50@hesiod>
Mime-Version: 1.0
Content-Type: multipart/alternative;
boundary="=====================_101442777==_.ALT"
--=====================_101442777==_.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed
Team Name: Data Warehouse
Team Leader: Scott Thorne
Report Date: September 11, 2001
URL: http://web.mit.edu/warehouse/
This month's accomplishments (August 2001)
- Coordinated the move from blimp to Taj as the warehouse test
machine - copied over all software, source code & data files, coordinated
with database group & ASST.
- Investigated various purchasing-related user questions.
- Assisted in user question regarding confidentiality of a student's
personal information sent to the on-line directory.
- Alumni data loaded to Warehouse: address, degree, affiliation
(schools and departments), biographic. Mark Jacobs is checking them out
with his "functional people".
- Grad Admissions data loaded to Warehouse: application data, test
score, school attended. Just completed the design and load. Will have SSIT,
Admissions people start checking out the data and the design later this week.
- Financial Aid COFHE report. Generated queries to answer all the
questions. SFS is checking the discrepancies, the criteria, etc. Report
due: October 12... will load the results to a table later.
- Continue working on Sloan School of Management Tuition Revenue
Sharing project:
- Finalize HR/Benefits design.
- Demo HR/Benefits initial design & prototype to HR/Benefits team,
Benefit Administrators, and Medical.
- Work with HR/Benefits & Benefits Administrators to define reports
to be created in the DW.
- Demo the new major Construction costs tracking system to Vicky
Sirianni.
- Start of monthly meetings with Financial Aid Office to discuss DW
issues and for training.
- Create initial budget & project plan for AAUDE.
- Finish data model and business model for the MIT News Office.
- Work with Campus Police to install BrioQuery on their machines.
Also, provided training.
Next Month's Plans (October 2001)
- Clean test warehouse machine and turn over to development for AAUDE
use.
- Implement and Test HR/Benefits design.
- Create HR/Benefits reports.
- Continue prototype of MIT Card Office (building access data) data.
- Begin to rollout New Major Construction Costs system to Facilities
Project Managers
- Continue work on AAUDE Data Warehouse.
- Provide BrioQuery Training to the Office of Dean Student Life.
- Duplicate directory structure form old Planning Office NT Server on the
AAUDE Machine.
Issues
- None
Training
Competency Classes - Individual
Conveying Respect, Interest, and Concern - 8/28/2001
Maija Ahlquist, Elena Zhitnikov
Speaking Clearly - What's Involved 9/06/2001
Huey Chan, Chuck Schubert, Mary Weisse
Competency Classes - Team
Dealing with difficult People: Angry behavior- 9/04/2001
Maija Ahlquist, Elena Zhitnikov
Speaking Clearly - What's Involved 9/04/2001
Dealing with difficult People: Resistant behavior 9/04/2001
Maija Ahlquist , Huey Chan, Chuck Schubert, Scott Thorne,
Steve Turner, Mary Weisse, Elena Zhitnikov
--=====================_101442777==_.ALT
Content-Type: text/html; charset="us-ascii"
<html>
<b>Team Name</b>: Data Warehouse<br>
<b>Team Leader:</b> Scott Thorne<br>
<b>Report Date:</b> September 11, 2001<br>
<b>URL:</b>
<a href="http://web.mit.edu/warehouse/" eudora="autourl"><font color="#0000FF"><u>http://web.mit.edu/warehouse/</a><br>
<br>
<br>
</u></font><b>This month's accomplishments (August 2001)<br>
<br>
</b>- <x-tab> </x-tab>Coordinated the move from blimp to Taj as the warehouse test machine - copied over all software, source code & data files, coordinated with database group & ASST.<br>
<br>
-<x-tab> </x-tab> Investigated various purchasing-related user questions.<br>
<br>
-<x-tab> </x-tab> Assisted in user question regarding confidentiality of a student's personal information sent to the on-line directory.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Alumni data loaded to Warehouse: address, degree, affiliation (schools and departments), biographic. Mark Jacobs is checking them out with his "functional people".<br>
<br>
-<x-tab> </x-tab>Grad Admissions data loaded to Warehouse: application data, test score, school attended. Just completed the design and load. Will have SSIT, Admissions people start checking out the data and the design later this week.<br>
<br>
-<x-tab> </x-tab>Financial Aid COFHE report. Generated queries to answer all the questions. SFS is checking the discrepancies, the criteria, etc. Report due: October 12... will load the results to a table later.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Continue working on Sloan School of Management Tuition Revenue Sharing project:<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Finalize HR/Benefits design. <br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Demo HR/Benefits initial design & prototype to HR/Benefits team, Benefit Administrators, and Medical.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Work with HR/Benefits & Benefits Administrators to define reports to be created in the DW.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Demo the new major Construction costs tracking system to Vicky Sirianni.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Start of monthly meetings with Financial Aid Office to discuss DW issues and for training.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Create initial budget & project plan for AAUDE.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Finish data model and business model for the MIT News Office.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Work with Campus Police to install BrioQuery on their machines. Also, provided training.<br>
<br>
<br>
<b>Next Month's Plans (October 2001)<br>
<br>
</b><font face="Times New Roman, Times">-<x-tab> </x-tab></font>Clean test warehouse machine and turn over to development for AAUDE use.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Implement and Test HR/Benefits design.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Create HR/Benefits reports.<br>
<br>
<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>Begin to rollout New Major Construction Costs system to Facilities Project Managers<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Continue work on AAUDE Data Warehouse.<br>
<br>
<font face="Times New Roman, Times">-<x-tab> </x-tab></font>Provide BrioQuery Training to the Office of Dean Student Life.<br>
<br>
- Duplicate directory structure form old Planning Office NT Server on the AAUDE Machine.<br>
<br>
<br>
<br>
<b>Issues<br>
</b>
<dl><font face="Times New Roman, Times">
<dd>-<x-tab> </x-tab></font>None<br>
<br>
<br>
<br>
<br>
<br>
</dl><b>Training<br>
<br>
<x-tab> </x-tab><u>Competency Classes</u></b> - Individual<br>
<dl>
<dd>Conveying Respect, Interest, and Concern - 8/28/2001
<dd><x-tab> </x-tab>Maija Ahlquist, Elena Zhitnikov<br>
<br>
<dd>Speaking Clearly - What's Involved 9/06/2001
<dd><x-tab> </x-tab>Huey Chan, Chuck Schubert, Mary Weisse<br>
<br>
</dl><b><x-tab> </x-tab><u>Competency Classes</u></b> - Team<br>
<dl>
<dd>Dealing with difficult People: Angry behavior- 9/04/2001
<dd><x-tab> </x-tab>Maija Ahlquist, Elena Zhitnikov<br>
<br>
<dd>Speaking Clearly - What's Involved 9/04/2001
<dd>Dealing with difficult People: Resistant behavior 9/04/2001
<dl>
<dd>Maija Ahlquist , Huey Chan, Chuck Schubert, Scott Thorne,
<dd>Steve Turner, Mary Weisse, Elena Zhitnikov<br>
<br>
</dl>
<dd><x-tab> </x-tab>
</dl><br>
</html>
--=====================_101442777==_.ALT--
