Data Warehouse:

The Compelling Need for Data Warehousing Data Warehouse: The Building Blocks

• Escalating Need for Strategic Information

• Failures of Past Decision-Support Systems

• Operational Versus Decision-Support Systems

• Datawarehousing—The Only Viable Solution

• Datawarehouse Defined

• The Datawarehousing Movement

• Evolution of Business Intelligence

• Review formal definitions of a data warehouse

• Discuss the defining features

• Distinguish between data warehouses and data marts

• Study each component or building block that makes up a data warehouse

• Introduce metadata and highlight its significance


Trends in Data Warehousing Planning and Project Management

• Data Warehouse Do-Overs

• Proliferation of Data Sources

• Outsourcing

• Hub Versus Relational Databases

• Active Data Warehouses

• Fusion with CRM

• Growing Number of End Users

• More Complex Queries

• Integrated Customer View

• Exploding Data Volumes

• Phases in project management

• Inception

• Elaboration

• Construction

• Transition


Defining the Business Requirements Requirements as the driving force for data warehousing

• To gain agreement with stakeholders

• To provide a foundation to communicate to a technology service provider what the solution needs to do to satisfy the customer’s and business’ needs

• To provide input into the next phase for this project

• To describe what not how the customer/business needs will be met by the solution

• Understand why business requirements are the driving force

• Discuss how requirements drive every development phase

• Specifically learn how requirements influence data design

• Review the impact of requirements on architecture

• Note the special considerations for ETL and metadata

• Examine how requirements shape information delivery


The Architectural Components Infrastructure as the Foundation for Data Warehousing

• Overall Architecture

• Data Warehouse Database

• Sourcing, Acquisition, Cleanup and Transformation Tools

• Meta data

• Data Marts

• Data Warehouse Administration and Management

• Understand the distinction between architecture and infrastructure

• Find out how the data warehouse infrastructure supports its architecture

• Gain an insight into the components of the physical infrastructure

• Review hardware and operating systems for the data warehouse

• Study parallel processing options as applicable to the data warehouse

• Discuss the server options in detail

• Learn how to select the DBMS

• Review the types of tools needed for the data warehouse

• Study the concept and use of data warehouse appliances


The Significant Role of Metadata Principles of Dimensional Modeling

• Find out why metadata is so important

• Understand who needs metadata and what types they need

• Review metadata types by the three functional areas

• Discuss business metadata and technical metadata in detail

• Examine all the requirements metadata must satisfy

• Understand the challenges for metadata management

• Study options for providing metadata

• Clearly understand how the requirements definition determines data design

• Introduce dimensional modeling and contrast it with entity-relationship modeling

• Review the basics of the STAR schema

• Find out what is inside the fact table and inside the dimension tables

• Determine the advantages of the STAR schema for data warehouses


Dimensional Modeling: Advanced Topics Data Extraction, Transformation, and Loading

• Discuss and get a good grasp of slowly changing dimensions

• Understand large dimensions and how to deal with them

• Examine the snowflake schema in detail

• Learn about aggregate tables and determine when to use them

• Completely survey families of STARS and their application

• Part I: When to build your data warehouse

• Part II: Building a new schema

• Part III: Location of your data warehouse


The Physical Design Process in DWH Matching Information to the Classes of Users

• Distinguish between physical design and logical design as applicable to the data warehouse

• Study the steps in the physical design process in detail

• Understand physical design considerations and know the implications

• Grasp the role of storage considerations in physical design

• Examine indexing techniques for the data warehouse environment

• Review and summarize all performance enhancement options

• Matching Information to the Classes of Users


OLAP in the Data Warehouse

• OLAP (Online Analytical Processing)

• Overview & Introduction

• OLAP Cube

• HISTORY of OLAP

• OLAP Operations

• DATAWAREHOUSE

• ARCHITECHTURE Difference between OLAP &

• OLTP & TYPES OF OLAP APPLICATIONS OF OLAP

• Data Warehousing and the Web

• Data Warehouse Deployment

• Data Quality: A Key to Success

• Data Mining Basics

• Growth and Maintenance