Dynamically Passing Parameters to a SQL Stored Procedure in Excel 365 Using Power Query
In September 2014, I wrote a blog post on dynamically passing parameters from PowerPivot to a SQL Server stored procedure…
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…
Slowly Changing Dimension (SCD) in Power BI, Part 1, Introduction to SCD
Slowly changing dimension (SCD) is a data warehousing concept coined by the amazing Ralph Kimball. The SCD concept deals with…
Thin Reports, Real-world Challenges
I previously explained in a blog post what thin reports are and why we should care about them. I also…