Virtual Microsoft Fabric Bootcamp
- Start: Sep 23, 2024 9:00 AM EDT
- End: Sep 26, 2024 5:00 PM EDT
- Cost: $2,995.00
- Instructor: Manuel Quintana
- Event Categories:
- Avaliable Seats: Limited seats remaining!
- Tickets: Get your ticket HERE
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
Get tickets:
| Ticket type | Price | Quantity |
|---|---|---|
| Virtual Microsoft Fabric Bootcamp (Sep 23, 2024 – 9/26/24) | $2,995.00 | |
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.