dataMinds News Round up –
January 2024
Having the right requirements is essential to design, build, and deliver data for a BI solutions that provide business value. If you design the wrong thing for the wrong problem (or don’t identify the problem at all), your solution is destined for failure… even if it’s using all the latest features or technology, and following all the best practices. But how can you approach requirements gathering for semantic models? What considerations should you keep in mind, and what tools or methods can help?
In this article, describes key considerations for collecting requirements to design and build semantic models. He’ll also describe how you can use Tabular Editor to create model wireframes, and how you can use those wireframes in prototypes or later to accelerate your semantic model development.
In this article Dennes Torres wants to address a missing point for a lot of Fabric administrators: How to do maintenance on multiple lakehouses that are located in different workspaces. Is it a good idea to keep multiple lakehouses in the same workspace? Probably not.
The main maintenance tasks you would generally execute on Lakehouses are VACUUM and OPTIMIZE. But how can you schedule those tasks as notebooks can’t loop through lakehouses in different workspaces? Dennes walks the talk!
Access quality data, wherever it resides, with Microsoft Fabric, our next generation managed data and analytics service. Make data accessible across your entire data estate, without having to integrate different sources or work across multiple toolsets.
Zachary Cavanell elaborates on the new data mirroring capabilities and AI-powered Copilot experiences, from building data pipelines, to creating predictive models and generating Power BI reports.
Extended Events has become the de facto and best way to trace activity on a SQL Server instance. However, many people still like the Profiler tool and use that. To try and get some of them to switch, Microsoft released the XE Profiler in SSMS.
Steve Jones explains how Microsoft has now ported this to the profiler extension in ADS which you can add to your tool and access the same data.
Power BI, known for its unique features and easy-to-use interface, is much like a software kit with hidden treasures. Discovering these overlooked, but useful features, can significantly increase productivity.
Amira Bedhiafi uncovers some of Power BI’s often missed aspects, explaining their possible advantages and the causes of them being unnoticed by both novice and pro users.
Ever wondered whether you can create a measure from a filtered visual in Power BI?
“Guy in a Cube” Patrick got you covered using the new DAX query view!
