Book description
Teach yourself to use SQL Server 2008 Analysis Services for business intelligence one step at a time. You'll start by building your understanding of the business intelligence platform enabled by SQL Server and the Microsoft Office System, highlighting the role of Analysis Services. Then, you'll create a simple multidimensional OLAP cube and progressively add features to help improve, secure, deploy, and maintain an Analysis Services database. You'll explore core Analysis Services 2008 features and capabilities, including dimension, cube, and aggregation design wizards; a new attribute relationship designer; designer AMO warnings; and using dynamic management views to monitor resources. And as you complete each lesson, you can hone your skills using the practice exercises from the companion CD. Plus, you can review and download code samples illustrating the author's own, professional techniques direct from the companion Web site.
Publisher resources
Table of contents
-
Microsoft® SQL Server® 2008 Analysis Services Step by Step
- SPECIAL OFFER: Upgrade this ebook with O’Reilly
- A Note Regarding Supplemental Files
- Acknowledgments
- Introduction
-
I. Understanding Business Intelligence and Analysis Services
- 1. Business Intelligence: A Data Analysis Foundation
- 2. Understanding OLAP and Analysis Services
- 3. Accessing Source Data
- II. Design Fundamentals
- III. Advanced Design
-
IV. Production Management
- 14. Managing Partitions and Database Processing
- 15. Managing Deployment
- 16. Advanced Monitoring and Management Tools
- About the Author
- Index
- SPECIAL OFFER: Upgrade this ebook with O’Reilly
Product information
- Title: Microsoft® SQL Server® 2008 Analysis Services Step by Step
- Author(s):
- Release date: April 2009
- Publisher(s): Microsoft Press
- ISBN: 9780735626201
You might also like
book
AWS Certified Solutions Architect Official Study Guide
Validate your AWS skills. This is your opportunity to take the next step in your career …
book
Building a Scalable Data Warehouse with Data Vault 2.0
The Data Vault was invented by Dan Linstedt at the U.S. Department of Defense, and the …
book
Head First Design Patterns, 2nd Edition
You know you don’t want to reinvent the wheel, so you look to design patterns—the lessons …
book
Python Crash Course, 2nd Edition
This is the second edition of the best selling Python book in the world. Python Crash …