The course is structured in a way to introduce new topics and components of Blue Prism with an exercise which is built on throughout each of the chapters. The idea is that you learn and implement what you have learned at the same time, which allows you to gain very practical experience from this course. The process which we are building on throughout this course is an Orders Queries process using Airtable, Excel, and Gmail.
- [Instructor] This course is designed to give you a fundamental understanding of the main components of Blue Prism. It will enable you to make processes using the Blue Prism tool set. Every chapter introduces a new component, accompanied by an exercise. The idea is to build an end to an automated process, by adding components in every chapter. The process we'll use for this purpose is an auto query. We'll build it using the following applications: we will use Microsoft Excel to the load Blue Prism key, Airtable is a web browse application, where the orders and their statuses are available and will be taken from. In order to send communication back to the customer with the order statuses, we're going to an email. Before we continue, let's set up a workspace in our table that we'll use throughout the course. If you haven't had a chance to already your account in Airtable, you can simply click on the sign up button. When you get your credentials, you can move to the sign in. In order to do that, you can simply use your user name and password, which will log in you to the main window of Airtable. In order to create a workspace, you can click on the add workspace button. In this scenario, we're going to call it orders. The next step of setting up Airtable, will be to select a base. In order to do that, we're going to click on add a base, and then import from a spreadsheet. The next step will be click on choose a CSV file, and then click here to upload. For this purpose, we're going to use one of the exercise files, which is orders to upload to Airtable. We're going to double-click and simply click on upload. Once imported, we can rename the imported base into orders. And if you click on here, you're going to see all of the orders, which have been successfully uploaded to Airtable. Let's now go through what the end and automated process is going to look like, after you have completed all of the chapters in this course. For this course, I've custom order queries, which is a very common business process. This scenario will focus on order queries, or said in another way, customer raise inquiries about the status of their orders. A list of order queries will be picked up by an Excel file, which has been previously populated. Please have a look at the exercise files, where the order queries Excel can be found. We'll use this Excel to populate the work queue for the robot. In order to get the statuses for each of their orders, we'll need to launch and log-in into Airtable. Each of the orders will be found across the records in your table and then the customer will be notified about the order status. Keep in mind, the chapter order does not necessarily follow the process flow, but we'll go through every single one of these steps at some point throughout this course.
- The main components of Blue Prism
- User interface interactions
- Data items and collections
- Building object and process layers using web apps and Excel
- Exception handling
- Creating and monitoring queues
- Configuring email