SQLBI Newsletter #142

NEW VIDEO

This session recorded at Microsoft Business Application Summit summarizes the unifying theory of evaluation contexts based on filter context, row context, filter context operators, and blocking semantic. If you are serious about DAX, this session is a real must.
Watch now »

NEW ARTICLE

Understanding Calculation Groups

This second article about calculation groups in DAX explores the properties in detail and then it describes how a calculation item is applied to a measure. Read more »

#142 – July 2019

DATA MODELING

	Jul 23-25 - Melbourne
	Oct 30-Nov 1 - San Francisco
	Nov 26-28 - Amsterdam

MASTERING DAX

	Jul 17-19 - Brisbane
	Jul 30-Aug 1 - Sydney
	Aug 6-8 - Melbourne
	Aug 14-16 - Perth
	Sep 17-19 - Chicago
	Oct 1-3 - Amsterdam
	Oct 2-4 - Denver
	Oct 8-10 - Washington
	Oct 22-24 - Copenhagen
	Nov 12-14 - Toronto

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

COURSES HIGHLIGHT

Upcoming courses

• Learn DAX in Australia:

Brisbane, AU – July 17-19

Sydney, AU – July 30-Aug 1

Melbourne, AU – Aug 6-8

Perth, AU – Aug 14-16

• Learn DAX in USA and Canada:

Chicago, IL – Sep 17-19

Denver, CO – Oct 2-4

Washington, DC – Oct 8-10

Toronto, ON – Nov 12-14

NEWS DIGEST

Latest news on BI

	• Power BI Report Builder available for Pro datasets Read it carefully: paginated reports are still a feature for Premium only, but the Power BI Report Builder tool can be downloaded for free and used with your Power BI Pro dataset. This justifies future articles about writing efficient DAX queries! Read more »
	• Viewer role for Power BI workspaces We finally have a viewer role for the new workspace experience in Power BI, making it easier to provide read-only access to reports. Read more »
	• New features in Power BI dataflows The Power BI dataflows have an enhanced computing engine just for the Premium version, and it introduces dataflows templates for everyone - even though templates cannot be customized yet. Read more »
	• Power BI reporting API Power BI has an API to programmatically create a report in an embedded session. There is not much advertising about this API, which can unlock interesting scenarios for developers. Read more »
	• DAX Studio 2.9.2 In the last few weeks several fixes have been released for DAX Studio, so it is important to update your copy. Download now »
	• Convert M partitions to legacy data sources in Analysis Services If you create an Analysis Services project today, you likely create M data sources even though you are just mapping tables from a standard data source like SQL Server. Daniel Otykier explains how to obtain a standard (legacy) data source to improve performance and get advantage of Tabular Editor features. Read more »
	• Analysis Services as a Power BI dataflows data source: why it is not a good idea Matthew Roche explains why using Analysis Services as a data source for Power BI dataflows is hardly a good idea. In a few words, you lose the advantages of a semantic model. Matthew completes the description with several diagrams. The simpler, the better. Read more »

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