The Microsoft Data Warehouse Toolkit : With SQL Server 2005 and the Microsoft Business Intelligence Toolset

Chapter 1: Defining Business Requirements Building the foundation Overview Business requirements are the bedrock of the DW/BI system. Busi...

Chapter 2: Designing the Business Process Dimensional Model To arrive at the simple is difficult#8212;Rashid Elisha Overview This chapter is abou...

Chapter 3: The Toolset When you have a hammer, everything looks like a nail. Overview In this chapter, we describe the architecture and product...

Chapter 4: Setup and Physical Design Where the rubber meets the road Overview Up to this point, we#8217;ve been talking about project manageme...

Chapter 5: Designing the ETL System Measure twice; cut once Overview Some people like to plan, specify, and document systems; most don#8217;t. W...

Chapter 6: Developing the ETL System What could possibly be more fun? Overview The Extract, Transformation, and Load (ETL) application is t...

Chapter 7: Designing the Analysis Services OLAP Database The tip of the iceberg Overview You#8217;ve designed, built, and loaded the relatio...

Chapter 8: Business Intelligence Applications We#8217;re from the Data Warehouse, and we#8217;re here to help Overview We have struggled s...

Chapter 9: Building the BI Application in Reporting Services Building a bridge for those who don#8217;t want to swim Overview Every user of...

Chapter 10: Incorporating Data Mining We dig up diamonds by the score A thousand rubies, sometimes more From Snow White by Walt Disney Company, mu...

Chapter 11: Working with an Existing Data Warehouse Doing the best with what you have Overview Throughout this book, we#8217;ve been talki...

Chapter 12: Security Balancing safety and opportunity Overview Security is another one of those black holes of the DW/BI system. It seems s...

Chapter 13: Metadata Plan The Bermuda Triangle of data warehousing Overview Metadata is a vast, relatively uncharted region of the DW/BI sy...

Chapter 14: Deployment The Great Unveiling Overview As you see in Figure 14.1, the deployment step in the Business Dimensional Lifecycle is wher...

Chapter 15: Operations and Maintenance Trust but verify Overview We#8217;ve seen too many DW/BI teams postpone thinking about how to operate...

Chapter 16: Managing Growth There#8217;s no rest for the weary Overview At this point, unless you plan to include real-time capabilities, you...

Chapter 17: Real-Time Business Intelligence Man waits not for time nor tide#8212;Mark Twain Overview What does real time mean in the contex...

Chapter 18: Present Imperatives and Future Outlook The endless loop Our goal with this book was to teach you how to build a successful business i...