Kategorier: Alla - design - ai - technology - microsoft

av Sam Cammiss för 14 timmar sedan

809

Applied Design Thinking AI + ML

The course focuses on integrating design thinking with artificial intelligence and machine learning. It includes practical applications using various tools and platforms such as Tidio, ChatGPT, Microsoft Power Automate, and KNIME.

Applied Design Thinking
AI + ML

Applied Design Thinking AI + ML

...the Design Challenge

Design Sprint
Microsoft: Responsible AI
Design Thinking
Leveraging AI
IBM: Essentials for AI Workbook
IBM: Team Essentials
IBM: Design for AI

...the Technology

...hands on...
Agents

Custom GPTs

Go to GPT 4.0.


Click to Create a GPT.


Prompt the GPT Builder.


I want to create an assistant that guides the user through the process of calculating their carbon footprint in accordance with the Greenhouse Gas Initiative's Corporate Standard.


Name and Profile the GPT.


Configure the GPT.

Bus Uncle

Datacamp: Custom GPTs

OpenAI: GPTs

Chatbots

Go to Tidio.


Click to Create a FLOW.


Explore the "Lead Generation for Real Estate" Flow.


Flows > Leads Flows > "Lead Generation for Real Estate"

Test it Out

Use Template


Create a Flow.


Flows > Create from Scratch

Test it Out


Create an AI Chatbot.


Lyro AI Chatbot

Review Knowledge

Review Q&A Configuration

Review Website Knowledge

Review Suggestions

Explore Playground

Review Tasks

Analytics

Example From MIT...


Go to GPT 4.0.


Upload Data.


Prompt #1.


Please read in this dataset, describe it, and clean it by removing any years that contain all null values. Then please transpose this data set such that it forms a panel, with columns for country, years, and emissions. Only include non-null values in this preset.


Review Working.


Prompt #2.


Please provide a download link for the cleaned csv dataset.


Download Data.


(Optional Prompts).

Worldbank: CO2 Emissions

OpenAI

Datacamp

Hootsuite

DALL-E Prompt Manual

Writesonic

Prompting Guide

MIT: Data Analytics

Production

Example: Create a PowerPoint Presentation...


Take Prompt (from Classpoint).


"Write me VBA PowerPoint codes on [topic]. Make it [number] slides."


Copy VBA Code.


Open PowerPoint.


Design Slides.


Example: Create a Website...


Take Prompts (from Themeisle).


I would like you to act as a frontend web developer. For the project, you’ll code a new website using these tools: HTML, Bootstrap framework using the CDN for CSS and JavaScript. The website should be mobile-friendly and responsive. It should also include the most recent version of Twitter Bootstrap CSS classes in the site structure for layout and style. When it’s all done, there should be a single HTML file. You should also include a navigation menu with internal links to the headings within the page content. Do not provide explanations for any of the code you write. Do you understand everything? Please reply with a yes or no answer if you understand all the requirements.


My first request is “Create a single web page that is a product review of the Apple Vision Pro.” You should include five sections of content on this page, each with an h2 tag to start the section, along with several paragraph tags after that with relevant text about the the Apple Vision Pro. Also, include an image of the Apple Vision Pro, along with a caption that explains what the image is. This image should float to the right side of the page and have a maximum width of 600px.


Please fill the section headers and paragraphs with relevant content that explains the features and benefits of the the Apple Vision Pro.


Copy HTML.


Paste to Notepad.


Save as "xyz.html".


Open with Browser.


Review, Reflect, Refine (Prompts).

Microsoft: Copilot

Themeisle: Websites

Classpoint: PowerPoint

Models

KNIME Churn Predictor Recipe

Prepare Data


Create New Workflow


CSV Reader Node


Missing Value Node


Partitioning Node


Random Forest Learner Node


Random Forest Predictor Node


Scorer Node


Run

Kaggle: Churn Dataset

Kaggle: Churn Dataset

KNIME: Random Forest Explainer

Excel Predict/Precribe Recipe

Objective: predict future values using Linear Regression...


#Activate the Regression Module…




