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.
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 #.