Future-Proof Your Career, Master Data Skills + AI


Future-Proof Your Career, Master Data Skills + AI


What is Microsoft Fabric? A Guide to Features & Benefits

by | 4:42 pm EDT | June 22, 2023 | Microsoft Fabric, Power BI

Imagine a one-stop shop that not only crunches numbers like it’s eating cereal for breakfast but also has the power to deliver those “aha” insights that make you feel like a mastermind. This platform is transforming the way we make sense of data and is putting powerful analytics in the hands of many, not just data science wizards. Excited? Yeah, us too. We’re talking about Microsoft Fabric.

Microsoft Fabric is a new unified data analytics platform from Microsoft that’s bringing together a range of data technologies, some of which are already available in the Azure universe, under one umbrella. Its goal is to enable business and data professionals to unlock the potential of their data and lay the foundation for a new era of AI.

This article aims to demystify Microsoft Fabric. We’ll delve into the core of Fabric and explore its features, capabilities, and the value it brings to developers and organizations. We’ll also go over how you can start your free 60-day trial today.

Let’s dive in!

What is Microsoft Fabric?

What is microsoft fabric

Microsoft Fabric is an all-in-one analytics platform designed for organizations that covers everything from data storage and data movement to data science and real-time analytics.

It’s a unified platform that brings together a diverse range of technologies and tools into a single solution. It offers a comprehensive suite of services, including data lake, data engineering, and data integration, all in one place.

This isn’t the first time Microsoft has done something of this sort; back in 2015, it did the same by bringing together Power Query, Power View, and Power Pivot under the Power BI umbrella.

Over the years, Power BI has grown to become an integral part of business intelligence services offered across the globe and now ranks at the top of Gartner’s Magic Quadrant for data analytics and BI platforms.

Microsoft seems to be trying to do the same with Fabric, which is merging Microsoft’s three main data analytics products: Power BI, Azure Synapse, and Data Factory.

In the next section, we’ll go over the components that now fall under the Microsoft Fabric umbrella.

Components of Microsoft Fabric

As part of the Microsoft Fabric trial, users can access six exciting services. One component called Data Activator is currently still in private preview but will likely become available soon, so keep an eye out for updates!

Now let’s go over the six services you can access via Fabric.

1. Data Factory

Homepage of Data Factory

Data Factory brings together the best of Azure Data Factory and Microsoft Power Query.

It enables organizations to seamlessly access a variety of data estates and unlock value with a data integration experience that combines the ease of use of Power Query with the scale and power of Data Factory.

In Microsoft Fabric, Data Factory empowers you with:

  • Data pipelines directly in Fabric: The service comes with a rich set of integration capabilities, enabling you to begin any copy task from data sources to data destinations.
  • Extensive connectivity: It supports connectivity to more than 170+ data stores, including cloud databases, on-premises data sources, analytical platforms, and more.
  • Built-in artificial intelligence: Like other tools in the Microsoft 365 suite, Data Factory also comes with AI that can help you accelerate and automate common tasks.
  • Next-gen Power BI dataflows: You can access more than 300 data transformations right out of the box, including AI transformations and scalable data flows.

Data Factory offers a low code but customizable experience for creating a powerful and comprehensive data solution

2. Synapse Data Engineering

Home page for Synapse Data Engineering

As the amount of data that organizations need to process continues to grow ever larger, there’s no denying the importance of data engineering.

Synapse Data Engineering is one of the core products offered by Fabric. It empowers data professionals to collaborate on their projects, ranging from data warehousing, data integration, business intelligence, and data science.

Some of its key experiences include:

  • Robust lakehouse architecture: Synapse Data Engineering brings the best of data lake and data warehouse, reducing the friction of ingesting, transforming, and sharing data. It can also be used to leverage the power of Apache Spark to transform data at scale and build out a robust lakehouse architecture.
  • Runtime 1.1. to give users a great default performance: Synapse Data Engineering ships with Runtime 1.1, which includes Python 3.10, Apache Spark 3.3.1, and Delta 2.2. Spark Runtime is pre-wired to every workspace by default so no tuning is required.
  • Notebooks for a superior developer experience: Synapse Data Engineering features notebooks that support a variety of tools, programming languages, and libraries. Notebooks have native lakehouse integration, co-authoring, and integration with Spark, VS Code, and more.

