book

The Data Warehouse Lifecycle Toolkit

by Ralph Kimball, Margy Ross, Warren Thornthwaite, Joy Mundy, Bob Becker

January 2008

Beginner to intermediate

672 pages

31h 44m

English

Wiley

Read now

Unlock full access

How this Book is OrganizedWho Should Read this BookHow this Book Differs from the First Edition
Lifecycle History LessonLifecycle MilestonesUsing the Lifecycle RoadmapLifecycle Navigation AidsLifecycle Vocabulary PrimerConclusion
Define the ProjectPlan the ProjectManage the ProjectManage the ProgramConclusionManaging the Effort and Reducing RiskAssuring QualityKey RolesKey DeliverablesEstimating ConsiderationsWebsite ResourcesTask List

Overall Approach to Requirements DefinitionPrepare for the InterviewConduct the InterviewProgram Compliance/Security InterviewsReview the Interview ResultsPrepare and Publish Requirements DeliverablesPrioritize and Agree on Next StepsAdjustments for Project Level RequirementsDeal with Challenging IntervieweesConclusionManaging the Effort and Reducing RiskAssuring QualityKey RolesKey DeliverablesEstimating ConsiderationsWebsite ResourcesTask List
The Value of ArchitectureTechnical Architecture OverviewBack Room ArchitecturePresentation Server ArchitectureFront Room ArchitectureInfrastructureMetadataSecurityConclusion
Create the ArchitectureSelect ProductsManage the MetadataSecure the SystemCreate the Infrastructure MapInstall the Hardware and SoftwareConclusionManaging the Effort and Reducing RiskAssuring QualityKey RolesKey DeliverablesEstimating ConsiderationsWebsite ResourcesTask List
Making the Case for Dimensional ModelingDimensional Modeling PrimerEnterprise Data Warehouse Bus ArchitectureMore on DimensionsMore on FactsFables and Falsehoods About Dimensional ModelingConclusion
Modeling Process OverviewGet OrganizedRecall the Four-Step Modeling ProcessDesign the Dimensional ModelDevelop the Detailed Dimensional ModelEmbrace Data StewardshipConclusionManaging the Effort and Reducing RiskAssuring QualityKey RolesKey DeliverablesEstimating ConsiderationsWebsite ResourcesTask List
Develop StandardsDevelop the Physical Data ModelBuild the Development DatabaseDesign Processing Data StoresDevelop the Initial Index PlanDesign the OLAP DatabaseBuild the Test DatabaseDesign AggregationsDesign and Build the Database InstanceDevelop the Physical Storage StructureConclusionManaging the Effort and Reducing RiskAssuring QualityKey RolesKey DeliverablesEstimating ConsiderationsWebsite ResourcesTask List
Round Up the RequirementsThe 34 Subsystems of ETLExtracting DataCleaning and Conforming DataDelivering Data for PresentationManaging the ETL EnvironmentReal Time ImplicationsConclusion
ETL Process OverviewGetting StartedDevelop the ETL PlanDevelop One-Time Historic Load ProcessingDevelop Incremental ETL ProcessingConclusionManaging the Effort and Reducing RiskAssuring QualityKey RolesKey DeliverablesEstimating ConsiderationsWebsite ResourcesTask List
Importance of Business Intelligence ApplicationsAnalytic Cycle for Business IntelligenceTypes of Business Intelligence ApplicationsNavigating Applications via the BI PortalConclusion
Business Intelligence Application Resource PlanningBusiness Intelligence Application SpecificationBusiness Intelligence Application DevelopmentBusiness Intelligence Application MaintenanceConclusionManaging the Effort and Reducing RiskAssuring QualityKey RolesKey DeliverablesEstimating ConsiderationsWebsite ResourcesTask List
System DeploymentDocumentation and TrainingMaintenance and SupportConclusionManaging the Effort and Reducing RiskAssuring QualityKey RolesKey DeliverablesEstimating ConsiderationsTask List
Manage the Existing EnvironmentPrepare for Growth and EvolutionPrioritize Opportunities for GrowthConclusionManaging the Effort and Reducing RiskAssuring QualityKey RolesKey DeliverablesEstimating Considerations