SQLBI Newsletter #274

NEW ARTICLE

This article describes the DAX row context using a conceptual model based on a visual representation.
Read more

ANNOUNCEMENT

Stop using ancient data for your next demo, use the new (free, open-source with MIT license) Contoso Data Generator!

Download ready-to-use files in CSV, Parquet, Delta Table, PBIX, and SQL Server format, with fresh data (2014-2024).

Or use the command-line tool for Windows, macOS, and Linux, to customize distribution.

#274 · Jul 2024

LEARNING

Course calendar

Mastering DAX - 3 DAYS

	Aug 6-8 - Melbourne
	Aug 12-14 - Sydney
	Aug 19-21 - Brisbane
	Sep 18-20 - Calgary
	Oct 14-16 - London
	Oct 30-Nov 1 - New York City
	Nov 12-14 - Seattle
	Nov 19-21 - Amsterdam
	Dec 2-4 - Copenhagen

DAX OPTIMIZATION - 1 DAY

	Aug 9 - Melbourne
	Aug 15 - Sydney

DATA MODELING - 3 DAYS

	Sep 23-25 - Vancouver
	Dec 10-12 - 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

COURSES IN THE US

Mastering DAX in Seattle and New York City

We have the final roster for the second half of 2024!

Oct. 30-Nov. 1, 2024: New York City
Nov. 12-14, 2024: Seattle

We just added Seattle, so you have options on the East and West coasts before the end of the year.
Hurry, seats are limited and that is it for 2024!
Overall schedule

BI-WEEKLY NEWS DIGEST

Latest news

	• VPAX Command Line Tool for Windows, Mac OS, and Linux You can extract a VPAX file with a command line tool. Why? Because you want to automate the process. Or because you want to use a native macOS or Linux application (of course, there is also Windows). Why? Why not! Jul 20, 2024 · Marco Russo
	• On-premises data gateway July 2024 When there are not many news, you can always count on the monthly update of the on-premises data gateway. What would we do if there were an automatic update? Jul 16, 2024 · Microsoft
	• Combining calculation groups When you play with multiple calculation groups you should pay attention to the precedence. The reward is a flexible way to reuse complex filter logic on multiple measures. Jul 12, 2024 · Štěpán Rešl

SQLBI YOUTUBE CHANNEL