Jun 11, 2014 · 6:30 PM
This location is no longer available
Microsoft released its new Tabular model of Analysis Services, its BI tool for building cubes, over two years ago. It is relatively new for many developers, but Marco and colleagues have already used it to build several cubes for customers. Marco will explain what the tabular model is and how it differs from Microsoft’s traditional, multi-dimensional model. He will share some of the hard lessons learned from these projects. How do you handle billions of rows with complex calculations? Can you perform reporting in any time zone, with time intelligence, in an efficient way? What tools do you use to benchmark and choose the right hardware? How do you scale up performance on large databases? How do you make a very large database fit in memory? What are the common mistakes in DAX formulas that might cause performance bottlenecks?
This talk will be of most interest to developers especially those who have built cubes in Microsoft’s traditional multi-dimensional model and who are now considering or starting to implement a cube in the tabular model.
Marco is recognised as a world-class expert expert in Microsoft’s technology stack for building cubes (SSAS). He speaks at at international conferences and has written several books on BI.
Marco is based in Turin but is in London at this time to give an Advanced DAX workshop , from Jun 11th to 13th. The details are at http://www.sqlbi.com/courses/advanced-dax-workshop-london-jun2014. Marco is offering a 10% discount to all the members of our group. Please email Mark Wilcock (the organiser of this group) who will provide a discount code to enter into the coupon field of the registration form.