Microsoft SQL Server Analysis Services Design Challenges
Microsoft SQL Server Analysis Services allows developers to produces cubes which,when designed well,can deliver intuitive,feature-rich and highly-performant data models. In many ways they are a key component to delivering Business Intelligence within the enterprise. To be clear,this session intentionally explores beyond the basics. It covers best practice design for dimensions and cubes,and also addresses common design challenges in relation to the supporting source schema design,cube calculations and security. This session is suitable for those already familiar with Analysis Services cube development. Additionally,some knowledge and experience of MDX is preferable to get the most out of this session.