SQLBI Newsletter 152

NEW ARTICLE

Optimizing conditions involving blank values in DAX

This article describes how blank values considered in a DAX conditional expression can affect its query plan and how to apply possible optimizations to improve performance in these cases.
Read more

NEW ARTICLE

DAX 101: Sorting months in fiscal calendars

This article shows a basic technique used to sort months according to a fiscal calendar, by using a couple of calculated columns and the “sort by column” feature of Power BI.
Read more

#152 · Nov 2019

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

ANNOUNCEMENT

Black Friday 2019

The best shopping day of the year is around the corner. Don't miss our special discounts by visiting the SQLBI website on Nov 29, 2019!

BI-WEEKLY NEWS DIGEST

Latest news

	• Updated Ribbon Experience for Power BI Desktop Power BI Desktop November 2019 introduced a new ribbon experience, which is in preview and must be manually activated. This is a more Office-like experience and it is a work in progress: expect changes in the next releases based on customers feedbacks. Nov 12,2019 · Microsoft
	• Decomposition tree visual in Power BI This is probably the longest awaited feature for data visualization in a Microsoft BI tool and in Power BI Desktop in particular. After the acquisition of ProClarity (in 2006) we have seen a decomposition tree in SharePoint, but now it is in preview with Power BI Desktop November 2019. Nov 8,2019 · Microsoft
	• Creative aggregations in Power BI Phil Seamark wrote a series of articles describing different type of aggregations you can create in Power BI. Before creating a model in DirectQuery counting on aggregations to solve performance issue, you should really read these articles. Or just import your data, of course. Nov 15,2019 · Phil Seamark
	• The updated Power BI end-to-end diagram Melissa Coates published a new version of the Power BI end-to-end diagram, which includes all the services that can take part of a Power BI solution. Warning: large monitor required to get the full picture! Nov 19,2019 · Melissa Coates
	• A low cost approach for paginated report subscriptions in Power BI A detailed blog post by John White describes how to implement paginated reports without Power BI Premium, running the service for scheduled reports only a few hours a day/week/month with the Power BI Embedded Azure service. This is the pay-per-use cloud world that we like! Nov 12,2019 · John White
	• Self-paced lab for creating paginated reports Microsoft provides a self-paced lab to learn how to use Power BI Report Builder to create paginated reports. And remember, Power BI Report Builder can be used for free, locally on your PC. You do not need Power BI Premium for that. Nov 16,2019 · Microsoft
	• How to use VertiPaq Analyzer with Power BI Patrick LeBlanc (from Guy in a Cube) and Marco Russo show how to use the new VertiPaq Analyzer integrated in DAX Studio to optimize a Power BI data model. Nov 13,2019 · Guy in a Cube
	• Analyze a Power BI data model without the PBIX file VertiPaq Analyzer 2.0 has the ability to export a VPAX file from DAX Studio to enable a remote analysis of the data model without having access to the PBIX file. In this second video Marco Russo and Patrick LeBlanc describe this procedure step-by-step. Nov 20,2019 · Guy in a Cube

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.