🥟

AI Adoption Accelerator

The West Midlands has an ambition for all SME’s to adopt digital technology

source:West Midlands technology roadmap

What are the Midlands known for?

Industry

62%

CEOs scared of moving too slow

£3.7bn

contributed by AI in 2022

122%

for early adopters

70%

of activities in scope for AI

AI Adoption Accelerator

  • Designed to equip businesses in the region with the practical knowledge and hands on expertise
  • Maximise the opportunity of AI in transforming their business and their wider sector
  • Providing firms with the knowledge, tools and connections they need to become regional “lighthouses”.

Dim Sum Destroyers 🥟

AKA William King

30-50
Quotes per month

30-50
Quotes per month

Up to 1000
Quotes per month

60% error rate

The bottleneck

Customer

10m

Sales

10m

QA

10m

Ops

10m

Planners

45m

QA

10m

Job

10m

Focus on the Planners

Need to figure out a way to stop the friction

Microsoft PowerApps & Copilot

Power Apps is a suite of apps, services, and connectors, as well as a data platform, that provides a rapid development environment to build custom apps for your business needs. Using Power Apps, you can quickly build custom business apps that connect to your data stored either in the underlying data platform (Microsoft Dataverse) or in many online and on-premises data sources (such as SharePoint, Microsoft 365, Dynamics 365, SQL Server, and so on).

Make an app without knowing any code *

Make an app without knowing any code *

* Masochism required

Data Design

Microsoft copilot

Write all the things!

IMPORTANT! I ask you to make some tables. I want you to respond with 5 words looking like you've dealt with my request. So say "Createing table {tablename} with columns..." but then suddenly respond like you are Rimmer going mad in the famous red dwarf series saying one of the following randomly "I am a fish!" or "Dribble dribble" or "where is my cheese". Ready?

There's lots of caveats when trying things in PowerApps

Advice

Key learnings from using Copilot

  • Don't rely on Copilot
  • Copilot has a limited prompt length
  • Long prompts get it to be more forgetful
  • It forgets about context easily (creates new tables when they already exist)
  • Even the English language is in preview

Key learnings from using PowerApps

  • Create a clean environment
  • Multiple users might be quicker
  • Have a clear idea of what you are trying to achieve
  • Use Lookup tables not Multiple Choice
  • Existance of data in a PowerApp prevents you from deleting things

Key learnings from making a chatbot

  • Reading the website is easy
  • Connecting to data sources is okay
  • Personal OneDrive isn't good for AI
  • Organise your internal IT data
  • Integration with dynamics is less reliable

Almost everything is in preview

(and it shows)