Category: Data Modeling

13 Oct

How to overcome the Identity column limitation in Microsoft Fabric

by Nikola

7 Comments

Identity column feature is an excellent example of the "missing puzzle" in Microsoft Fabric. Hence, we still have to rely on some workarounds and "hacks"...

29 Sep

Data Modeling Lakehouse Learning Mastering DP-600 Microsoft Fabric

Mastering DP-600 Exam: Implementing Star Schema in Fabric Lakehouse

by Nikola

1 Comment

You've heard that Star schema IS the preferred way for modeling data in your BI solutions. But, how do you create one in the Fabric...

18 Aug

Data Modeling Data Visualization Power BI Power Query

5 Clicks to WOW! How changing data types can quickly optimize your Power BI model!

by Nikola

3 Comments

Optimizing Power BI semantic model doesn't always have to be a daunting and time-consuming task. You can often celebrate many quick and easy wins!

03 Jun

Data Modeling Data Visualization Learning Mastering DP-600 Power BI

Mastering DP-600 Exam: Implement Field Parameters

by Nikola

No Comments

Field parameters is one of those features you simply know will have a huge impact! Not just because it opens up literally an indefinite number...

04 May

Data Modeling External Tools Lakehouse Learning Mastering DP-600 Microsoft Fabric Power BI

Mastering DP-600 Exam: Implement Calculation Groups

by Nikola

1 Comment

Calculation groups are one of the most powerful features in Power BI to reduce the data model complexity and measure redundancy!

19 Apr

Data Modeling Learning Mastering DP-600 Microsoft Fabric Power BI

Mastering DP-600 Exam: Implement a Star Schema for Power BI Semantic Model

by Nikola

3 Comments

You've heard that Star schema IS the preferred way for modeling data in your PowerBI semantic models. But, how do you create one? It's easier...

06 Apr

Data Modeling Data Visualization Direct Lake Lakehouse Microsoft Fabric Power BI

Migrate Existing Power BI Semantic Models to Direct Lake – A Step-by-step Guide!

by Nikola

8 Comments

Need to migrate existing Power BI reports from Import to Direct Lake mode? Michael Kovalsky provided a straightforward solution to tackle this challenge effectively

04 Apr

Data Modeling Data Visualization DAX External Tools Power BI