From SQL to DAX

Abstract: Data Analysis Expressions (DAX) is used to query Analysis Services Tabular models and is used in the Power BI modeling engine. It's actually a very simple and extremely powerful query language, but many T-SQL developers (including myself) struggle with this at first. While it has a lot in common with T-SQL (for instance it returns data), it also has many differences. Some people may have questions about the perceived lack of some keywords or the fact that a query is doing something that it wasn't asked to do. But once we understand the key differences, it all starts to make sense - at least it did for me. Come along to this session and learn a little bit of DAX, explained using T-SQL. Questions you might have include

How do I insert data?
Where are my FROM and WHERE clauses?
How do I delete and update data?
What is a measure?
Are calculated columns just computed columns.
How do I write a stored procedure?

This session will answer all of these questions and more.
By the end of this session you'll be well on your way to knowing your way around DAX by avoiding the awkward questions that this SQL Professional had when they started out with SQL Server Analysis Services Tabular and Power BI.

Speaker: Martin Catherall

Speaker Bio: Martin Catherall is a Data Architect working on Microsoft Data Platform technologies. He is currently based in Brisbane, Australia.

Martin’s career has expanded from the world of SQL Server Administration and T-SQL development to encompass data engineering and architecture on the Microsoft Azure Platform.

He has over 15 years’ experience in the data industry and has been a recipient of the Microsoft Most Valuable Professional Award since 2014

When he is not engaged in data related activities, he can be found exploring the Queensland landscape (he’s recently escaped Melbourne), learning about Minecraft or Super Mario from his kids and learning the guitar – despite being tone deaf!

Martin is the co-host of DataPlatform downunder

Linked In
https://www.linkedin.com/in/martincatherall

Blogging
https://martincatherall.com

Twitter:
https://www.twitter.com/MartyCatherall

Agenda:

• 12:15-12:30pm: Sign-in & network
• 12:30-12:35 pm: Announcements & Intro
• 12:35-1:35pm: Presentation
• 1:35-2:00pm: Q&A, wrap-up

Location:
Online. You must register for the link