When ever we start to learn any new tools, it is always a big question what would be the practical use of any tool. It is useless if we have knowledge of any tools but not aware what is practical use of that tool in industries.
So I thought to start this post where I will share the case studies I have implemented in our company using RPA tools.
1. Data Comparison Automation
Business Challenge
One of our big US based insurance customer had to compare his insurance rates on monthly basis on various different competitors site. There were many different insurance parameters i.e. age, state, risk coverage etc had to fill on competitors portal to compare the price. They had around two thousand combinations of parameters which they had to search on competitors sites to adjust their price to make them competitive.
In order to achieve this, customer outsourced this process to another data collection agents, who used to extract the data manually on competitors site. This process was very time consuming and also too much error prone. This process used to take around 6 to 8 days to create the comparison report.
Our Solution
We studied their process, competitors sites and various parameters they had to submit on competitors site to understand how RPA (Robotic Process Automation) can help them to eliminate the manual process. After studying the process we created a list of various inputs and parameter to submit on each site and using UI Path data scraping method, we have been able to extract the data points needed for comparison.
Deployment
After test various parameters thoroughly we have deployed the solution, now they just need to put various parameter to be searched in excel file and deployed robot extract all the data from competitors site.
Benefits
Before automation it used to take 6 to 8 days to create comparison report and error prone as well
After automation this report can be developed in 3-4 hours only.
As I can not add the name of actual customer here and the sites we used to scrape, but I will create video of data extraction using UI path by taking example of another site.
Stay tuned…..
Hi,
A very useful and informative post on the practical purpose of RPA. Thank you very much for sharing it!
Could you please share the data extraction video as well? Also, how long did this development take because I suppose the list of parameters/inputs vary from website to website making it a lengthy process to automate also?
Hi Gayathri, Yes, you are correct, parameter/inputs for each development will be different as per need. I can create a video for data extraction we did for an insurance company. Let me know if you have any specific requirement you would like me to cover in that video.