SQLBI Newsletter #201

NEW ARTICLE

Header/Detail vs Star Schema models in Tabular and Power BI

In this article, we look at a performance comparison between header/detail models and star schemas. Building a star schema might require a few ETL steps and some coding. Nonetheless, it is always the best modeling option.
Read more

#201 · Oct 2021

LEARNING

Course calendar

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

DAX PATTERNS

Parent-child hierarchies

Parent-child hierarchies are often used to represent charts of accounts, stores, salespersons and such. Parent-child hierarchies have a peculiar way of storing the hierarchy in the sense that they have a variable depth. In this pattern we show how to use parent-child hierarchies to show budget, actual and forecast values in a report using both a chart of accounts and a geographic hierarchy.
Read more

SQLBI YOUTUBE CHANNEL

Latest news

	• Power BI September 2021 updates In September Microsoft released a new version of Power BI, but also an updated data gateway and a new version of Power BI Report Server. No big news, many small improvements. Sep 21, 2021 · Microsoft
	• Using PowerShell to run Power BI DAX queries and extract data to CSV You can build your query in DAX Studio using the query builder if you do not know DAX. You can then export the data to CSV files (which are Excel friendly, you know) by using the REST API. Repeat and automate the process with PowerShell. Oct 8, 2021 · Gilbert Quevauvilliers
	• Parent-child hierarchy scripting with Tabular Editor Scripts in Tabular Editor allow you to automate boring and repetitive manual operations. One example is when you want to create calculated columns to implement the parent-child hierarchies pattern above. Not to be lazy, just more efficient, right? Aug 27, 2021 · Sergio Murru
	• Preserving data types with SQL queries in Power Query and Power BI When you use native SQL queries in Power Query, you might experience a data type change that requires additional transformations in Power Query. A simple property can save you valuable time. Productivity, again! Sep 12, 2021 · Chris Webb
	• Tabular Editor 2.16.4 Even though Tabular Editor 3 dramatically increases your productivity, you can always rely on the free Tabular Editor 2 if you cannot use the commercial version. The project is alive and kicking, getting fixes and updates. Sep 27, 2021 · Daniel Otykier

View Web Version · Status & 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.