Analysis Services Best Practices

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.
Presented by Ashwani Roy at SQLBits VII
  • Downloads
  • SpeakerBIO
    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 #.
  • Video