7/6/2007 2:21:18 PM
Microsoft SQL Server 2005 Analysis Services includes a complete re-architecture of the Online Analytical Processing (OLAP) engine from Microsoft SQL Server 2000.
In this session we will focus on the performance and scalability aspects of the Analysis Services architecture and cover cube design, providing specific guidance on how to design for optimal performance, and also cover MDX and calculations.
Cube design and storage
We will discuss cube modeling (emphasizing the importance of attribute relationships), partitioning strategies, aggregation management and cube processing. For each of these, we will explain the important design principles, and provide best practices for performance and scalability.
MDX and calculations
We take common business problems and show how MDX can be utilized to solve them while keeping query performance under control. Finally we point out common gotchas for poor performance in MDX and best practices to address them.
These principles and practices should be a necessary foundation for any organization embarking on a large-scale business intelligence project based on Analysis Services 2005.
We will make *you* the BI hero!
About the presenter:
Grant Paisley is the Chief Solutions Architect for Angry Koala, http://www.angrykoala.com a Microsoft Partner specialising in Business Intelligence Solutions. Grant is a SQL Server MVP, and president of the Sydney SQL Server User Group. With more than 10 years of consulting experience in Business Intelligence and data warehousing he has delivered solutions such as the Scorecard Reporting System for the Microsoft Australia Enterprise Group. He is sought after as a speaker presenting practical Business Intelligence Solutions advice at events such as TechEd and various Australian user group meetings.
Venue: Mechanics' School of Arts, Level 1, 280 Pitt St, Sydney |
Duration 5:30pm for pizza, 6pm until 8pm Session |
On: Wednesday, July 11, 2007