The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset
This groundbreaking book is the first in the Kimball Toolkit series to be product-specific. Microsoft’s BI toolset has undergone significant changes in the SQL Server 2005 development cycle. SQL Server 2005 is the first viable, full-functioned data warehouse and business intelligence platform to be offered at a price that will make data warehousing and business intelligence available to a broad set of organizations. This book is meant to offer practical techniques to guide those organizations...
Search in google:
As longtime data warehousing practitioners and former Microsoft insiders, authors Joy Mundy and Warren Thornthwaite have extensive experience in building and managing data warehouse (DW) and business intelligence (BI) systems. With this book, they share best practices for using SQL Server 2005 to build a successful DW/BI system. Covering the complete suite of data warehousing tools that accompanies SQL Server 2005, they focus on the full project lifecycle, including design, development, deployment, and maintenance.You'll learn how and when to use BI tools such as Analysis Services, Integration Services, and the SQL Server database to accomplish various data warehousing tasks. A helpful case study used throughout the book provides examples of the techniques presented. You'll find practical guidance for every member of the data warehouse team and learn how to:Identify high-value business requirements and build organizational support for the projectDesign an information infrastructure for the enterprise using established dimensional design Design and build a flexible and powerful ETL system to clean, align, and restructure data for business useProvide decision makers with tools to analyze business problems and opportunitiesUse data mining to uncover data relationships and trendsBuild BI applications in Reporting ServicesMaintain, secure, and operate the DW/BI systemVisit the companion Web site at www.wiley.com/go/MsftDWToolkitThe companion Web site contains all the code samples, the sample database used throughout, sample templates, and other job aids.
Ch. 1Defining business requirements3Ch. 2Designing the business process dimensional model39Ch. 3The toolset107Ch. 4Setup and physical design129Ch. 5Designing the ETL system177Ch. 6Developing the ETL system221Ch. 7Designing the analysis services OLAP database289Ch. 8Business intelligence applications353Ch. 9Building the BI application in reporting services379Ch. 10Incorporating data mining419Ch. 11Working with an existing data warehouse483Ch. 12Security499Ch. 13Metadata plan541Ch. 14Deployment573Ch. 15Operations and maintenance615Ch. 16Managing growth659Ch. 17Real-time business intelligence675Ch. 18Present imperatives and future outlook707
![SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]](/application/data/covers/44/31/9780321444431.jpg "SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]")
