This book cuts through the hype and theory about data warehousing and gets down to the basics of walking every member of the team through the design and implementation of a data warehouse. Beyond "how to do it", this book is an implementation methodology that helps project teams identify who will be doing what and what tools each member will need. .
From the Back Cover
Just do it! Cut through the hype and get that data warehouse deployed!
Based on Meyer and Cannon's extensive practical experience Building a Better Data Warehouse is a systematic guide to successful data warehouse deployment. It cuts through the hype, briefing managers on exactly what to expect building, piloting, deploying and maintaining a data warehouse. You'll learn how to take control of the process from start to finish-and discover the key success factors associated with data warehouses that deliver real business benefits.
- Understand the unique issues surrounding OLAP applications
- Compare data warehouses and data marts
- Plan your goals, architecture, infrastructure, platforms and tools
- Build the data model and the physical model
- Optimize performance, security and end-user access
- Maximize data integrity
Meyer and Cannon pull no punches. They offer specific guidance for every critical decision, including hardware platforms, operating systems, databases tools and applications. They also provide comprehensive advice for both data modelers and DBAs, including proven techniques for completing data model deliverables and constructing the data warehouse. Building a Better Data Warehouse covers metadata, extraction programming, populating the data warehouse, end-user access tools, training, and much more. It's the one book every member of your data warehouse team should read.
See all Editorial Reviews