SQLBits 2024
Master Python in Fabric for Data Engineers
The world of data engineering is changing and being fluent in T-SQL is not enough anymore. In this full day workshop with lots of exercises you will get up to speed with Python and learn all the tips and tricks you need to know.
The world of data engineering is changing. Being fluent in T-SQL is not enough anymore. Whether you want to use Jupyter Notebooks to analyse your data or implement a Lakehouse in Microsoft Fabric, Python is the new kid on the block.
In this fullday workshop with lots of exercises you will get up to speed with Python and learn all the tips and tricks you need to know. The following topics will be covered:
- Syntax overview
- Leverage Jupyter Notebooks in Fabric
- Data Wrangling with Pandas
- Select, Group, Filter and Join data
- Big Data with PySpark
- Extract data from SQL Server, CSV files and Parquet files
- Load data into a Lakehouse as Parquet files and Delta Tables
In this fullday workshop with lots of exercises you will get up to speed with Python and learn all the tips and tricks you need to know. The following topics will be covered:
- Syntax overview
- Leverage Jupyter Notebooks in Fabric
- Data Wrangling with Pandas
- Select, Group, Filter and Join data
- Big Data with PySpark
- Extract data from SQL Server, CSV files and Parquet files
- Load data into a Lakehouse as Parquet files and Delta Tables
Speakers
Arthur Graus's previous sessions
Master Python in Fabric for Data Engineers
The world of data engineering is changing and being fluent in T-SQL is not enough anymore. In this full day workshop with lots of exercises you will get up to speed with Python and learn all the tips and tricks you need to know.
Python in Fabric for Data Engineers: all you need to know
The data engineering landscape is evolving. T-SQL proficiency isn't enough now. Dive into modern tools like Delta Lake, Jupyter Notebooks, and MS Fabric with Python. This session covers Python syntax, Jupyter in Fabric, data manipulation with Pandas, PySpark for Big Data, and data extraction/loading techniques for various formats.
Power Query formule language M for beginners
M is the formula language behind Power Query. Any transformation you apply to your data is translated into M code. Knowledge of this language opens doors that remain closed if you only use the GUI.