SQLBI Newsletter 14/2018

NEW ARTICLE

Microsoft Power BI is a model-based tool

This article describes the differences between report-based tools and model-based tools. Because Power BI is a model-based tool and not a report-based tool, it is useful to have a quick reference explaining these differences. Read more »

COURSES HIGHLIGHT

Next courses

	Mastering DAX (Sep 18-20) back in Toronto in September.
	Mastering DAX (Oct 1-3) for the first time in San Francisco.

See more cities »

DATA MODELING

	Aug 7-9 - Sydney
	Oct 10-12 - London
	Nov 28-30 - New York

MASTERING DAX

	Jul 24-26 - Sydney
	Jul 31/Aug 2 - Melbourne
	Aug 20-22 - Perth
	Sep 18-20 - Toronto
	Oct 1-3 - San Francisco
	Oct 10-12 - Amsterdam
	Oct 23-25 - Copenhagen
	Oct 31/Nov 2 - Boston
	Nov 13-15 - Houston
	Nov 20-22 - London
	Dec 3-5 - Miami
	Dec 11-13 - Zurich

VIDEO COURSES

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

NEWS DIGEST

Latest news on Power BI and SSAS

	• DAX Formatter update DAX Formatter has an automatic handling of the comma separator. It is based on the number of occurrences of commas and semicolons and it works most of the times. Manual selection is always possible. Find out more »
	• Smart Filter Pro update Smart Filter Pro has an important update (v2.0.1) that fixed many bugs, improved performance on large number of rows, and added a few small features like multiple-selection in Observer mode, and Consolidate Filters option for Filter mode. Find out more »
	• Power BI expands self-service prep for big data Microsoft is preparing some big announcements for Power BI at the Microsoft Business Applications Summit in Seattle next week. Some vague and incomplete anticipations is already available. Read more »
	• DAX formula bar keyboard shortcuts in Power BI Desktop Daniil Maslyuk wrote a useful post describing the shortcuts available in the DAX formula bar in Power BI. You will discover many shortcuts you didn't know! Read more »
	• How the new IsAvailableInMDX property for Analysis Services Tabular can reduce memory usage Chris Webb describes how to use the IsAvailableInMDX property in Analysis Services 2017 and Azure Analysis Services. He also reports some example of the savings in memory and processing time that can be obtained in large models. Read more »

SQLBI REPLAY - SEP 26, 2016

Using ALLEXCEPT versus ALL and VALUES

This article describes the semantic difference between ALLEXCEPT and the joint use of ALL and VALUES, showing practical examples of the different results in Power BI and SSAS 2016. Read more »

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