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.
Microsoft SQL Server 2008 Analysis Services is the multidimensional online analytical processing (OLAP) component of Microsoft SQL Server 2008 that integrates relational and OLAP data for business intelligence (BI) analytical solutions. The goal of this book is to show you how to use the tools and features of Analysis Services so you can easily create, manage, and share OLAP cubes within your organization. Step-by-step exercises are included to prepare you for developing your own BI solutions.
This book covers the full life cycle of an Analysis Services solution from development to deployment. If you're responsible only for certain activities, you can choose to read the chapters that apply to your situation and skip the remaining chapters. Use the following table to find your best starting point.
Book Details
- Paperback: 448 pages
- Publisher: Microsoft Press; 1 edition (April 15, 2009)
- Language: English
- ISBN-10: 0735626200
- ISBN-13: 978-0735626201
- File Size: 13.9 MiB
- Hits: 2,425 times
