1 / 20

MIS 451 Building Business Intelligence Systems

MIS 451 Building Business Intelligence Systems. Project Planning and Requirements Analysis. Agenda. Data Warehouse Development Lifecycle Project Planning Requirements Analysis. Data Warehouse Development Lifecycle. Data Warehouse – Enterprise Data Warehouse

kibo-nelson
Download Presentation

MIS 451 Building Business Intelligence Systems

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MIS 451Building Business Intelligence Systems Project Planning and Requirements Analysis

  2. Agenda • Data Warehouse Development Lifecycle • Project Planning • Requirements Analysis

  3. Data Warehouse Development Lifecycle • Data Warehouse – Enterprise Data Warehouse • Data Mart – Departmental Data Warehouse

  4. Data Warehouse Development Lifecycle Project Planning Requirements Analysis Logical Design Physical Design Data Staging Data Analysis (OLAP)

  5. Data Warehouse Development Lifecycle • Logical Design (Tool: Oracle Data Mart Designer) • ER Modeling  Dimensional Modeling • Design appropriate table structure and primary key/Foreign key relationship

  6. Data Warehouse Development Lifecycle • Physical Design • Database selection • Storage selection • Web based? • Performance

  7. Data Warehouse Development Lifecycle • Data Staging (Tool: Oracle Data Mart Builder) • Extraction • Cleansing and Transformation • Transportation

  8. Data Warehouse Development Lifecycle Extraction Transformation Transportation

  9. Data Warehouse Development Lifecycle • Data Analysis (OLAP) (Tool: Oracle Data Mart Discoverer) • Reporting • Ad-hoc query • Graphical Analysis

  10. Data Warehouse Development Lifecycle Analytical Report

  11. Data Warehouse Development Lifecycle Drill-up&Drill-down Query

  12. Data Warehouse Development Lifecycle Graphical Analysis

  13. Project Planning Project Planning Requirements Analysis Logical Design Physical Design Data Staging Data Analysis (OLAP)

  14. Project Planning • Feasibility Study – Assess readiness for your data warehouse project • Define the scope of your data warehouse project • Develop the project plan

  15. Project Planning – Feasibility Study • Factors that establish the foundation for a successful Data Warehouse project • Strong Management Support • Compelling business motivation – e.g., customer-centric companies, acquisition • IS/Business partnership

  16. Project Planning – DW Scope • Provide a single data source to support decision making • Include at lease n years of historical data • Support at least n concurrent users • Provide better decision support information using less time

  17. Project Planning – Project Plan • DW Team Staff • Project Manager • Business System Analyst • Data Modeler • DBA • Data Staging System Developer • End User Application Developer • Time & Milestones • Budget

  18. Requirements Analysis Project Planning Requirements Analysis Logical Design Physical Design Data Staging Data Analysis (OLAP)

  19. Requirements Analysis • Pre-Interview Research • Identify Interviewees • Business Executive • Business Unit Manager • Key Staff • Ask Relevant Questions • e.g., what analysis do you currently do? what analysis do you plan to do? How much historical information do you need?

  20. Requirements Analysis • Summarize interview with interviewees • Write interview report • Analytical Requirements • Information Requirements

More Related