SQLBI Newsletter #135

NEW ARTICLE

Values such as inventory and account balance, usually calculated from a snapshot table, require the use of semi-additive measures. This article describes how to implement these calculations in DAX according to your specific requirements. Read more »

NEW VIDEO COURSE

FREE Introduction to Data Modeling video course

SQLBI is now offering a new free video course: Introduction to Data Modeling for Power BI. This article describes which users will benefit from this learning experience the most, and how to enroll in the course.
Read more »
Free enroll now »

#135 – Apr 2019

DATA MODELING

	May 8-10 - Amsterdam
	Jun 3-5 - Calgary
	Jul 23-25 - Melbourne

MASTERING DAX

	Apr 9-11 - Amsterdam
	May 15-17 - Orange County
	May 21-23 - Cincinnati
	May 21-23 - Helsinki
	Jun 12-14 - New York
	Jun 18-20 - Aarhus
	Jun 19-21 - Portland
	Jul 17-19 - Brisbane
	Jul 30-Aug 1 - Sydney
	Aug 6-8 - Melbourne
	Aug 14-16 - Perth

VIDEO COURSES

	Intro to Data Modeling
	Data Modeling for Power BI
	Power BI Dashboard Design
	Introducing DAX
	Mastering DAX
	Optimizing DAX
	SSAS Tabular
	Power Pivot

COURSES HIGHLIGHT

Upcoming DAX courses

	Mastering DAX in Unites States: Orange County, CA / Cincinnati, OH / New York, NY / Portland, OR
	Mastering DAX in Europe: Amsterdam, NL / Helsinki, FI / Aarhus, DK
	Mastering DAX in Australia: Brisbane / Sydney / Melbourne / Perth

NEWS DIGEST

Latest news on BI

	• Update on the New Workspace Experiences Preview Microsoft announced that the new workspace experience for Power BI (currently in preview) will become generally available in April 2019. If you did not pay attention to the changes coming in the workspace features, you should absolutely read this article and plan accordingly. Read more »
	• Slideshow mode in Windows Power BI app The Windows Power BI app is almost unknown – but you can install a Power BI Mobile app from the Windows Store that runs on any desktop and enable a presentation mode that now can also run a slideshow. You don't need to export your reports to PowerPoint, just click on Play! Read more »
	• XMLA endpoints in preview for Power BI Premium The data models published as datasets in Power BI Premium can now be seen as Analysis Services database through XMLA endpoints, enabling access from any existing XMLA-compliant tool. DAX Studio and Reporting Services are the first two tools that can use this service, because at the moment it is read-only. Tabular Editor must wait the support of read-write features – which should be available soon. Read more »
	• DAX Studio 2.8.4 Another set of bug fixes and small changes for DAX Studio that also improve the support for the XMLA endpoints and the analysis of Power BI aggregations. Download now »
	• Analysis Services 2019 CTP 2.4 The new CTP version of Analysis Services 2019 introduces the many-to-many cardinality for relationships in the data model, the same feature that has been introduced in Power BI with the composite models a few months ago. There are also new settings to limit resources used by a single query. Improvement in calculation groups will appear in a future CTP. Read more »
	• Intelligent Cloud Conference Marco Russo will deliver two breakout sessions at the Intelligent Cloud Conference in Copenhagen on April 9-10, 2019: "DAX Filter Context in 1 hour" and "Aggregations in Power BI". If you are in Denmark, or you need a good reason to visit it, you can still register. Register now »

You are receiving this email because we have registered your interest in SQLBI.
unsubscribe me - Privacy Policy