MDX Books

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.

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.

Applied Microsoft Analysis Services 2005 : And Microsoft Business Intelligence Platform by Teo Lachev

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.

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.

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.

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)

Foundation of SQL Server 2005 Business Intelligence

Foundations of SQL Server 2005 Business Intelligence by Lynn Langit

Just as every business needs to effectively employ Business Intelligence (BI) to stay competitive, every IT professional needs to master BI to stay employed in this fastest-growing segment of Information Technology. Foundations of SQL Server 2005 Business Intelligence is the quickest path to understanding BI, and it is essential reading for all who work with SQL Server 2005. It is written from a practical perspective, perfect for anyone who uses the tools in SQL Server 2005s extraordinarily rich BI product suite.

This book explains how best to use Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, and SQL Server Data Mining. It also describes best practices for implementing end-to-end BI solutions in small, medium, and large business environments. And it provides important information about integrating BI with various client tools, including Excel, Business Scorecards, Proclarity, and SharePoint Portal Server. Developers, end users, and even managers will find this an enlightening guide to the power and promise of SQL Server 2005 BI. Highlights include the following:

Comprehensive coverage of all aspects of the SQL Server 2005 BI tool suite
Concise, yet thorough, so you can use all BI tools effectively
Special focus on features to useand avoidto cleanly scale BI solutions
Full of sound, practical guidance on real-world best practices
Essential reading for developers and users with any level of BI experience

Practical Business Intelligence with SQL Server 2005 image

Practical Business Intelligence with SQL Server 2005 by John C. Hancock and Roger Toren

In this book, two of Microsoft’s leading consultants illustrate how to use SQL Server 2005 Business Intelligence (BI) technologies to solve real-world problems in markets ranging from retail and finance to healthcare. Drawing on extensive personal experience with Microsoft’s strategic customers, John C. Hancock and Roger Toren offer unprecedented insight into BI systems design and step-by-step best practices for implementation, deployment, and management.

Hancock and Toren introduce practical BI concepts and terminology and provide a concise primer on the Microsoft BI platform. Next, they turn to the heart of the book—constructing solutions. Each chapter-length case study begins with the customer’s business goals, and then guides you through detailed data modeling. The case studies show how to avoid the pitfalls that derail many BI projects. You’ll translate each model into a working system and learn how to deploy it into production, maintenance, and efficient operation.

Whether you’re a decision-maker, architect, developer, or DBA, this book brings together all the knowledge you’ll need to derive maximum business value from any BI project.

Leverage SQL Server 2005 databases, Integration Services, Analysis Services, and Reporting Services
Build data warehouses and extend them to support very large databases
Design effective Analysis Services databases
Ensure the superior data quality your BI system needs
Construct advanced enterprise scorecard applications
Use data mining to segment customers, cross-sell, and increase the value of each transaction
Design real-time BI applications
Get hands-on practice with SQL Server 2005’s BI toolset

Microsoft SQL Server 2008 Analysis Services Unleashed

Microsoft SQL Server 2008 Analysis Services Unleashed by Irina Gorbach, Edward Melomed, Alexander Berger

An enormous worldwide community of database professionals has eagerly awaited Microsoft SQL Server 2008 Analysis Services. The most powerful analytics toolset Microsoft has ever created, Analysis Services 2008 is the foundation of Microsoft's next-generation Business Intelligence strategy. Microsoft SQL Server 2008 Analysis Services Unleashed is the first book to offer the comprehensive insights these professionals need to build enterprise-class OLAP solutions with Analysis Services 2008 rapidly and efficiently. Using this book, developers, architects, and DBAs can create solutions that uncover new opportunities, give managers actionable insights, and solve real business problems. The authors are key members of the Analysis Services team, and can offer insights and advice not available anywhere else.

Paperback: 960 pages
Publisher: Sams; 1 edition (December 18, 2008)
Language: English
ISBN-10: 0672330016
ISBN-13: 978-0672330018

SQL Server 2008 Analysis Services Step by Step

Table of contents and sample chaper here...

Microsoft SQL Server 2008 Analysis Services Step by Step (Step By Step (Microsoft)) by Scott Cameron

Paperback: 416 pages
Publisher: Microsoft Press (February 16, 2009)
Language: English
ISBN-10: 0735626200
ISBN-13: 978-0735626201

Delivering Business Intelligence book image

Delivering Business Intelligence with Microsoft SQL Server 2/E 2008 by Brian Larson

With help from this fully updated bestselling book, database professionals will be able to transform disparate enterprise data into actionable Business Intelligence. Covering all the new and improved BI features available in SQL Server 2008, the book shows you how to put timely, mission-critical information in the hands of employees across the organization.

Delivering Business Intelligence with Microsoft SQL Server 2008 begins with a discussion of BI, defining what it is and why it is important in today's business environment. After laying this foundation, the book works through the entire BI lifecycle: defining the analysis database; analyzing the data; mining the data; and delivering BI. Several analysis databases will be built and used for examples throughout the book.

Paperback: 750 pages
Publisher: McGraw-Hill Osborne Media; 2 edition (December 16, 2008)
Language: English
ISBN-10: 0071549447
ISBN-13: 978-0071549448

Professional Microsoft SQL Server Analysis Services 2008 with MDX