dataMinds News Round up – December 2021
Azure Synapse
As we reach the end the end of 2021, Saveen reddy is utterly excited to show you all the new things that were shipped during the past month. What does Azure Synapse has up its sleeve?
The lakehouse pattern enables you to keep a large amount of your data in Data Lake and to get the analytic capabilities without a need to move your data to some data warehouse to start an analysis. A lakehouse represents a good trade-off between query performance and the ability to access the latest version of data without the need to wait for data to be reloaded. While designing the Lakehouse solution, you should carefully organize your databases and tables based on the underlying folder structure. Jovan Popovic reveals some best practices and recommendations that can help you to organize your lakehouses if you are using Synapse Analytics workspace to implement them.
One of the biggest announcements at Microsoft Ignite was Azure Synapse Analytics database templates, now in public preview. The idea is that instead of creating a data model from scratch, which can take weeks if not months, you have pre-built, well tested data models you can use instead. Triggered by this thought? James Serra, the stage is yours!
Workload management is one of the tools you can use to ensure a smooth-running workload by leveraging different groups with classifiers.
This is one of the features that is sometimes overlooked by customers and is one of the key components to deal with concurrency issues and the “noisy neighbor” issue. Stijn Wynants shines his light on workload management in Dedicated SQL Pools!
Power BI
Amanda Rivera announces a new way to visualize your model-driven Power Apps and Dynamics 365 data stored within Dataverse. With a single click, Power BI automatically generates a set of visuals for you to explore and find insights within your data. This integration is great way to take advantage of the full power of the Power Platform.
Have you been spending too much time guessing and testing what various format settings do? Tired of aimlessly scrolling in the format pane to find what you’re looking for? Unsure if you’ve truly reverted all the settings to default? And what about those darn double scrollbars!
Roseanne Levasseur introduces you to the redesigned format pane! Find out all the biggest changes Power BI had in its journey to improve the usability and consistency across visuals and non-visual elements.
