Microsoft Fabric – New and “old”

Tram Ho

Introduce

image.png

  • The problem : an enterprise’s data analysis system often includes a number of services that use proprietary data formats because these services are provided from different vendors. This makes integration complicated, time consuming and expensive, and the resulting systems are often very fragile .
  • On May 23, 2023, a new Microsoft solution was born: Microsoft Fabric
  • Microsoft Fabric is a solution that is considered to cover all the data services an enterprise needs, from data to data science, real-time data analytics and data predictions. .
  • This means that businesses will not need to use many services from many providers , instead using many data analysis services from a single provider: Microsoft
  • built on top of Software as a Service (SaaS),

What makes Microsoft Fabric different?

Fabric is an end-to-end analytics product that addresses every aspect of an organization’s analytics needs. But according to the Microsoft homepage, there are five aspects that make Fabric different from other solutions on the market:

Fabric is a complete analytics platform

  • Each project will consist of multiple subsystems, each of which typically requires products from multiple vendors. Therefore, the integration of these products is expensive and complicated
  • With Fabric, customers can use a single product whose architecture provides all the necessary requirements for a developer, from storage and retrieval to analysis, prediction, reporting, and presentation of objects. with data
  • By providing a software-as-a-service (SaaS) experience, everything is automatically integrated and optimized, users can register and use it quickly without having to install it on a computer. or may own owner

Fabic is a Lake-centric and Open

  • Lake-centric :
    • The problem is that Data Warehouses today are relatively messy and complicated because each product in a subsystem can have its own data formats , which can cause duplication or difficulty in homogenization.
    • Fabric comes with a Cloud Data Lake, which is OneLake .
      • OneLake provides a single, unified storage system for developers where data discovery and sharing is easy with centrally enforced policies and security.
      • OneLake allows easy sharing of data between users and applications without the need to move and copy information unnecessarily.
  • Open :
    • Here comes the open data format
    • Customers only need to load data into the Lake once, and all jobs can operate on the same data without having to import it separately.
    • It also means that OneLake supports structured data in all formats and unstructured data, giving customers complete flexibility.
    • A single copy of data in OneLake can directly feed all workloads.

Fabric is powered by AI

  • Microsoft is combining Fabric with Azure OpenAI services in every layer
  • This helps customers unlock the full potential of their data
  • Enable developers to leverage the power of AI for data and help business users understand insights from their data

Fabric empowers every user in the enterprise

  • Business need to foster a data culture, where everyone in the organization can make better decisions based on data
  • Fabric integrates deeply with the Microsoft 365 apps that people use frequently today.
  • Specifically, Power BI is a core part of Fabric and is integrated across Microsoft 365. This means users can easily discover and access relevant data from OneLake right from Microsoft 365 (Excel, Teams). , PowerPoint, …)
  • For example, Microsoft Excel users can directly explore and analyze data in OneLake and generate reports using Power BI with the click of a button, or embed reports from Power BI into their PowerPoint presentations.

Fabric reduces costs through unification

  • As has been stated many times, today’s data analysis systems often combine products from multiple vendors into a single project, which is bound to cost a lot more than a customer buying a single one. The solution can cover all the services needed for an analytical system

7 main components of Microsoft Fabric

image.png

  • Data Factory : provides more than 150 connectors to on-premises data sources (data sources are stored and managed on an organization’s internal storage and server infrastructure) and in the cloud, besides Data Factory provides drag-and-drop capabilities to transform data and organize data pipeline
  • Synapse Data Engineering : Is a cloud data analysis service from Azure that provides tools for big data processing and analysis.
  • Synapse Data Science : Is a cloud data analytics service from Azure that provides tools to build and deploy machine learning and AI models.
  • Synapse Data Warehousing : Is a data warehouse service on the Cloud of Azure, providing the ability to store and retrieve big data.
  • Synapse Real-Time Analytics : Is a cloud data analysis service from Azure that enables live data analysis through real-time data streams.
  • Power BI : Is a data analysis and Business Intelligence tool from Microsoft that allows you to create and share reports, visualize data, and perform data analysis.
  • Data Activator : Not a major component of Microsoft Azure. However, it is possible that this is a third party product or tool related to data activation or data related tasks.

Fabric brings all of these experiences together into one unified platform to deliver the most comprehensive big data analytics platform in the industry.

summary

After a whole bunch of words, I want everyone to understand one essential thing as follows: Microsoft products such as Azure Synapse Analytics, Azure Data Factory or Azure Data Explorer are already available, and Fabric represents the development of Microsoft. those services in the form of simplified SaaS solutions that can be connected to those PaaS services , ie, in my opinion, to fully learn about Fabric, at least we need to understand what the 7 components mentioned above are and how to work with it. I will continue to update my knowledge about Fabric in upcoming articles.

I also saw a page that helps us equip Fabric a bit, you can check it outhere . Thank you everyone for reading my post ^^

Document

Share the news now

Source : Viblo