@MicahDail Just a caution that if you have many rows and deep hierarchies (along with many measures), then perf on the matrix suffers. So worth testing.
@MicahDail It might be worth looking into the Inforiver matrix (if you have the appetite). We had a very similar scenario and found that Inforiver had very nice (and flexible) ragged hierarchy handling, and made the measures simpler.
(Btw I/my company has no affiliation with Inforiver!)
Turbocharge your Data Science workflow with Microsoft Fabric with @barry_j_a_smart🛫
Microsoft Fabric's SaaS platform empowers full-stack data scientists with tools like MLflow and Semantic Link to revolutionize machine learning model development🛩️
https://t.co/lAjO1yCUEu https://t.co/hA7mj0YJ7L
How To Actually Make Decisions When Architecting a Data Platform from @edfreeman_ ☺️
Introducing tried-and-tested methods to help you make decisions when architecting a Modern Data Platform amongst a sea of options🛫
https://t.co/jg8Sw04kpq
Super excited to be speaking at #SQLBits2024 about #DataOps with @barry_j_a_smart. If you'd like to level up the quality of your Data Platform, then this training day's for you!
1/n If you're interested in the #MicrosoftFabric announcements from #MSBuild - we have lots of content for you! We were fortunate to be part of the private preview, and we wanted to share what we learned.
A top level post and a long 🧵
https://t.co/qOTWkLtOuj
@mim_djo@DeltaLakeOSS The cost of streaming data back to the Synapse Studio web client can be non-trivial. Anyway, I'm not sure it'll change your original conclusion regarding single vs multi-node architectures😀
@mim_djo@DeltaLakeOSS Depending on the size of the resultset, be careful using Synapse Studio timings as a direct indicator of performance. See whether using a local client (SSMS/Azure Data Studio) makes a difference. I've had some queries be an order of magnitude faster for operations like these.
@alexdupler@ehansalytics@DOtykier From a Power BI Desktop perspective, doesn't the "Pause visuals" functionality brought in a few months ago give you that middle ground, to some extent? https://t.co/0JxC6YtshI
1st issue of @AzureWeekly for 2023 almost done. It's a whopper. 220+ articles. The emergent theme from the community is "cutting the cost of #azure spend" 🔎💰
@GiveBloodNHS Hi there, I'm due to give blood next Monday. Will the donation centre still be open (given that it's a bank holiday for the Queen's state funeral)? Thanks!