Perth SQL Server User Group

Event

Next Meeting: Tue, Aug 21 2018

DirectQuery in Analysis Services: best practices, performance, use cases

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.meetup.com/Perth-SQL-Server-User-Group/events/253412388

DirectQuery is a feature of Analysis Services that transforms a Tabular model in a semantic layer on top of a relational database, transforming any MDX or DAX query in a real-time request to the underlying relational engine using the SQL language. This feature has been improved and optimized in the latest versions, including Azure Analysis Services, extending the support to relational databases other than SQL Server, and dramatically improving its performance.
In this session, you will learn what are the features of DirectQuery, how to implement best practices in order to obtain the best results, and what are typical use cases where DirectQuery should be considered as an alternative to the in-memory engine embedded in Analysis Services.


When

iCal
UTC : Tue, Aug 21 2018 09:30 - 11:00
Event Time : Tue, Aug 21 2018 17:30 - 19:00 (UTC+08:00) Perth
Your Local Time: Tue, Aug 21 2018 09:30 - 11:00

Where

Level 3, 100 St George's Terrace
Perth , WA

Direction: None

Featured Presentation

DirectQuery in Analysis Services: best practices, performance, use cases

Speaker: Marco Russo, Business Intelligence consultant and mentor SQLBI

Summary: DirectQuery is a feature of Analysis Services that transforms a Tabular model in a semantic layer on top of a relational database, transforming any MDX or DAX query in a real-time request to the underlying relational engine using the SQL language. This feature has been improved and optimized in the latest versions, including Azure Analysis Services, extending the support to relational databases other than SQL Server, and dramatically improving its performance. In this session, you will learn what are the features of DirectQuery, how to implement best practices in order to obtain the best results, and what are typical use cases where DirectQuery should be considered as an alternative to the in-memory engine embedded in Analysis Services.

About Marco: Marco Russo is a Business Intelligence consultant and mentor, specialized in Microsoft BI Technologies. He wrote several books about DAX, Analysis Services, Power BI, and Power Pivot, and regularly publish articles and tools on www.sqlbi.com. He is also a speaker at international conferences such as Microsoft Ignite, PASS Summit, and SQLBits.

Attachments

PASSChapterLogo100.jpg 

PASS provides the Perth SQL Server User Group with this website and other resources.

Microsoft provides us with a venue in which to host our meetings once a month.

OnCall DBA provides us with complimentary refreshments each month.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids