EDUCATION >> DATA WAREHOUSING 


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



 

Innovative Logic’s service offerings are categorized within our four core competencies - Strategic Consulting, Data Warehousing, Business Intelligence, and Data Management. Together these four competency areas enable us to provide our clients with a strategic approach to address enterprise or departmental information integration and delivery needs by leveraging appropriate technologies and making the best business choices...
READ MORE...

Business Intelligence (BI) is insight – insight into information that is required to make sound business decisions. BI is a key component of a successful data warehouse endeavor...
READ MORE...

The definition of a data warehouse has taken on many meanings and interpretations throughout the years. But at its core, a data warehouse represents a consolidated view of an entity's data...
READ MORE...

Unlike many modern methodologies, Innovative Logic Inc. has taken the extra, and unique, step of turning the "theory" into actual deliverables.
READ MORE...