SQLBI Newsletter #148

NEW ARTICLE

This article describes a naming convention for temporary columns in DAX expressions to avoid ambiguity with measure reference notation.
Read more »

COURSES HIGHLIGHT

Upcoming courses

• Last Data Modeling for Power BI in 2019:

San Francisco, US – Oct 30-Nov 1

Amsterdam, NL – Nov 26-28

• New Mastering DAX class in November:

Seattle, US – Nov 12-14

#148 – Oct 2019

DATA MODELING

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

MASTERING DAX

	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

NEWS DIGEST

Latest news on BI

	• Power BI Report Server September 2019 Feature Summary The September 2019 update of Power BI Report Server aligns most of the features already released for Power BI Desktop and service. If you use Power BI on-premises, you don't want to wait to update it. Read more »
	• Paginated Reports in Power BI September 2019 The latest update of Power BI Paginated Reports introduces user comments and secure embed support. But the more interesting news is the availability of an RDL Migration Tool available on GitHub. Read more »
	• Dataflows best practice This document is an official set of guidelines for Dataflows released by Microsoft. The document is short but dense and you need a good knowledge of Power Query and Dataflows to fully understand it. For example, if you don't know the enhanced compute engine, you need to update your skills! Read more »
	• Power BI custom format string examples - Part 2 Chris Webb completes the exploration of custom format strings in Power BI covering custom formats for dates and times. Read more »
	• On-premises data gateway September 2019 The September 2019 version of the data gateway requires .NET 4.7.2 Framework and is aligned to the September 2019 mashup engine of Power BI. Read more »
	• New Azure Analysis Services SKUs The new Azure AS tiers (or SKUs) are S8V2 and S9V2 and they double the processing power (number of cores) of S8 and S9, respectively. They also double the price, unfortunately! These new SKUs are interesting to scale-out the capacity, but they hardly improve single slow queries. Read more »
	• Improved query replica sync in Azure Analysis Services Microsoft announced the development of important improvements for query replica synchronization in Azure Analysis Services: better consistency across replicas, improved latency, and optimization of memory usage are the main improvements planned to be released in Q3 2019 - yes, they are already late! Read more »

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