Alex is a Data Platform MVP, and is the owner and lead consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK. He specializes in Data Warehouse modelling, ETL, Cubes, MDX & DAX. He's a chartered engineer & has an MSc in Business Intelligence. He runs the Birmingham (UK) SQL Pass chapter & Azure user groups, is on the SQLBits and SQL Relay committees in the UK. Alex is a regular speaker at global events including SQLBits, PASS Summit, SQL Relay, SQL Saturdays as well as numerous SQL Pass chapters around Europe. Alex is a regular speaker at global events including SQLBits, PASS Summit, SQL Relay, SQL Saturdays.
SSAS Multidimensional Performance Tuning
- Stopnja 300
16. maj 2016 13:15
Creating a multidimensional cube in Analysis Services is fairly easy, but getting them to perform and scale well can be a challenge. In this session we’ll look at a number of techniques that can be used to prepare your cube for TB scale; including matrix partitioning, data modelling, distinct count optimization, aggregations, MDX, scoped assignments, cache warming and more.