Baton Rouge .Net, SQL Server & PowerBI User Groups Meeting

Agenda:
• 5:15 - 5:45 - Food and Drinks (Networking)
• 5:45 - 6:00 - Introduction/Announcements
• 6:00 - 7:15 - Presentations
• 7:15 - 8:00 - Open forum for questions

This month's meeting is being sponsored by Baton Rouge User Groups

Lighting Round: Doug Lubey
Architecting 1000s of APis to work together!

Main Speaker: Thomas LeBlanc

The Fabric capacity allows you, a data engineer versus a T-SQL analyst, to use Delta Tables in OneLake. This consistent Data Lake storage is an open-source structure that stores data in a column-store, compressed format. Column-store is faster for analytical reporting than rows in a database. The session starts with importing csv files and creating tables in a Lakehouse. The Monitor Hub will show the Spark engine processing the request. After creating a shortcut to parquet files in a storage account, a notebook will be shown to import that shortcut to a Lakehouse table. This data will then be ETL-ed into a Warehouse with a dataflow. Finally, we will create a Direct Lake semantic model for reporting in Power BI.