SQLBI Newsletter 17/2018

NEW ARTICLE

This article describes how to consider possible optimization approaches to improve the performance of nested iterators in DAX. Read more »

BUSINESS APPLICATIONS SUMMIT 2018

Time intelligence in Microsoft Power BI

Almost every Power BI model has calculation over dates. Quick measures and DAX functions can help, but what are the best practices in data modeling and DAX expressions to manage also non-standard calculations? Watch now »

DATA MODELING

	Oct 10-12 - 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!

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

	Data Modeling for Power BI Oct 10-12 - London, UK
	Data Modeling for Power BI Nov 28-30 - New York, NY, US

Mastering DAX - Last seats in Toronto, Early Bird expiring for San Francisco:

	Mastering DAX LAST SEATS Sep 18-20 - Toronto, ON, CA
	Mastering DAX EARLY BIRD EXPIRING Oct 1-3 - San Francisco, CA, US

NEWS DIGEST

Latest news on Business Intelligence

	• Power BI Server Update - August 2018 Power BI Report Server has finally a new release, which includes many of the features released in Power BI service in the last months. The previous update was in March 2018, but there are many business still running the October 2017 release. And every upgrade in an on-premises environment can be complex because of other dependencies. Test your upgrade before going in production! Read more »
	• Sparklines and small multiples in Power BI Chris Webb wrote an interesting post describing how to leverage the Google Image Charts API to obtain sparklines and small multiples in Power BI. The concept is very appealing, even though relying on a deprecated API could be not rock-solid for a production environment. However, using the same approach there are many other possible applications. Read more »
	• Map small multiples in Power BI with Azure Maps API In fact, Chris Webb used the same approach with the Azure Maps API, which is supported and free up to 250K renders per month. Not free for everyone, but free for many scenarios. And the demo is amazing. Read more »
	• Power BI Report URL filter improvements Microsoft improved how to provide filters to a specific Power BI report through URL parameters. And the URL can be created in a DAX measure, obtaining dynamic links in a Power BI report. Read more »
	• Basics of Python in Power BI Toufiq Abrahams wrote a simple introduction to Python in Power BI. Very useful if you need a practical example to start with. Read more »
	• Power BI App Workspaces: the new experience Adam Saxton introduces the new experience of Power BI App Workspaces in 11 minutes. This feature is in preview and the video could be useful to get a guided tour before trying the new experience for the first time. Watch now »
	• On-premises Data Gateway August update The August update of the on-premises data gateway supports DirectQuery and ODBC drivers for custom data connectors. However, the most important reason to update the on-premises data gateway is to keep it aligned to the Power BI mashup engine. You never know the bugs they solved every month. Read more »

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