Explore end-to-end analytics with Microsoft Fabric

Completed

Scalable analytics can be complex, fragmented, and expensive. With Microsoft Fabric, you don't have to spend all of your time combining various services from different vendors. Instead, you can use a single product that is easy to understand, set up, create, and manage. Fabric offers persona-optimized experiences and tools in an integrated user interface.

In addition to a simple, shared user experience, Fabric is a unified software-as-a-service (SaaS) offering, with all your data stored in a single open format in OneLake. OneLake is accessible by all of the analytics engines in the platform. Fabric offers scalability, cost-effectiveness, accessibility from anywhere with an internet connection, and continuous updates and maintenance provided by Microsoft.

Explore OneLake

OneLake is Fabric's lake-centric architecture that provides a single, integrated environment for data professionals and the business to collaborate on data projects. Fabric's OneLake architecture facilitates collaboration between data team members and saves time by eliminating the need to move and copy data between different systems and teams. OneCopy is a key component of OneLake that allows you to read data from a single copy, without moving or duplicating data.

Think of it like OneDrive for data; OneLake combines storage locations across different regions and clouds into a single logical lake, without moving or duplicating data. Similar to how Office applications are prewired to use your organizational OneDrive, all the compute workloads in Fabric are preconfigured to work with OneLake. Fabric's data warehousing, data engineering (lakehouses and notebooks), data integration (pipelines and dataflows), real-time intelligence, and Power BI all use OneLake as their native store without needing any extra configuration.

Screenshot of the Fabric architecture built on OneLake.

OneLake is built on top of Azure Data Lake Storage (ADLS) and data can be stored in any format, including Delta, Parquet, CSV, JSON, and more.

What this means is that all of the compute engines in Fabric automatically store their data in OneLake. Data that is stored in OneLake is then directly accessible by all of the compute engines without needing to be moved or copied. For tabular data, the analytical engines in Fabric write data in delta-parquet format and all engines interact with the format seamlessly.

One important feature of OneLake is the ability to create shortcuts, which are embedded references within OneLake that point to other files or storage locations. Shortcuts allow you to quickly source your existing cloud data without having to copy it, and enables Fabric experiences to derive data from the same source to always be in sync.

Screenshot of the OneLake architecture displaying the Delta-Parquet storage format as the foundation for serverless compute.

Explore Fabric's experiences

Fabric offers a set of analytics experiences that are designed to accomplish specific tasks and work together seamlessly. Fabric's experiences include:

  • Synapse Data Engineering: data engineering with a Spark platform for data transformation at scale.
  • Synapse Data Warehouse: data warehousing with industry-leading SQL performance and scale to support data use.
  • Synapse Data Science: data science with Azure Machine Learning and Spark for model training and execution tracking in a scalable environment.
  • Synapse Real-Time Intelligence: real-time intelligence to query and analyze large volumes of data in real-time.
  • Data Factory: data integration combining Power Query with the scale of Azure Data Factory to move and transform data.
  • Power BI: business intelligence for translating data to decisions through interactive reports.

Fabric provides a comprehensive data analytics solution by unifying all these experiences on a single platform.

Explore workspaces

Fabric uses workspaces to contain the different items created across the different experiences. Each organization can customize how to separate and control access to the items. Some possibilities include a dedicated workspace for lakehouse development and a separate workspace for the production lakehouse.

In Microsoft Fabric, workspaces serve as logical containers that help you organize and manage your data, reports, and other assets. They provide a clear separation of resources, making it easier to control access and maintain security. Each workspace can have its own set of permissions, ensuring that only authorized users can view or modify the contents. This structure supports collaboration within teams while maintaining strict access control, which is crucial for both business and IT users.

Workspaces in Microsoft Fabric also offer settings to manage compute resources and integrate with Git for version control. You can configure compute settings to optimize performance and cost, ensuring that your resources are used efficiently. Git integration allows you to track changes, collaborate on code, and maintain a history of your work, which is essential for development and data management. Additionally, workspaces support features like data lineage and impact analysis, providing a comprehensive view of data flow and dependencies, which enhances transparency and decision-making.

Explore security and governance

Fabric's OneLake is centrally governed and open for collaboration. Data is secured and governed in one place, which allows users to easily find and access the data they need. Fabric administration is centralized in the admin center.

In the admin center you can manage groups and permissions, configure data sources and gateways, and monitor usage and performance. You can also access the Fabric admin APIs and SDKs in the admin center, which you'd use to automate common tasks and integrate Fabric with other systems.

Note

For more information about Fabric administration, see What is Microsoft Fabric admin.

Your Fabric tenant is natively integrated with Microsoft Purview Information Protection. Fabric uses Microsoft Purview Information Protection’s sensitivity labels to help your organization classify and protect sensitive data, from ingestion to export.