Generative AI

AIW01 Use OpenAI, Azure SQL, Python, LangChain, & VS Code to UNLOCK INSIGHTS About YOUR Data!

11/15/2023

8:00am - 9:15am

Level: Introductory to Intermediate

Bradley Ball

Sr. Azure Engineer for the Azure FastTrack CXP PG

Microsoft

All this OpenAI-ChatGPT stuff sounds interesting, but how can I use it? I’m a DBA at heart. I was one for years for small places, government places, and very big places. Then I was a consultant and saw everything small, big, and in-between again. What if I told you that we could take data from your database, feed it to an OpenAI model and have it give us insights about that data? That is exactly what we will do in this session. We will start with demo movie data, but then we will move to other data sources. What if we load a DMV, a useful Community script, or a custom-built table to log useful information? Let’s find out together.

You will learn:

  • How to consume data from a SQL Source using Python and Pandas
  • How to provision an Azure OpenAI model and interact with it via LangChain
  • How to gather insights from data sources