Virtual Microsoft Fabric Bootcamp

Start: Jul 22, 2024 9:00 AM EDT
End: Jul 25, 2024 5:00 PM EDT
Cost: $2,995.00
Instructor: Manuel Quintana
Event Categories:
Available Seats: Limited seats remaining!
Missed your change to sign up, but still want to get in on the fun? Contact us!
Need help convincing your boss? We can help.

Event description

Microsoft Fabric is an all-in-one analytics solution that encompasses everything from data movement to data science and business intelligence. It offers a comprehensive suite of services, including data lakes, data engineering, and data integration, all within a unified platform. The Microsoft Fabric bootcamp provides a comprehensive overview of the capabilities of Data Factory, Azure Synapse, and Power BI, seamlessly integrated into the Power BI Service. Participants will gain proficiency in the intricacies of the Data Lakehouse architecture, utilizing various technologies such as pipelines, notebooks, and Dataflows Gen 2.

Prerequisites

It is recommended attending the complimentary [Dashboard in a Day](https://events.microsoft.com/en-us/allevents/?search=pragmaticworks&language=English&clientTimeZone=1) before registering for this bootcamp.

System Requirements

Access to a Fabric capacity Power BI Service workspace or the ability to enable a Fabric trial on a workspace in Power BI Service
Admin access to the workspace
Power BI Desktop
A personal laptop if you work in a highly secure environment

Course Outline:

Module 01 – Microsoft Fabric Overview
- What is Microsoft Fabric?
- Fabric Personas
- Why Fabric vs. Synapse/Databricks
Module 02 – Microsoft Fabric Workspaces
- Permissions
- Best Practices
- Fabric Licensing and Settings
Module 03 – Fabric Lakehouses and OneLake
- OneLake Overview
- OneLake Data Hub
- Lakehouses
- Lakehouse SQL Endpoint
- Connecting to Lakehouse with External Tools (SSMS, Azure Storage Explorer, OneLake File Explorer)
Module 04 – Dimensional Modeling in Fabric
- Semantic Models
- Creating a Lakehouse for Single Source of Truth
- DAX Measures and Relationships in Lakehouse Semantic Model
Module 05 – Dataflows Gen2
- Extracting, Loading, and Transforming Data with Dataflows Gen2
- Power Query Editor in the Cloud for Data Transformation
Module 06 – Data Factory Pipelines in Fabric
- Copy Data Activity
- Scheduling Pipelines
- Pipeline Activities
Module 07 – Medallion Lakehouse Architecture – Bronze
- Pipelines
- Spark Notebooks
- Shortcuts
Module 08 – Medallion Lakehouse Architecture – Silver
- Transforming Data with Dataflows Gen2
- Transforming Data with Spark Notebooks
Module 09 – Apache Spark Notebooks with PySpark
- Spark Notebooks for ETL
- Spark Environments
- Spark ETL Data Wrangler
Module 10 – Medallion Lakehouse Architecture – Gold
- Fabric Data Warehouse
- Building New Semantic Models
- DirectLake Performance in Power BI
- DirectLake Optimization
Module 11 – Advanced PySpark Notebooks
- Delta Lake and Time Travel
- Changing Data Types and other transformations with PySpark
Module 12 – Data Science with R
- Using R in Fabric
Module 13 – Data Science with PySparks
- Leveraging PySpark in Fabric
Module 14 – Data Activator
- Monitoring Real-Time Data
- Actionable Insights
Module 15 – Fabric Lakehouse/Warehouse Security
- Row-Level Security in Fabric
- Object-Level Security
- Dynamic Data Masking
Module 16 – Azure DevOps Integration with Fabric
- Setup and Configuration
- Branching and Pull Requests

Add an event to your calendar

Instructor – Manuel Quintana

As a Training Content Manager and Trainer with Pragmatic Works, Manuel uses his extensive knowledge of the BI Stack (SSRS, SSIS, SSAS etc.) to deliver exciting and engaging content. He also has experience with T-SQL, DAX, Power Platform and Azure Data Services. Manuel, however, is known for his impressive knowledge of the Microsoft Power BI tool. A native of Puerto Rico, He graduated from the University of Central Florida and loves being involved in the world of business intelligence. Manuel is a thought leader in the BI community.