SQLBI Newsletter #155

NEW ARTICLE

Why reports obtained with Analyze in Excel can be slower

This article describes the reasons why an Excel pivot table may be slow when using the Analyze in Excel feature of Power BI.
Read more

NEW POST

What has happened in the DAX world in 2019

Another year has gone by and it has now been 10 years since DAX was first introduced in late 2009. As usual, it is time to review the past year and to take a look at the year ahead.
Read more

#155 · Jan 7, 2020

LEARNING

Course calendar

Data modeling

	Apr 15-17 - New York
	Jun 3-5 - Amsterdam

Mastering DAX

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

LEARNING

Courses highlights

Kick off 2020 by learning DAX at one of our live workshops!
Last few days of early bird discount for:

• Houston (Feb 5-7)

• San Diego (Feb 11-13)

• Amsterdam (Feb 18-20)

BI-WEEKLY NEWS DIGEST

Latest news

	• Introducing the Power BI Activity Log Microsoft released a new Power BI API called the activity log, which enables Power BI service admins to track user and admin activities within a Power BI tenant. Dec 21,2019 · Microsoft
	• New “Diagnose Step” Power Query Feature In Power BI Chris Webb introduces a feature included in the December 2019 release of Power BI Desktop, the “Diagnose Step” button on the Tools tab of the Power Query Editor ribbon. This was not mentioned in the release blog post from Microsoft, so you probably missed it just like we did! Dec 23,2019 · Chris Webb
	• On-premises data gateway December 2019 update We would like to stop mentioning data gateway updates when the automatic update is available. Until then, remember to update your gateway! Dec 26,2019 · Microsoft
	• Azure Synapse Analytics & Power BI concurrency James Serra discusses concurrency issues using Azure Synapse Analytics and Power BI. There ain't no such thing as a free lunch, not even in the cloud. Dec 27,2019 · James Serra
	• Aggregations and Time Series calculations in Power BI Shabnam Watson describes how to use Power BI aggregations to cover time series calculations such as Year to Date, Quarter to Date, and Month to Date. You always need to pay attention to the details. Dec 30,2019 · Shabnam Watson
	• Data Color Reference for Power BI Themes David Eldersveld describes how to get the hex color reference for the themes in Power BI Desktop. Sooner or later, you will need to retrieve exactly one of those colors... Dec 31,2019 · David Eldersveld

View Web Version · Change Email 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.