Demystifying AutoML; Building Machine Learning Models with Azure
Proposed session for SQLBits 2026TL; DR
“Machine learning is often seen as complex and inaccessible. This session explains ML and AutoML from first principles and shows how Azure AutoML can build, deploy, and consume models end to end. Ideal for data professionals new to ML.
Session Details
This session introduces Machine Learning from first principles, explaining the core concepts in a clear and accessible way. It clarifies how Machine Learning relates to Artificial Intelligence, showing how it is a branch of AI with a distinct purpose and approach, helping attendees understand where each fits.
The focus then moves to AutoML, exploring what is actually being automated across the machine learning lifecycle and why this is valuable for both newcomers and experienced practitioners. Realistic examples are used to demonstrate the types of problems that can be solved using Azure AutoML.
The session is built around three demonstrations. The first provides a guided tour of Azure Machine Learning Studio. The second shows how to create an AutoML model end to end, from data ingestion through training and deployment as a web service, with a brief coded example in VS Code using the Azure ML extension to show a faster, code-first approach. The final demo demonstrates how to consume predictions from the deployed model using a simple Excel and VBA interface, making machine learning outputs accessible through a familiar tool.
This session is aimed at data professionals who want a practical understanding of what machine learning and AutoML are, how they work, and how they can be applied using the Azure platform.
By attending this session, you will understand the difference between AI and machine learning, learn what AutoML automates across the ML lifecycle, see how to build and deploy AutoML models in Azure, and learn how to consume model predictions in tools such as Excel.
The focus then moves to AutoML, exploring what is actually being automated across the machine learning lifecycle and why this is valuable for both newcomers and experienced practitioners. Realistic examples are used to demonstrate the types of problems that can be solved using Azure AutoML.
The session is built around three demonstrations. The first provides a guided tour of Azure Machine Learning Studio. The second shows how to create an AutoML model end to end, from data ingestion through training and deployment as a web service, with a brief coded example in VS Code using the Azure ML extension to show a faster, code-first approach. The final demo demonstrates how to consume predictions from the deployed model using a simple Excel and VBA interface, making machine learning outputs accessible through a familiar tool.
This session is aimed at data professionals who want a practical understanding of what machine learning and AutoML are, how they work, and how they can be applied using the Azure platform.
By attending this session, you will understand the difference between AI and machine learning, learn what AutoML automates across the ML lifecycle, see how to build and deploy AutoML models in Azure, and learn how to consume model predictions in tools such as Excel.
3 things you'll get out of this session
- understand the difference between AI and machine learning
- learn what AutoML automates across the ML lifecycle
-learn how to consume model predictions in tools such as Excel.
Speakers
Lewis Prince's other proposed sessions for 2026
AI Beyond the Hype; Practical Solutions for Real Businesses - 2026
Automating Multilingual Document Translation with Microsoft Fabric and Azure AI - 2026
Responsible AI in Practice for the Microsoft Data Platform - 2026
Unlocking Insight from Text Using Azure AI Language Studio - 2026
Using Microsoft Copilot Studio to Build Chatbots That Answer Questions and Take Action - 2026
Lewis Prince's previous sessions
Fast and Efficent Text Analysis using Azure's Language Cognitive Service
We will go on a whirlwind tour of Azure Cognitive Services Language Studio, to show the wealth of tools available there, and then talking in particular about Key Word Extraction, Sentiment Analysis and Opinion Mining. We will apply these concepts through Language Studio APIs via Python on Customer Reviews data to then feed into a Power BI report to show how we can really squeeze so much more useful data out of chunks of text!
Copilot Studio: Guiding Your Chatbot Takeoff with AI Aviation!
I will talk you through how I created the Copilot chatbot for the SQLBits website.
The SQLBits Website ChatBot with Copilot Studio: How I built the chatbot for this events website)
I will talk you through how I created the Copilot chatbot for the SQLBits website.
Model Creation in Azure AutoML and Ingestion Through Excel
We will go through a brief introduction to what Machine Learning is and some of its applications. we will then explore why AutoML should be used by all; as a great starting point for anyone new to Machine Learning, as well as a time saving tool for those more experienced. Finally, we will expose a model as an endpoint and understand how we can use it. Specifically in this case how to use it in excel via VBA.
Technologies I will demonstrate are:
- Azure Machine Learning Studio
- VS code (with Azure Machine Learning Studio extension)
- Python
- VBA