SQLBI Newsletter #136

NEW ARTICLE

This article shows how to compute a measure that sums the values produced row by row in the visual into the visual total, instead of recomputing the total value in the filter context of the total. Read more »

NEW VIDEO

Aggregations in Power BI

Watch this SQLBits session where Alberto Ferrari explains how aggregations work in Power BI. You will learn the advantages and the limitations of aggregations and you will understand how and when to use aggregations in Power BI models. Watch now »

#136 – Apr 2019

DATA MODELING

	May 8-10 - Amsterdam
	Jun 3-5 - Calgary
	Jul 23-25 - Melbourne

MASTERING DAX

	May 15-17 - Orange County
	May 21-23 - Cincinnati
	May 21-23 - Helsinki
	Jun 12-14 - New York
	Jun 18-20 - Aarhus
	Jun 19-21 - Portland
	Jul 2-4 - Amsterdam
	Jul 17-19 - Brisbane
	Jul 30-Aug 1 - Sydney
	Aug 6-8 - Melbourne
	Aug 14-16 - Perth

VIDEO COURSES

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

COURSES HIGHLIGHT

Upcoming courses

• Early Bird expiring soon:

Mastering DAX

Orange Country, CA – May 15-17

Cincinnati, OH – May 21-23

• Full schedule Australia 2019:

Data Modeling for Power BI

Melborune – August 6-8

Mastering DAX

Brisbane – July 17-19

Melbourne – July 23-25

Sydney – July 30-August 1

Perth – August 14-16

NEWS DIGEST

Latest news on BI

	• Power BI Desktop April 2019 release The gem of this monthly release of Power BI Desktop is probably the drillthrough across reports, even though improvements in filter pane and the Key Influencer supporting continuous analysis for numeric targets will make many people happy. There are also several other enhancements in Query Editor and M IntelliSense. Read more »
	• Power BI dataflows general availability After several months of preview, Power BI dataflows are now generally available. Between the new features included in this release, the most relevant is probably the email notification on scheduled refresh failures. Read more »
	• Preview of Automated Machine Learning for dataflows Automated Machine Learning (AutoML) is a feature for Power BI Premium and Power BI Embedded that allows creating ML models for Binary Predictions, Classifications, and Regressions. The model can be applied to data coming from a Power BI dataflow. The goal is not to replace other machine learning services, but rather to enable data analysts creating simple ML models without having to integrate different services. Read more »
	• General availability of new workspace experience in Power BI The New Workspace Experience in Power BI is now available. It is no longer necessary to create an Office 365 Group for every new Power BI workspace. While this is a welcome feature, there are a number of differences with the "old" workspace experience. Release notes are an important reading. Read more »
	• Paginated Reports in Power BI support Azure Analysis Services If you have an Azure Analysis Services database, you can now create paginated reports (the new name for Reporting Services reports) connected to Azure Analysis Services. Read more »
	• Power BI Paginated Report Builder The good old Report Builder for Reporting Services has a new life now as Power BI Paginated Report Builder. Although paginated reports are available only in Power BI Premium, the Report Builder can be downloaded and used also by Power BI Pro users. This will be more interesting once XMLA endpoints will be available in Power BI Pro, even just in read-only mode. Read more »

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