{"product_id":"the-microsoft-data-warehouse-toolkit-isbn-9780470640388","title":"The Microsoft Data Warehouse Toolkit","description":"\u003cb\u003eBest practices and invaluable advice from world-renowned data warehouse experts\u003c\/b\u003e  \u003cp\u003eIn this book, leading data warehouse experts from the Kimball Group share best practices for using the upcoming “Business Intelligence release” of SQL Server, referred to as SQL Server 2008 R2. In this new edition, the authors explain how SQL Server 2008 R2 provides a collection of powerful new tools that extend the power of its BI toolset to Excel and SharePoint users and they show how to use SQL Server to build a successful data warehouse that supports the business intelligence requirements that are common to most organizations. Covering the complete suite of data warehousing and BI tools that are part of SQL Server 2008 R2, as well as Microsoft Office, the authors walk you through a full project lifecycle, including design, development, deployment and maintenance.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eFeatures more than 50 percent new and revised material that covers the rich new feature set of the SQL Server 2008 R2 release, as well as the Office 2010 release\u003c\/li\u003e \u003cli\u003eIncludes brand new content that focuses on PowerPivot for Excel and SharePoint, Master Data Services, and discusses updated capabilities of SQL Server Analysis, Integration, and Reporting Services\u003c\/li\u003e \u003cli\u003eShares detailed case examples that clearly illustrate how to best apply the techniques described in the book\u003c\/li\u003e \u003cli\u003eThe accompanying Web site contains all code samples as well as the sample database used throughout the case studies\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003ci\u003eThe Microsoft Data Warehouse Toolkit, Second Edition\u003c\/i\u003e provides you with the knowledge of how and when to use BI tools such as Analysis Services and Integration Services to accomplish your most essential data warehousing tasks.\u003c\/p\u003e \u003cp\u003eForeword xxvii\u003c\/p\u003e \u003cp\u003eIntroduction xxix\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 1 Requirements, Realities, and Architecture 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1 Defining Business Requirements 3\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Most Important Determinant of Long-Term Success 5\u003c\/p\u003e \u003cp\u003eAdventure Works Cycles Introduction 6\u003c\/p\u003e \u003cp\u003eUncovering Business Value 6\u003c\/p\u003e \u003cp\u003eObtaining Sponsorship 7\u003c\/p\u003e \u003cp\u003eDefining Enterprise-Level Business Requirements 8\u003c\/p\u003e \u003cp\u003ePrioritizing the Business Requirements 22\u003c\/p\u003e \u003cp\u003eRevisiting the Project Planning 25\u003c\/p\u003e \u003cp\u003eGathering Project-Level Requirements 26\u003c\/p\u003e \u003cp\u003eSummary 28\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2 Designing the Business Process Dimensional Model 29\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDimensional Modeling Concepts and Terminology 30\u003c\/p\u003e \u003cp\u003eFacts 31\u003c\/p\u003e \u003cp\u003eDimensions 33\u003c\/p\u003e \u003cp\u003eBringing Facts and Dimensions Together 34\u003c\/p\u003e \u003cp\u003eThe Bus Matrix, Conformed Dimensions, and Drill Across 36\u003c\/p\u003e \u003cp\u003eAdditional Design Concepts and Techniques 38\u003c\/p\u003e \u003cp\u003eSurrogate Keys 38\u003c\/p\u003e \u003cp\u003eSlowly Changing Dimensions 39\u003c\/p\u003e \u003cp\u003eDates 42\u003c\/p\u003e \u003cp\u003eDegenerate Dimensions 43\u003c\/p\u003e \u003cp\u003eSnowflaking 43\u003c\/p\u003e \u003cp\u003eMany-to-Many or Multivalued Dimensions 44\u003c\/p\u003e \u003cp\u003eHierarchies 47\u003c\/p\u003e \u003cp\u003eAggregate Dimensions 49\u003c\/p\u003e \u003cp\u003eJunk Dimensions 51\u003c\/p\u003e \u003cp\u003eThe Three Fact Table Types 52\u003c\/p\u003e \u003cp\u003eAggregates 53\u003c\/p\u003e \u003cp\u003eThe Dimensional Modeling Process 54\u003c\/p\u003e \u003cp\u003ePreparation 55\u003c\/p\u003e \u003cp\u003eData Profiling and Research 60\u003c\/p\u003e \u003cp\u003eBuilding Dimensional Models 63\u003c\/p\u003e \u003cp\u003eDeveloping the Detailed Dimensional Model 66\u003c\/p\u003e \u003cp\u003eTesting and Refining the Model 68\u003c\/p\u003e \u003cp\u003eReviewing and Validating the Model 68\u003c\/p\u003e \u003cp\u003eCase Study: The Adventure Works Cycles Orders Dimensional Model 69\u003c\/p\u003e \u003cp\u003eThe Orders Fact Table 69\u003c\/p\u003e \u003cp\u003eThe Dimensions 69\u003c\/p\u003e \u003cp\u003eIdentifying Dimension Attributes and Facts for the Orders Business Process 72\u003c\/p\u003e \u003cp\u003eThe Final Draft of the Initial Orders Model 74\u003c\/p\u003e \u003cp\u003eDetailed Orders Dimensional Model Development 75\u003c\/p\u003e \u003cp\u003eFinal Dimensional Model 77\u003c\/p\u003e \u003cp\u003eSummary 77\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3 The Toolset 79\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Microsoft DW\/BI Toolset 80\u003c\/p\u003e \u003cp\u003eWhy Use the Microsoft Toolset? 82\u003c\/p\u003e \u003cp\u003eArchitecture of a Microsoft DW\/BI System 83\u003c\/p\u003e \u003cp\u003eWhy Analysis Services? 84\u003c\/p\u003e \u003cp\u003eWhy a Relational Store? 86\u003c\/p\u003e \u003cp\u003eETL Is Not Optional 86\u003c\/p\u003e \u003cp\u003eThe Role of Master Data Services 88\u003c\/p\u003e \u003cp\u003eDelivering BI Applications 88\u003c\/p\u003e \u003cp\u003eOverview of the Microsoft Tools 89\u003c\/p\u003e \u003cp\u003eWhich Products Do You Need? 90\u003c\/p\u003e \u003cp\u003eSQL Server Development and Management Tools 92\u003c\/p\u003e \u003cp\u003eSummary 97\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4 System Setup 99\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSystem Sizing Considerations 100\u003c\/p\u003e \u003cp\u003eCalculating Data Volumes 101\u003c\/p\u003e \u003cp\u003eDetermining Usage Complexity 102\u003c\/p\u003e \u003cp\u003eEstimating Simultaneous Users 104\u003c\/p\u003e \u003cp\u003eAssessing System Availability Requirements 105\u003c\/p\u003e \u003cp\u003eHow Big Will It Be? 105\u003c\/p\u003e \u003cp\u003eSystem Configuration Considerations 105\u003c\/p\u003e \u003cp\u003eMemory 106\u003c\/p\u003e \u003cp\u003eMonolithic or Distributed? 106\u003c\/p\u003e \u003cp\u003eStorage System Considerations 110\u003c\/p\u003e \u003cp\u003eProcessors 113\u003c\/p\u003e \u003cp\u003eSetting Up for High Availability 114\u003c\/p\u003e \u003cp\u003eSoftware Installation and Configuration 115\u003c\/p\u003e \u003cp\u003eDevelopment Environment Software Requirements 116\u003c\/p\u003e \u003cp\u003eTest and Production Software Requirements 120\u003c\/p\u003e \u003cp\u003eOperating Systems 122\u003c\/p\u003e \u003cp\u003eSQL Server Relational Database Setup 122\u003c\/p\u003e \u003cp\u003eAnalysis Services Setup 126\u003c\/p\u003e \u003cp\u003eIntegration Services Setup 129\u003c\/p\u003e \u003cp\u003eReporting Services Setup 130\u003c\/p\u003e \u003cp\u003eSummary 131\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 2 Building and Populating the Databases 133\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5 Creating the Relational Data Warehouse 135\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGetting Started 136\u003c\/p\u003e \u003cp\u003eComplete the Physical Design 137\u003c\/p\u003e \u003cp\u003eSurrogate Keys 138\u003c\/p\u003e \u003cp\u003eString Columns 138\u003c\/p\u003e \u003cp\u003eTo Null, or Not to Null? 140\u003c\/p\u003e \u003cp\u003eHousekeeping Columns 140\u003c\/p\u003e \u003cp\u003eTable and Column Extended Properties 142\u003c\/p\u003e \u003cp\u003eDefine Storage and Create Constraints and Supporting Objects 142\u003c\/p\u003e \u003cp\u003eCreate Files and Filegroups 142\u003c\/p\u003e \u003cp\u003eData Compression 144\u003c\/p\u003e \u003cp\u003eEntity and Referential Integrity Constraints 145\u003c\/p\u003e \u003cp\u003eInitial Indexing and Database Statistics 147\u003c\/p\u003e \u003cp\u003eAggregate Tables 150\u003c\/p\u003e \u003cp\u003eCreate Table Views 151\u003c\/p\u003e \u003cp\u003eInsert an Unknown Member Row 152\u003c\/p\u003e \u003cp\u003eExample CREATE TABLE Statement 152\u003c\/p\u003e \u003cp\u003ePartitioned Tables 153\u003c\/p\u003e \u003cp\u003eFinishing Up 163\u003c\/p\u003e \u003cp\u003eStaging Tables 163\u003c\/p\u003e \u003cp\u003eMetadata Setup 163\u003c\/p\u003e \u003cp\u003eSummary 164\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6 Master Data Management 165\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eManaging Master Reference Data 166\u003c\/p\u003e \u003cp\u003eIncomplete Attributes 167\u003c\/p\u003e \u003cp\u003eData Integration 168\u003c\/p\u003e \u003cp\u003eSystems Integration 170\u003c\/p\u003e \u003cp\u003eMaster Data Management Systems and the Data Warehouse 171\u003c\/p\u003e \u003cp\u003eIntroducing SQL Server Master Data Services 171\u003c\/p\u003e \u003cp\u003eModel Definition Features 172\u003c\/p\u003e \u003cp\u003eData Management Features 174\u003c\/p\u003e \u003cp\u003eUser Interface: Exploring and Managing the Master Data 174\u003c\/p\u003e \u003cp\u003eImporting and Updating Data 176\u003c\/p\u003e \u003cp\u003eExporting Data 177\u003c\/p\u003e \u003cp\u003eFull Versioning of All Attributes 179\u003c\/p\u003e \u003cp\u003eCreating a Simple Application 179\u003c\/p\u003e \u003cp\u003eSummary 186\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7 Designing and Developing the ETL System 187\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eRound Up the Requirements 188\u003c\/p\u003e \u003cp\u003eDevelop the ETL Plan 191\u003c\/p\u003e \u003cp\u003eIntroducing SQL Server Integration Services 192\u003c\/p\u003e \u003cp\u003eControl Flow and Data Flow 194\u003c\/p\u003e \u003cp\u003eSSIS Package Architecture 197\u003c\/p\u003e \u003cp\u003eThe Major Subsystems of ETL 198\u003c\/p\u003e \u003cp\u003eExtracting Data 199\u003c\/p\u003e \u003cp\u003eSubsystem 1: Data Profiling 199\u003c\/p\u003e \u003cp\u003eSubsystem 2: Change Data Capture System 200\u003c\/p\u003e \u003cp\u003eSubsystem 3: Extract System 202\u003c\/p\u003e \u003cp\u003eCleaning and Conforming Data 206\u003c\/p\u003e \u003cp\u003eSubsystem 4: Data Cleaning System 206\u003c\/p\u003e \u003cp\u003eSubsystem 5: Error Event Schema 214\u003c\/p\u003e \u003cp\u003eSubsystem 6: Audit Dimension Assembler 215\u003c\/p\u003e \u003cp\u003eSubsystem 7: Deduplication System 216\u003c\/p\u003e \u003cp\u003eSubsystem 8: Conforming System 217\u003c\/p\u003e \u003cp\u003eDelivering Data for Presentation 218\u003c\/p\u003e \u003cp\u003eSubsystem 9: Slowly Changing Dimension Manager 218\u003c\/p\u003e \u003cp\u003eSubsystem 10: Surrogate Key Generator 223\u003c\/p\u003e \u003cp\u003eSubsystem 11: Hierarchy Manager 223\u003c\/p\u003e \u003cp\u003eSubsystem 12: Special Dimensions Manager 224\u003c\/p\u003e \u003cp\u003eSubsystem 13: Fact Table Builders 225\u003c\/p\u003e \u003cp\u003eSubsystem 14: Surrogate Key Pipeline 229\u003c\/p\u003e \u003cp\u003eSubsystem 15: Multi-Valued Dimension Bridge Table Builder 235\u003c\/p\u003e \u003cp\u003eSubsystem 16: Late Arriving Data Handler 235\u003c\/p\u003e \u003cp\u003eSubsystem 17: Dimension Manager 238\u003c\/p\u003e \u003cp\u003eSubsystem 18: Fact Provider System 238\u003c\/p\u003e \u003cp\u003eSubsystem 19: Aggregate Builder 239\u003c\/p\u003e \u003cp\u003eSubsystem 20: OLAP Cube Builder 239\u003c\/p\u003e \u003cp\u003eSubsystem 21: Data Propagation Manager 240\u003c\/p\u003e \u003cp\u003eManaging the ETL Environment 240\u003c\/p\u003e \u003cp\u003eSummary 243\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8 The Core Analysis Services OLAP Database 245\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eOverview of Analysis Services OLAP 247\u003c\/p\u003e \u003cp\u003eWhy Use Analysis Services? 247\u003c\/p\u003e \u003cp\u003eWhy Not Analysis Services? 249\u003c\/p\u003e \u003cp\u003eDesigning the OLAP Structure 250\u003c\/p\u003e \u003cp\u003ePlanning 251\u003c\/p\u003e \u003cp\u003eGetting Started 253\u003c\/p\u003e \u003cp\u003eCreate a Project and a Data Source View 255\u003c\/p\u003e \u003cp\u003eDimension Designs 257\u003c\/p\u003e \u003cp\u003eCreating and Editing Dimensions 261\u003c\/p\u003e \u003cp\u003eCreating and Editing the Cube 274\u003c\/p\u003e \u003cp\u003ePhysical Design Considerations 291\u003c\/p\u003e \u003cp\u003eUnderstanding Storage Modes 293\u003c\/p\u003e \u003cp\u003eDeveloping the Partitioning Plan 294\u003c\/p\u003e \u003cp\u003eDesigning Performance Aggregations 296\u003c\/p\u003e \u003cp\u003ePlanning for Deployment 298\u003c\/p\u003e \u003cp\u003eProcessing the Full Cube 299\u003c\/p\u003e \u003cp\u003eDeveloping the Incremental Processing Plan 299\u003c\/p\u003e \u003cp\u003eSummary 304\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9 Design Requirements for Real-Time BI 305\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eReal-Time Triage 306\u003c\/p\u003e \u003cp\u003eWhat Does Real-Time Mean? 306\u003c\/p\u003e \u003cp\u003eWho Needs Real Time? 307\u003c\/p\u003e \u003cp\u003eReal-Time Tradeoffs 308\u003c\/p\u003e \u003cp\u003eScenarios and Solutions 311\u003c\/p\u003e \u003cp\u003eExecuting Reports in Real Time 313\u003c\/p\u003e \u003cp\u003eServing Reports from a Cache 313\u003c\/p\u003e \u003cp\u003eCreating an ODS with Mirrors and Snapshots 314\u003c\/p\u003e \u003cp\u003eCreating an ODS with Replication 314\u003c\/p\u003e \u003cp\u003eBuilding a BizTalk Application 315\u003c\/p\u003e \u003cp\u003eBuilding a Real-Time Relational Partition 315\u003c\/p\u003e \u003cp\u003eQuerying Real-Time Data in the Relational Database 317\u003c\/p\u003e \u003cp\u003eUsing Analysis Services to Query Real-Time Data 318\u003c\/p\u003e \u003cp\u003eSummary 319\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 3 Developing the BI Applications 321\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10 Building BI Applications in Reporting Services 323\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eA Brief Overview of BI Applications 324\u003c\/p\u003e \u003cp\u003eTypes of BI Applications 325\u003c\/p\u003e \u003cp\u003eThe Value of Business Intelligence Applications 326\u003c\/p\u003e \u003cp\u003eA High-Level Architecture for Reporting 328\u003c\/p\u003e \u003cp\u003eReviewing Business Requirements for Reporting 328\u003c\/p\u003e \u003cp\u003eExamining the Reporting Services Architecture 330\u003c\/p\u003e \u003cp\u003eUsing Reporting Services as a Standard Reporting Tool 332\u003c\/p\u003e \u003cp\u003eReporting Services Assessment 339\u003c\/p\u003e \u003cp\u003eThe Reporting System Design and Development Process 340\u003c\/p\u003e \u003cp\u003eReporting System Design 341\u003c\/p\u003e \u003cp\u003eReporting System Development 348\u003c\/p\u003e \u003cp\u003eBuilding and Delivering Reports 351\u003c\/p\u003e \u003cp\u003ePlanning and Preparation 351\u003c\/p\u003e \u003cp\u003eCreating Reports 354\u003c\/p\u003e \u003cp\u003eReporting Operations 368\u003c\/p\u003e \u003cp\u003eAd Hoc Reporting Options 369\u003c\/p\u003e \u003cp\u003eThe Report Model 370\u003c\/p\u003e \u003cp\u003eShared Datasets 371\u003c\/p\u003e \u003cp\u003eReport Parts 371\u003c\/p\u003e \u003cp\u003eSummary 372\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11 PowerPivot and Excel 375\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing Excel for Analysis and Reporting 376\u003c\/p\u003e \u003cp\u003eThe PowerPivot Architecture: Excel on Steroids 378\u003c\/p\u003e \u003cp\u003eCreating and Using PowerPivot Databases 380\u003c\/p\u003e \u003cp\u003eGetting Started 381\u003c\/p\u003e \u003cp\u003ePowerPivot Table Design 381\u003c\/p\u003e \u003cp\u003eCreating Analytics with PowerPivot 385\u003c\/p\u003e \u003cp\u003eObservations and Guidelines on PowerPivot for Excel 392\u003c\/p\u003e \u003cp\u003ePowerPivot for SharePoint 394\u003c\/p\u003e \u003cp\u003eThe PowerPivot SharePoint User Experience 394\u003c\/p\u003e \u003cp\u003eServer-Level Resources 397\u003c\/p\u003e \u003cp\u003ePowerPivot Monitoring and Management 397\u003c\/p\u003e \u003cp\u003ePowerPivot’s Role in a Managed DW\/BI Environment 400\u003c\/p\u003e \u003cp\u003eSummary 401\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12 The BI Portal and SharePoint 403\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe BI Portal 404\u003c\/p\u003e \u003cp\u003ePlanning the BI Portal 405\u003c\/p\u003e \u003cp\u003eImpact on Design 406\u003c\/p\u003e \u003cp\u003eBusiness Process Categories 407\u003c\/p\u003e \u003cp\u003eAdditional Functions 408\u003c\/p\u003e \u003cp\u003eBuilding the BI Portal 409\u003c\/p\u003e \u003cp\u003eUsing SharePoint as the BI Portal 411\u003c\/p\u003e \u003cp\u003eArchitecture and Concepts 412\u003c\/p\u003e \u003cp\u003eSetting Up SharePoint 417\u003c\/p\u003e \u003cp\u003eSummary 426\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 13 Incorporating Data Mining 429\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDefining Data Mining 430\u003c\/p\u003e \u003cp\u003eBasic Data Mining Terminology 432\u003c\/p\u003e \u003cp\u003eBusiness Uses of Data Mining 433\u003c\/p\u003e \u003cp\u003eRoles and Responsibilities 440\u003c\/p\u003e \u003cp\u003eSQL Server Data Mining Architecture Overview 440\u003c\/p\u003e \u003cp\u003eThe Data Mining Design Environment 442\u003c\/p\u003e \u003cp\u003eBuild, Deploy, and Process 442\u003c\/p\u003e \u003cp\u003eAccessing the Mining Models 443\u003c\/p\u003e \u003cp\u003eIntegration Services and Data Mining 443\u003c\/p\u003e \u003cp\u003eAdditional Features 444\u003c\/p\u003e \u003cp\u003eArchitecture Summary 445\u003c\/p\u003e \u003cp\u003eMicrosoft Data Mining Algorithms 445\u003c\/p\u003e \u003cp\u003eDecision Trees 446\u003c\/p\u003e \u003cp\u003eNaïve Bayes 447\u003c\/p\u003e \u003cp\u003eClustering 448\u003c\/p\u003e \u003cp\u003eSequence Clustering 448\u003c\/p\u003e \u003cp\u003eTime Series 449\u003c\/p\u003e \u003cp\u003eAssociation 449\u003c\/p\u003e \u003cp\u003eNeural Network 449\u003c\/p\u003e \u003cp\u003eThe Data Mining Process 450\u003c\/p\u003e \u003cp\u003eThe Business Phase 451\u003c\/p\u003e \u003cp\u003eThe Data Mining Phase 453\u003c\/p\u003e \u003cp\u003eThe Operations Phase 460\u003c\/p\u003e \u003cp\u003eMetadata 462\u003c\/p\u003e \u003cp\u003eData Mining Examples 463\u003c\/p\u003e \u003cp\u003eCase Study: Categorizing Cities 463\u003c\/p\u003e \u003cp\u003eCase Study: Product Recommendations 472\u003c\/p\u003e \u003cp\u003eSummary 488\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 4 Deploying and Managing the DW\/BI System 491\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 14 Designing and Implementing Security 493\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIdentifying the Security Manager 494\u003c\/p\u003e \u003cp\u003eSecuring the Hardware and Operating System 495\u003c\/p\u003e \u003cp\u003eSecuring the Operating System 495\u003c\/p\u003e \u003cp\u003eUsing Windows Integrated Security 496\u003c\/p\u003e \u003cp\u003eSecuring the Development Environment 497\u003c\/p\u003e \u003cp\u003eSecuring the Data 498\u003c\/p\u003e \u003cp\u003eProviding Open Access for Internal Users 498\u003c\/p\u003e \u003cp\u003eItemizing Sensitive Data 500\u003c\/p\u003e \u003cp\u003eSecuring Various Types of Data Access 500\u003c\/p\u003e \u003cp\u003eSecuring the Components of the DW\/BI System 502\u003c\/p\u003e \u003cp\u003eReporting Services Security 502\u003c\/p\u003e \u003cp\u003eAnalysis Services Security 505\u003c\/p\u003e \u003cp\u003eRelational DW Security 514\u003c\/p\u003e \u003cp\u003eIntegration Services Security 520\u003c\/p\u003e \u003cp\u003eUsage Monitoring 521\u003c\/p\u003e \u003cp\u003eSummary 521\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 15 Metadata Plan 523\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eMetadata Basics 524\u003c\/p\u003e \u003cp\u003eThe Purpose of Metadata 524\u003c\/p\u003e \u003cp\u003eMetadata Categories 525\u003c\/p\u003e \u003cp\u003eThe Metadata Repository 526\u003c\/p\u003e \u003cp\u003eMetadata Standards 526\u003c\/p\u003e \u003cp\u003eSQL Server 2008 R2 Metadata 527\u003c\/p\u003e \u003cp\u003eCross-Tool Components 528\u003c\/p\u003e \u003cp\u003eRelational Engine Metadata 532\u003c\/p\u003e \u003cp\u003eAnalysis Services 532\u003c\/p\u003e \u003cp\u003eIntegration Services 533\u003c\/p\u003e \u003cp\u003eReporting Services 533\u003c\/p\u003e \u003cp\u003eMaster Data Services 534\u003c\/p\u003e \u003cp\u003eSharePoint 534\u003c\/p\u003e \u003cp\u003eExternal Metadata Sources 534\u003c\/p\u003e \u003cp\u003eLooking to the Future 535\u003c\/p\u003e \u003cp\u003eA Practical Metadata Approach 535\u003c\/p\u003e \u003cp\u003eCreating the Metadata Strategy 536\u003c\/p\u003e \u003cp\u003eBusiness Metadata Reporting 538\u003c\/p\u003e \u003cp\u003e \u003c\/p\u003e \u003cp\u003eProcess Metadata Reporting 541\u003c\/p\u003e \u003cp\u003eTechnical Metadata Reporting 542\u003c\/p\u003e \u003cp\u003eOngoing Metadata Management 543\u003c\/p\u003e \u003cp\u003eSummary 543\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 16 Deployment 545\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSetting Up the Environments 546\u003c\/p\u003e \u003cp\u003eTesting 550\u003c\/p\u003e \u003cp\u003eDevelopment Testing 551\u003c\/p\u003e \u003cp\u003eSystem Testing 555\u003c\/p\u003e \u003cp\u003eData Quality Assurance Testing 557\u003c\/p\u003e \u003cp\u003ePerformance Testing 559\u003c\/p\u003e \u003cp\u003eUsability Testing 562\u003c\/p\u003e \u003cp\u003eTesting Summary 563\u003c\/p\u003e \u003cp\u003eDeploying to Production 564\u003c\/p\u003e \u003cp\u003eRelational Database Deployment 565\u003c\/p\u003e \u003cp\u003eIntegration Services Package Deployment 567\u003c\/p\u003e \u003cp\u003eAnalysis Services Database Deployment 568\u003c\/p\u003e \u003cp\u003eReporting Services Report Deployment 571\u003c\/p\u003e \u003cp\u003eMaster Data Services Deployment 572\u003c\/p\u003e \u003cp\u003eData Warehouse and BI Documentation 573\u003c\/p\u003e \u003cp\u003eCore Descriptions 573\u003c\/p\u003e \u003cp\u003eAdditional Documentation 575\u003c\/p\u003e \u003cp\u003eUser Training 576\u003c\/p\u003e \u003cp\u003eUser Support 579\u003c\/p\u003e \u003cp\u003eDesktop Readiness and Configuration 580\u003c\/p\u003e \u003cp\u003eSummary 581\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 17 Operations and Maintenance 583\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eProviding User Support 584\u003c\/p\u003e \u003cp\u003eMaintaining the BI Portal 585\u003c\/p\u003e \u003cp\u003eExtending the BI Applications 586\u003c\/p\u003e \u003cp\u003eSystem Management 587\u003c\/p\u003e \u003cp\u003eGoverning the DW\/BI System 588\u003c\/p\u003e \u003cp\u003ePerformance Monitoring 593\u003c\/p\u003e \u003cp\u003eUsage Monitoring 600\u003c\/p\u003e \u003cp\u003eManaging Disk Space 602\u003c\/p\u003e \u003cp\u003eService and Availability Management 603\u003c\/p\u003e \u003cp\u003ePerformance Tuning the DW\/BI System 604\u003c\/p\u003e \u003cp\u003eBackup and Recovery 606\u003c\/p\u003e \u003cp\u003eExecuting the ETL Packages 611\u003c\/p\u003e \u003cp\u003eSummary 611\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 18 Present Imperatives and Future Outlook 613\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eGrowing the DW\/BI System 613\u003c\/p\u003e \u003cp\u003eLifecycle Review with Common Problems 615\u003c\/p\u003e \u003cp\u003ePhase I — ​Requirements, Realities, Plans, and Designs 616\u003c\/p\u003e \u003cp\u003ePhase II — ​Developing the Databases 616\u003c\/p\u003e \u003cp\u003ePhase III — ​Developing the BI Applications and Portal Environment 617\u003c\/p\u003e \u003cp\u003ePhase IV — ​Deploying and Managing the DW\/BI System 618\u003c\/p\u003e \u003cp\u003eIteration and Growth 618\u003c\/p\u003e \u003cp\u003eWhat We Like in the Microsoft BI Toolset 619\u003c\/p\u003e \u003cp\u003eFuture Directions: Room for Improvement 620\u003c\/p\u003e \u003cp\u003eConclusion 623\u003c\/p\u003e \u003cp\u003eIndex 625\u003c\/p\u003e  \u003cb\u003eJoy Mundy\u003c\/b\u003e is a member of the Kimball Group and has been focusing on data warehousing and business intelligence since the early 1990s.  \u003cp\u003e\u003cb\u003eWarren Thornthwaite\u003c\/b\u003e has been building decision support and data warehousing systems since 1980 and is a member of the Kimball Group.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eRalph Kimball\u003c\/b\u003e, PhD, is known worldwide as an innovator, writer, educator, speaker, and consultant in the field of data warehousing. He is the founder of the Kimball Group (www.kimballgroup.com), which provides data warehouse consulting and education.\u003c\/p\u003e  \u003cb\u003eLearn to use SQL Server 2008 R2 to build a successful data warehouse\u003c\/b\u003e  \u003cp\u003eAs the most influential thought leaders in the data warehousing and business intelligence industry, the Kimball Group has developed pioneering techniques that serve as industry standards for DW\/BI system design, development, and management. With this new edition of their bestseller, veteran experts from the Kimball Group get you up to speed with using the new Business Intelligence release of SQL Server: SQL Server 2008 R2. Covering the complete suite of data warehousing and BI tools that are part of SQL Server 2008 R2, the authors follow the full project lifecycle, including design, development, deployment, and maintenance.\u003c\/p\u003e \u003cp\u003eIn addition to a substantial update to the content of the previous edition as well as a look at the new features and functionality of SQL Server 2008 R2 such as PowerPivot and Master Data Services, this new version includes detailed examples that illustrate how to best apply the techniques described in the book. The authors share their own trial-and-error experiences of building a DW\/BI system with the Microsoft tools so that you can benefit from their challenges and successes. You'll also discover how using the Kimball Lifecycle to build your DW\/BI system encourages you to zero in on four primary principles: focus on the business, build an information infrastructure, deliver in meaningfulincrements, and deliver the entire solution. With these principles in hand, you'll be well on your way to building a successful DW\/BI system that supports business intelligence requirements common to most organizations.\u003c\/p\u003e \u003cp\u003eNo matter your role in the process of working on a DW\/BI project, The Microsoft Data Warehouse Toolkit, Second Edition shows you how to:\u003c\/p\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eFocus your efforts on the best opportunities\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eSelect, install, and configure the appropriate components of SQL Server 2008 R2 and other Microsoft products\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eDesign the dimensional model and create the database structures for the relational and Analysis Services databases\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eBuild an ETL System in Integration Services to populate the DW\/BI databases\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eBuild the BI applications and data mining models to deliver value to your organization\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eManage, secure, and grow the DW\/BI system for long-term success\u003c\/p\u003e \u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eWith SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset\u003c\/p\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47990288416997,"sku":"NP9780470640388","price":50.0,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9780470640388.jpg?v=1761787216","url":"https:\/\/k12savings.com\/es\/products\/the-microsoft-data-warehouse-toolkit-isbn-9780470640388","provider":"K12savings","version":"1.0","type":"link"}