Smart Business Intelligence Solutions with Microsoft SQL Server 2008
Published on 4. February 2009
Book
Paperback/Softback
800 pages
978-0-7356-2580-8 (ISBN)
Description
Get the end-to-end instruction you need to design, develop, and deploy more effective data integration, reporting, and analysis solutions using SQL Server 2008-whether you're new to business intelligence (BI) programming or a seasoned pro. With real-world examples and insights from an expert team, you'll master the concepts, tools, and techniques for building solutions that deliver intelligence-and business value-exactly where users want it.
Discover how to:
Manage the development life cycle and build a BI team
Dig into SQL Server Analysis Services, Integration Services, and Reporting Services
Navigate the Business Intelligence Development Studio (BIDS)
Write queries that rank, sort, and drill down on sales data
Develop extract, transform, and load (ETL) solutions
Add a source code control system
Help secure packages for deployment via encryption and credentials
Use MDX and DMX Query Designers to build reports based on OLAP cubes and data mining models
Create and implement custom objects using .NET code
View reports in Microsoft Office Excel and Office SharePoint Serverook
Discover how to:
Manage the development life cycle and build a BI team
Dig into SQL Server Analysis Services, Integration Services, and Reporting Services
Navigate the Business Intelligence Development Studio (BIDS)
Write queries that rank, sort, and drill down on sales data
Develop extract, transform, and load (ETL) solutions
Add a source code control system
Help secure packages for deployment via encryption and credentials
Use MDX and DMX Query Designers to build reports based on OLAP cubes and data mining models
Create and implement custom objects using .NET code
View reports in Microsoft Office Excel and Office SharePoint Serverook
More details
Language
English
Place of publication
Redmond
United States
Target group
Professional and scholarly
Dimensions
Height: 229 mm
Width: 187 mm
ISBN-13
978-0-7356-2580-8 (9780735625808)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Persons
Davide Mauri, MCP, MCAD, MCDBA, MCT, is a Microsoft MVP who has worked with SQL Server since version 6.5.
Content
Foreword
Acknowledgments
Introduction
Part I: Business Intelligence for Business Decision Makers and Architects
Chapter 1: Business Intelligence Basics
Chapter 2: Visualizing Business Intelligence Results
Chapter 3: Building Effective Business Intelligence Processes
Chapter 4: Physical Architecture in Business Intelligence Solutions
Chapter 5: Logical OLAP Design Concepts for Architects
Part II: Microsoft SQL Server 2008 Analysis Services for Developers
Chapter 6: Understanding SSAS in SSMS and SQL Server Profiler
Chapter 7: Designing OLAP Cubes Using BIDS
Chapter 8: Refining Cubes and Dimensions
Chapter 9: Processing Cubes and Dimensions
Chapter 10: Introduction to MDX
Chapter 11: Advanced MDX
Chapter 12: Understanding Data Mining Structures
Chapter 13: Implementing Data Mining Structures
Part III: Microsoft SQL Server 2008 Integration Services for Developers
Chapter 14: Architectural Components of Microsoft SQL Server 2008 Integration Services
Chapter 15: Creating Microsoft SQL Server 2008 Integration Services Packages with Business Intelligence Development Studio
Chapter 16: Advanced Features in Microsoft SQL Server 2008 Integration Services
Chapter 17: Microsoft SQL Server 2008 Integration Services Packages in Business Intelligence Solutions
Chapter 18: Deploying and Managing Solutions in Microsoft SQL Server 2008 Integration Services
Chapter 19: Extending and Integrating SQL Server 2008 Integration Services
Part IV: Microsoft SQL Server Reporting Services and Other Client Interfaces for Business Intelligence
Chapter 20: Creating Reports in SQL Server 2008 Reporting Services
Chapter 21: Building Reports for SQL Server 2008 Reporting Services
Chapter 22: Advanced SQL Server 2008 Reporting Services
Chapter 23: Using Microsoft Excel 2007 as an OLAP Cube Client
Chapter 24: Microsoft Office 2007 as a Data Mining Client
Chapter 25: SQL Server Business Intelligence and Microsoft Office SharePoint Server 2007
About the Authors
Acknowledgments
Introduction
Part I: Business Intelligence for Business Decision Makers and Architects
Chapter 1: Business Intelligence Basics
Chapter 2: Visualizing Business Intelligence Results
Chapter 3: Building Effective Business Intelligence Processes
Chapter 4: Physical Architecture in Business Intelligence Solutions
Chapter 5: Logical OLAP Design Concepts for Architects
Part II: Microsoft SQL Server 2008 Analysis Services for Developers
Chapter 6: Understanding SSAS in SSMS and SQL Server Profiler
Chapter 7: Designing OLAP Cubes Using BIDS
Chapter 8: Refining Cubes and Dimensions
Chapter 9: Processing Cubes and Dimensions
Chapter 10: Introduction to MDX
Chapter 11: Advanced MDX
Chapter 12: Understanding Data Mining Structures
Chapter 13: Implementing Data Mining Structures
Part III: Microsoft SQL Server 2008 Integration Services for Developers
Chapter 14: Architectural Components of Microsoft SQL Server 2008 Integration Services
Chapter 15: Creating Microsoft SQL Server 2008 Integration Services Packages with Business Intelligence Development Studio
Chapter 16: Advanced Features in Microsoft SQL Server 2008 Integration Services
Chapter 17: Microsoft SQL Server 2008 Integration Services Packages in Business Intelligence Solutions
Chapter 18: Deploying and Managing Solutions in Microsoft SQL Server 2008 Integration Services
Chapter 19: Extending and Integrating SQL Server 2008 Integration Services
Part IV: Microsoft SQL Server Reporting Services and Other Client Interfaces for Business Intelligence
Chapter 20: Creating Reports in SQL Server 2008 Reporting Services
Chapter 21: Building Reports for SQL Server 2008 Reporting Services
Chapter 22: Advanced SQL Server 2008 Reporting Services
Chapter 23: Using Microsoft Excel 2007 as an OLAP Cube Client
Chapter 24: Microsoft Office 2007 as a Data Mining Client
Chapter 25: SQL Server Business Intelligence and Microsoft Office SharePoint Server 2007
About the Authors