SQLBI Newsletter #219

NEW ARTICLE

Understanding the optimization of SWITCH

The SWITCH function in DAX has been optimized over the years. It is helpful to know what makes the optimization work best.
Read more

DAX PATTERNS

New and returning customers

The new and returning customers pattern helps in understanding how many customers within a given time period are new, returning, lost, or recovered.

#219 · Jun 2022

LEARNING

Course calendar

Mastering DAX

	Jun 28-30 - Las Vegas
	Aug 29-31 - Munich
	Sep 28-30 - Brisbane
	Oct 4-6 - Melbourne
	Oct 4-6 - Amsterdam
	Oct 10-12 - Sydney
	Nov 9-11 - Chicago

Data modeling

	Nov 9-11 - Chicago
	Dec 5-7 - Amsterdam

video courses

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

There are several variations to this pattern, each with different performance and results depending on the requirements. Moreover, it is a very flexible pattern that allows the identification of new and returning customers, or the computation of these customers’ purchase volume – also known as sales amount.
Read more

CLASSROOM COURSES

New dates in Europe and North America

The schedule for the second half of the year is ready.

Munich and Amsterdam are the cities we picked for our courses in Europe.
Other than Las Vegas next week, Chicago is the place for North America.
We already announced the dates in Australia a few weeks ago.

The bad news is that we will not be adding more dates to the 2022 schedule because we are busy producing new content. If you want to experience a full immersion with your peers in the classroom, hurry and book your seat before it is too late!

In the meantime, you can access our video courses, which do not run the risk of selling out.

SQLBI YOUTUBE CHANNEL

Latest news

	• Report performance impact of concurrent connections in DirectQuery The “Maximum connections per data source” property should be neither too small nor too large for a DirectQuery dataset in Power BI, or else the performance of the report may be impacted. Jun 12, 2022 · Chris Webb
	• Swapping Gantt chart hierarchies with field parameters Many articles were written upon the release of the new Field Parameters feature in Power BI. This piece about dynamically changing the hierarchy in a Gantt chart built using a standard Matrix is brilliant! Jun 2, 2022 · Sam Fischer
	• Power BI Notebooks The .NET Interactive Notebooks can be configured to test the Power BI Api running C# and PowerShell scripts in Visual Studio Code. Jun 15, 2022 · Stephen Maguire
	• SQL Server Reporting Services 2022 A new version of SQL Server is coming, and SQL Server Reporting Services is back. Do not expect new features: the world is moving to the cloud. But you can extend the support of existing solutions for another 10 years. Jun 10, 2022 · Microsoft

View Web Version · Status & Preferences · Unsubscribe

You are receiving this email because you have registered to a mailing list from sqlbi.com. If you would like to avoid similar emails in the future, please change your email preferences by clicking the link above.