Book description
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.
Table of contents
- About the Author
- About the Technical Reviewer
- Acknowledgments
- 1. What Is Business Intelligence?
- 2. OLAP Modeling
- 3. Introducing SSIS
- 4. Using SSAS
- 5. Intermediate OLAP Modeling
- 6. Advanced OLAP Modeling
- 7. Cube Storage and Aggregation
-
8. Intermediate SSIS
- General ETL Package-Design Best Practices
- Creating the SSIS Package from Scratch
- Reviewing the Included Samples Packages
- Adding Control Flow Tasks
- Understanding Data Flow Transformations
- Adding Transformations to the Data Flow
- Adding Data Transformations
- Using the Dynamic Package Configuration Wizard
- Summary
- 9. Advanced SSIS
- 10. Introduction to MDX
- 11. Introduction to Data Mining
-
12. Reporting Tools
- Using Excel 2003: Pivot Charts and More
- Using SQL Server Reporting Services (SSRS)
- Producing Reports with Report Builder
- Working with .NET 2.0 Report Viewer Controls
- Understanding SharePoint 2003 Web Parts
- Examining Business Scorecard Manager (BSM) 2005
- Considering ProClarity and Data Mining Clients
- Summary
- 13. SSAS Administration
- 14. Integration with Office 2007
Product information
- Title: Foundations of SQL Server 2005 Business Intelligence
- Author(s):
- Release date: April 2007
- Publisher(s): Apress
- ISBN: 9781590598344
You might also like
book
Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition
Foundations of SQL Server 2008 R2 Business Intelligence introduces the exciting gamut of business intelligence tools …
book
Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008
Get the end-to-end instruction you need to design, develop, and deploy more effective data integration, reporting, …
book
Microsoft® SQL Server® 2008 Integration Services: Problem-Design-Solution
An authoritative guide to designing effective solutions for data cleansing, ETL, and file management with SQL …
book
Professional Microsoft® SQL Server® 2008 Administration
SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, …