Teo Lachev (Author)

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, database administrators and developers can design, build, and manage sophisticated OLAP cubes that provide rich data analytics and data mining services. Through this book, developers can acquire the necessary background to extend UDM with custom programming logic in the form of MDX expressions, scripts, and .NET code, and will also learn how to implement a wide range of reporting applications that integrate with Analysis Services, Reporting Services, and Microsoft Office. Assuming no prior experience with OLAP or Microsoft Analysis Services, this easy-to-follow guide builds each chapter 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:
• Design sophisticated UDM models
• Build ETL processes with SSIS
• Implement data mining tasks
• Enrich UDM programmatically with MDX
• Extend UDM with SSAS stored procedures
• Create rich end-user model
• Optimize Analysis Services storage and processing
• Implement dynamic security
• Build custom OLAP clients
• Author standard and ad-hoc reports with SSRS
• Build Office-based BI applications and dashboards