Slowly Changing Dimension (SCD) in Power BI, Part 2, Implementing SCD 1
I explained what SCD means in a Business Intelligence solution in my previous post. We also discussed that while we do not expect to handle SCD2 in a Power BI implementation, we can handle scenarios similar to SCD1. In this post, I explain how to do so. Scenario We have a retail company selling products. … Continue reading Slowly Changing Dimension (SCD) in Power BI, Part 2, Implementing SCD 1
The post Slowly Changing Dimension (SCD) in Power BI, Part 2, Implementing SCD 1 appeared first on BI Insight.
Published on:
Learn moreRelated posts
Microsoft Viva: Create and customize Power BI reports
Microsoft Viva Insights will allow eligible users to create, customize, and save supported Power BI reports, including adjusting periods, filt...
The Benefits Of Using Direct Lake Mode In Power BI
This is a blog post I’ve been meaning to write for a long time. Since Fabric launched there has been a lot of focus on Direct Lake mode ...
Optimising DAX: Model Design Comparisons and Testing Tips
Star schema vs flat table vs header/detail - which Power BI model design gives you the best performance? This post compares all three and cove...
Tips to Export Data To Data Lake From MS Dynamics 365 CE And Use It In Power BI.
Integrating Dynamics 365 with Azure Data Lake allows you to continuously sync operational data for cost-effective big data analytics, AI workl...
The Power BI Expert Is GONE. Now What?
Deep dive into tooltip options in Power BI visuals (Generally Available)
Discover how Power BI’s tooltip (Generally Available) options help you tailor hover experiences—from curated field lists and sentence-style in...
No Code, No Tools: Documentation for Power BI and Fabric Using Fabric Skills and GitHub Copilot
Documentation is one of those things that every data team knows they should do — and almost nobody does well. You build a Power BI semantic mo...