Book description
Your hands-on guide to learning Microsoft SQL Server Analysis Services, Microsoft’s customizable analysis solution for business data modeling and interpretation. Analysis Services is a powerful tool for business intelligence, so understanding the essentials—how to create a cube, as well as how to deploy, customize, and extend the basic calculations—is critical to harnessing the full benefits of SQL Server. This step-by-step tutorial shows you how to get started, how to build scalable analytical applications, and how to use and administer advanced features. Interactivity features (enhanced in SQL Server 2005), data translation, and security are also covered in detail. With STEP BY STEP, you work at your own pace through hands-on, learn-by-doing exercises. Whether you’re a beginning programmer or new to this version of the technology, you’ll understand the fundamental techniques for using Analysis Services. A companion CD includes data sets and sample code.
Publisher resources
Table of contents
- Microsoft® SQL Server™ 2005 Analysis Services Step by Step
- A Note Regarding Supplemental Files
- Introduction
-
I. Getting Started with Analysis Services
- 1. Understanding Business Intelligence and Data Warehousing
- 2. Understanding OLAP and Analysis Services
- 3. Building Your First Cube
-
II. Design Fundamentals
- 4. Designing Dimensions
- 5. Designing Measure Groups and Measures
- 6. Working with a Finance Measure Group
- 7. Designing Aggregations and Hierarchies
-
III. Advanced Design
- 8. Using MDX
- 9. Exploring Special Features
- 10. Interacting with Cubes
-
IV. Production Management
-
11. Implementing Security
- Using Role-Based Security
- Applying Security to a Dimension
- Securing Data at the Cell Level
- Setting Administration Security
- Chapter 11 Quick Reference
- 12. Managing Partitions and Database Processing
- 13. Managing Deployment
-
11. Implementing Security
- Glossary
- About the Authors
- Index
- About the Authors
- Copyright
Product information
- Title: Microsoft® SQL Server™ 2005 Analysis Services Step by Step
- Author(s):
- Release date: March 2006
- Publisher(s): Microsoft Press
- ISBN: 9780735621992
You might also like
book
Relational Database Design and Implementation, 3rd Edition
Fully revised, updated, and expanded, Relational Database Design and Implementation, Third Edition is the most lucid …
book
Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition
The fast-answers, daily administration guide to SQL Server® 2008 (updated for R2). This pocket-sized guide from …
book
Microsoft SQL Server 2012 Internals
Dive deep inside the architecture of SQL Server 2012 Explore the core engine of Microsoft SQL …
book
MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442)
All-in-One is All You Need Get complete coverage of all three Microsoft Certified IT Professional database …