Book 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
Table of contents
- Foreword
- Acknowledgments
-
Introduction
- Who This Book Is For
-
What This Book Is About
- Part I, “Business Intelligence for Business Decision Makers and Architects”
- Part II, “Microsoft SQL Server 2008 Analysis Services for Developers”
- Part III, “Microsoft SQL Server 2008 Integration Services for Developers”
- Part IV, “Microsoft SQL Server Reporting Services and Other Client Interfaces for Business Intelligence”
- Prerelease Software
- Hardware and Software Requirements
- Find Additional Content Online
- Support for This Book
-
I. Business Intelligence for Business Decision Makers and Architects
- 1. Business Intelligence Basics
-
2. Visualizing Business Intelligence Results
- Matching Business Cases to BI Solutions
- Understanding Business Intelligence from a User’s Perspective
- Elements of a Complete BI Solution
- Common Business Challenges and BI Solutions
- Measuring the ROI of BI Solutions
- Summary
- 3. Building Effective Business Intelligence Processes
- 4. Physical Architecture in Business Intelligence Solutions
- 5. Logical OLAP Design Concepts for Architects
-
II. Microsoft SQL Server 2008 Analysis Services for Developers
- 6. Understanding SSAS in SSMS and SQL Server Profiler
- 7. Designing OLAP Cubes Using BIDS
- 8. Refining Cubes and Dimensions
- 9. Processing Cubes and Dimensions
- 10. Introduction to MDX
- 11. Advanced MDX
-
12. Understanding Data Mining Structures
- Reviewing Business Scenarios
- Working in the BIDS Data Mining Interface
- Data Mining Algorithms
- The Art of Data Mining
- Summary
- 13. Implementing Data Mining Structures
-
III. Microsoft SQL Server 2008 Integration Services for Developers
- 14. Architectural Components of Microsoft SQL Server 2008 Integration Services
- 15. Creating Microsoft SQL Server 2008 Integration Services Packages with Business Intelligence Development Studio
- 16. Advanced Features in Microsoft SQL Server 2008 Integration Services
- 17. Microsoft SQL Server 2008 Integration Services Packages in Business Intelligence Solutions
- 18. Deploying and Managing Solutions in Microsoft SQL Server 2008 Integration Services
- 19. Extending and Integrating SQL Server 2008 Integration Services
-
IV. Microsoft SQL Server Reporting Services and Other Client Interfaces for Business Intelligence
- 20. Creating Reports in SQL Server 2008 Reporting Services
- 21. Building Reports for SQL Server 2008 Reporting Services
- 22. Advanced SQL Server 2008 Reporting Services
- 23. Using Microsoft Excel 2007 as an OLAP Cube Client
- 24. Microsoft Office 2007 as a Data Mining Client
- 25. SQL Server Business Intelligence and Microsoft Office SharePoint Server 2007
- A. About the Authors
- Index
- About the Authors
- Copyright
Product information
- Title: Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008
- Author(s):
- Release date: February 2009
- Publisher(s): Microsoft Press
- ISBN: 9780735625808
You might also like
book
Microsoft® SQL Server® 2008 Step by Step
Teach yourself SQL Server 2008—one step at a time. Get the practical guidance you need to …
book
Foundations of SQL Server 2005 Business Intelligence
Just as every business needs to effectively employ business intelligence (BI) to stay competitive, every IT …
book
MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide
This ebook does not provide access to the CD-ROM files. Covering Microsoft's brand-new SQL 2005 administrator …
book
Microsoft® SQL Server® 2008 For Dummies®
If you’re a database administrator, you know Microsoft SQL Server 2008 is revolutionizing database development. Get …