This course introduces you to the concept of using PySpark to merge data in Lakehouses, helping you understand how Fabric handles large-scale data processing with flexibility and performance in mind. Manuel walks you through a hands-on example of writing a PySpark merge statement in Fabric, showing you where to write, how to test, and how to run the code directly in the platform. Whether you’re new to PySpark or exploring how Fabric supports advanced data workflows, this session provides a practical, focused introduction to a powerful technique.
Overview
COURSE DIFFICULTY
COURSE DURATION
1h 37m
Skills Learned
After completing this online training course, students will be able to:
Transform and prepare data for analysis
Publish and share reports through Power BI Service
Write T-SQL queries for data retrieval and manipulation
BI Developers, Data Analysts, Database Administrators, Excel Power Users
None
01. What You Need to Get Started
02. Introduction
03. Connecting to a SQL Server
04. Connecting to a Blank Query
05. Connecting to a CSV
06. Connecting to a Folder
07. Connecting to a Live Semantic Model
08. Connecting to a Microsoft Access Database
09. Connecting to a SharePoint Folder
10. Connecting to a SharePoint List
11. Connecting to a Website
12. Connecting to Dataverse
13. Connecting to an Excel File
14. Connecting to Google Sheets
15. Connecting to JSON File and Web
16. Connecting to Salesforce
17. Connecting to Snowflake
18. Connecting to Your Outlook Calendar
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Transform and prepare data for analysis
Publish and share reports through Power BI Service
Write T-SQL queries for data retrieval and manipulation
WHO SHOULD ATTEND
BI Developers, Data Analysts, Database Administrators, Excel Power Users
PREREQUISITES
None
COURSE OUTLINE
01. What You Need to Get Started
02. Introduction
03. Connecting to a SQL Server
04. Connecting to a Blank Query
05. Connecting to a CSV
06. Connecting to a Folder
07. Connecting to a Live Semantic Model
08. Connecting to a Microsoft Access Database
09. Connecting to a SharePoint Folder
10. Connecting to a SharePoint List
11. Connecting to a Website
12. Connecting to Dataverse
13. Connecting to an Excel File
14. Connecting to Google Sheets
15. Connecting to JSON File and Web
16. Connecting to Salesforce
17. Connecting to Snowflake
18. Connecting to Your Outlook Calendar
