The SQLBits Website ChatBot with Copilot Studio: How I built the chatbot for this events website)

on YouTube ↗20m

" summary

SQLBits gets a website chatbot built with Copilot Studio that indexes the conference site as a source, is created in about 5 minutes, and is published via an iframe embed to the site. It answers low‑to‑medium complexity FAQs (venue, travel, childcare), returns source links for each answer, reduces repetitive volunteer queries, and runs 24/7. Setup includes topic prompts, system instructions for tone and behavior, and a publish step to push to Teams, web and messaging channels; multiple bots (four or five) live on the same Copilot account.

AI-written summary · about

" chapters (11)

1. 0:00Introduction
2. 2:16Business problem and goals
3. 5:32What is Copilot
4. 7:59What is Copilot Studio
5. 10:06Live demo: SQLBits chatbot
6. 11:12Testing with real questions
7. 14:54Optimizing topics and prompts
8. 16:46Setting personality and tone
9. 17:50Publishing the chatbot
10. 18:54Top tips for Copilot chatbots
11. 19:56Closing remarks

" related talks

• 36mWhat's new with Copilot StudioKendra Springer, Omar Aftab, Aarthy Longino, Gary Pretty, Jack Rowbotham, Peter Swimm · Microsoft Build 2024
• 48mBuild your own copilot with Copilot StudioKendra Springer, Gary Pretty · Microsoft Build 2024
• 42mLet’s Chat-Bots using Azure AILiji Thomas · AzConf 2020
• 47mBuilding Intelligent Enterprise-Grade Help Desk Bots using Conversational AIPrashant G Bhoyar · Build Stuff 2021
• 09mMaking the case for AI, chat bots, and Power BIMabel Gerónimo · Caribbean Developers Conference 2019
• 49mBuild your custom Copilot with Microsoft Copilot StudioDaniel Laskewitz · Devworld Conference 2025
• 10mHow to go from opening Visual Studio to interacting with a live chat bot in 10 minutesKristian Brimble · NDC London 2017
• 59mBuilding Intelligent Bots using Microsoft Bot Framework and Cognitive ServicesPrashant G Bhoyar · AzConf 2020