Reviewing the Tables

1. Reviewing the Tables

Let's talk about the data we're working with. You should have already run the setup scripts that creates the two tables. If you haven't done it already, go back and review the reading. The first table is a sales conversations. Each row is a full transcript from a sales call, includes customer name, the deal stage, which rep was on the call, the date, the most importantly, the full conversation transcript. This is unstructured data. The second table is the sales metrics. This has the quantitative side, the deal ID, customer name, deal value, closing date, sales stage, whether it was won or lost, which rep owns it and what product line it's part of. This is structured data. Here's a preview of what your agent will be able to do. Someone asks, what were the main concerns in a TechCorp discovery call? Your agent uses search service to find conversation, pulls out the relevant sections about the integration timeline concerns and legacy system X migration, and gives you a clear summary with direct quotes. Someone else asks, what's our win rate for enterprise suite deals? Your agent uses the semantic view to query the metrics tables, calculates the win rate for the specific product line, and gives you the number with context about how many deals that represents. And a sales leader asks which deals are most likely to close this quarter and why. Now your agent needs both data sources. It queries the metrics to find the deals in the late stage with high values. Then it searches conversations to understand deal momentum, customer sentiment, and what blockers exist. The answer combines hard numbers with conversation insights. This is a difference between a simple chatbot and a real agent. Your agent autonomously decides which tools to use based on the question. You don't say search this or query that, it figures it out, that's autonomy. By the end of this module, you'll understand exactly how these pieces come together. You'll have built each component yourself and you'll have a sales intelligence agent that's ready for your team to use. Are you ready? Let's start building. Join me in the next video where we'll dive deep into semantic views and why your agents need them.

2. Let's practice!

Create Your Free Account

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.