Six sessions to accelerate your DAX expertise at Microsoft Business Application Summit 2019
This year’s summit promises a two (or three) day download of the latest and greatest from Microsoft’s Power Platform. And to get the most out of this Platform, you need to familiarize yourself with DAX.
There’s an abundance of functionality straight out of the box, increasing with every monthly update. but to deliver on the trickier requirements, you will need to get under the hood a little.
If you are hoping to leave the summit with a sharper set of tools, you owe it to yourself to check out this list of sessions:
Learning DAX? Five things to get you started fast
Presenters:
Philip Seamark – Microsoft, Jeffrey Wang – Microsoft
If you are just getting started, with the Power Platform as a whole, or with using DAX – This intro session is can’t miss. You’ll be treated to an overview of the most useful topics as you begin learning this immensely powerful tool!
Phil Seamark on how he used Microsoft Forums to learn DAX
Presenter:
Philip Seamark – Microsoft
This session sounds great for all levels – one of the foremost DAX experts discussing how he learned from participation in online forums. For those who learn best by being thrown into the deep end of the pool, you’ll want to hear how Seamark was able to turn community forums into sources of invaluable expertise!
Microsoft Power BI: Data modeling fundamentals
Presenter:
Peter Myers – Bitwise Solutions
DAX and Data Modeling go hand in hand. After all, whatever logic you build in DAX is evaluated against the model you’ve built or was built for you. This advanced session discusses the fundamentals of good data modelling, and the DAX functions built on top of these models. This one is hands on, so bring your laptop along to participate in the full experience!
Microsoft Power BI: Deep dive into DAX evaluation context
Presenter:
Marco Russo – SQLBI
Without exaggeration, context is perhaps the most critical concept to understand in writing DAX functions. And the team at SQLBI.com are some of the foremost resources in the world when it comes to DAX. This session should be a homerun in terms of understanding context. This advanced session should NOT be missed.
Microsoft Power BI: My Power BI report is slow. What should I do?
Presenters:
Marco Russo – SQLBI, Bhavik Merchant – Microsoft
This was one of my favorite sessions from the 2018 summit. There’s so much to learn about optimizing performance in DAX, and you’ll watch as what initially appears to be productive logic is revised to improve from taking over 20 sec down to milliseconds. If you are concerned about production performance for the consumers of your reporting, you need to attend this advanced session.
Microsoft Power BI:The Do’s and Don’ts of Power BI Relationships
Presenter:
Peter Myers – Bitwise Solutions
Another advanced session on data modelling, this one focuses on the logic of relationships between tables in your model. In a complex model, relationship design can be the difference between a speedy, functional report and a useless mess. This session will start at the beginning and dive into the more complex model use cases. Additionally, DAX functions leveraging or modifying model relationships will be explored. If your reports have dependencies on more than single tables, this session is definitely for you!