SQLBI Newsletter #249

NEW ARTICLE

Differences between GROUPBY and SUMMARIZE

Both GROUPBY and SUMMARIZE are useful functions to group by columns. However, they differ in both performance and functionalities. Knowing the details lets developers choose the right function for their specific scenario.
Read more

CLASSROOM COURSES

DAX: class in Palo Alto, CA!

We received many requests for a Mastering DAX class on West Coast, and we have been able to add a date for 2023 in the Bay Area:

Palo Alto, CA on Nov. 1-3, 2023

We also have classes in Chicago and Atlanta in 2023, don't wait to get your seat!
Courses schedule

#249 · Aug 2023

LEARNING

Course calendar

Mastering DAX

	Sep 19-21 - Amsterdam
	Sep 27-29 - Chicago
	Nov 1-3 - Palo Alto
	Nov 6-8 - Atlanta
	Dec 5-7 - Cologne

Data Modeling

	Nov 7-9 - 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
	DAX Patterns

PREVIEW

Under the hood of DAX Optimizer

Do you want to know the magician’s tricks in DAX Optimizer? Read this blog post!
If you are already on the waitlist, watch out for your inbox: your invite might arrive this week... or in the next few weeks, depending on your position!
Read more

BI-WEEKLY NEWS DIGEST

Latest news

	• XMLA Write support for Direct Lake datasets Direct Lake is the big news in Fabric for Tabular models. We will write articles on these topics once the product is stable and we know enough. In the meantime, Microsoft enabled creation of datasets based on Direct Lake using XMLA endpoints. Aug 9, 2023 · Microsoft
	• Cross database query folding for SQL Server (in M) How to enable the query folding on multiple SQL Server sources in Power Query. It could make a difference when you join tables from different databases! Aug 6, 2023 · Chris Webb
	• BI Developer or Analytics Engineer? It is not directly related to Power BI or Analysis Services, but it is a good read if you wonder what these terms actually mean - or should! Aug 6, 2023 · Vincent Rainardi

SQLBI YOUTUBE CHANNEL