Foundations of SQL Server 2005 Business Intelligence

1. Front Matter

   Pages i-xvii

   PDF

2. What is Business Intelligence?

   Pages 1-24

3. OLAP Modeling

   Pages 25-49

4. Introducing SSIS

   Pages 51-71

5. Using SSAS

   Pages 73-93

6. Intermediate OLAP Modeling

   Pages 95-112

7. Advanced OLAP Modeling

   Pages 113-132

8. Cube Storage and Aggregation

   Pages 133-158

9. Intermediate SSIS

   Pages 159-196

10. Advanced SSIS

    Pages 197-217

11. Introduction to MDX

    Pages 219-242

12. Introduction to Data Mining

    Pages 243-276

13. Reporting Tools

    Pages 277-304

14. SSAS Administration

    Pages 305-328

15. Integration with Office 2007

    Pages 329-367

16. Back Matter

    Pages 369-396

    PDF

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 2005s 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.

• SQL
• data mining
• design
• development
• modeling
• structured analysis

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

Policies and ethics