MICROSOFT FABRIC OVERVIEW
What is Microsoft Fabric?
A unified SaaS platform for data ingestion, storage, processing, real-time analytics, and reporting.
01 · PLATFORM ARCHITECTURE
One Unified SaaS Platform
Specialized Fabric experiences work together on a shared data foundation, eliminating the need to integrate multiple disconnected services.
02 · ONELAKE
One Data Lake for the Entire Organization
OneLake organizes data across tenants, workspaces, and Fabric items, enabling data to be reused across multiple workloads without creating unnecessary copies.
03 · FABRIC EXPERIENCES
9 Workloads Across the Entire Data Lifecycle
From data connectivity and processing to real-time analytics, reporting, AI, and operational data.
Data Factory
Pipelines · Dataflow Gen2 · Copy Job · Data connectivity and orchestration.
Data Engineering
Spark · Notebooks · Spark Job Definitions · Lakehouse (Delta format).
Data Warehouse
T-SQL · Delta · Enterprise data warehousing for relational analytics.
Real-Time Intelligence
Eventstream · Eventhouse · KQL Database · Real-time analysis of data in motion.
Data Science
Notebooks · Experiments · ML Models · MLflow.
Power BI
Semantic Models · Direct Lake · Reports and Dashboards.
Databases / Mirroring
Fabric SQL Database · Mirroring · Transactional data and replication into OneLake.
Industry Solutions
Industry-specific data and analytics solutions.
Fabric IQ (Preview)
Business Semantics · Ontology (Preview) · Data Agents.
04 · DATA FLOW
From Source Data to Decisions with Power BI
A reference data flow based on the Medallion architecture, with two serving-layer options designed to support different business and analytics requirements.
05 · GOVERNANCE & OPERATIONS
Govern Data from Access to Operations
Access control, data classification, lineage, auditing, and capacity monitoring are managed within a unified platform.
Workspace roles
Four standard roles: Admin, Member, Contributor, and Viewer.
Item sharing & permissions
Share individual items, manage access permissions, and control who can use them.
SQL permissions
Database roles, schema permissions, and object permissions for the SQL layer.
Semantic model RLS / OLS
RLS filters data at the row level, while OLS hides sensitive tables or columns within the semantic model.
Sensitivity labels
Classify and protect sensitive data according to organizational policies.
Lineage & Impact analysis
Track data dependencies and assess potential impacts before making changes to Fabric items.
Microsoft Purview Audit
Capture important activities to support auditing, investigation, and compliance requirements.
Capacity Metrics / Monitoring hub
Monitor capacity utilization, job status, and operational issues.
Considering Microsoft Fabric for Your Business?
BIVIET helps you define the right architecture, implementation roadmap, and starting point based on your existing data environment.