LEADER 04551nam 2200637I 450 001 9910464823403321 005 20220207160726.0 010 $a1-118-06795-9 010 $a1-283-37456-0 010 $a9786613374561 010 $a1-118-06793-2 035 $a(CKB)3400000000021985 035 $a(EBL)661473 035 $a(OCoLC)741107251 035 $a(SSID)ssj0000539128 035 $a(PQKBManifestationID)11965843 035 $a(PQKBTitleCode)TC0000539128 035 $a(PQKBWorkID)10568043 035 $a(PQKB)10083907 035 $a(MiAaPQ)EBC661473 035 $a(CaSebORM)9780470640388 035 $a(Au-PeEL)EBL661473 035 $a(CaPaEBR)ebr10510406 035 $a(CaONFJC)MIL337456 035 $a(EXLCZ)993400000000021985 100 $a20101008d2011 uy 0 101 0 $aeng 135 $aurcn|---||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 14$aThe Microsoft data warehouse toolkit $ewith SQL server 2008 R2 and the Microsoft Business Intelligence toolset /$fJoy Mundy and Warren Thornthwaite, with Ralph Kimball 205 $a2nd edition. 210 1$aIndianapolis, IN :$cWiley,$dc2011. 215 $a1 online resource (698 pages) 300 $aIncludes index. 311 1 $a0-470-64038-3 327 $aIntroduction -- Part 1: Requirements, Realities, and Architecture -- Chapter 1. Defining Business Requirements -- Chapter 2. Designing the Business Process Dimensional Model -- Chapter 3. The Toolset -- Chapter 4. System Setup -- Part 2: Building and Populating the Databases -- Chapter 5. Creating the Relational Data Warehouse -- Chapter 6. Master Data Management -- Chapter 7. Designing and Developing the ETL System -- Chapter 8. The Core Analysis Services OLAP Database -- Chapter 9. Design Requirements for Real-Time BI -- Part 3: Developing the BI Applications -- Chapter 10: Building BI Applications in Reporting Services -- Chapter 11. Power Pivot and Excel -- Chapter 12. The BI Portal and SharePoint -- Chapter 13. Incorporating Data Mining -- Part 4: Deploying and Managing the DW/BI System -- Chapter 14: Designing and Implementing Security -- Chapter 15. Metadata Plan -- Chapter 16. Deployment -- Chapter 17. Operations and Maintenance -- Chapter 18. Present Imperatives and Future Outlook. 330 $aBest practices and invaluable advice from world-renowned data warehouse experts In 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. Features 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 Includes 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 Shares detailed case examples that clearly illustrate how to best apply the techniques described in the book The accompanying Web site contains all code samples as well as the sample database used throughout the case studies The Microsoft Data Warehouse Toolkit, Second Edition 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. 606 $aData warehousing 606 $aClient/server computing 608 $aElectronic books. 615 0$aData warehousing. 615 0$aClient/server computing. 676 $a005.7585 700 $aMundy$b Joy$f1961-$0982871 702 $aThornthwaite$b Warren$f1957- 702 $aKimball$b Ralph 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 801 2$b6680 906 $aBOOK 912 $a9910464823403321 996 $aThe Microsoft data warehouse toolkit$92585765 997 $aUNINA