Pozor, nahajate se na testni strani. Informacije, ki so na voljo na spetnem mestu, niso uradne in niso uporabne, vprašljiva pa je tudi njihova verodostojnost.

Ta spletna stran hrani piškotke, da bi vam zagotovili boljšo uporabniško izkušnjo in popolno funkcionalnost te strani.

Analitične piškotke uporabljamo s storitvijo Google Analytics, samo z vašo privolitvijo. Sprejemam Zavrnitev Več informacij
Pojdi na vsebino
Arhiv predavanj

SSAS Multidimensional Performance Tuning

  • NTK 2016
  • Stopnja 300
  • Datum ponedeljek
    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.

Alex Whittles

Company

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.