1. Business Analysis
    1. Define Architecture
      1. Databases – sources and targets.
      2. Hardware platforms for sources and targets.
      3. Hardware platform for ETL (Extraction, Transformation, Load) tool.
      4. Communications (e.g. protocols, ODBC, etc.).
      5. Data access (e.g. ODBC, gateways, file libraries, etc.).
      6. Obtain network schematic.
    2. Define Subject Areas
      1. Interview business users to define subject areas.
        • define major subject groups.
        • define key dimensional attributes.
        • understand questions that need answers (queries) at all levels.
        • understand end-user PC literacy (to choose query tool).
        • understand Web requirements.
      2. Define integrated enterprise data warehouse.
      3. Define incrementally building each subject area.
      4. Define dimensional processes and entities.
      5. Define terminology.
      6. Define conforming dimensions.
      7. Define slowly changing dimensions.
      8. Define reusable elements to ensure integrity across all subject areas.
      9. Define history requirements.
    3. Define Meta Data Requirements
      1. CASE tool requirements.
      2. Extract/Transform/Load requirements.
      3. Query tool requirements.
    4. Analyze Source Data
      1. Determine source data elements.
        • Determine cleansing requirements.
        • Define Change-Data-Capture requirements.
      2. Determine data feasibility.
        • Compare user data requirements to available data sources.
        • Identify potential issues.
          1. Define Data Mart Grain
            1. Define fact table metrics.
              • Define statistical measurements.
              • Define source database coorelations
            2. Determine fact table partitions.
            3. Determine legacy database’s ability to deliver grain.
            4. Define business rules.
            5. Estimate database size.
            6. Estimate hardware requirements
            7. Estimate query speed.
          2. Define Aggregates and Summarizations
            1. Define aggregates for query optimization.
            2. Define aggregates for most highly utilized reports.
          3. Choose Products and Tools
            1. CASE tool.
            2. Cleansing requirements
            3. Extraction/transformation tool.
            4. Query tool.
            5. Data mart management.
            6. Change management.