SQLBits 2023
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
Through this talk I will introduce the concept of Machine Learning and frame it in a simple manner to allow comprehension of the base concept. I will also talk about Machine Learning being in fact a branch of Artificial Intelligence and thus should not be thought of as one and the same but similar and distinct of each other. Following this I will then discuss AutoML as a concept paying particular attention to what we are automating (we will show this through talking holistically about the machine learning model lifecycle and highlight what is automated), why it is useful for both novices and experienced users alike (but for different reasons) and what problems can be solved via Azure based AutoML in particular (this will be accompanied with spoken examples to cement what is possible). The meat and bones of the talk will be 3 demos spread through the talk. The first will give a tour of the Azure Machine Learning Studio. The second will go through the process of creating an AutoML model through the Azure Machine Learning Studio from data ingestion to model deployment via a web service. I will also briefly go through a coded example in VS code (with Azure ML extension) showing how the same can be done in a faster and more efficient way if you have the necessary coding knowledge. Finally, the third demo will go through how to get predictions from the deployed model which I will demonstrate using a simple VBA in Excel based interface as excel is something that arguably everyone will be familiar with and so will be a great starting point.
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
Demystifying AutoML; Building Machine Learning Models with Azure - 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