#Apply the Regression Module…



  1. Input Y Range = Number of Weekly Riders
  2. Input X Range = Select One Column
  3. Check for Labels
  4. Toggle Residuals “On”


#Interpret…




#Refine...


Try a new model if the R Squared is Low and the p-Values are High (i.e. New Input Variables).


Eliminate Correlation between independent variables using CORR.


#Predict…


Apply the coefficients in the “Y = Bo + BiXi + e” equation


#Perform a Multivariate Linear Regression...


As above, but select multiple Input Variables.


#Replicate using Excel Functions...


The =TREND() function can be used for simple regression-based projections. 


  1. Data #1 Sheet > Cell B29 > Use “=TREND( B2:B28, C2:C28, C29, TRUE )”
  2. Input Values > C29


  1. Data #1 Sheet > Cell B29 > Use “=TREND( B2:B28, C2:F28, C29:F29, TRUE )”
  2. Input Values > C29:F29


#Replicate using Graphical Methods...


  1. Insert Tab > Scatter Chart > Y Axis = Visitors > X Axis = Select
  1. Right Click Plotted Line > Add Trendline > Select Linear Trend
  2. Toggle Equation “On”
  3. Toggle R Squared “On”
  1. Derive the “Y = Bo + BiXi + e” equation for each line and use to predict.
  2. Y = Number of Weekly Riders
  3. Bo = Read from Equation
  4. Bi = Read from Equation
  5. Xi = Input
  6. (E = Read from Equation)


#Use Solver to Prescribe...


  1. Target
  2. Parameters
  3. Algorithm
  4. Constraints

Excel Easy: Regressions

Robots

Development Practices

Power Automate Data Entry Bot Recipe

...a subflow from the identity verification case.


A document has been collected from the applicant and saved to a network folder. Our bot must collect all documents in this folder and enter the information into a system app.


Preparation steps...


  1. Create a "Folder"
  2. Create a Dummy "Application Form" in Excel with 3 x "Answers"
  3. Save 5 x Duplicate "Application Forms" to the "Folder"
  4. Create a Dummy 3 x Answer "System App" using Google/Microsoft Forms
  5. Publish the Form (make the Form public access and save the URL)


Open Power Automate Desktop App


Add the "Get Files in Folder" Action to Row 1


Add the "For Each" Action to Row 2


Add the "Launch Excel" Action into Loop


Add the "Read from Excel Worksheet" Action into Loop


Repeat the "Read from Excel Worksheet" Action x 2


Add the "Close Excel" Action into Loop


Save Flow


Select "Subflows"


Add the "Launch New *Browser*" Action to Row 1 of the Subflow


Ensure the Power Automate Extension is Loaded for the Browser


Add the "Populate Text Field on a Web Page" Action to Row 2 of the Subflow

  1. Navigate to the Data Collection App View
  2. Observe Red Box Selection of UI Elements
  3. Click + Ctrl to Define UI Element (ie. Item #1)


Repeat the "Populate Text Field on a Web Page" Action x 2


Add the "Click Link on Webpage" Action to End of the Subflow


Add the "Close Web Browser" Action to Row 4 of the Subflow


Add the Subflow to Main Flow


Save, Test, Refine


Enhance


Explore Additional Flows using the "Record" Feature


Save and Close


END.

Microsoft: Power Automate Desktop

Technical Review

Power Automate Desktop Introduction

...building an understanding of the Power Automate Desktop solution...


Open Power Automate Desktop App

Go to Example Flows

Edit the "Launch Excel and Extract a Table" Flow

Run the "Launch Excel and Extract a Table"

Extend the "Launch Excel and Extract a Table" Flow

Save Flow and Exit

Go to Example Flows

Edit the "Open a Web Page" Flow

Run "Open a Web Page"

Extend the "Open a Web Page" Flow

Save Flow and Exit

END.

Microsoft: Create Desktop Flows

Spectrum

Start

...tools...
...other...

Tidio

ChatGPT

KNIME
Microsoft Power Automate
Course Page
bit.ly/smu_dtaiml