Book

Amazon links by country

Description

Amazon US

Amazon UK

Amazon Canada

MDX Solutions: With Microsoft SQL ServerTM Analysis Services 2005 and Hyperion Essbase, 2nd Edition, by George Spofford, Sivakumar Harinath, Christopher Webb

Serving as both a tutorial and a reference guide to the MDX (Multidimensional Expressions) query language, this book shows data warehouse developers what they need to know to build effective multidimensional data warehouses After a brief overview of the MDX language and a look at how it is used to access data in sophisticated, multidimensional databases and data warehousing, the authors move directly to providing practical examples of MDX in use New material covers changes in the MDX language itself as well as major changes in its implementation with the latest software releases of Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase Also covers more advanced techniques, like aggregation, query templates, and MDX optimization, and shows users what they need to know to access and analyze data to make better business decisions.

Note from ssas-info.com: Must have book for anyone learning MDX.

Amazon US

Amazon UK

Amazon Canada

Fast Track to MDX, by Mark Whitehorn, Robert Zare, Mosha Pasumansky

Fast Track to MDX gives you all the necessary background to let you write useful, powerful MDX expressions and introduces the most frequently used MDX functions and constructs. No prior knowledge is assumed and examples are used throughout the book to rapidly develop your MDX skills to the point where you can solve real business problems.

Note from ssas-info.com: Altough this book for for learning MDX in Analysis Services 2000, I still recommend to buy it. It will give you good background on MDX language.

Amazon US

Amazon UK

Amazon Canada

Microsoft SQL Server 2005 Analysis Services, by Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman

Microsoft SQL Server 2005 Analysis Services is definitive guide to programming Analysis Services 2005. It will give you unparalleled insight into the ways in which Analysis Services functions straight from the members of the Analysis Services team at Microsoft . It not only explains ways to use Analysis Services 2005 to design and create multidimensional objects, databases, dimensions, cubes, but it also provides invaluable information about the reasons behind design decision taken by the development team.

Note from ssas-info.com: Highly recommended.

Amazon US

Amazon UK

Amazon Canada

Professional SQL ServerTM Analysis Services 2005 with MDX, by Sivakumar Harinath, Stephen R. Quinn

Written by members of the Analysis Services product team at Microsoft, this timely and authoritative book shows you how to use Analysis Services along with SQL Server components like Integration Services, Data Mining, and Reporting Services to provide comprehensive, end-to-end solutions. Ultimately you'll learn to solve business problems by leveraging all the tools that SQL Server 2005 has to offer.

Amazon US

Amazon UK

Amazon Canada

Applied Micrisoft Analysis Services 2005 shows database administrators and developers how to build complete OLAP solutions with Microsoft Analysis Services 2005 and Microsoft Business Intelligence Platform. Database administrators will learn how to design and manage sophisticated OLAP cubes that provide rich data analytics and data mining services.

The book gives developers the necessary background to extend UDM with custom programming logic, in the form of MDX expressions, scripts and .NET code. It teaches them how to implement a wide range of reporting applications that integrate with Analysis Services, Reporting Services, and Microsoft Office.

This book doesn't assume any prior experience with OLAP and Microsoft Analysis Services. It is designed as an easy-to-follow guide where each chapter builds upon the previous to implement the components of the innovative Unified Dimensional Model (UDM) in a chronological order. New concepts are introduced with step-by-step instructions and hands-on demos.

Amazon US

Amazon UK

Amazon Canada

Microsoft SQL Server 2005 Analysis Services by Reed Jacobson, Stacia Misner, Hitachi Consulting

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. A companion CD includes data sets and sample code.

Amazon US

Amazon UK

Amazon Canada

Delivering Business Intelligence with Microsoft SQL Server 2005 by Brian Larson

Put timely, mission-critical information in the hands of employees across your organization using Microsoft SQL Server 2005 and the comprehensive information in this unique resource. Delivering Business Intelligence with Microsoft SQL Server 2005 shows you, step-by-step, how to author, customize, and distribute information that will give your company the competitive edge. It's all right here--from data mining, warehousing, and scripting techniques to MDX queries, KPI analysis, and the all-new Unified Dimensional Model. Real-world examples, start-to-finish exercises, and downloadable code throughout illustrate all of the integration, analysis, and reporting capabilities of SQL Server 2005.

Amazon US

Amazon UK

Amazon Canada

The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset by Joy Mundy, Warren Thornthwaite

Microsoft’s BI toolset has undergone significant changes in the SQL Server 2005 development cycle. SQL Server 2005 is the first viable, full-functioned data warehouse and business intelligence platform to be offered at a price that will make data warehousing and business intelligence available to a broad set of organizations. This book is meant to offer practical techniques to guide those organizations through the myriad of challenges to true success as measured by contribution to business value.

Building a data warehousing and business intelligence system is a complex business and engineering effort. While there are significant technical challenges to overcome in successfully deploying a data warehouse, the authors find that the most common reason for data warehouse project failure is insufficient focus on the business users and business problems. In an effort to help people gain success, this book takes the proven Business Dimensional Lifecycle approach first described in best selling The Data Warehouse Lifecycle Toolkit and applies it to the Microsoft SQL Server 2005 tool set.

Beginning with a thorough description of how to gather business requirements, the book then works through the details of creating the target dimensional model, setting up the data warehouse infrastructure, creating the relational atomic database, creating the analysis services databases, designing and building the standard report set, implementing security, dealing with metadata, managing ongoing maintenance and growing the DW/BI system. All of these steps tie back to the business requirements. Each chapter describes the practical steps in the context of the SQL Server 2005 platform.

Note from ssas-info.com: I would say this is a must have book for the person who is responsible for designing architecture of data warehouse using Microsoft technologies and for anyone who wants to know how to do that.

Review by Greg Low (SQL MVP)

Book

Amazon links by country

Description

Amazon US

Amazon UK

Amazon Canada

MCTS Self-Paced Training Kit (Exam 70-445): Microsoft SQL Server(TM) 2005 Business Intelligence Implementation and Maintenance (Pro - Certification) , by Erik Veerman (Author), Dejan Sarka (Author), Javier Loria (Author)

Announcing an all-new Self-Paced Training Kit designed to help maximize your performance on 70-445, the required exam for the new Microsoft Certified Technology Specialist (MCTS): SQL Server 2005 Business Intelligence certification. This 2-in-1 kit includes the official Microsoft study guide, plus practice tests on CD to help you assess your skills. It comes packed with the tools and features exam candidates want most--including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and customizable testing options. It also provides real-world scenarios, case study examples, and troubleshooting labs for skills and expertise that you can apply to the job.

Key Book Benefits:

• In-depth coverage of exam objectives and sub-objectives--plus instructive case studies and troubleshooting scenarios to enhance your performance on the job
• 200+ practice and review questions
• Test engine that enables customized testing, pre-assessment and post-assessment, and automated scoring and feedback
• Complete objective-by-objective review section, plus a handy exam-mapping grid
• 180-day evaluation version of SQL Server 2005 Enterprise Edition
• 15 percent exam discount voucher from Microsoft (limited-time offer)
• Entire study guide in searchable eBook format