What is Microsoft Fabric?

Pubudu Dewagama
3 min readFeb 7, 2024

--

Microsoft Fabric is an all-in-one analytics solution for enterprises that covers everything from data movement to data science, real-time analytics, and business intelligence. It offers a comprehensive suite of services, including a data lake, data engineering, and data integration, all in one place.

To Watch the video tutorial, you can access:-https://www.youtube.com/watch?v=13CTq4NQpiA&t=129s

You no longer have to patch together various services from various vendors when using Fabric. Instead, you can benefit from a fully integrated, all-encompassing, and user-friendly platform that is created to make your analytics needs simpler.

The platform is based on Software as a Service (SaaS), which raises the bar for simplicity and integration.

Data Engineering: In order to do large-scale data transformation and democratize data through the lakehouse, data engineers need a top-notch Spark platform with exceptional writing experiences. This is what Data Engineering Experience offers. Spark tasks and notebooks can be planned to the integration of Microsoft Fabric Spark with Data Factory.

Data Factory: Azure Data Factory combines the simplicity of Power Query with the scale and power of Azure Data Factory. You can use more than 200 native connectors to connect to data sources on-premises and in the cloud.

Data Science: The Data Science experience enables you to build, deploy, and operationalize machine learning models seamlessly within your Fabric experience. It integrates with Azure Machine Learning to provide built-in experiment tracking and a model registry. Data scientists are empowered to enrich organizational data with predictions and allow business analysts to integrate those predictions into their BI reports. This way, it shifts from descriptive to predictive insights.

Data Warehouse: Data Warehouse experience provides industry-leading SQL performance and scale. It fully separates compute from storage, enabling independent scaling of both components. Additionally, it natively stores data in the open Delta Lake format.

Real-Time Analytics: observational data, which is collected from various sources such as apps, IoT devices, human interactions, and so many more. It’s currently the fastest-growing data category. This data is often semi-structured in formats like JSON or text. It comes in at high volume, with shifting schemas. These characteristics make it hard for traditional data-warehousing platforms to work with. Real-Time Analytics is best-in-class engine for observational data analytics.

Power BI: Power BI is the world’s leading business intelligence platform. It ensures that business owners can access all the data in Fabric quickly and intuitively to make better decisions with the data.

OneLake is the backbone of Microsoft Fabric. The data lake is the foundation on which all the fabric services are built. Microsoft Fabric Lake is also known as OneLake. It’s built into the Fabric service and provides a unified location to store all organizational data where the experiences operate.

OneLake is built on top of ADLS (Azure Data Lake Storage) Gen2. It provides a single SaaS experience and a tenant-wide store for data that serves both professional and citizen developers. The OneLake SaaS experience simplifies the experiences, eliminating the need for users to understand any infrastructure concepts such as resource groups, RBAC (Role-Based Access Control), Azure Resource Manager, redundancy, or regions. Additionally it doesn’t require the user to even have an Azure account.

Microsoft Purview is a comprehensive data governance solution designed to empower organizations in discovering, classifying, and managing their data assets across the enterprise. This platform addresses challenges related to data sprawl, regulatory compliance, and data privacy by providing features such as data discovery and cataloging, automated data classification, sensitivity labeling, data lineage tracking, and impact analysis. Purview offers a centralized hub for understanding the data landscape, supporting users in visualizing data relationships, and ensuring compliance with data protection policies. It integrates seamlessly with other Microsoft services like Azure Synapse Analytics, Azure Data Factory, and Power BI, contributing to a cohesive and efficient data ecosystem. For the latest and most detailed information about Microsoft Purview, it is recommended to refer to Microsoft’s official documentation or website.

Thank you !!!

--

--