DAX is not only an expression language, but also a query language and, when it comes to performance, the xVelocity in-memory engine is second to none. Scanning fact tables and performing leaf-level computation happens in a matter of milliseconds. Nevertheless, as with any other language, you can write good DAX or bad DAX, depending on your understanding of the engine internals. This session introduces DAX as a query language, showing the different ways of querying with DAX using real-world data. Some queries will be fast, others will need optimizations. Many practical examples based on common patterns and an analysis of the query plans will show how to get the best out of DAX.
Do you have an old static company or department portal? Are you spending too much time actively maintaining relevant content for it? Social is in! In this session we enhance a company portal in a few easy steps and enable it for open social communication inside both Yammer and Microsoft SharePoint. We walk through the different ways of integrating Yammer including Open Graph, Embed and REST API. We also show you how to utilize search and recommendations to move from a static site to a dynamic and user engaging portal.