SQLBI Newsletter 18/2018

NEW ARTICLE

Optimizing DAX with cardinality estimation: computing working days

Estimating the cardinality of iterators is an important skill when optimizing DAX code. This article explains how to use this technique, evaluating different ways of computing the number of working days between two dates. Read more »

BUSINESS APPLICATIONS SUMMIT 2018

DAX optimization examples video

How can you optimize your DAX expressions? In this session, Alberto Ferrari analyzes DAX expressions and Tabular models, then utilize DAX Studio and VertiPaq Analyzer to explore how to optimize them. Watch now »

DATA MODELING

	Oct 16-18 - London
	Nov 28-30 - New York

MASTERING DAX

	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

COURSES HIGHLIGHT

Don't miss the last seats available!

Mastering DAX - Last seats in San Francisco, first course in Boston:

	Mastering DAX LAST SEATS Oct 1-3 - San Francisco, CA, US
	Mastering DAX Oct 31-Nov 2 - Boston, MA, US

Data Modeling - Only two classes until the end of the year:

	Data Modeling for Power BI EARLY BIRD EXPIRING Oct 16-18 - London, UK
	Data Modeling for Power BI Nov 28-30 - New York, NY, US

NEWS DIGEST

Latest news on Business Intelligence

	• Tabular Editor 2.7.3 released There are no doubts that Tabular Editor is the more productive editor for Analysis Services Tabular models. Well, it works also for Power BI template files, even though it is not officially supported for that - yet. The script method FormatDax is worth the update. Read more »
	• New monitoring capabilities for Power BI Premium Capacities Microsoft released a service app to monitor Power BI Premium capacities - this is a must have to understand what is going on and if it's time to upgrade to a larger capacity (or downgrade, maybe!) Read more »
	• Power BI Developer community update - August 2018 Some updates for developers using Power BI Embedded, and a preview for the Power BI REST APIs for the new workspace experience in Power BI. New API version (2.1) for custom visuals and support of localization are the other news of the month. Read more »
	• No news, good news The last two weeks have been slow for news, but it was the end of holiday seasons in many countries. The following weeks will be hectic. We know that Microsoft will release a new version of Power BI Desktop in September, and other announcements and releases will follow before the end of the year. Well, we do the same! We are almost ready to release something useful to all the DAX developers. Maybe in the next newsletter? Stay tuned!

DAX GUIDE

How to learn DAX

Whether you are starting from scratch or have already learned the basics of DAX, this guide will show you all the steps to follow in order to master the Power BI and Analysis Services query language. Start learning here »

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