SQLBI Newsletter #147

NEW ARTICLE

Strong and weak relationships in Power BI

This article describes what weak relationships are and the differences between strong and weak relationship in Power BI and DAX.
Read more »

NEW ARTICLE

DAX 101: Previous year up to a certain date

This article describes how to compute previous year values up to a certain date. This is useful in case the data is presenting incomplete months or years. Read more »

#147 – Sep 2019

DATA MODELING

	Oct 30-Nov 1 - San Francisco
	Nov 26-28 - Amsterdam

MASTERING DAX

	Oct 1-3 - Amster
	Oct 2-4 - Denver
	Oct 8-10 - Washington
	Oct 8-10 - Amsterdam
	Oct 22-24 - Copenhagen
	Nov 12-14 - Toronto
	Nov 12-14 - Seattle
	Dec 10-12 - Amsterdam

VIDEO COURSES

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

COURSES HIGHLIGHT

Upcoming courses

• Last Data Modeling for Power BI classes in 2019:

San Francisco, CA, US – Oct 30-Nov 1

Amsterdam, NL – Nov 26-28

• New Mastering DAX class in November:

Seattle, WA, US – Nov 12-14

NEWS DIGEST

Latest news on BI

	• VertiPaq Analyzer 2.0 Preview 1 VertiPaq Analyzer 2.0 is coming. The Preview 1 is available – because it is a preview, it is not ready for production and it has bugs, so any feedback by early adopters is welcome. It needs DAX Studio 2.9.4. Read more »
	• DAX Studio 2.9.4 The new version of DAX Studio added the support for VertiPaq Analyzer 2.0 (currently in preview) and introduces a new wizard to the Export Data feature. You don't want to miss this release. Read more »
	• Power BI Desktop September 2019 Update New default themes are the most visible of the new Power BI features. But performance improvements for DirectQuery and connection to multi-dimensional cubes are probably more important if you are using those features. Read more »
	• Power BI Custom Format String Examples Another feature of Power BI September 2019 update is the adoption of custom format strings using the VBA syntax, which does not have a very good documentation. Chris Webb wrote a blog post explaining what you can do through several examples. Read more »
	• Power BI Comparer Imke Feldmann published an Excel file that compares two Power BI models by opening and loading the corresponding templates (PBIT files). Useful tool to check what changed in two versions that seemed identical. Read more »
	• Power BI End-To-End diagram Melissa Coates updated the Power BI end-to-end diagram that in a single page recap all the high-level features of Power BI and many related services. Also a seasoned Power BI expert can find unknown parts of the architecture: who knew that you can configure the Power BI mobile app with Intune? Read more »
	• The AutoSetDefaultInitialCatalog Analysis Services property Chris Webb describes how to change a setting in Analysis Services that does not select an initial catalog by default for a new connection. This can improve the user experience using tools like SQL Server Management Studio when the security does not provide access to all the databases on a server. Read more »

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