Sold OutMsBIP møde nr. 36

Som noget nyt foregår tilmelding direkte her på MsBIP.dk. Klik på “Register now” og udfyld dine oplysninger. Tilmeldingfrist er fredag d. 20. maj kl. 12. Der er plads til 50 deltagere.

Agenda:

• Velkomst
• Time Intelligence in DAX, Marco Russo
• Pause incl. sandwich og networking
• Pro Techniques for the SSAS Developer, Jens Vestergaard
• Afrunding

Time Intelligence in DAX, Marco Russo

Time Intelligence is probably the most interesting feature of any analytical solution. Computing Year To Date, Month To Date, Same Period Previous Year is quite easy in DAX but, as soon as the customer requests for time intelligence require working days evaluation, complex and custom calendar shapes, seasonal pattern recognition, the DAX formulas start to be harder to write.
In this session we are going to show how to compute classical time intelligence with the built-in DAX functions. Then, we will show some more complex time intelligence formulas that require to think out of the box, using advanced data modeling and querying techniques to produce interesting and useful formulas.

Pro Techniques for the SSAS Developer, Jens Vestergaard

Getting the techniques in your tool belt right, makes a world of a difference.  Did you ever wonder, how to deploy a cube, with minimum impact to query performance? Or how to optimize processing performance? Are you really ready to deploy when its required? Or do you get nervous every time?
Attend this session to build and improve your SSAS Developer skills, by exploring:
Custom Assemblies – To improve Query Performance
Partitioning – To improve Processing Performance
Unit Testing – To improve Cube Release Quality
Synchronization – To improve End User Experience
and finally PowerShell to tie all the ends together