SQLBI Newsletter #125

NEW ARTICLE

Improving temporal line charts in Power BI with DAX

This article shows how to improve line charts with a date-based axis in Power BI using DAX and making choices in data modeling and visualization properties. Read more »

ANNOUNCEMENT

Black Friday 2018

The best shopping day of the year is around the corner. Don't miss our special discounts by visiting SQLBI website on Nov 23, 2018!

#125 – Nov. 2018

DATA MODELING

	Nov 28-30 - New York
	Mar 25-27 - Chicago
	May 8-10 - Amsterdam

MASTERING DAX

	Dec 3-5 - Miami
	Dec 4-6 - Amsterdam
	Dec 11-13 - Zurich
	Feb 6-8 - Seattle
	Feb 11-13 - Atlanta
	Feb 19-21 - Amsterdam
	Mar 13-15 - London
	Mar 13-15 - Vancouver
	Apr 9-11 - Amsterdam
	Jun 18-20 - Aarhus

VIDEO COURSES

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

COURSES HIGHLIGHT

Last classes of 2018 & new dates for 2019!

Last seats for Mastering DAX on December 2018:
Miami / Amsterdam / Zurich

New dates for 2019 announced:
Seattle - Atlanta - Chicago / Vancouver / Amsterdam
London / Aarhus (other dates/cities coming soon)

NEWS DIGEST

Latest news on Business Intelligence

	• Power BI Desktop November 2018 The November 2018 update is huge, and there are many other announcements for the services. The biggest features in the Desktop are Expand & Collapse in Matrix (almost like a PivotTable, but only for rows), new filtering experience, and a new modeling view with editing features (including display folders). There are other small improvements, don't miss the official announcement. Read more »
	• Introducing Power BI dataflows In short, you can copy your M script in Power Query from your Power BI Desktop file to a dataflow, running it on the Power BI service and storing the result of the transformation in a format that can be quickly and easily consumed by several Power BI datasets. The feature is in public preview and it is a more advanced form of self-service ETL that can be easily shared across different models. Read more »
	• Paginated Reports (aka Reporting Services) in Power BI Yes, you can publish a RDL Reporting Services report in Power BI Premium capacity. And this is already another big news. But what if you want to try this feature without Power BI Premium? Read the official instructions from Christopher Finlan (he's the MS Program Manager) to test this feature with the minimum cost. Read more »
	• Nested display folders in Power BI Chris Webb describes how to use one of the many new features in Power BI Desktop November 2018. The display folders have been available in Analysis Services Tabular since 2016, and now they can be defined within a Power BI data model. Chris shows how to create nested folders. This feature is a must for those models with too many measures. Read more »
	• New ISINSCOPE function in DAX Daniil Maslyuk and Kasper de Jonge wrote two good introductions to the new ISINSCOPE DAX function that has been introduced to better support the Expand & Collapse feature of the Matrix visualization in Power BI. Post by Daniil Maslyuk » Post by Kasper de Jonge »
	• On-premises data gateway November update There are so many updates in November that you simply need to update the data gateway, too. Don't wait. Read more »
	• VertiPaq Analyzer 1.91 The last version of VertiPaq Analyzer only adds a tab to capture the filter expressions used in role based security. The DAX code of these expression can be formatted as any other tab with DAX expressions (measures, calculated columns, and calculated tables). Download now »
	• Celebrating 20 years of Analysis Services Microsoft Analysis Services is 20 years old and the product team wanted to celebrate the event interviewing many influencers in community and development team: Chris Webb, Darren Gosbell, Jeffrey Wang, Josh Caplan, Kasper de Jonge, Marco Russo, Will Thompson. Many stories, jokes, and a look at the future. Watch now »

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