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, 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(R) and Office SharePoint(R) Serverook
CONTENTS:
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 ArchitectsPart 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 StructuresPart 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 ServicesPart 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 2007About the Authors