Synopses & Reviews
Your hands-on, practical guide to Microsoft SQL ServerTM 2005 Analysis Services. Get started using Business Intelligence tools that simplify data analysis and with this popular, learn-by-doing tutorial. Includes data sets and sample code on CD. 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.
Teach yourself the fundamentals of SQL Server Analysis Services—one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to build flexible and powerful solutions that meet the analytical needs of your organization.
Discover how to:
- Start building cubes using the Microsoft Visual Studio 2005 Business Intelligence designers
- Create dimensions and measure groups to build, browse, and modify OLAP cubes
- Design objects to handle unique financial analysis requirements
- Improve query performance with aggregations and user hierarchies
- Customize cubes with multi-dimensional expressions (MDX) and other advanced design techniques
- Use actions to integrate Web pages, reporting applications, and drillthrough capabilities with cubes
- Manage role-based security and restrict data access
- Deploy and maintain a database in a production environment
- All practice exercises and answer files
- Fully searchable eBook
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
About the Author
Reed Jacobson is a senior architect in Hitachi Consultings Business Intelligence practice. He has authored several training courses and books, including Microsoft SQL Server 2000 Analysis Services Step by Step.
Hitachi Consulting, a division of Hitachi Ltd., is a global business and IT consulting firm serving Fortune 2000 companies. It is a leader in developing corporate training and custom solutions for Reporting Services
Stacia Misner, MCITP, MCTS, is a consultant and trainer specializing in Microsoft business intelligence solutions. She has more than 20 years of IT experience and has written several books on SQL Server, including Microsoft SQL Server 2008 Reporting Services Step by Step. Stacia is also one of the first to earn the new SQL Server Analysis Services Maestro certification.
Table of Contents
Introduction; Finding Your Best Starting Point; About the Companion CD-ROM; System Requirements; Installing and Using the Sample Files; Conventions and Features in This Book; Part I: Getting Started with Analysis Services; Chapter 1: Understanding Business Intelligence and Data Warehousing; Introducing Business Intelligence; Reviewing Data Warehousing Concepts; Chapter 1 Quick Reference; Chapter 2: Understanding OLAP and Analysis Services; Understanding OLAP; Understanding Analysis Services; Chapter 2 Quick Reference; Chapter 3: Building Your First Cube; Exploring Business Intelligence Development Studio; Preparing to Create a Cube; Creating a Cube; Generating a Schema; Processing and Browsing a Cube; Chapter 3 Quick Reference; Part II: Design Fundamentals; Chapter 4: Designing Dimensions; Reviewing the Data Warehouse Structure; Building a Standard Dimension; Working with a Time Dimension; Creating a Parent-Child Dimension; Chapter 4 Quick Reference; Chapter 5: Designing Measure Groups and Measures; Adding Measure Groups to a Cube; Aggregating Semiadditive Measures; Calculating Distinct Counts; Creating Simple Calculations; Chapter 5 Quick Reference; Chapter 6: Working with a Finance Measure Group; Designing an Account Dimension; Designing Nonadditive Financial Measures; Chapter 6 Quick Reference; Chapter 7: Designing Aggregations and Hierarchies; Understanding Aggregation Design; Designing User Hierarchies; Optimizing Aggregations; Chapter 7 Quick Reference; Part III: Advanced Design; Chapter 8: Using MDX; Creating Tuple-Based Calculated Members; Querying with MDX; Designing Custom Members; Working with MDX Scripts; Developing Key Performance Indicators; Chapter 8 Quick Reference; Chapter 9: Exploring Special Features; Defining Dimension Relationships; Supporting Currency Conversions; Localizing Cubes; Organizing Information with Folders and Perspectives; Chapter 9 Quick Reference; Chapter 10: Interacting with Cubes; Implementing Actions; Using Writeback; Chapter 10 Quick Reference; Part IV: Production Management; Chapter 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; Chapter 12: Managing Partitions and Database Processing; Managing Very Large Databases; Working with Storage; Managing OLAP Processing; Monitoring Cube Activity; Chapter 12 Quick Reference; Chapter 13: Managing Deployment; Reviewing Deployment Options; Managing Database Objects Programmatically; Automating Database Processing; Planning for Disaster and Recovery; Chapter 13 Quick Reference; Glossary; Appendix : About the Authors; Contributing Authors;