Driving Implementation Through a Methodology,Overview,Project Management (Methodology, Maintaining Metadata),Defining DW Concepts & Terminology,Planning for a Successful Warehouse,Analyzing User Query Needs,Choosing a Computing Architecture,Modeling the Data Warehouse,Planning Warehouse Storage,ETT (Building the Warehouse),Meeting a Business Need,Supporting End User Access,Managing the Data Warehouse,Objectives,After completing this lesson, you should be able to do the following: Explain the different approaches to warehouse development and the benefits of an incremental approach Identify the purpose of the Oracle Method Discuss the purpose and fundamental elements of the Oracle Consulting Data Warehouse Method Identify the Data Warehouse Method as a series of processes and approaches Discuss the objectives of the Oracle Warehouse Technology Initiative,“Big Bang” Approach,Analyze enterprise requirements,Build enterprise data warehouse,Report in subsets or store in data marts,“Big Bang” Approach: Advantages and Disadvantages,Advantages: The only real advantage is where the warehouse is being built as part of another major project or program such as reengineering and they are dependent on each other Having a “big picture” of the data warehouse before starting the data warehousing project Disadvantages: Involves a high risk, takes a longer time Runs the risk of needing to change requirements,Incremental Approach to Warehouse Development,Multiple iterations Shorter implementations Validation of each phase,Benefits of an Incremental Approach,Delivers a strategic data warehouse solution through incremental development efforts Provides extensible, scalable architecture Supports the information needs of the enterprise organization Quickly provides business benefits and ensures a much earlier return of investment Allows a data warehouse to be built based on a subject or application area at a time Allows the construction of an integrated data mart environment,Marketing,Top-Down Approach,Legacy data,Operations data,External data sources,Sales,Data warehouse,Data marts,Users,Top-Down Approach: Advantages and Disadvantages,Advantages: Provides a relatively quick implementation and payback Offers significantly lower risk Emphasizes high-level business needs Achieves synergy among subject areas Disadvantages: Requires an increase in up-front costs Difficult to define the boundaries May not be suitable unless the client needs cross-functional reporting,Bottom-Up Approach,Legacy data,Operations data,External data sources,Data warehouse,Data marts,Bottom-Up Approach: Advantages and Disadvantages,Advantages: Appealing to IT Easier to get buy-in from IT Disadvantages: Requires source systems to encapsulate the current business processes Design may be out-of-date before delivery Requires reengineering for each increment Solutions may be rejected by the next line of business to be involved Overall benefit to the business may be minimized,Oracle Method,Consists of: Online guidelines and manuals Workplan templates Deliverable templates Created by experienced and field-based practitioner for estimating, managing, developing, and delivering business solutions.,Oracle Data Warehouse Method,Guides through development: Business functions Processes Tasks Modeled on the Custom Development Method,Method Materials,Software Tools,Workplan templates* Deliverable templates* Online handbooks Estimating software*Not production available yet,Handbooks,Method handbook Process and task reference* Deliverable reference*,Oracle Data Warehouse Method,Focuses on scoping Manages risk Relies on user involvement throughout Delivers an extensible, scalable solution Uses a variety of technologies Identifies tasks with clear objectives and deliverables Employs common techniques, skills, and dependencies Assigns tasks to processes and processes to phases,Benefits,DWM Fundamental Elements,Approaches Phases Processes Tasks and deliverables Roles,Phase 1,Phase 2,Phase 3,Phase 1 Task1 Phase 1 Task2 Phase 1 Task3,Phase 3 Task1 Phase 3 Task2 Phase 3 Task3,Phase 2 Task1 Phase 2 Task2 Phase 2 Task3,Process 1,Process 2,Approaches,Incremental,Packaged data mart,Warehouse,Data mart,Data mart,Data mart,Warehouse infrastructure implementation,Business application implementation,Increment I Proof of Concept,Requirements Capture,Incremental Approach,Business Strategy,IT Strategy,Warehouse Strategy Phase,Scoping Services,Technical Architecture Services,Warehouse Infrastructure Services,Warehouse Business Solution Services,Increment 1,Increment 2,Increment 3,Increment n,Increment A,Increment B,Increment C,Increment z,Proof of Concept,Incremental Development,Focus on business functionality Deliver business benefit Suited to warehouse evolution Once an increment is complete the selection and scope of the next increment is defined Each increment follows the same phase sequence,Strategy,Incremental Development,