mana kaneuchi
fully automated business for everyone

fully automated business for everyone

How to Develop Task and Process Mining System With Make and MongoDB

How to Develop Task and Process Mining System With Make and MongoDB

mana kaneuchi's photo
mana kaneuchi
·Aug 15, 2022·

4 min read

Play this article

Table of contents

  • Key Takeaways
  • Concept
  • Sample App
  • The Benefits
  • The Data to Analyse
  • Working With System Variables
  • Conclusion

Key Takeaways

  • You can easily develop a mining system with NoCode
  • Make and MongoDB can be a good solution to start
  • It stores system logs to detect the bottlenecks

Concept

Hyper automation is not only for enterprises, but for SMEs and individuals as well. This means you should get more benefits from task and process automation. In the context of digital transformation, the major problems are related to the huge cost and the number of tools to integrate. So you can develop your own mining system to discover the bottlenecks to optimise the existing workflows and improve productivity.

Sample App

This sample app is very simple. It sends an email from the data. In the final step, the app stores system logs to MongoDB with the system variables that are newly added to Make.

Screenshot 2022-08-15 at 2.23.34 PM.png

How It Works

  1. Prepare the data with an array (email, subject, message)
  2. Send an email with the data
  3. Store the system logs to MongoDB

System Variables

  • Scenario ID
  • Execution ID
  • Scenario name
  • Execution started at (datetime)
  • Data consumed (number)
  • Operations consumed (number)

Screenshot 2022-08-15 at 2.24.01 PM.png

The Benefits

The benefits you can get are: analysing the tasks and workflows you automated and detect the effectiveness of automation and integration. If the system are well-organised and well-integrated, you can calculate how many hours/minutes are saved by the automation and integration.

With these system variables, you can analyse the following things.

  • How many operations were consumed
  • How many data were transferred
  • How many times the scenario was executed

To make sure how many hours are saved, you can count how many operations are consumed in a specific scenario or the total numbers of operations that are already consumed.

It can be, for example, 1 operation is equal to 1 minute. You need to have 1 minute for preparing the data, 1 minute for sending an email and 1 minute for checking the task. In this case, you saved 3 minutes with the sample app.

The Data to Analyse

If you're an AI developer or a Python/R expert, you will be able to analyse the data with yourself. Because you already stored every system log in your MongoDB. So you can also predict the future with the data for further improvement.

Screenshot 2022-08-15 at 2.26.50 PM.png

For instance, you can count the scenario ID to analyse how many times the scenario were executed. You can analyse how many operations are consumed in the particular process. And you might also be interested in why the process consumed so many operations (minutes.)

If you're a citizen developer, you will be able to analyse the collected data with MongoDB Charts. With this chart feature, you can create and customise a dashboard like below.

705809abd5befb483f471cdfd3d9eedc.gif

This is not a dashboard for task/process mining, but I believe that you can easily imagine how it works.

Working With System Variables

Lastly, let me share with you how to use the system variables in your Make environment.

Screenshot 2022-08-15 at 2.24.45 PM.png

It's super easy because the mapping dialog "{ }" has all the system variables so that you can simply select and insert the variable you want to use in the mapping dialog.

Conclusion

While creating this sample app, I realised that the system variables are useful for data analysis, prediction and business process improvement. Those elements are required in providing consulting services.

If you want to add more values to your consulting services, not only app development, you can implement the system variables into the task and workflow automation.

In general, task and process mining solutions are too expensive to use for SMEs and individuals so that you can develop your own mining system for your company or clients.

It's very simple and easy to start with Make and MongoDB!

Template for the Sample App

If you're interested in business process improvement with the system variables, use the template by importing a JSON file into your Make environment.

This template is hosted on GitHub and prepared for all the people who want to build a fully automated business. If you need a detailed instruction, please check the README.md.

References

P.S.

If you're interested in automation and integration, please follow my LinkedIn account. I constantly share the samples of automation in LinkedIn.

Thanks for reading and happy automation!

 
Share this