Your hands-on guide to learning Microsoft SQL Server Analysis Services, Microsofts customizable analysis solution for business data modeling and interpretation. Analysis Services is a powerful tool for business intelligence, so understanding the essentialshow to create a cube, as well as how to deploy, customize, and extend the basic calculationsis 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 youre a beginning programmer or new to this version of the technology, youll understand the fundamental techniques for using Analysis Services.
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 progres…
Teach yourself the Multidimensional Expressions (MDX) query language one step at a time. With this practical, learn-by-doing tutorial, you ll build the core techniques for using MDX with Analysis Services to deliver high-performance business intelligence solutions. Discover how to: Construct and execute MDX queries Work with tuples, sets, and expre…
Marco Russo, Alberto Ferrari, and Chris Webb, Packt Publishing, 2009
Design and implement fast, scalable and maintainable cubes * A real-world guide to designing cubes with Analysis Services 2008 * Model dimensions and measure groups in BI Development Studio * Implement security, drill-through, and MDX calculations * Learn how to deploy, monitor, and performance-tune your cube * Filled with best practices and usefu…
Jeremy Kashel, Martyn Bullerwell, Packt Publishing, 2011
This is a practical, step-by-step guide to managing and maintaining your master data and improving data quality with Microsoft SQL Server 2008 R2 Master Data Services, with practical examples on how to use each feature. If you are a business and systems analyst or database administrator who wants to manage and maintain your business master data and…
Transform Raw Data Into Meaningful Business Intelligence with SSIS. Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclus…