Data Warehousing Concepts and Principles -- An Introduction to the Field of Data Warehousing (One-day Course / Certificate Course) Prerequisite: None You Will Learn: • Basic concepts of data warehousing • Common language, terminology, and definitions in data warehousing • Key factors that contribute to data warehousing success • Risk factors for data warehousing projects • Common approaches to data warehousing architecture • Data warehousing roles and responsibilities • Data warehouse development concepts and best practices • Data warehouse operations and administration considerations Geared To: Anyone new to data warehousing; DW teams that need to develop a common base of concepts and terminology; DW team members who need to understand the roles and responsibilities of others on their team Module One Data Warehousing Concepts • Data Warehousing Basics • Understanding Data, Information, and Knowledge • Kinds of Information Needs • Data Warehousing Definitions • Data Warehouse • Data Warehousing • Data Stores • The Data Warehousing Application • Building Blocks – Extract, Transform, and Load • Configuring the Application • three-tiers: staging, warehouse, and data marts • two-tiers: warehouse and data marts • conformed data marts • independent data marts • Contrasting Data Stores • Data Warehouse • Data Mart • Staging Area • The Data Warehousing Process • Architecture, Implementation, and Operation • Incremental Implementation with Evolving Architecture • The Data Warehousing Program • Program Planning • Program Charter • Readiness Assessment Module Two Data Warehousing Architecture • Business Architecture • Business Drivers • Business Goals • Business Processes • Data Architecture • Data Analysis and Data Standards • Information Needs Analysis • Business Questions • Information Needs Priorities • Data Warehouse Subject Model • Fact/Qualifier Matrix • Target Data Store Configuration • Source Data Subjects & Source Data Composition • Metadata Requirements • Technology Architecture • Project Architecture •Planning for Incremental Implementation • Project Dependency • Project Decomposition • Timebox Techniques • Organizational Architecture • Deployment and Operations Planning • Training Plan • Support Plan • Communication Plan Module Three Data Warehouse Implementation • Implementation Planning • Incremental Projects • Architectural Adjustments • Balancing Time, Resources, and Results • Warehousing Data Design • Logical Data Modeling • Relational Data Modeling • Dimensional Data Modeling • Structural Data Modeling • Adjusting for Time Requirements • Adjusting for Distribution & Security Requirements • Adjusting for Access & Navigation Requirements • Physical Design Considerations • Warehousing Process Design • Source/Target Maps • Data Transformation Concepts • Data Cleansing Concepts • Specifying Transformation Rules • Deployed Technology • Tool Installation • Technology Configuration • Connectivity and Access • Building the Data Warehouse Components • Data Acquisition & Load Processes • Ready-to-Use Databases • Business Analysis Applications • Operation Environment • Data Warehouse Deployment • Production Delivery • Training • Assigned Support Responsibilities • Published Policies and Procedures • Formal Warehouse Acceptance • Project Closure Module Four Data Warehouse Operation • Business Services • Valuable and Sustainable Services • Service Environment & Culture • Data Warehouse Administration • Data Refresh • Managed Platforms • Managed Environment • Customer Service • Managed Quality • Managed Infrastructure Module Five Summary & Conclusions • Common Mistakes • References & Resources Course Cost: $ 750.00 For more information and/or to schedule, contact: info@innovative-logic.
Posted on: Sat, 28 Sep 2013 21:40:00 +0000
Trending Topics
Recently Viewed Topics
© 2015