SQLBI Newsletter #174

NEW ARTICLE

Creating a simpler and chart-friendly Date table in Power BI

A Date table in Power BI can have a smaller number of columns by leveraging custom format strings to adequately control the chart visualization and the sort order.
Read more

#174 · Sep 2020

LEARNING

Course calendar

video courses

	DAX Patterns collection
	Intro to Data Modeling
	Data Modeling for Power BI
	Power BI Dashboard Design
	Introducing DAX
	Mastering DAX 2
	Optimizing DAX
	SSAS Tabular
	Power Pivot

Classroom courses

Check out the latest updates on our training page.

DAX PATTERNS

Static Segmentation

The Static segmentation pattern classifies numeric values into ranges. The price ranges are stored in a configuration table and the pattern requires the model to be entirely data-driven. In other words, when the configuration table is updated, the model is updated automatically without requiring any change to the DAX code.
Read more

SQLBI YOUTUBE CHANNEL

Latest news

	• Chat with Marco Russo (podcast) Lars Schreiber has invited Marco Russo to his podcast series. The result is a nearly two-hour not-very-technical interview covering SQLBI history, public speaking, teaching, consulting, challenges in IT careers, business intelligence trends, and much more. Sep 6, 2020 · Marco Russo
	• Power BI Premium per User license Big news: Power BI Premium Gen2 will come with a choice of capacity or per-user license. Chris Finlan explains all the details, we just have to wait for an important thing: pricing. With the right price, this is a game-changer. The preview will be free and starts in November. Sep 23, 2020 · Microsoft
	• Power BI September 2020 release Enhanced Dataset Metadata is now generally available and External Tools are much easier to use. Try the new smart narratives and many other improvements described in the announcement. Seriously, this is a mandatory upgrade, don't waste another minute. Sep 22, 2020 · Microsoft
	• Other Power BI announcements at Microsoft Ignite Now that you have seen all the features in the September release of Power BI Desktop and you have planned the Premium features to use in November, you can see the other Power BI announcements Microsoft made at Ignite. Integration with Teams, Synapse, HoloLens, and much more coming up in the next few months. Sep 23, 2020 · Microsoft
	• Introducing the new Power BI Premium “Gen-2” architecture The second generation of Power BI Premium presents many architectural differences compared to the current version. The new architecture enables per-user licensing, but there are also many improvements to the generic Capacity licensing. This short article is a good summary of these changes. Sep 23, 2020 · John P White
	• New Power BI experiences in Microsoft Teams Read all the details about the integration between Power BI and Microsoft Teams. You can also watch many of these demos in the second half of the Deliver insights where decisions are made with Power BI session at Microsoft Ignite. Sep 22, 2020 · Microsoft
	• Check the quality of all Power BI data models at once with Best Practice Analyzer Automation (BPAA) Dave Ruijter created Best Practice Analyzer, an automated solution that runs the Tabular Editor Best Practices Analyzer over all the data models published on Power BI and consolidates the result into a Power BI report. You need Power BI Premium because it requires XMLA endpoints. Sep 12, 2020 · Dave Ruijter
	• Power BI report performance and the number of visuals on a page Chris Webb demonstrates why too many visuals in a report page can slow down your report, and how to measure this cost in the browser. Because sometime it's just an HTML problem... Sep 20, 2020 · Chris Webb
	• Design guide for Power BI slicers and filters The first OKVIZ article about data visualization techniques in Power BI is a guide to slicers and filters in Power BI. David Eldersvaeld describes the tools available and when to use each one. A useful guide for new and experienced Power BI users. Sep 21, 2020 · David Eldersveld
	• Time for a new Power BI icon We don't usually repeat the same image in two consecutive pieces of news related to the same topic. We made an exception in this newsletter because this could be the last time you see the Power BI logo you know so well. Microsoft is changing the Power BI icon. Click the title of this paragraph for a sneak peek, and for the result of the survey. You may be surprised by the new icon, or by the survey, or by both! Sep 29, 2020 · Marco Russo

View Web Version · Change Email Preferences · Unsubscribe

You are receiving this email because you have registered to a mailing list from sqlbi.com. If you would like to avoid similar emails in the future, please change your email preferences by clicking the link above.