Applied Microsoft Analysis Services 2005 and Microsoft Business Intelligence Platform: A Guide to the Leading OLAP Platform

Front Cover
Prologika Press, 2005 - Computers - 696 pages
Knowledge is power! As its name suggests, the promise of Microsoft SQL Server Analysis Services 2005 is to promote better data analytics by giving information workers the right tool to analyze consistent, timely, and reliable data. Empowered with Analysis Services and Microsoft Business Intelligence Platform, you are well positioned to solve the perennial problem with data--that there is too much of it and finding the right information is often difficult, if not impossible.

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.

What's Inside:
o Design sophisticated UDM models
o Build ETL processes with SSIS
o Implement data mining tasks
o Enrich UDM programmatically with MDX
o Extend UDM with SSAS stored procedures
o Create rich end-user model
o Optimize Analysis Services storage and processing
o Implement dynamic security
o Build custom OLAP clients
o Author standard and ad-hoc reports with SSRS
o Build Office-based BI applications and dashboards
o and much more
 

What people are saying - Write a review

User Review - Flag as inappropriate

An excellent book, very in depth and invaluable given the poor quality of BOL for Analysis Services.

Contents

Chapter 1
1
Chapter 2
39
Chapter 3
76
Chapter 4
113
Chapter 5
156
Chapter 6
197
Chapter 7
224
Chapter 8
258
Chapter 11
361
Chapter 12
380
Chapter 13
421
Chapter 14
452
Chapter 15
485
Chapter 16
519
Chapter 17
557
Chapter 18
592

Chapter 9
289
Chapter 10
327
Chapter 19
629
Copyright

Common terms and phrases

About the author (2005)

Teo Lachev has more than a decade of experience in designing and developing Microsoft-centered solutions. He is technical architect for a leading financial institution where he designs and implements Business Intelligence applications for the banking industry. Teo is a Microsoft Most Valuable Professional (MVP) for SQL Server, Microsoft Certified Solution Developer (MCSD), and Microsoft Certified Trainer (MCT).

He is the author of Microsoft Reporting Services in Action. He lives with his family in Atlanta, GA. Visit Teo's website www.prologika.com for sample chapters, code download, discussion list, and blog.

Bibliographic information