View Larger Image	Lynn Langit Apress, Paperback, Published April 2007, 416 pages, ISBN 1590598342
	List Price: $49.99 Our Price: $30.50 You Save: $19.49 (39% Off)
	Availability: In-Stock

Download excerpts: Chapter 1: What is Business Intelligence? Table of Contents Excerpt provided courtesy of Apress. Copyright © Apress, Inc. Written permission from the publisher is required for any use of this material.

Write a Review and tell the world about this title!

People who purchase this book frequently purchase:

• Building a Data Warehouse: With Examples in SQL Server; Vincent Rainardi, $45.95, 23% Off!
• Microsoft SQL Server 2005 Administrator's Companion; Edward Whalen, et al, $37.50, 37% Off!
• Microsoft SQL Server 2005 Analysis Services Step by Step; Hitachi Consulting Services, et al, $24.95, 38% Off!
• Pro SQL Server 2005 Integration Services; James Wightman, $30.50, 39% Off!

• Databases : Microsoft SQL Server
• Databases : SQL
• Databases : SQL Server 2005
• Enterprise Computing : Business Intelligence

• Apress

Just as every business needs to effectively employ Business Intelligence (BI) to stay competitive, every IT professional needs to master BI to stay employed in this fastest-growing segment of Information Technology. Foundations of SQL Server 2005 Business Intelligence is the quickest path to understanding BI, and it is essential reading for all who work with SQL Server 2005. It is written from a practical perspective, perfect for anyone who uses the tools in SQL Server 2005’s extraordinarily rich BI product suite.

This book explains how best to use Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, and SQL Server Data Mining. It also describes best practices for implementing end-to-end BI solutions in small, medium, and large business environments. And it provides important information about integrating BI with various client tools, including Excel, Business Scorecards, Proclarity, and SharePoint Portal Server. Developers, end users, and even managers will find this an enlightening guide to the power and promise of SQL Server 2005 BI. Highlights include the following:

* Comprehensive coverage of all aspects of the SQL Server 2005 BI tool suite
* Concise, yet thorough, so you can use all BI tools effectively
* Special focus on features to use—and avoid—to cleanly scale BI solutions
* Full of sound, practical guidance on real-world best practices
* Essential reading for developers and users with any level of BI experience

Table of Contents

About the Author . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii
About the Technical Reviewer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv
Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii
Chapter 1 What Is Business Intelligence? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
Chapter 2 OLAP Modeling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
Chapter 3 Introducing SSIS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51
Chapter 4 Using SSAS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73
Chapter 5 Intermediate OLAP Modeling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95
Chapter 6 Advanced OLAP Modeling . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113
Chapter 7 Cube Storage and Aggregation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 133
Chapter 8 Intermediate SSIS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 159
Chapter 9 Advanced SSIS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 197
Chapter 10 Introduction to MDX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 219
Chapter 11 Introduction to Data Mining . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 243
Chapter 12 Reporting Tools. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 277
Chapter 13 SSAS Administration. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 305
Chapter 14 Integration with Office 2007 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 329
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 369

About the Author

Lynn Langit is the founder and lead architect of WebFluent, which for the past six years has trained users and developers in building BI solutions. A holder of numerous Microsoft certifications, including MCT, MCITP, MCDBA, MCSD.NET, MCSE, and MSF, she also has ten years’ experience in business management. This unique background makes her particularly qualified to share her expertise in developing successful real-world BI solutions using SQL Server 2005.

Jun 27, 2008     John from usa
Knows her stuff, poorly written
I got through the first four chapters when I realized that this book wasn't helping me learn SSAS & business intelligence tools. I _think_ the author knows her stuff, but her writing is not at all clear. I'm still not clear on what a "fact" table is as opposed to a "dimension" table. The hands-on example were also very poor, and instructions often left out steps necessary to follow along.

Forgot your password? FAQs Shipping Options Returns Your Orders Your Account