What is Microsoft Fabric?
Microsoft Fabric is the newly released one-stop shop for analytics, which spans data workloads from data movement to data science, Real-Time Analytics, and business intelligence. It offers a comprehensive suite of Software-as-a-Service (SaaS) data services, including data lake, data engineering, and data integration, all in one place.
Why is Microsoft Fabric is a big deal?
Microsoft Fabric adopted the lakehouse architecture with open-source Delta file format and provided a unified data lake that supports multiple data types, such as structured, semi-structured, and unstructured data. They also adapted the existing mature and performant query engines, from Power BI to the SQL engine, to fully support the delta format in favor of big data and analytical processing. By adapting and adopting structural for a long-term vision, Fabric helps enterprises leverage the power of data and gain insights for better decision-making.
What are the Components of Microsoft Fabric?
- Data Engineering is based on the same technology as the Spark pools in Azure Synapse Analytics; it allows for notebooks & thus gives a code-first data engineering. However, a nice touch: Spark resources in Fabric can now be provided serverless using “live pools”.
- Azure Data Factory combines the simplicity of Power Query with the scale and power of Azure Data Factory. You can use over 200 native connectors to connect to data sources on-premises and in the cloud.
- Data Science which provides for training, deployment, and management of machine learning models. This component is also mainly based on Spark, but incorporates elements of Azure Machine Learning, SQL Server Machine Learning Services, and the open-source MLflow project.
- Data Warehouse, known as initially Azure SQL Data Warehouse technology and now “converged” to Lakehouse. Note that to enable this and connect Fabric to OneLake (a Lakehouse), Microsoft made a massive effort in optimizing the SQL engine to ensure that BI users can benefit from Data-Warehouse-like performance while running actually 'on a Data Lake' and not a database.
- Real-Time Analytics aims to combine Azure Event Hubs, Azure Stream Analytics, and Azure Data Explorer and supports OT analytics and thus analytics on IoT, telemetry, log, and other streaming data sources.
- Power BI is Microsoft’s flagship business intelligence platform, but soon-to-be enhanced with a new large language model AI-based Copilot experience that can generate DAX (Data Analysis eXpressions — Power BI’s native query language).
Read more about the general concepts of Fabric:
- The (r)evolutions of Microsoft Fabric | element61
- Introducing Microsoft Fabric - an end-to-end, unified analytics platform | element61
- Microsoft Fabric Licensing & how will your existing Power BI licenses be affected? | element61
Getting started with Microsoft Fabric:
- How to load data from on-premises sources into Fabric using DataFlow Gen2 🦾 | element61
- Build your Lakehouse in Fabric with 3 easy steps | element61
- Creating a data lakehouse with Drag-and-Drop ETL in Microsoft Fabric | element61\
- Empowering your Databricks Lakehouse with Microsoft Fabric | element61
Governance in Microsoft Fabric:
- How Microsoft Fabric governance protects your data | element61
- Administration and Governance in Microsoft Fabric | element61
- Workspace Management in Microsoft Fabric | element61
- Secure your data in Microsoft Fabric! 🔐 | element61
Microsoft Fabric and Self-service BI:
Analytics in Microsoft Fabric:
- Comparing Direct Lake and Import Mode in Power BI | element61
- How Microsoft Fabric Enables Realtime Analytics for Business Success | element61
Microsoft Fabric and Data Science: