Microsoft Data Platform News 2023 - Week 47
Luká? Karlovsky
Fabric | Power BI | Power Query | SQL | PySpark | Data | Powershell | DWH | Excel | VBA | Instructor
Content
Power BI
Fabric
Excel
Power BI
New button slicer
The Power BI update introduces a button slicer, offering a flexible and user-friendly alternative to the traditional tile slicer. This new feature, accessible in the visual gallery, simplifies data visualization and report customization. It only requires a single field (excluding measures) and offers customization options such as shape, size, and grid layout. The button slicer also supports both single and multi-select options.
On/Off Switch with new slicer
In this video, you can beautifully see how to create an active button using the new slicer visual without the use of bookmarks.
New Card Reference labels
Reference labels will help you highlight key metrics, benchmarks, goals, and more, making your new cards stunning, captivating, and convincing for your audience. In this document, we’ll show you how to use reference labels and harness their full potential.
Query view
Discover the new DAX Query View introduced in Power BI Desktop November 2023. Spoiler: it is a good feature!
Fabric
Fabric is General Available
Microsoft Fabric is now generally available! Fabric brings together the best of Microsoft Power BI, Azure Synapse Analytics, and Azure Data Factory into a single software as a service (SAAS) platform. Fabric provides multiple workloads purpose-built for specific personas and specific tasks.
New Microsoft Fabric Certification (DP-600: BETA)
This exam evaluates your skills in designing, creating, and deploying large-scale data analytics solutions using Microsoft Fabric. It contains understanding and applying Microsoft Fabric components such as Lakehouses, Data Warehouses, Notebooks, Dataflows, Data Pipelines, Semantic Models, and Reports. The exam also requires knowledge in data modeling, data transformation, Git-based source control, and programming languages like SQL, DAX, and PySpark.
领英推荐
Fabric Update - November 2023
We have lots of features this month including Narrative visual with Copilot, cross workspace “save as” for Data Factory, the general availability of Semantic model scale-out, and many more. Continue reading for more details on our new features!?
MS Fabric - Git Integration enhancement
Exciting news! Microsoft Fabric has recently upgraded its Git Integration feature. This enhancement now extends support for versioning to a broader range of items, including Data Pipelines, Notebooks, and Lakehouses.
Medallion Architecture in MS Fabric
The article discusses implementing medallion lake architecture in Microsoft Fabric, targeting data engineers, analytics teams, and Fabric administrators. It focuses on designing data infrastructures for efficient data management and analytics.
Mirroring in MS Fabric
Mirroring provides a modern way of accessing and ingesting data continuously and seamlessly from any database or data warehouse into the Data Warehousing experience in Microsoft Fabric. This is all in near real-time thus giving users immediate access to changes in the source!
Excel
New aggregation functions
I’m excited to announce Excel's new?GROUPBY and PIVOTBY functions. These functions allow you to perform data aggregations using a single formula. And while these functions are extremely powerful, they are also simple to get started with. In fact, you can do a data aggregation with just 3 arguments, the same number as a simple XLOOKUP.?
Luká? Karlovsky
Power BI | FABRIC | Power Query | SQL | Data | DWH | Excel | VBA | Instructor
Joyful Craftsmen
Joyful Craftsmen is a data design and data engineering team. We’ve been learning and building data solutions since 2014. We focus on our vision to do the data craft as smartly as reachable. Humanity, teamwork and joy is part of our game, regardless you are our partner or one of us. Altogether we are valued for delivering cutting edge data solutions, on time, in top quality.