Enabling AI in your Data Practice with Ginger Grant

Schedule

Fri Jun 26 2026 at 09:00 am to 05:00 pm

UTC-05:00
Location

Microsoft Corporation | Austin, TX

Advertisement
AI promises productivity gains. This day long session shows you how to embed AI into SQL Server 2025 and Microsoft Fabric.
About this Event

This workshop will provide participants with the knowledge and tools to create an enterprise-ready Microsoft Fabric environment. The workshop covers everything from getting started, gathering data from different sources, transforming the data into an analytical model, securing access, and monitoring its performance. As Fabric provides many different methods for performing these tasks, we will cover a variety of different development tools, including using shortcuts, copying data, pipelines, Data Flow Gen 2, and notebooks, and explain which is the best choice in a given situation.
Participants will practice the steps in hands-on exercises using medallion architecture to transform the data into an analytical lakehouse, which can be used for ad-hoc querying and, of course, as a source for Power BI reports. Participants will learn how to provide ongoing maintenance, security, and monitoring of the lakehouse to ensure it is an enterprise-level solution. The workshop experience and examples will provide participants with the knowledge needed to implement the techniques to create their own lakehouse.
By the end of the session, participants will not only understand the technical steps involved but also when and why to choose a lakehouse architecture for their organizational data needs.
Agenda Breakout
Lakehouse architecture and capabilities in Fabric
•Overview of all you can do with a Fabric
• One lake and Fabric Architecture
• Parquet and Delta Lake
• Architectural reasons for selecting data stores
• Developing a Lakehouse with Medallion Architecture
• Process Description
• Workspace Organization
• Component organization
Loading Data
• Using the copy command
• Shortcuts
• Data Exploration in the Lakehouse with SSMS and Azure Data Studio
Implementing optimal data storage designs
• Dimensional modeling
• Transforming data with Pyspark and Spark SQL
• Data flow Gen2
Using Fabric in Your Environment
• Power BI Direct Lake
• Loading data to a Data Warehouse
• Sharing
• Security
• Monitoring and Performance
• Default and other semantic modeling
This course includes follow-along exercises. You will need access to a Fabric environment to complete the exercises.


Advertisement

Where is it happening?

Microsoft Corporation, 10900 Stonelake Blvd, Austin, United States

Event Location & Nearby Stays:

Tickets

USD 150.00

Know what’s Happening Next — before everyone else does.
Austin SQL Server User Group
Host or PublisherAustin SQL Server User Group

Ask AI if this event suits you