Foundations of SQL Server 2005 Business Intelligence (Google eBook)

Front Cover
Apress, Apr 24, 2007 - Computers - 396 pages
0 Reviews

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.

  

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

What Is Business Intelligence?
1
OLAP Modeling
25
Introducing SSIS
51
Using SSAS
73
Intermediate OLAP Modeling
95
Advanced OLAP Modeling
113
Cube Storage and Aggregation
133
Intermediate SSIS
159
Advanced SSIS
197
Introduction to MDX
219
Introduction to Data Mining
243
Reporting Tools
277
SSAS Administration
305
Integration with Office 2007
329
Index
369
Copyright

Common terms and phrases

Popular passages

Page 17 - PivotTable and PivotChart Wizard - Layout | | Construct your PivotTable report by dragging the field buttons on the right to the diagram on the left.
Page 16 - Data fields have been retrieved. To use an Office Data Connection (.ode) file, click cancel and then use the Import Data command (Data menu. Import External Data submenu) to open the file.

About the author (2007)

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

Bibliographic information