Duration:

Two day classroom instruction. Optional one-day workshop (see below).

Prerequisite Education or Experience

Introductory course for data warehousing or basic exposure to business intelligence or data warehousing projects.

Course Outline:

Introductions

  • Instructor & class introductions
  • Survey

Section 1: What is BI & DW 
(optional: if attendees need)

  • Brief History Of Accessing, Reporting And Analyzing Data
  • Data to Information Lifecycle
  • Business Intelligence (BI) defined
  • Data Warehousing (DW) defined

Section 2: DW Methodology

  • Project methodologies
  • DW methodology
  • Differences between DW and traditional IT projects

Section 3: DW Processes

  • Sponsorship & Governance
  • Program Management
  • Project Management
  • Change Management
  • Data Quality & Data Management
  • Ongoing Administration & Support

Section 4: DW Roles & Responsibilities

  • Organizations
  • IT And Business Interaction
  • Context Of Roles & Responsibilities
  • IT And Business Roles
  • Skills And Training

Section 5: DW Project Planning

  • DW Project Phases
  • Major DW Project Activities
  • Developing Scope & Building Business Case
  • Assembling Team

Section 6: DW Project Planning

  • DW Project Phases
  • Major Activities & Deliverables
  • Developing Scope & Building Business Case
  • Staffing & Management

Section 7: DW Assessment Activities

  • Requirements Gathering
  • Source Systems Analysis
  • Data Quality & Integrity Metrics

Section 8: DW Data Design Activities

  • Data Architecture
  • Data Staging
  • Data Modeling
  • Database Design

Section 9: DW Data Preparation Activities

  • Data Souring & Quality Requirements
  • ETL Architecture
  • Designing & Creating ETL Processes

Section 10: DW BI Activities

  • BI, Reporting & Analysis Requirements
  • BI Architecture
  • BI Tool Selection
  • Design & Build BI Processes
  • Business User Involvement

Section 11: DW Testing, Deployment & Roll-out

  • Testing
  • Deployment
  • Roll-out
  • Ongoing Administration & Maintenance

Section 12: Conclusions

  • Highlights
  • References & Resources

Section 13: Optional One-Day Workshop

You may choose to add an additional, custom, one-day consulting workshop in which the instructor will work with your team on a particular issue you are facing. This option will add one day of training plus up-front consulting work to prepare for the workshop.

Workshop Sessions:

  • Review Course Materials in your Context
  • Plan by Exercise Different Portions of your Project
  • Discuss Best Practices and Factors Impacting your Project