Welcome to this Microsoft solutions workshop on Microsoft Fabric for the Data Professional. Microsoft Fabric is an end-to-end analytics solution with full-service capabilities including data movement, data lakes, data engineering, data integration, data science, real-time analytics, and business intelligence—all backed by a shared platform providing robust data security, governance, and compliance.
In this workshop, you'll learn what the Microsoft Fabric platform is, the various services and components it contains, how to create, use and manage a deployment, from the point of view of the data professional. The focus of this workshop is to understand how to use Microsoft Fabric in a solution, focusing on the data aspects of the platform.
We will start with a review of the scenario that we will be building. We will cover OneLake, how to connect, and the basics of setting up a Lakehouse with attaching Azure Data Lake Gen2 Storage. Then we will review Ingestions techniques such as Data Pipelines, Data Flows Gen 2, Database Mirroring, and more. We will also cover Data Warehousing, Real-Time Intelligence, advanced Lakehouse concepts such as Spark, Notebooks, and data enrichment. Finally, we will use Power BI to visualize the results of our scenario.
Please note that you will need access to a Microsoft Fabric Environment in order to complete the hands-on labs. The following prerequisites must be in place before the day begins: https://github.com/sqlballs/MicrosoftFabricPre-Con/blob/main/fabricoverview/00%20-%20Pre-Requisites.md
You will learn:
- Understand the individual components of Microsoft Fabric & when to use them
- Gain hands-on experience with Microsoft Fabric
- Understand how to utilize different components in conjunction with one another
Attendee Requirements:
This hands-on lab is taught using the following components, which you will install and configure in the sections that follow.
In order to complete the activities in this workshop, you must have a Power BI License and a Microsoft Fabric-Enabled Workspace. The steps for these requirements are explained below.
- For this workshop, you will be required to execute workloads using Microsoft Fabric. In order to do this you must first sign up for, or currently have, an M365 account with the proper permissions. If you do not have an M365 account with the proper permissions, you can sign up for a 90 day free trial of M365.
- Next you must have a Power BI Pro license. If you do not have a Power BI license you can sign up for one for free 60 day trial.
- You will also require a Microsoft Fabric Capacity or a Free trial Microsoft Fabric Capacity which will run for 60 days.
- Signing up for M365, Power BI, and Microsoft Fabric is free and does not require a credit card.
- Your Power BI Tenant must have Fabric Capacity enabled to create a Microsoft Fabric Workspace. Please review, Enable for your tenant and Enable for a capacity for instructions in how to do this.
You can also create a free Azure Subscription for 1 year with a $200 credit, and then provision a Microsoft Fabric Capacity and attach it to a Power BI Workspace.
Required Permissions
In order to be a Microsoft Fabric Admin for your organization, you must be in one of the following roles
- Global administrator
- Power Platform administrator
- Microsoft Fabric administrator
These roles are assigned in the Microsoft 365 Administration portal. Microsoft 365 user admins assign users to the Fabric administrator or Power Platform administrator roles in the Microsoft 365 admin portal.
The other requirements are:
- A M365 Subscription or organizational account with the proper rights - This will allow you to create a "domain" account which can be used to sign up for Power BI.
- A Power BI License - You must have a Power BI License to utilize Microsoft Fabric.
- A Microsoft Fabric Capacity - This could be a free trial or a provisioned Azure Capacity.
- A Computer with an Internet Browser - To participate in the activities in this Workshop you must have a computer and an internet browser.
- A Working Internet Connection - Microsoft Fabric is a SaaS, Software as a Service, platform hosted on the Internet. You must have internet connectivity to access Microsoft Fabric.
- Potentially: A Microsoft Azure Account: This is only required if you do not have a free trial Microsoft Fabric Capacity. This workshop uses the Microsoft Fabric which platform to host the Microsoft Fabric Capacity, and optionally you can deploy a Microsoft Fabric Capacity. You can use a free Azure account, an MSDN Account, your own account, or potentially one provided for you, if you can create about $200.00 (U.S.) worth of assets.
Note that all following activities must be completed prior to class - there will not be time to perform these operations during the workshop.
Activity: Set up M365 account, Power BI License, Microsoft Fabric Capacity, Validate you have a computer, and Internet
Open this link in a separate tab or window and follow all of the instructions.
Verification of pre-requisites for the Activities
In order to complete any exercises required in this class you should have followed the Pre-Requisites outlined in the Read.me file.
Validate that you have a Microsoft Fabric Enabled Workspace:
- Navigate to Tutorial: Create a Microsoft Fabric workspace
- Navigate to your Microsoft Fabric enabled workspace
- Click +New
- Click Show all
- Validate that you see the options available to you to create Microsoft Fabric objects such as a Lakehouse, a Data Warehouse, Pipelines, KQL Database, or an EventStream