Category: Data Modeling
27
May
Data Modeling DP-700 KQL Lakehouse Mastering DP-600 Mastering DP-700 Microsoft Fabric Real-Time Intelligence Spark T-SQL
Triple Five – How to Perform Common Data Transformations in Fabric!
by Nikola
1 Comment
Discover how to perform 5 essential data transformations in Microsoft Fabric using PySpark, T-SQL, and KQL. Whether you're coding in Python, SQL, or Kusto, this...
13
May
Data Modeling DP-700 KQL Lakehouse Mastering DP-600 Mastering DP-700 Microsoft Fabric OneLake Spark T-SQL
Stop Guessing! Choose the Right Fabric Engine for Your Data!
by Nikola
2 Comments
Microsoft Fabric is all about the options. This article provides a guidance on the most common Fabric dilemma - which analytical storage engine to choose?
24
Apr
A Tale of Two Direct Lakes in Microsoft Fabric
by Nikola
No Comments
If you were confused or felt lost with the Direct Lake mode in Microsoft Fabric, I have "great" news for you - things just got...
05
Mar
How to set up Object-level security directly in Power BI Desktop
by Nikola
4 Comments
Setting up OLS in Power BI requires an external tool. Not anymore! With the new TMDL view, you can configure and manage the OLS directly...
13
Oct
How to overcome the Identity column limitation in Microsoft Fabric
by Nikola
8 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
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
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
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
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
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...