These are just a few of the features that are currently available in Synapse Data Engineering. Microsoft plans to release a wide variety of capabilities over the coming months, including copilot integration, enhanced lakehouse security, environments, and more.

3. Synapse Data Warehouse

Homepage for Data Warehouse

Synapse Data Warehouse brings next-gen data warehousing capabilities to Microsoft Fabric. It natively supports an open data format so data engineers, IT teams, and business users can seamlessly collaborate without compromising enterprise security.

Some of its improvements over the previous data warehouse generation include:

  • Fully managed: Synapse Data Warehouse is a fully managed SaaS solution with features to support those with no coding skills and developers who love to write code.
  • Open data standards: Data is not locked behind the proprietary SQL Server format. Synapse Data Warehouse uses an open data standard and supports interoperability with the Spark ecosystem.
  • Cross-querying: Thanks to the open data standard support, data in the warehouse can be queried and cross-joined in Fabric or any other computer engine.
  • Automatic scaling: The data warehouse can automatically scale its resources as usage requirements go up and scales down when those resources aren’t needed anymore, all without user intervention.

All of this and more can be accessed from the Fabric homepage for Data Warehouse. All you need to do to get started is a name and a sensitivity label. No additional setup is required!

4. Synapse Data Science

Homepage for Synapse Data Science

Synapse Data Science enables data scientists to work on top of the same secured data that has been prepared by data engineering teams without having to copy data or figure out ways to gain secure access.

Additionally, users can gain access to a variety of experiences, including machine-learning tools, low-code tools, and collaborative code authoring through Notebooks and Visual Studio Code.

Some of the core experiences offered by Synapse Data Science include:

  • Data Wrangler: Data Wrangler is a powerful tool for all your data preparation needs. It makes cleaning and preparing data easier than ever before with seamless integration with Python libraries like Pandas. Future updates will include support for natural language processing via Azure OpenAI and Spark.
  • Access to ML tools: Synapse Data Science has built-in ML tools and supports MLFlow and the Synapse ML library. Depending on your settings, your data team can use it to run experiments with machine learning models and capture key metrics to further train models and gain insights from data.
  • R language support: In addition to supporting code authoring with Python, Data Science also has native support for the R language on Apache Spark.

In the near future, Microsoft plans to add numerous other features to Synapse Data Science, including Semantic Link, hyperparameter tuning and AutoML, Copilot, and pre-trained AI models.

5. Synapse Real-Time Analytics

Synapse real-time analytics homepage

Synapse Real-Time Analytics makes data integration simple for large organizations and enables quick access to data insights through automatic data streaming, indexing, and partitioning and auto-generated visualizations and queries.

Real-Time Analytics can ingest data in any format and from any source without the need of complex scripts or data models to transform data. It has unlimited scalability (from terabytes to petabytes) for concurrent users and queries, making it the perfect solution for organizations that work with high-volume, high-speed data streams.

The best part? It’s seamlessly integrated with all of Fabric’s components, including Power BI, Lakehouse, and Data Warehouse.

Some other features of Synapse Real-Time Analytics include:

  • Instant Power BI report generation: You can create reports for your data with just one click.
  • Use of only one logical copy: Your data is stored in Microsoft OneLake and directly integrated into other Fabric components.
  • Real-time streaming and complex data structure transformation: It can begin querying data within seconds of ingestion

Synapse Real-Time Analytics offers a variety of data analytics services and simplifies integration with other Microsoft Fabric services.

Its ability to ingest and query data from any source for data analysis as well as scale to handle large volumes of data makes it an ideal service for organizations that want to stay on top in a data-driven world.

6. OneLake

OneLake data hub

OneLake is what Microsoft is calling the “OneDrive for data.” It’s a multi-cloud data lake where you can store all your organizational data, just like how you can use OneDrive for your documents.

