May 2010
Beginner
599 pages
18h 56m
English
Content preview from Data Warehousing Fundamentals for IT Professionals
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
APPENDIX A
PROJECT LIFE CYCLE STEPS AND CHECKLISTS
DATA WAREHOUSE PROJECT LIFE CYCLE: MAJOR STEPS AND SUBSTEPS
Note: The substeps indicated here are at a high level. Expand these substeps as necessary to suit the requirements of your environment.
Project Planning
Definition of scope, goals, objectives, and expectations
Establishment of implementation strategy
Preliminary identification of project resources Assembling of project team
Estimation of project schedule
Requirements Definition
Definition of requirements gathering strategy
Conducting interviews and group sessions with users
Review of existing documents
Study of source operational systems
Derivation of business metrics and dimensions needed for analysis
Design
Design of the logical data model
Definition of data extraction, transformation, and loading functions Design of the information delivery framework
Establishment of storage requirements
Definitions of the overall architecture and supporting infrastructure
Construction
Selection and installation of infrastructure hardware and software
Selection and installation of the DBMSs
Selection and installation of ETL and BI (business intelligence) tools
Completion of the design of the physical data model
Completion of the metadata component
Deployment
Completion of user acceptance tests
Performance of initial data loads
Making user desktops ready for the data warehouse
Training and support for the initial set of users
Provision for data warehouse security, backup, and ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.