avatarChristianlauer

Free AI web copilot to create summaries, insights and extended knowledge, download it at here

1925

Abstract

nd AI-based analytics. In addition, Fabric includes a new no-code developer interface that allows users to monitor their data in real time and trigger actions and notifications based on incoming information[1][2].</p><figure id="0e96"><img src="https://cdn-images-1.readmedium.com/v2/resize:fit:800/1*mJu0KKIkZKUne4dF-UeVLw.png"><figcaption>Architecture of Microsoft Fabric — Source: <a href="https://azure.microsoft.com/en-us/blog/introducing-microsoft-fabric-data-analytics-for-the-era-of-ai/">Microsoft</a>[1]</figcaption></figure><p id="a2b7">I have already introduced the feature in another article about Power BI where the AI based solution is also supposed to simplify the creation of analyses and reports.</p><div id="abc5" class="link-block"> <a href="https://readmedium.com/its-official-microsoft-brings-chatgpt-to-power-bi-115979c0cb2a"> <div> <div> <h2>It’s official: Microsoft brings ChatGPT to Power BI</h2> <div><h3>Microsoft Power BI, Azure Synapse, and Azure Data Factory are unified to one Software</h3></div> <div><p>medium.com</p></div> </div> <div> <div style="background-image: url(https://miro.readmedium.com/v2/resize:fit:320/1*OV9AFeqj1nuTKoHTqjAP0Q.jpeg)"></div> </div> </div> </a> </div><p id="16a8">Through the tool, users experience several benefits such as easier and platform-independent data integration and analysis. Also the processing of data by ETL and ELT processes should be simplified, according to the motto Zero ETL that many of the large cloud providers go. In the area of data analysis, however, it is also possible to make suggestions and generate queries by entering text requests. Fabric, therefore comes with seven core workloads[1]:</p><ul><li><b>Data Factory: </b>This<b> </b>provides more than 150 conne

Options

ctors to cloud and on-premises data sources, drag-and-drop experiences for data transformation, and the ability to orchestrate data pipelines.</li><li><b>Synapse Data Engineering: </b>This offers the possibility of good authoring experiences for Spark, instant start with live pools, and the ability to collaborate.</li><li><b>Synapse Data Science: </b>This<b> </b>provides an end-to-end workflow for data scientists to build sophisticated AI models.</li><li><b>Synapse Data Warehousing: </b>This<b> </b>provides a converged Data Lakehouse and Data Warehouse experience.</li><li><b>Synapse Real-Time Analytics: </b>This<b> </b>enables developers to work with data streaming in from the Internet of Things (IoT) devices, telemetry, logs, etc.</li><li><b>Power BI in Fabric: </b>This provides industry-leading visualization and AI-driven analytics that enable business analysts and business users to gain insights from data.</li><li><b>Data Activator: </b>This<b> </b>provides real-time detection and monitoring of data and can trigger notifications and actions when it finds specified patterns in data, all in a no-code experience.</li></ul><p id="8e33">It is important to note here that most of the features, which are quite fresh, are available in preview for the time being. That is not necessarily intended for productive use, but this should change shortly.</p><h2 id="2b23">Sources and Further Readings</h2><p id="b73b">[1] Microsoft, <a href="https://azure.microsoft.com/en-us/blog/introducing-microsoft-fabric-data-analytics-for-the-era-of-ai/">Introducing Microsoft Fabric: Data analytics for the era of AI</a> (2023)</p><p id="6a55">[2] AppMaster, <a href="https://appmaster.io/de/news/microsoft-fuhrt-fabric-als-umfassende-datenanalytische-plattform-mit-multi-cloud-integration-ein">Microsoft stellt Fabric vor, eine umfassende Daten- und Analyseplattform für Multi-Cloud-Integration</a> (2023)</p></article></body>

What is Microsoft Fabric and why it’s a Big Deal

Microsoft’s new End-to-End Data and Analytics Platform

Photo by Griffin Wooldridge on Unsplash

Microsoft just has unveiled Microsoft Fabric, a new type of end-to-end data and analytics platform built on the company’s OneLake Data Lake. The platform also will support integration with other cloud storage services, such as Amazon S3 and Google Cloud Platform in the near future. Competitor Google has presented BigLake about a year ago and offered a similar service. From a technical point of view, we are in the Data Lakehouse/Data Fabric area here.

The comprehensive offering includes integration tools, a Spark-based analytics platform, a real-time analytics tool and an enhanced Power BI that enables user-friendly visualization and AI-based analytics. In addition, Fabric includes a new no-code developer interface that allows users to monitor their data in real time and trigger actions and notifications based on incoming information[1][2].

Architecture of Microsoft Fabric — Source: Microsoft[1]

I have already introduced the feature in another article about Power BI where the AI based solution is also supposed to simplify the creation of analyses and reports.

Through the tool, users experience several benefits such as easier and platform-independent data integration and analysis. Also the processing of data by ETL and ELT processes should be simplified, according to the motto Zero ETL that many of the large cloud providers go. In the area of data analysis, however, it is also possible to make suggestions and generate queries by entering text requests. Fabric, therefore comes with seven core workloads[1]:

  • Data Factory: This provides more than 150 connectors to cloud and on-premises data sources, drag-and-drop experiences for data transformation, and the ability to orchestrate data pipelines.
  • Synapse Data Engineering: This offers the possibility of good authoring experiences for Spark, instant start with live pools, and the ability to collaborate.
  • Synapse Data Science: This provides an end-to-end workflow for data scientists to build sophisticated AI models.
  • Synapse Data Warehousing: This provides a converged Data Lakehouse and Data Warehouse experience.
  • Synapse Real-Time Analytics: This enables developers to work with data streaming in from the Internet of Things (IoT) devices, telemetry, logs, etc.
  • Power BI in Fabric: This provides industry-leading visualization and AI-driven analytics that enable business analysts and business users to gain insights from data.
  • Data Activator: This provides real-time detection and monitoring of data and can trigger notifications and actions when it finds specified patterns in data, all in a no-code experience.

It is important to note here that most of the features, which are quite fresh, are available in preview for the time being. That is not necessarily intended for productive use, but this should change shortly.

Sources and Further Readings

[1] Microsoft, Introducing Microsoft Fabric: Data analytics for the era of AI (2023)

[2] AppMaster, Microsoft stellt Fabric vor, eine umfassende Daten- und Analyseplattform für Multi-Cloud-Integration (2023)

Microsoft
Data Science
Azure
Technology
Business
Recommended from ReadMedium