It provides you with:

  • One data estate that can scale with your organization’s needs
  • One data copy for use across numerous analytical engines available in Fabric (T-SQL, Spark, etc.)
  • One universal security model so you only have to define security definitions once that are enforced across all analytical engines

OneLake is basically a centralized Microsoft data platform for managing data with your team. Collaboration is baked in and one Fabric tenant automatically gains exactly one OneLake instance where all of your organization’s data is stored — no additional setup is necessary!

Some core features of OneLake include:

  • Unified management and governance: Through OneLake workspaces, different teams can work independently using the same data lake. Each workspace can have its own admin and access control.
  • Data mesh and domains: OneLake lets teams organize data logically and efficiently by enabling different business groups to operate and manage their own data. For instance, you could use data mesh to define a variety of business domains, such as sales, human resources, marketing, ecommerce, and more. Each domain will contain its respective data (engagement and site statistics, personalized content and ads, etc.), enabling optimized consumption and more granular control for admins.
  • Open at every level: OneLake is built on Azure Data Lake Storage Gen2 and can support any file type. All of Fabric’s components like Power BI, lakehouses, and warehouses will automatically store their data in OneLake.
  • File Explorer for Windows: You can access OneLake directly from Windows using the OneLake file explorer app. This app integrates OneLake and Data Lake for Fabric right into your Windows File Explorer, simplifying data warehousing and making data accessible even to non-technical users.

To sum up, OneLake is a centralized solution for all your data needs that’s integrated directly into Microsoft Fabric and Power BI Desktop. Using OneLake, you can eliminate data silos and enable quick and easy access to necessary data in any context.

To learn more about how to set up and use OneLake, check out the official documentation.

Alright, now that we’ve gone over what Fabric has to offer, let’s discuss how you can get started with the platform in the next section!

How to Get Started With Microsoft Fabric

Fabric sign-up page

Microsoft Fabric is currently in public preview, and you can try out its features by signing up for the free 60-day trial — no credit card information required!

To get started, go to app.fabric.microsoft.com. Sign up by clicking the “Try for free” button and entering your organization email.

You must have a Power BI license; if you don’t have one, check out our comprehensive guide on Power BI to learn how to get started.

If you’re already a Power BI user, then Fabric is enabled by default in your account. You just need to activate the trial from your Power BI account.

Upgrade to a free Fabric trial

After you click “Upgrade,” you’ll receive a confirmation message. Refresh your page, and you’ll now have access to Fabric.

To see how many days remain in your trial, click on the “Account manager” in the top-right corner. You can see your trial status as well as the option to cancel the trial.

Trial countdown under account manager

Notice there’s also an option to “Buy Fabric now” in the menu. If you like Fabric and its components, you have the option to purchase different Fabric capacities for your organization or individual needs. To learn more about the available options, check out this guide.

Final Thoughts

Microsoft Fabric is a significant step forward in simplifying the data analytics landscape. By integrating various tools and services under one umbrella, it allows organizations to focus on results rather than the complexities of technology.

With its focus on simplicity and integration, Fabric is set to make a significant impact on the data analytics market. It’s also laying the foundation for a future powered by AI, which is becoming a transformative force that’s enhancing the capabilities of data analytics tools.

As we wrap up this comprehensive overview of Fabric, remember that the journey doesn’t end here. The world of technology is constantly evolving, and Fabric is just one piece of the puzzle that’s opening up a new world of possibilities for data professionals!

To learn more about Microsoft Fabric and its use cases, check out the video below:

Frequently Asked Questions

What is Microsoft Fabric?

Microsoft Fabric is an all-in-one analytics platform that’s combining a variety of tools from the Azure universe and offering some new capabilities, including real-time analytics, business intelligence, data engineering, data lakes, and more.

Is Microsoft Fabric free?

Microsoft is offering a free 60-day trial that gives access to Fabric’s full capabilities. There is also an option to purchase a license once your trial period is up.

Will Microsoft Fabric replace Power BI?

No, it won’t. However, Microsoft has renamed the Power BI administrator role to Fabric administrator to reflect its decision to put all of its products and services, including Azure Active Directory and Microsoft 365, under the Fabric umbrella.

Related Posts