To OAIRP Membership: On October 29 and 30, a two-day course in data warehouse project management will be offered at the University of Toledo. This is a very happy coincidence, with OAIRP set to discuss data warehouses at its October 19 conference, and with one or more presenters and panelists likely to emphasize the importance of effective project management. If you might benefit from this course, please consider joining us on the 29th and 30th. And please share this message with others who might also be interested. The following copy of a recent message to UT staff provides information about the course. Also, please note that as of 9:00 this morning, 7 of the 22 available seats in the course have been filled. Thanks, and see you Friday in Columbus. Daryl -----Original Message----- From: [log in to unmask] [mailto:[log in to unmask]] Sent: Tuesday, October 09, 2001 10:33 AM To: [log in to unmask] Subject: Data Warehouse Project Management Course The Division of Continuing Education is proud to offer this inhouse special training session in cooperation with: Sid Adelman, Principal, Sid Adelman & Associates (http://www.sidadelman.com/) This in-depth data warehouse class will be held on October 29 - 30, 2001 8:30am - 5:00pm at the University Computer Center (UCC) Fee Payments can be processed for this class, please use the following code: INC 1306 This is the first part of a Data Warehouse Bootcamp, the second part in the series will be offered November 13-14, 2001 (INC 1307) Course Description for Data Warehouse Project Management Course: DW Project Managers are usually thrown into the position without a clear idea of their role and authority, what they are expected to do, or even the objective of the DW. In the process of implementing a DW project, these managers are forced to develop materials and approaches out of whole cloth. If they are resourceful and clever, they can be moderately successful but they always have false starts and failures along the way. This seminar should minimize those false starts and failures. It will provide many of the materials the project manager has to develop and should maximize the chances for success. The key to the success of data warehouse projects is strong project management. This session will address the components of project management that are unique to data warehouse. It will give prospective data warehouse project managers a good understanding of their role as well as the important ingredients for their success. The session will highlight: Establishing goals and objectives and creating a scope agreement Organizational and cultural issues including staffing and roles and responsibilities Managing user expectations for function, schedules, performance and availability Understanding and mitigation of risk Data warehouse methodology, project planning and project control Some of the topics that would be covered in the class include: 1. Role of the DW Project Manager Skills required Where do they report, authority 2. Goals and objectives of the DW - what are we trying to accomplish? Matching the strategic goals of the enterprise Short and long term objectives 3. Indicators of success Critical success factors What constitutes success 4. Project planning, scheduling, scope creep Tasks and deliverables Realistic scheduling Managing demands for new capabilities 5. Managing the user, managing user expectations, agreements with users Document user requirements Relationship with the user User expectations for performance, availability. schedules, access capability and data 6. Internal selling of the project The necessity to sell Evaluating results Modes of presentation and communication 7. Organizational and cultural issues Staffing, roles and responsibilities Data ownership Governance 8. Risk mitigation Areas of risk How to minimize risk and keep your job 9. Controlling the project Managing the vendors Managing staff changes Managing changes in direction Managing detractors Cases and Exercises 1. Evaluating risk 2. Dealing with Scope Creep 3. Assessing your team's skills 4. Negotiating with your boss Audience Description This class would be attended by current (or hopeful) data warehouse project managers, data warehouse leads, data warehouse managers and users who are responsible for co-managing a data warehouse project. Objectives Learn the roles and responsibilities necessary to implement a successful data warehouse Learn how to plan a data warehouse project and learn of the tasks unique to data warehouse. Understand the risks involved with data warehouse and how to mitigate those risks. Learn how to cost justify a data warehouse project. Key Topics Scoping a data warehouse project Establishing an organization Building a cost/benefit analysis Selecting data warehouse tools and dealing with vendors Prerequisites Basic understanding of the concepts of data warehouse. An absolute desire to be successful in implementing a data warehouse application. Course Materials Students that already have a set of requirements, a scope document, an organizational outline or a project plan are asked to bring them to the class. Contact information for replies to this message: Name: Bev, Mary or Judy Department/organization: Continuing Education UT Location: SeaGate Phone Number: 419-321-5139