Professional Microsoft SQL Server Analysis Services 2008 with MDX (Wrox Programmer to Programmer) (Paperback)

~ Sivakumar Harinath (Author), Robert Zare (Author), Sethu Meenakshisundaram (Author), Matt Carroll (Author), Denny Guang-Yeu Lee (Author) "Business intelligence (BI) helps enterprises to gain insight from historical data and formulate strategic initiatives for the future..." (more)
Key Phrases: row labels, dim customer, dim employee, Analysis Services, Internet Sales Amount, Cancel Figure (more...)

Editorial Reviews

Product Description

• When used with the MDX query language, SQL Server Analysis Services allows developers to build full-scale database applications to support such business functions as budgeting, forecasting, and market analysis.
• Shows readers how to build data warehouses and multi-dimensional databases, query databases, and use Analysis Services and other components of SQL Server to provide end-to-end solutions
• Revised, updated, and enhanced, the book discusses new features such as improved integration with Office and Excel 2007; query performance enhancements; improvements to aggregation designer, dimension designer, cube and dimension wizards, and cell writeback; extensibility and personalization; data mining; and more

From the Back Cover

The new features of Analysis Services 2008 make it even easier to use andbuild your databases for efficient and improved performance. This authoritative book, written by key members of the Analysis Services product team at Microsoft, explains how to best use these enhancements for your business needs. The authors provides you with valuable insight on how to use Analysis Services 2008 effectively to build, process, and deploy top-of-the-line business intelligence applications.

You'll explore everything that Analysis Services 2008 has to offer and examinethe important features of this product with the help of step-by-step instructionson building multi-dimensional databases. Within each chapter, you will not only learn how to use the features, but you'll also discover more about the features at a user level and what happens behind the scenes to make things work. You'll get a look at how features really operate, enabling you to understand how to use them to their full potential. Plus, you'll sharpen your ability to debug problems that you might not have been able to otherwise.

What you will learn from this book

• The basic concepts of using Analysis Services and the common operations you need to design your databases

• How to create multi-dimensional databases (such as multiple measure groups, business intelligence wizards, key performance indicators, and more)

• Methods for extending MDX via external functions

• Ways to administer your Analysis Services programmatically and design and optimize your cube for best performance

• How data mining along with Microsoft Office 2007 makes it easy to use and effective to perform analysis on data

Who this book is for
This book is for database and data warehouse developers and administrators interested in exploiting the power of business intelligence and leveraging the SQL Server 2008 tool set.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

See all Editorial Reviews

Product Details

• Paperback: 1056 pages
• Publisher: Wrox (March 16, 2009)
• Language: English
• ISBN-10: 0470247983
• ISBN-13: 978-0470247983
• Product Dimensions: 9.2 x 7.4 x 2.4 inches
• Shipping Weight: 3.2 pounds (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
• Amazon.com Sales Rank: #30,095 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #9 in	Books > Computers & Internet > Databases > Data Warehousing
  #19 in	Books > Computers & Internet > Microsoft > Development > SQL Server
  #33 in	Books > Computers & Internet > Databases > Database Management Systems

Customer Reviews

Most Helpful Customer Reviews

3 of 4 people found the following review helpful:

5.0 out of 5 stars End-to-End Microsoft BI book for professional consultants, June 30, 2009

By	Binh N. Cao "Binh Cao" (San Diego, CA) - See all my reviews (REAL NAME)

I am a microsoft professional consultant who makes a living working with Microsoft BI toolsets. I find this book of tremendous value because of the contents and because of who wrote it. The authors are part of the SSAS product group as well as http://www.sqlcat.com team (the #1 BI application team that takes on the world's largest and greatest database and Business Intelligent design challenges and delivers great designs and success stories)...this is the best of the best at Microsoft. I read the book end-to-end. I can tell you that the MDX, performance tuning, and scenario chapters alone, are worth the price of the book many times over. This book helped me succeed in my job and go further than other consultants. I would highly recommend this book to "professional" consultants. Beginners who want to learn the fundamentals to MSFT BI would benefit greatly from this best-practices microsoft team.