Applied Microsoft Analysis Services 2005 and Microsoft Business Intelligence Platform: A Guide to the Leading OLAP Platform
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.
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
ADOMD.NET algorithm Analysis Services attribute hierarchy attribute members Business Intelligence calculated member cell changes chapter column configuration connection create Cube Designer Cube Wizard currency data mining data mining model data source view data warehouse dataset Date dimension Date].[Calendar default defined deploy dialog dimension key dimension members dimension table dimensional model drillthrough dropdown end users example fact table filter folder function HOLAP implement Internet Sales Management Studio MDX expressions MDX query member properties metadata Microsoft Microsoft SQL Server mode MOLAP multilevel hierarchies OLAP cube OLE DB OLTP option package pane partition performance PivotTable proactive caching processing Product dimension Reporting Services Reseller Sales right-click ROLAP role rows Sales Amount scenario schema Scorecard script shown in Figure specify SQL Server 2005 SSAS SSAS database storage stored procedure supports task tuple UDM objects Windows writeback XMLA