Model | BI & Reporting

Data & BI Summit

PUGML04 - DAX Query Use Cases

Wednesday, April 25
13:00 - 14:00
Room: Liffey Hall 2

Format: Presentation
Level: Yes - A
Level: Intermediate

Most Microsoft BI developers are familiar with authoring DAX measures for Analysis Services Tabular models and Power BI datasets. However, far fewer are experienced with writing DAX queries or integrating DAX queries into MSBI projects. This session includes three 20 minute segments as follows: DAX query structure and functions; embedding DAX queries into DAX measures; and leveraging DAX queries in paginated Power BI Report Server reports. Attendees will learn the essential concepts and functions of DAX as a query language, powerful DAX features including variables and set-based functions, and how to utilize DAX Studio to develop and test DAX queries. Each segment of this session will be supported by multiple example DAX queries and all queries will be made available for download following the event.

Brett Powell

Owner, Consultant
Frontline Analytics

Brett is a business intelligence consultant, an author, and the owner of Frontline Analytics, a Microsoft Power BI partner. In his work at Frontline Analytics, Brett partners with clients on a range of topics including technical architecture, solution design, management and administration, internal training and performance optimization. In addition to consulting, Brett has authored the Microsoft Power BI Cookbook, which was published in September of 2017, and has recently completed his second book, Mastering Microsoft Power BI scheduled to published in April of 2018.

Brett also maintains Insight Quest, a blog dedicated to Microsoft BI development tools and techniques, and is the organizer of the Boston Business Intelligence user group. Typically a new blog post is published every week and Brett helps to coordinate speakers and sponsors for monthly Boston BI events. Additionally, Brett is a regular speaker at Power BI and MSBI events such as the Power BI World Tour - New York in 2017, SQL Saturday, and Boston Code Camp.

Prior to Frontline Analytics, Brett was a consultant and technical architect at other MSBI consulting firms with a focus on Analysis Services Tabular models and Power BI deployments. Brett has also worked as a corporate business intelligence developer as well as an analytics manager operating within a business unit. These diverse experiences have shaped his experience in the opportunities and challenges with both self-service business intelligence and corporate business intelligence.


Send Email for Brett Powell


DAX Query Use Cases

Attendees who have favorited this

Send Email for DAX Query Use Cases