SQLBI Newsletter #232

NEW ARTICLE

Customizing date and time intelligence templates in Bravo for Power BI

This article explains how to create a Bravo for Power BI template to customize a Date table and the related Time Intelligence measures created by the tool.
Read more

NEW BLOG POST

Fixing incorrect dictionary size reported by VertiPaq Analyzer

How to fix cases where the dictionary size reported by VertiPaq Analyzer does not correspond to the memory required by the dictionary.
Read more

#232 · Dec 2022

LEARNING

Course calendar

Mastering DAX

	Feb 28-Mar 2 - Amsterdam
	Mar 15-17 - San Francisco
	Mar 21-23 - Dallas
	Apr 17-19 - Copenhagen
	Jun 27-29 - Amsterdam

Data modeling

	Apr 18-20 - Amsterdam

video courses

	Mastering Tabular
	Intro to Data Modeling
	Data Modeling for Power BI
	Power BI Dashboard Design
	DAX Tools
	Introducing DAX
	Mastering DAX
	Optimizing DAX
	Power Pivot

BI-WEEKLY NEWS DIGEST

Latest news

	• Power BI December 2022 updates The big news this month are windows functions in DAX: INDEX, OFFSET, and WINDOW. These functions are the foundations of visual-level calculations we'll see next year. Of course, we'll cover them in the next few weeks and months! Dec 13, 2022 · Microsoft
	• Introducing DAX window functions One of the lead engineers of the DAX language explains how the new DAX functions work. Put it on your reading list and read it again and again, it's very dense! Nov 29, 2022 · Jeffrey Wang
	• Simplifying capacity management with unified v-cores If you want to evaluate the capacity to purchase for your Power BI Premium subscription, read this article and especially the comments below it. There is a change in how the cores are counted. Remember, read the comments! Dec 8, 2022 · Microsoft
	• Use Microsoft Clarity in Power BI Read how you can analyze how a Power BI report is used (how users navigate into the report) by using Microsoft Clarity in a few steps. Dec 8, 2022 · Igor Cotruta
	• Enterprise scorecards with hierarchies and linked metrics in Power BI Metrics You can now create more complex enterprise scorecards with Power BI Metrics. Microsoft continues to add one feature after another; this is a good, healthy sign for a feature. Dec 6, 2022 · Microsoft
	• What's new in Analysis Services 2022? The main reason to upgrade an on-premises instance of Analysis Services is the large list of performance improvements (for both DAX and MDX queries) applied to this new release. It now aligns with the Azure version, which continues to evolve every other week. Dec 5, 2022 · Chris Webb
	• Azure Analysis Services (AAS) migration to Power BI Premium experience At the same time, Microsoft is pushing hard to convince customers to move their Azure Analysis Services workload to Power BI Premium. A real-world experience with the migration tool provides useful tips to those ready to move. Dec 4, 2022 · Dan English

SQLBI YOUTUBE CHANNEL