SQLBits 2010

Analysis Services Best Practices

Some tips and tricks which I have picked in my last few projects which can help you optimize cube design , optimize query and processing performance .

This session contains tips and tricks for modelling a high performance cube both in terms of processing and querying. I will demonstrate how attribute relationships play a crucial role in a cube design , why are hierachies important , how to make sure aggregations are used efficiently and many more tips around dimensional modelling , AS server configuration etc . Expect loads of demos and real life examples.

Speaker

I am SQL Server MVP and SQL Server Business Intelligence and C# consultant at CodePerfect Limited . I am also a regular speaker in SQL Server and BI conferences in UK. I have worked with SQL Server BI stack since 2003 and I am Microsoft Certified IT Professional. My main field of expertise are SQL Server Analysis Services, MDX, SQL Server Database Engine, T-SQL, and SSIS and C #.

Ashwani Roy's Sessions

Analysis Services Best Practices