SQLBI Newsletter #133

NEW ARTICLE

DAX 101: Computing running totals in DAX

DAX 101 is a new series of short articles describing how to solve common requirements in DAX. The first article is about computing running totals in DAX.
Read more »

NEW VIDEO

Understanding relationships in DAX

Alberto Ferrari presented at SQLBits 2019 the session Understanding relationships in DAX: if you need evidence of why bidirectional filters must be used carefully, you should watch this! Watch now »

#133 – Mar 2019

DATA MODELING

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

MASTERING DAX

	Mar 13-15 - London
	Mar 13-15 - Vancouver
	Apr 9-11 - Amsterdam
	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
	More cities (Australia)

VIDEO COURSES

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

COURSES HIGHLIGHT

Upcoming SQLBI courses

• Mastering DAX:

London, UK – March 13-15

Vancouver, BC, CA – March 13-15

Amsterdam, NL – April 9-11

• Data Modeling for Power BI:

Chicago, IL, US – March 25-27

Amsterdam, NL – May 8-10

Calgary, AB, CA – June 3-5

OKVIZ UPDATE

Smart Filter 2.0.6

OKViz just released a new version of Smart Filter Pro for Power BI. It includes a few bug fixes and the most requested feature among users: autocomplete!
Try it now »

NEWS DIGEST

Latest news on BI

	• Calculation Groups in DAX – first impressions Microsoft announced at SQLBits a very important feature for DAX: Calculation Groups. Marco Russo shares his first impressions about the new feature and the impact it will have on Analysis Services and Power BI. Read more »
	• Power BI data lineage experience for dataflows This new feature in Power BI dataflows shows a diagram with a visual representation of the dependencies between different data sources and dataflows. While still in preview, Power BI dataflows looks very interesting to split the transformation from the semantic model in Power BI, also enabling to share common transformations between different datasets. Read more »
	• Power BI Template Apps Microsoft is replacing Power BI Content Packs with Power BI Apps. You can now create templates enabling the deployment of a Power BI solution to a large number of companies. This services requires a registration in the Cloud Partner Portal so you can publish your solution on Microsoft AppSource. Read more »
	• Handling different granularities in Power BI using slicers groups Chris Webb describes a Power BI technique to manage measures at different granularities by just leveraging slicer synchronization instead of writing DAX code or modifying the data model. This could be your only option connecting to certain data sources. Read more »
	• Deploying and Managing Power BI Premium Capacities Peter Myers wrote a white paper for Microsoft describing the best practices to manage a Power BI Premium capacity. The initial part includes an introduction useful for your system administrators that are not Power BI practitioners, and then it goes deep in analyzing metrics and options available to the capacity administrators. Read more »
	• DAX Studio Parameters Dialog Darren Gosbell describes one of the new features of DAX Studio 2.8: you can define the parameters of a DAX query in a Parameter Dialog, also generating the required XMLA if you are sending a DAX query from your own application instead of using SQL Server Reporting Services. Read more »
	• Videos from SQLBits 2019 SQLBits is probably the largest European conference on Microsoft Data Platform. It is entirely community driven and this year Microsoft chose that event to announce new features in SQL Server 2019 and Analysis Services 2019. And the best news is that you can already watch most of the recorded sessions for free! Watch now »

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