Implement a Helpdesk Chatbot with Dialogflow & BigQuery ML

Hours 5 Credits

GSP431

Overview

Wouldn’t it be awesome to have an accurate estimate of how long it will take for tech support to resolve your issue? In this lab you will train a simple machine learning model for predicting helpdesk response time using BigQuery Machine Learning. You will then build a simple chatbot using Dialogflow, and learn how to integrate your trained BigQuery ML model with your helpdesk chatbot. The final solution will provide an estimate of response time to users at the moment a request is generated.

The exercises are ordered to reflect a common cloud developer experience:

Train a Model using BigQuery Machine Learning

Deploy a simple Dialogflow application

Use an inline code editor within Dialogflow for deploying a Node.js fulfillment script that integrates BigQuery

Test your chatbot

What you'll learn

How to train a machine learning model using BigQuery ML

How to evaluate and improve a machine learning model using BigQuery ML

How to import intents & entities into a Dialogflow agent

How to implement custom Node.js fulfillment scripts

How to integrate BigQuery with Dialogflow

Prerequisites

Basic concepts and constructs of Dialogflow. Click here for an introductory Dialogflow tutorial that covers basic conversational design and fulfillment using a webhook.