title
RPA UiPath Full Course | RPA UiPath Tutorial For Beginners | RPA Course | RPA Tutorial | Simplilearn

description
🔥Business Analyst Masters Program (Discount Coupon - YTBE15):https://www.simplilearn.com/business-analyst-certification-training-course?utm_campaign=23AugustTubebuddyExpBA&utm_medium=DescriptionFF&utm_source=youtube 🔥Explore Advanced Certification In UI UX Design by Simplilearn: https://www.simplilearn.com/ui-ux-bootcamp?utm_campaign=RPAUiPathFCJun30&utm_medium=Descriptionff&utm_source=youtube This RPA UiPath full course will help you understand what RPA is, and the working of UiPath. UiPath is an advanced RPA tool that enables you to design automation processes visually through diagrams. If you wish to become a UiPath developer, then you're in the right place! The following are the topics covered in this video - 0:00 - RPA UiPath Full course 0:02:12 - What is RPA? 0:08:43 - Top 10 Reasons to learn RPA 00:15:45 - RPA Examples 00:26:25 - Blueprism vs UiPath vs Automation Anywhere 00:36:46 - What is UiPath? 00:59:36 - UiPath Installation 1:04:37 - UiPath Tutorial 1:38:29 - What is UiPath Orchestrator 2:01:30 - What is a Framework and its purpose? 2:19:55 - What is Web Automation? 2:43:07 - What is Excel Automation? 2:56:48 - Who is an RPA developer? 3:03:48 - UiPath Interview Questions ✅Subscribe to our Channel to learn more about the top Technologies: https://bit.ly/2VT4WtH ⏩ Check out the RPA training videos: https://bit.ly/2Sy2zeO #RPAUiPathFullCourse #RPAUiPathTutorial #UiPathTutorial #UiPathCourse #LearnUiPath #UiPath TutorialForBeginners #UiPath #UiPath #Simplilearn What is UiPath? UiPath is an advanced RPA tool that enables you to design automation processes visually through diagrams. UiPath provides complete end-to-end automation, calling it “hyper-automation.” 🔥FREE RPA Course With Completion Certificate: https://www.simplilearn.com/learn-rpa-basics-skillup?utm_campaign=RPAUiPathFCJun30&utm_medium=Description&utm_source=youtube ➡️ About Advanced Certification In UI UX Design This Advanced Certification in UI UX Design by IIIT Bangalore helps you learn a design-centric approach to User Interface and User Experience Design, including UX Research, UI Styling, User-centered Design processes, Wireframes, Prototypes, and Usability Testing. Practice via Capstone Projects, course-wide assignments and create your Dribbble portfolio ✅ Key Features - Simplilearn's JobAssist helps you get noticed by top hiring companies - Get professionally certified in UI UX with a program completion certificate from IIIT Bangalore - Hands-on Practical Learning Experience via curriculum-wide assignments & projects - Industry-oriented problem solving via Capstone Projects on E-commerce, Fitness, and Technology industries - Hands-on learning with Designer Toolkit (Figma, Invision & Balsamiq, Sketch & Mural) for an enhanced learning experience - Masterclasses from top faculty of IIIT Bangalore - 8X higher engagement in live online classes by Simplilearn’s expert instructors - Portfolio creation assistance on Dribbble - Live Masterclasses delivered by Top Design Experts from Adobe, Amazon, and Microsoft ✅ Skills Covered - UI and Visual Design - Design Thinking - Prototyping - Information and Interaction Design - User Experience Design - Product Designing - Wireframing - Usability Testing - User-centered design - Persona mapping - Empathy mapping - Clickstream Analysis - Gestalt principles - Heuristics Evaluation - Microcopy 👉 Learn More At: https://www.simplilearn.com/ui-ux-bootcamp?utm_campaign=RPAUiPathFCJun30&utm_medium=Description&utm_source=youtube 🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688

detail
{'title': 'RPA UiPath Full Course | RPA UiPath Tutorial For Beginners | RPA Course | RPA Tutorial | Simplilearn', 'heatmap': [], 'summary': "Provides a comprehensive rpa uipath course covering core concepts, real-time examples, tool comparison, installation tutorials, web and excel automation, with insights on demand, growth, and developer salaries, emphasizing benefits of rpa, diverse applications, and its potential economic impact, including demonstration of automation processes, orchestrator functionality, integration, and automation benefits, as well as rpa development overview and uipath's role in business process automation.", 'chapters': [{'end': 136.47, 'segs': [{'end': 65.648, 'src': 'embed', 'start': 13.7, 'weight': 0, 'content': [{'end': 17.227, 'text': 'Hey guys, welcome to this full course on RPA UI path.', 'start': 13.7, 'duration': 3.527}, {'end': 21.876, 'text': 'This full course video will cover the core topics of RPA UI path.', 'start': 17.848, 'duration': 4.028}, {'end': 25.35, 'text': 'RPA is in demand and highly growing field.', 'start': 22.689, 'duration': 2.661}, {'end': 31.351, 'text': 'UiPath is the leading robotic process automation tool for large-scale end-to-end automation.', 'start': 26.03, 'duration': 5.321}, {'end': 38.433, 'text': 'For an accelerated business change, it provides solution for business to automate routine office activities.', 'start': 32.07, 'duration': 6.363}, {'end': 44.574, 'text': 'So if you are interested in RPA and tools like UiPath, then you are in the right place.', 'start': 39.433, 'duration': 5.141}, {'end': 49.595, 'text': 'This video will help you understand the concepts of RPA UiPath.', 'start': 45.374, 'duration': 4.221}, {'end': 51.836, 'text': 'So here is the list of topics covered.', 'start': 49.835, 'duration': 2.001}, {'end': 61.807, 'text': "We'll first understand what is RPA, then look at the top 10 reasons to learn robotic process automation.", 'start': 54.585, 'duration': 7.222}, {'end': 65.648, 'text': 'We will see some of the real-time RPA examples,', 'start': 62.167, 'duration': 3.481}], 'summary': 'Full course on rpa ui path, covering core topics, in-demand field with uipath for end-to-end automation.', 'duration': 51.948, 'max_score': 13.7, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE13700.jpg'}, {'end': 119.063, 'src': 'embed', 'start': 93.353, 'weight': 1, 'content': [{'end': 101.215, 'text': 'UiPath Web Automation and then we will see Excel Automation in UiPath as to how Excel is used in UiPath.', 'start': 93.353, 'duration': 7.862}, {'end': 108.657, 'text': 'Lastly, we will see RPA Developer Salaries, Skills, Resume, Roles and Responsibilities.', 'start': 101.655, 'duration': 7.002}, {'end': 115.501, 'text': 'And finally, UiPath interview questions that will help you crack the interview with ease.', 'start': 109.557, 'duration': 5.944}, {'end': 119.063, 'text': "I'm sure you're excited to begin with full course.", 'start': 116.702, 'duration': 2.361}], 'summary': 'Learn uipath web and excel automation, rpa developer salaries, skills, and interview questions.', 'duration': 25.71, 'max_score': 93.353, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE93353.jpg'}], 'start': 13.7, 'title': 'Rpa ui path full course', 'summary': 'Provides a comprehensive course on rpa ui path, covering core concepts, real-time examples, tool comparison, installation tutorials, orchestrator, web and excel automation, and developer salaries, with demand and growth insights.', 'chapters': [{'end': 136.47, 'start': 13.7, 'title': 'Rpa ui path full course', 'summary': 'Provides a full course on rpa ui path, covering core topics of rpa ui path, its demand, and growth, with a list of topics including rpa concepts, real-time examples, tool comparison, uipath installation, tutorials, orchestrator, web automation, excel automation, developer salaries, and interview questions.', 'duration': 122.77, 'highlights': ['UiPath is the leading robotic process automation tool for large-scale end-to-end automation, catering to accelerated business change and routine office activity automation.', 'The video covers a comprehensive list of topics including RPA concepts, real-time examples, tool comparison, UiPath installation, tutorials, orchestrator, web automation, Excel automation, developer salaries, and interview questions.', 'RPA UI path is a highly growing and in-demand field with a focus on UiPath as a leading automation tool.', 'The chapter includes a variety of topics such as RPA concepts, real-time examples, tool comparison, UiPath installation, tutorials, orchestrator, web automation, Excel automation, developer salaries, and interview questions.', "UiPath is installed in the device, and the tutorial covers beginners' guide, orchestrator, web automation, Excel automation, developer salaries, and interview questions."]}], 'duration': 122.77, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE13700.jpg', 'highlights': ['UiPath is the leading RPA tool for large-scale automation.', 'The course covers RPA concepts, real-time examples, tool comparison, installation tutorials, orchestrator, web and Excel automation, and developer salaries.', 'RPA UI path is a highly growing and in-demand field with a focus on UiPath as a leading automation tool.', 'The chapter includes a variety of topics such as RPA concepts, real-time examples, tool comparison, UiPath installation, tutorials, orchestrator, web automation, Excel automation, developer salaries, and interview questions.', "UiPath is installed in the device, and the tutorial covers beginners' guide, orchestrator, web automation, Excel automation, developer salaries, and interview questions."]}, {'end': 743.77, 'segs': [{'end': 377.186, 'src': 'embed', 'start': 310.735, 'weight': 0, 'content': [{'end': 318.6, 'text': 'RPA can help decrease the average handling time, and this enhances the customer experience and ensures 24-7 business continuity.', 'start': 310.735, 'duration': 7.865}, {'end': 325.024, 'text': 'With respect to cost, according to NASSCOM, domestic businesses can reduce the cost by up to 65% through RPA.', 'start': 319.28, 'duration': 5.744}, {'end': 332.369, 'text': 'It offers a higher ROI by driving positive returns within quarters as opposed to years.', 'start': 327.165, 'duration': 5.204}, {'end': 340.796, 'text': 'Other advantages of RPA include reduced training costs, minimal utilization of IT resources, and easier software migration.', 'start': 333.05, 'duration': 7.746}, {'end': 349.543, 'text': 'Today, many domains and industries like banking and finance, IT integration processes, human resources, insurance agencies,', 'start': 341.436, 'duration': 8.107}, {'end': 354.047, 'text': 'marketing and sales and customer relationship management readily deploy RPA.', 'start': 349.543, 'duration': 4.504}, {'end': 363.174, 'text': 'RPA service adoption has been showing tremendous growth since 2016 and will continue to increase beyond 2020.', 'start': 354.867, 'duration': 8.307}, {'end': 371.482, 'text': "According to McKinsey's research, knowledge and work automation could have an economic impact of $5-7 trillion by the year 2025.", 'start': 363.174, 'duration': 8.308}, {'end': 377.186, 'text': 'It will impact more than 230 million knowledge workers, which constitute 9% of the global workforce.', 'start': 371.482, 'duration': 5.704}], 'summary': 'Rpa reduces handling time, lowers costs by up to 65%, and can impact 230m workers by 2025.', 'duration': 66.451, 'max_score': 310.735, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE310735.jpg'}, {'end': 560.558, 'src': 'embed', 'start': 533.865, 'weight': 9, 'content': [{'end': 539.607, 'text': 'Implementing a new RPA software system certainly happens much faster than training a new person.', 'start': 533.865, 'duration': 5.742}, {'end': 544.189, 'text': 'You can have these data entry bots up and running in just days.', 'start': 540.527, 'duration': 3.662}, {'end': 553.455, 'text': "In contrast, if you wanted to hire a new human employee, you'd be taking a lot of time in sorting out resumes, conducting interviews,", 'start': 545.211, 'duration': 8.244}, {'end': 555.476, 'text': 'going through the entire boring hiring process.', 'start': 553.455, 'duration': 2.021}, {'end': 560.558, 'text': "And then finally, when you find the right person, you'd have to spend time and energy on training them.", 'start': 555.876, 'duration': 4.682}], 'summary': 'Rpa software system is faster than hiring - data entry bots up in days.', 'duration': 26.693, 'max_score': 533.865, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE533865.jpg'}, {'end': 690.534, 'src': 'embed', 'start': 603.914, 'weight': 6, 'content': [{'end': 610.539, 'text': "Bots don't care how hard they're working or how boring their job is or how repeatedly they're doing the same tasks.", 'start': 603.914, 'duration': 6.625}, {'end': 615.504, 'text': 'Again, yes, it would be ironic if the bots got tired.', 'start': 612.461, 'duration': 3.043}, {'end': 623.17, 'text': 'Software bots can work all the time, 24 hours a day, every single day of the year, at 100% capacity.', 'start': 616.465, 'duration': 6.705}, {'end': 630.237, 'text': "RPA doesn't take holidays, it doesn't have sick needs, and of course, they do not have unproductive days at all.", 'start': 624.251, 'duration': 5.986}, {'end': 643.821, 'text': "Well, isn't that a treat, to have someone who never retires or decides it's time to move to a different job? Next up, minimal IT resources.", 'start': 631.057, 'duration': 12.764}, {'end': 647.923, 'text': 'Maintaining software bots requires minimal IT resources.', 'start': 644.701, 'duration': 3.222}, {'end': 653.185, 'text': "In some cases, IT doesn't need to get involved at all.", 'start': 648.843, 'duration': 4.342}, {'end': 656.847, 'text': 'Your RPA systems will be managed by the software provider.', 'start': 654.086, 'duration': 2.761}, {'end': 660.129, 'text': "They're responsible for maintenance and updates, all of that.", 'start': 657.567, 'duration': 2.562}, {'end': 664.871, 'text': 'It completely takes the burden off IT and saves your company a whole lot of money.', 'start': 660.929, 'duration': 3.942}, {'end': 668.383, 'text': 'ROI is visible.', 'start': 667.342, 'duration': 1.041}, {'end': 672.145, 'text': 'Now every organization wants to quantify their gains.', 'start': 669.083, 'duration': 3.062}, {'end': 676.947, 'text': 'Many of these organizations do not know how they should determine their ROI.', 'start': 673.165, 'duration': 3.782}, {'end': 682.27, 'text': 'But when it comes to adopting robotic process automation, ROI is visible.', 'start': 677.907, 'duration': 4.363}, {'end': 686.272, 'text': 'It defines a clearer path to demonstrate its returns.', 'start': 682.85, 'duration': 3.422}, {'end': 690.534, 'text': 'Complex problems can be solved.', 'start': 689.033, 'duration': 1.501}], 'summary': 'Software bots work 24/7, requiring minimal it resources, delivering visible roi, and solving complex problems.', 'duration': 86.62, 'max_score': 603.914, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE603914.jpg'}], 'start': 136.951, 'title': 'Robotic process automation', 'summary': 'Discusses efficient automation of invoice information extraction using rpa, emphasizing its benefits: reduced time and effort, operational risks, cost reduction, and increased roi, with a significant impact on industries and the global workforce. it also provides 10 reasons to learn rpa, emphasizing its rapid implementation, cost-effectiveness, and continuous efficiency.', 'chapters': [{'end': 270.542, 'start': 136.951, 'title': 'Implementing robotic process automation', 'summary': 'Discusses how jim efficiently automated the process of extracting information from invoices using robotic process automation, reducing time and effort, and also explains the key characteristics and working phases of rpa.', 'duration': 133.591, 'highlights': ['Jim implements Robotic Process Automation to extract information from invoices and automate the process, reducing time and effort. Jim builds a simple bot using RPA to extract information from invoices into an Excel sheet, attach necessary financial reports, and send them to his superiors via email daily.', 'Robotic Process Automation is the use of software with AI and machine learning capabilities to handle high-volume, repetitive tasks. RPA utilizes software with AI and machine learning capabilities to handle repetitive tasks such as addressing queries, making calculations, maintaining records, and performing transactions.', 'RPA does not have a physical form and cannot replicate human cognitive functions. RPA is clarified as not having a physical form, being unable to replicate human cognitive functions, having no brain of its own, and lacking the ability to perform logical or critical thinking like humans.', "The working of RPA includes four crucial phases: planning, development, deployment and testing. RPA's working involves four crucial phases: planning, development, deployment, and testing, each playing a vital role in the successful implementation and functioning of RPA."]}, {'end': 743.77, 'start': 271.123, 'title': 'The power of rpa in business', 'summary': 'Highlights the benefits of robotic process automation (rpa) including reduced operational risks, cost reduction, and increased roi, with a significant impact on various industries and the global workforce, and provides 10 reasons to learn rpa, emphasizing its rapid implementation, cost-effectiveness, and continuous efficiency.', 'duration': 472.647, 'highlights': ['RPA service adoption has been showing tremendous growth since 2016 and will continue to increase beyond 2020. RPA adoption has been experiencing significant growth since 2016, with a projected continued increase beyond 2020.', 'According to NASSCOM, domestic businesses can reduce the cost by up to 65% through RPA. RPA can lead to cost reduction of up to 65% for domestic businesses, as stated by NASSCOM.', "According to McKinsey's research, knowledge and work automation could have an economic impact of $5-7 trillion by the year 2025, impacting more than 230 million knowledge workers, which constitute 9% of the global workforce. McKinsey's research projects that knowledge and work automation could have a substantial economic impact of $5-7 trillion by 2025, affecting over 230 million knowledge workers.", 'RPA offers a higher ROI by driving positive returns within quarters as opposed to years. RPA provides a higher Return on Investment (ROI) by delivering positive returns within quarters rather than years.', 'RPA can help decrease the average handling time, enhancing the customer experience and ensuring 24-7 business continuity. RPA can lead to decreased average handling time, improving the customer experience and ensuring continuous business operations.', 'Implementing a new RPA software system certainly happens much faster than training a new person. Implementation of a new RPA software system is significantly faster than training a new employee.', 'RPA offers the ability to automate business processes quickly and easily, paving the way for digital transformation. RPA provides the capability to swiftly and easily automate business processes, facilitating digital transformation.', 'Software bots can work all the time, 24 hours a day, every single day of the year, at 100% capacity. Software bots can operate 24/7 at full capacity, ensuring continuous and efficient task execution.', 'Every organization wants to quantify their gains. Many of these organizations do not know how they should determine their ROI. But when it comes to adopting robotic process automation, ROI is visible. RPA adoption provides organizations with a visible Return on Investment (ROI), addressing the challenge of quantifying gains.', 'Maintaining software bots requires minimal IT resources, with the burden of maintenance and updates taken off IT, resulting in significant cost savings. Maintenance of software bots requires minimal IT resources, relieving IT from the burden of maintenance and updates, leading to substantial cost savings.']}], 'duration': 606.819, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE136951.jpg', 'highlights': ['RPA adoption has been experiencing significant growth since 2016, with a projected continued increase beyond 2020.', "McKinsey's research projects that knowledge and work automation could have a substantial economic impact of $5-7 trillion by 2025, affecting over 230 million knowledge workers.", 'RPA can lead to cost reduction of up to 65% for domestic businesses, as stated by NASSCOM.', 'RPA provides the capability to swiftly and easily automate business processes, facilitating digital transformation.', 'RPA offers a higher Return on Investment (ROI) by delivering positive returns within quarters rather than years.', 'RPA can lead to decreased average handling time, improving the customer experience and ensuring continuous business operations.', 'Software bots can operate 24/7 at full capacity, ensuring continuous and efficient task execution.', 'RPA adoption provides organizations with a visible Return on Investment (ROI), addressing the challenge of quantifying gains.', 'Maintenance of software bots requires minimal IT resources, relieving IT from the burden of maintenance and updates, leading to substantial cost savings.', 'Implementation of a new RPA software system is significantly faster than training a new employee.']}, {'end': 1546.792, 'segs': [{'end': 775.068, 'src': 'embed', 'start': 745, 'weight': 1, 'content': [{'end': 750.742, 'text': 'So RPA helps with data migration with accuracy, speed and continuous updating of software.', 'start': 745, 'duration': 5.742}, {'end': 754.684, 'text': 'RPA has a free tier.', 'start': 753.364, 'duration': 1.32}, {'end': 758.005, 'text': 'Many RPA vendors offer free tiers.', 'start': 755.624, 'duration': 2.381}, {'end': 763.448, 'text': 'Some of these vendors are Blue Prism, Automation Anywhere, UiPath among others.', 'start': 758.806, 'duration': 4.642}, {'end': 775.068, 'text': 'These RPA software vendors are offering high RPA software, notably UiPath with their Community Edition and WorkFusion with their RPA Express.', 'start': 764.659, 'duration': 10.409}], 'summary': 'Rpa aids data migration with speed, accuracy. some vendors offer free tiers.', 'duration': 30.068, 'max_score': 745, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE745000.jpg'}, {'end': 893.025, 'src': 'embed', 'start': 870.566, 'weight': 0, 'content': [{'end': 880.194, 'text': 'According to McKinsey research, knowledge and work automation could have an economic impact of 5-7 trillion dollars by the year 2025.', 'start': 870.566, 'duration': 9.628}, {'end': 886.92, 'text': 'It will touch more than 230 million knowledge workers which constitute about 9% of the global workforce.', 'start': 880.194, 'duration': 6.726}, {'end': 893.025, 'text': 'Any company which is labour intensive, where people are performing high volume.', 'start': 888.161, 'duration': 4.864}], 'summary': 'Mckinsey research projects $5-7 trillion economic impact by 2025, affecting 230m knowledge workers.', 'duration': 22.459, 'max_score': 870.566, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE870566.jpg'}, {'end': 1155.88, 'src': 'embed', 'start': 1130.937, 'weight': 3, 'content': [{'end': 1138.583, 'text': 'rpa in financial services tracks and standardizes and validates payments, process orders and avoids errors.', 'start': 1130.937, 'duration': 7.646}, {'end': 1140.644, 'text': 'and is always on top of things.', 'start': 1138.583, 'duration': 2.061}, {'end': 1147.089, 'text': "such a disciplined assistant makes the customer's experience less stressful, adding value to the service provider.", 'start': 1140.644, 'duration': 6.445}, {'end': 1155.88, 'text': 'RPA in Finance eliminates the need for endless email correspondence and ensures a smooth payment approval process,', 'start': 1148.596, 'duration': 7.284}], 'summary': 'Rpa in financial services streamlines payments, processes orders, and reduces errors, leading to a smoother customer experience and eliminating the need for excessive email correspondence.', 'duration': 24.943, 'max_score': 1130.937, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE1130937.jpg'}, {'end': 1342.937, 'src': 'embed', 'start': 1316.463, 'weight': 4, 'content': [{'end': 1321.888, 'text': 'With the implementation of RPA, the board completed the onboarding paperwork in less time,', 'start': 1316.463, 'duration': 5.425}, {'end': 1330.295, 'text': "allowing HRs to spend more time on corporate social responsibilities, hiring talent initiatives and improving a company's reputation.", 'start': 1321.888, 'duration': 8.407}, {'end': 1342.937, 'text': 'The tasks performed by RPA bots in HR service are screening resumes, onboarding of new hires, attendance management, induction and training,', 'start': 1332.264, 'duration': 10.673}], 'summary': 'Rpa reduced onboarding time, freeing hrs for csr and talent initiatives.', 'duration': 26.474, 'max_score': 1316.463, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE1316463.jpg'}], 'start': 745, 'title': 'Rpa and its applications', 'summary': 'Highlights benefits of rpa including data migration, accuracy, speed, and continuous software updating, availability of free tiers, job opportunities, and substantial growth projections with potential economic impact of 5-7 trillion dollars by 2025. it also covers diverse applications of rpa across industries, with examples of significant time and cost reductions and improved efficiency.', 'chapters': [{'end': 893.025, 'start': 745, 'title': 'Rpa: benefits, myths, and growth', 'summary': 'Highlights the benefits of rpa such as data migration with accuracy, speed, and continuous updating of software, the availability of free tiers from various rpa vendors, and the job opportunities and high salaries for rpa developers, along with the substantial growth projections of rpa, including its potential economic impact of 5-7 trillion dollars by 2025 and its reach to over 230 million knowledge workers.', 'duration': 148.025, 'highlights': ['RPA has substantial growth projections with a potential economic impact of 5-7 trillion dollars by 2025, touching more than 230 million knowledge workers, constituting about 9% of the global workforce.', 'RPA developers in the US earn an average salary of 77,000 US dollars, while in India, the beginning salary for an RPA developer is around 4.65 lakhs per annum, and top tier companies like Dell, IBM, Accenture, Capgemini, and Cognizant are actively hiring RPA developers.', 'RPA vendors such as Blue Prism, Automation Anywhere, and UiPath offer free tiers, which helps lower the total cost of ownership and does not require rip and replace of existing infrastructures.', "RPA assists in data migration with accuracy, speed, and continuous updating of software, contributing to the growth of new jobs and not jeopardizing existing employees' jobs.", 'Common misconception that RPA could steal jobs is debunked as RPA does not pull down existing systems but leverages them, with the responsibility of monitoring and controlling the bots falling on the developer.']}, {'end': 1546.792, 'start': 893.025, 'title': 'Rpa applications across industries', 'summary': 'Discusses the diverse applications of robotic process automation (rpa) across industries, including customer service, financial services, hr, telecom, and healthcare, with examples showcasing significant time and cost reductions and improved efficiency.', 'duration': 653.767, 'highlights': ['RPA in telecom service reduces error rates to close to zero, improves data quality, and increases operational efficiency, contributing significantly to cost reduction. Telecom industry benefits from RPA with close to zero error rates, improved data quality, and enhanced operational efficiency, leading to substantial cost reductions.', 'RPA implementation in healthcare enables time-saving in appointment scheduling and improves customer relations by allowing patients to reschedule appointments more quickly. RPA in healthcare streamlines appointment scheduling, allowing patients to reschedule appointments swiftly, leading to improved customer relations.', 'RPA streamlines customer service by automating actions, resulting in a drastic reduction in execution time, improving customer satisfaction, and decreasing call duration. In customer service, RPA automation significantly reduces execution time, enhances customer satisfaction, and decreases call duration.', 'RPA in financial services automates invoice generation, payment tracking, order processing, and data entry, resulting in prompt payments and improved customer experience. RPA automates invoice generation, payment tracking, order processing, and data entry in financial services, leading to prompt payments and enhanced customer experience.', 'RPA optimizes HR service by automating onboarding paperwork, resume screening, attendance management, and talent acquisition, freeing up time for more valuable work. RPA optimizes HR service by automating onboarding paperwork, resume screening, attendance management, and talent acquisition, allowing more time for valuable tasks.']}], 'duration': 801.792, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE745000.jpg', 'highlights': ['RPA has substantial growth projections with a potential economic impact of 5-7 trillion dollars by 2025, touching more than 230 million knowledge workers, constituting about 9% of the global workforce.', 'RPA vendors such as Blue Prism, Automation Anywhere, and UiPath offer free tiers, which helps lower the total cost of ownership and does not require rip and replace of existing infrastructures.', "RPA assists in data migration with accuracy, speed, and continuous updating of software, contributing to the growth of new jobs and not jeopardizing existing employees' jobs.", 'RPA in financial services automates invoice generation, payment tracking, order processing, and data entry, resulting in prompt payments and improved customer experience.', 'RPA optimizes HR service by automating onboarding paperwork, resume screening, attendance management, and talent acquisition, allowing more time for valuable tasks.']}, {'end': 2981.304, 'segs': [{'end': 1578.502, 'src': 'embed', 'start': 1547.253, 'weight': 6, 'content': [{'end': 1554.1, 'text': 'The primary goal was to increase the efficiency of existing approaches to achieve greater accuracy with reduced turnaround time.', 'start': 1547.253, 'duration': 6.847}, {'end': 1560.216, 'text': 'Robotic process automation was implemented and the most significant possible impact was obtained.', 'start': 1555.034, 'duration': 5.182}, {'end': 1565.798, 'text': 'RPA platform handled claims, processing, and health data reconciliation program.', 'start': 1560.896, 'duration': 4.902}, {'end': 1569.339, 'text': 'Healthcare was able to reduce turnaround time with this solution.', 'start': 1566.238, 'duration': 3.101}, {'end': 1578.502, 'text': 'The tasks performed by RPA bots in healthcare service are appointment scheduling, regulatory compliance,', 'start': 1571.299, 'duration': 7.203}], 'summary': 'Implemented rpa resulted in reduced healthcare turnaround time.', 'duration': 31.249, 'max_score': 1547.253, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE1547253.jpg'}, {'end': 1625.354, 'src': 'embed', 'start': 1598.433, 'weight': 5, 'content': [{'end': 1608.221, 'text': "Lastly, we'll compare the tools based on trial version base technologies, process designer accessibility, macro recorders, architecture,", 'start': 1598.433, 'duration': 9.788}, {'end': 1613.605, 'text': 'learning robots, accuracy, reusability, pricing and then certification.', 'start': 1608.221, 'duration': 5.384}, {'end': 1619.109, 'text': "So without further ado, let's begin and understand why was RPA introduced.", 'start': 1614.625, 'duration': 4.484}, {'end': 1625.354, 'text': 'Consider the process of onboarding a recruit to your organization.', 'start': 1622.113, 'duration': 3.241}], 'summary': 'Comparing rpa tools based on various features and criteria.', 'duration': 26.921, 'max_score': 1598.433, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE1598433.jpg'}, {'end': 1721.746, 'src': 'embed', 'start': 1697.059, 'weight': 9, 'content': [{'end': 1702.943, 'text': "Now assuming you have a basic understanding of RPA, let's go on and compare the popularly used tools.", 'start': 1697.059, 'duration': 5.884}, {'end': 1706.204, 'text': 'First up is trial version.', 'start': 1704.644, 'duration': 1.56}, {'end': 1712.048, 'text': 'Every tool generally offers a trial version for its users to get acquainted with the tool.', 'start': 1706.965, 'duration': 5.083}, {'end': 1718.412, 'text': 'This helps the users understand the tool better and decide if they want to proceed with using the tool.', 'start': 1712.788, 'duration': 5.624}, {'end': 1721.746, 'text': 'Blue Prism offers a free trial version.', 'start': 1719.505, 'duration': 2.241}], 'summary': 'Comparison of rpa tools: blue prism offers free trial version', 'duration': 24.687, 'max_score': 1697.059, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE1697059.jpg'}, {'end': 1785.97, 'src': 'embed', 'start': 1752.513, 'weight': 1, 'content': [{'end': 1754.474, 'text': 'Blue Prism is based on C-sharp.', 'start': 1752.513, 'duration': 1.961}, {'end': 1760.596, 'text': 'UiPath is based on Microsoft vendors like SharePoint, Kibana and Elasticsearch.', 'start': 1755.214, 'duration': 5.382}, {'end': 1765.218, 'text': 'While Automation Anywhere is based on modern Java technologies.', 'start': 1761.897, 'duration': 3.321}, {'end': 1771.301, 'text': 'The third feature of Comparison is Process Designer.', 'start': 1767.779, 'duration': 3.522}, {'end': 1779.424, 'text': 'Blue Prism enables you to create, design, edit, as well as test business processes from the visual business object.', 'start': 1772.338, 'duration': 7.086}, {'end': 1785.97, 'text': 'Now a VBO is like an adapter provided by Blue Prism for communicating with an application.', 'start': 1780.265, 'duration': 5.705}], 'summary': "Blue prism uses c-sharp, uipath uses microsoft vendors (sharepoint, kibana, elasticsearch), and automation anywhere uses modern java technologies. blue prism's process designer allows creation, design, editing, and testing of business processes visually.", 'duration': 33.457, 'max_score': 1752.513, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE1752513.jpg'}, {'end': 2258.721, 'src': 'embed', 'start': 2236.209, 'weight': 8, 'content': [{'end': 2245.234, 'text': 'The first UiPath desktop automation product line was launched in 2013, giving business RPA tools to automate manual and repetitive back office tasks.', 'start': 2236.209, 'duration': 9.025}, {'end': 2248.195, 'text': "Let's look at the features of UiPath.", 'start': 2246.414, 'duration': 1.781}, {'end': 2251.637, 'text': 'Drag and drop workflow.', 'start': 2250.497, 'duration': 1.14}, {'end': 2258.721, 'text': 'The user of UiPath will develop visual process steps by dragging and dropping related tasks onto the graphical workspace.', 'start': 2252.177, 'duration': 6.544}], 'summary': 'Uipath launched its first desktop automation product line in 2013, offering rpa tools for automating back office tasks with drag and drop workflow features.', 'duration': 22.512, 'max_score': 2236.209, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE2236209.jpg'}, {'end': 2415.468, 'src': 'embed', 'start': 2388.206, 'weight': 4, 'content': [{'end': 2398.612, 'text': 'UiPath Studio is a user-friendly interface inside the tool that allows user to visually plan and design various automation process through diagrams using drag-and-drop functionality.', 'start': 2388.206, 'duration': 10.406}, {'end': 2404.321, 'text': 'These diagrams are merely a structural reflection of specific tasks that must be completed.', 'start': 2399.457, 'duration': 4.864}, {'end': 2409.224, 'text': 'This is the activity pane in the UiPath Studio.', 'start': 2406.242, 'duration': 2.982}, {'end': 2412.426, 'text': 'It consists of project activities and snippets.', 'start': 2409.985, 'duration': 2.441}, {'end': 2415.468, 'text': 'This is the ribbon tab.', 'start': 2414.468, 'duration': 1}], 'summary': 'Uipath studio enables visual automation design with drag-and-drop functionality for project activities and snippets.', 'duration': 27.262, 'max_score': 2388.206, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE2388206.jpg'}, {'end': 2483.119, 'src': 'embed', 'start': 2457.674, 'weight': 0, 'content': [{'end': 2463.638, 'text': 'When given operation occurs on the computer, UiPath robots are programmed to begin executing tasks automatically.', 'start': 2457.674, 'duration': 5.964}, {'end': 2467.081, 'text': 'Next we have UiPath Orchestrator.', 'start': 2465.299, 'duration': 1.782}, {'end': 2471.504, 'text': 'The Orchestrator is a web-based application in UiPath.', 'start': 2467.841, 'duration': 3.663}, {'end': 2478.494, 'text': 'It has features like deploying, monitoring, scheduling, and controlling automated bots and process.', 'start': 2472.088, 'duration': 6.406}, {'end': 2483.119, 'text': "It's a centralized forum for managing and controlling all software bots.", 'start': 2479.315, 'duration': 3.804}], 'summary': 'Uipath robots automate tasks, orchestrator manages bots centrally.', 'duration': 25.445, 'max_score': 2457.674, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE2457674.jpg'}, {'end': 2750.985, 'src': 'embed', 'start': 2729.114, 'weight': 7, 'content': [{'end': 2738.701, 'text': 'Companies that do not have HR and CRM systems integrated can use RPA bots to ensure that CRM adjustments are submitted to scorecards in real time,', 'start': 2729.114, 'duration': 9.587}, {'end': 2740.923, 'text': 'allowing sales reps to track their progress.', 'start': 2738.701, 'duration': 2.222}, {'end': 2744.259, 'text': 'It is used in CRM updating.', 'start': 2742.097, 'duration': 2.162}, {'end': 2750.985, 'text': 'A new class of solution is evolving to incorporate their email, call and other contact data into CRM.', 'start': 2744.88, 'duration': 6.105}], 'summary': 'Rpa bots enable real-time crm updates, empowering sales reps to track progress.', 'duration': 21.871, 'max_score': 2729.114, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE2729114.jpg'}, {'end': 2825.727, 'src': 'embed', 'start': 2800.456, 'weight': 2, 'content': [{'end': 2806.659, 'text': 'RPA bots may be useful in situations where legacy systems are incapable of storing complex limit orders.', 'start': 2800.456, 'duration': 6.203}, {'end': 2809.6, 'text': 'However, this is more a band-aid solution.', 'start': 2807.339, 'duration': 2.261}, {'end': 2816.523, 'text': 'In the long run, switching to a sophisticated and competent trading system will certainly be a smart investment,', 'start': 2810.14, 'duration': 6.383}, {'end': 2820.004, 'text': 'considering how it could increase trading and minimize trader workload.', 'start': 2816.523, 'duration': 3.481}, {'end': 2822.545, 'text': 'Next, it is used in healthcare.', 'start': 2821.265, 'duration': 1.28}, {'end': 2825.727, 'text': 'In healthcare, it is used for appointment scheduling.', 'start': 2823.226, 'duration': 2.501}], 'summary': 'Rpa bots aid legacy systems; long-term switch to advanced trading system benefits trading and reduces workload. also used in healthcare for appointment scheduling.', 'duration': 25.271, 'max_score': 2800.456, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE2800456.jpg'}], 'start': 1547.253, 'title': 'Rpa tools comparison and integration benefits', 'summary': 'Discusses the implementation of rpa in healthcare, compares rpa tools blue prism, uipath, and automation anywhere, and highlights uipath components and rpa integration benefits across various industries, resulting in reduced turnaround time and improved productivity.', 'chapters': [{'end': 1934.075, 'start': 1547.253, 'title': 'Rpa tools comparison in healthcare', 'summary': 'Discusses the implementation of robotic process automation (rpa) in healthcare to handle claims, processing, and health data reconciliation, resulting in reduced turnaround time, and compares the popular rpa tools blue prism, uipath, and automation anywhere based on trial versions, base technologies, process designer accessibility, learning, and robots.', 'duration': 386.822, 'highlights': ['The RPA platform handled claims, processing, and health data reconciliation, resulting in reduced turnaround time in healthcare. The implementation of RPA in healthcare led to reduced turnaround time, demonstrating the impact of RPA in streamlining processes.', 'Comparison of RPA tools based on trial version availability, with Blue Prism offering a free trial version. The comparison of RPA tools includes the availability of trial versions, with Blue Prism standing out for offering a free trial version.', 'Comparison of RPA tools based on base technologies, with Blue Prism based on C-sharp, UiPath on Microsoft vendors, and Automation Anywhere on modern Java technologies. The comparison of RPA tools highlights the different base technologies used by Blue Prism, UiPath, and Automation Anywhere, providing insights into their technical foundations.', 'Comparison of RPA tools based on process designer accessibility, showing differences in creating, designing, and testing business processes. The comparison of RPA tools emphasizes the distinct process designer accessibility offered by Blue Prism, UiPath, and Automation Anywhere, portraying their capabilities in creating and testing business processes.', 'Comparison of RPA tools based on learning, with Blue Prism requiring programming knowledge, UiPath enabling visual automation process design, and Automation Anywhere offering drag and drop features for beginners. The comparison of RPA tools delves into the learning requirements and features of Blue Prism, UiPath, and Automation Anywhere, highlighting their approach to enabling users to design and manage automation processes.', 'Comparison of RPA tools based on robot types, with Blue Prism offering back office automation only. The comparison of RPA tools outlines the types of bots offered by Blue Prism, shedding light on its specific focus on back office automation.']}, {'end': 2370.061, 'start': 1934.884, 'title': 'Rpa tools comparison: uipath, automation anywhere, blue prism', 'summary': 'Compares uipath, automation anywhere, and blue prism in terms of features, architecture, accuracy, reusability, pricing, and certifications. uipath offers a variety of features such as drag and drop workflow, record and playback, inbuilt activities, advanced scraping options, high security, and robustness, while automation anywhere stands out with its hbc feature, macro recorder, universal recorder, cloud-native web-based microservices architecture, citrix automation with ai sense technology, and attractive entry-level pricing. blue prism excels in accuracy, reusability, and offers several certifications. uipath and automation anywhere are known for their pleasant entry-level pricing. automation anywhere has the lowest total cost of ownership due to its native capabilities and web-based architecture.', 'duration': 435.177, 'highlights': ['HBC Feature in Automation Anywhere The HBC feature enables humans and bots to work together to complete a task and manage exceptions and escalations', 'Macro Recorder in UiPath and Automation Anywhere UiPath uses a macro recorder for fast process mapping, while Automation Anywhere offers a universal recorder for different tasks', "Architecture: Automation Anywhere's Cloud-Native Web-Based Microservices Architecture Automation Anywhere incorporates a cloud-native web-based microservices architecture, allowing users of any skill level to start building robots on a browser without heavy installation", 'Citrix Automation with AI Sense Technology in Automation Anywhere Automation Anywhere shines in Citrix Automation with AI Sense technology, catering to virtual desktop automation', 'Reusability in Blue Prism, UiPath, and Automation Anywhere Blue Prism consists of a library of business objects for reuse, UiPath offers high degree of usability and moderate reliability, and Automation Anywhere allows custom actions development and has a Bot Store with pre-configured bots', 'Pricing: Entry-Level Pricing in UiPath and Automation Anywhere UiPath and Automation Anywhere offer pleasant entry-level pricing, with Automation Anywhere providing the lowest total cost of ownership due to its web-based architecture', 'Certifications in Blue Prism, UiPath, and Automation Anywhere Blue Prism offers several certifications, UiPath provides free online training and certification programs, and Automation Anywhere University offers free online training and certification programs for both students and advanced practitioners', 'UiPath Features: Drag and Drop Workflow, Record and Playback, Inbuilt Activities, Advanced Scraping Options, High Security, and Robustness UiPath offers features such as drag and drop workflow, record and playback, inbuilt activities, advanced scraping options, and high security and robustness, making it a comprehensive RPA tool']}, {'end': 2713.084, 'start': 2370.061, 'title': 'Uipath: automating with studio, robot, and orchestrator', 'summary': 'Introduces uipath components including studio, robot, and orchestrator, detailing their functions and architecture, and highlights its applications such as invoice generation in sales.', 'duration': 343.023, 'highlights': ['UiPath Orchestrator: web-based app for managing automated bots and processes UiPath Orchestrator is a web-based application with features like deploying, monitoring, scheduling, and controlling automated bots and processes, providing a centralized forum for managing all software bots.', 'UiPath Robot: translates processes into tasks for execution UiPath robots are used to translate processes into tasks, which are executed without human interference, and are programmed to begin executing tasks automatically upon given operations on the computer.', 'UiPath Studio: user-friendly interface for planning and designing automation processes UiPath Studio is a user-friendly interface that visually plans and designs automation processes through diagrams using drag-and-drop functionality, allowing for the structural reflection of specific tasks that must be completed.', "Persistence Layer: stores robot configuration information and log data The Persistence Layer of UiPath's architecture stores all the robot's configuration information and log data, including tasks, logging information, and assets, and uses Elasticsearch to store these logs for error detection and correction.", 'Applications in Sales: UiPath used for generating invoices In sales, UiPath is used to generate invoices, demonstrating its application in data replication and automation.']}, {'end': 2981.304, 'start': 2713.585, 'title': 'Rpa and crm integration benefits', 'summary': 'Discusses the benefits and applications of rpa bots in integrating crm and hr systems, banking, healthcare, and trading, highlighting improved productivity, cost-effectiveness, and the average salary for uipath developers.', 'duration': 267.719, 'highlights': ['RPA bots are used to integrate CRM and HR systems, and in banking, healthcare, and trading, increasing productivity and cost-effectiveness. RPA bots are utilized in various industries such as banking, healthcare, and trading to automate tasks, improve productivity, and reduce operational costs.', 'RPA bots can automate CRM updating, appointment scheduling in healthcare, and loan sanctioning, providing efficiency and cost-effectiveness. RPA bots enhance efficiency and reduce operational costs by automating tasks such as CRM updating, appointment scheduling in healthcare, and loan sanctioning.', 'The average salary for a UiPath developer in India is 5,45,000 rupees and ranges from 362,000 rupees to 1 million; in the USA, it ranges from 58,000 dollars to 107,000 dollars with an average of 76,000 dollars. The average salary for UiPath developers in India and the USA is provided, offering insights into the earning potential in this field.']}], 'duration': 1434.051, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE1547253.jpg', 'highlights': ['UiPath Orchestrator: web-based app for managing automated bots and processes', 'Comparison of RPA tools based on learning, with Blue Prism requiring programming knowledge, UiPath enabling visual automation process design, and Automation Anywhere offering drag and drop features for beginners', 'RPA bots are utilized in various industries such as banking, healthcare, and trading to automate tasks, improve productivity, and reduce operational costs', 'Comparison of RPA tools based on base technologies, with Blue Prism based on C-sharp, UiPath on Microsoft vendors, and Automation Anywhere on modern Java technologies', 'UiPath Studio: user-friendly interface for planning and designing automation processes', 'Comparison of RPA tools based on process designer accessibility, showing differences in creating, designing, and testing business processes', 'The implementation of RPA in healthcare led to reduced turnaround time, demonstrating the impact of RPA in streamlining processes', 'RPA bots can automate CRM updating, appointment scheduling in healthcare, and loan sanctioning, providing efficiency and cost-effectiveness', 'UiPath Features: Drag and Drop Workflow, Record and Playback, Inbuilt Activities, Advanced Scraping Options, High Security, and Robustness', 'Comparison of RPA tools based on trial version availability, with Blue Prism offering a free trial version']}, {'end': 4418.692, 'segs': [{'end': 3031.545, 'src': 'embed', 'start': 2981.985, 'weight': 0, 'content': [{'end': 2987.808, 'text': 'Consider a scenario where you have multiple excel files you want to combine the data in single file.', 'start': 2981.985, 'duration': 5.823}, {'end': 2994.711, 'text': 'In this demo we will merge two excel files into a single excel file and send it over an email.', 'start': 2988.628, 'duration': 6.083}, {'end': 2998.573, 'text': "Let's create automation to merge two excel files using UiPath.", 'start': 2995.251, 'duration': 3.322}, {'end': 3004.516, 'text': 'From here we can open a new project or existing project stored locally or on version control system.', 'start': 2999.373, 'duration': 5.143}, {'end': 3009.158, 'text': 'With a click we can open a new project or create a new project from a template.', 'start': 3005.296, 'duration': 3.862}, {'end': 3013.831, 'text': "UiPath offers many templates, depending on what you're trying to do.", 'start': 3010.009, 'duration': 3.822}, {'end': 3017.794, 'text': 'for now, let us start with a blank project.', 'start': 3013.831, 'duration': 3.963}, {'end': 3020.816, 'text': "so we'll open a blank project here.", 'start': 3017.794, 'duration': 3.022}, {'end': 3022.457, 'text': "so we'll open our main workflow.", 'start': 3020.816, 'duration': 1.641}, {'end': 3028.683, 'text': "Then we'll go to new and select a new sequence.", 'start': 3026.001, 'duration': 2.682}, {'end': 3031.545, 'text': 'We can do it using a flowchart as well.', 'start': 3029.764, 'duration': 1.781}], 'summary': 'Demonstration of merging two excel files using uipath for automation.', 'duration': 49.56, 'max_score': 2981.985, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE2981985.jpg'}, {'end': 3660.556, 'src': 'embed', 'start': 3551.768, 'weight': 3, 'content': [{'end': 3553.889, 'text': 'So this is the sample file 1 with 10 rows.', 'start': 3551.768, 'duration': 2.121}, {'end': 3561.026, 'text': 'and this is sample file 2 which also has 10 rows.', 'start': 3555.583, 'duration': 5.443}, {'end': 3565.149, 'text': 'so this is file 2 with 10 rows and file 1 with 10 rows.', 'start': 3561.026, 'duration': 4.123}, {'end': 3566.029, 'text': 'and here we go.', 'start': 3565.149, 'duration': 0.88}, {'end': 3573.073, 'text': 'this is the output file which has both 10 10 rows merged here.', 'start': 3566.029, 'duration': 7.044}, {'end': 3574.674, 'text': 'here we go.', 'start': 3573.073, 'duration': 1.601}, {'end': 3576.315, 'text': 'it is sent over and made.', 'start': 3574.674, 'duration': 1.641}, {'end': 3580.558, 'text': 'in this video we will be looking at the installation of uipath.', 'start': 3576.315, 'duration': 4.243}, {'end': 3582.279, 'text': 'so let us see the requirements.', 'start': 3580.558, 'duration': 1.721}, {'end': 3585.904, 'text': 'We will first look at the hardware requirements.', 'start': 3583.663, 'duration': 2.241}, {'end': 3598.568, 'text': "The CPU should at least have a processor of 1.4 GHz 32-bit configuration, or it's recommended to have a 1.8 GHz 64-bit configuration.", 'start': 3586.644, 'duration': 11.924}, {'end': 3605.911, 'text': 'The device is recommended to have a RAM of 8 GB, if not at least a minimum of 4 GB.', 'start': 3599.528, 'duration': 6.383}, {'end': 3609.284, 'text': 'Let us look at the software requirements.', 'start': 3607.403, 'duration': 1.881}, {'end': 3622.568, 'text': 'If you are using a Windows operating system, then Windows should be of version 8.1 or 8.1n or 10 or 10n, and the Windows Server should be of 2012,', 'start': 3610.204, 'duration': 12.364}, {'end': 3625.609, 'text': 'R2,, 2016 or 2019 versions.', 'start': 3622.568, 'duration': 3.041}, {'end': 3631.331, 'text': 'Another prerequisite is to have .NET framework of minimum of 4.5.2 version installed.', 'start': 3626.29, 'duration': 5.041}, {'end': 3639.32, 'text': 'Let us look at the editions, the different editions that UiPath offers.', 'start': 3634.577, 'duration': 4.743}, {'end': 3644.965, 'text': 'UiPath offers two types of editions, community edition and enterprise edition.', 'start': 3639.981, 'duration': 4.984}, {'end': 3651.489, 'text': 'Community edition is for the developers and small teams who are just starting on their automation journey.', 'start': 3645.445, 'duration': 6.044}, {'end': 3660.556, 'text': 'The enterprise edition is further classified into three types, enterprise studio edition, enterprise cloud edition and enterprise server edition.', 'start': 3652.11, 'duration': 8.446}], 'summary': 'The video covers the installation of uipath, including hardware and software requirements, as well as the different editions offered.', 'duration': 108.788, 'max_score': 3551.768, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE3551768.jpg'}, {'end': 3991.194, 'src': 'embed', 'start': 3898.54, 'weight': 8, 'content': [{'end': 3902.361, 'text': 'It provides complete end-to-end automation, calling it hyper-automation.', 'start': 3898.54, 'duration': 3.821}, {'end': 3909.224, 'text': 'UiPath was founded by Daniel Dines and Mariusz Styrka in 2005.', 'start': 3903.341, 'duration': 5.883}, {'end': 3911.745, 'text': 'UiPath is specially used for Windows Process Automation.', 'start': 3909.224, 'duration': 2.521}, {'end': 3914.146, 'text': 'It automates repetitive tasks.', 'start': 3912.726, 'duration': 1.42}, {'end': 3919.568, 'text': 'And lastly, UiPath offers drag and drop functionalities to make it easy to use.', 'start': 3915.066, 'duration': 4.502}, {'end': 3927.632, 'text': 'Now, since there are so many other tools like Blue Prism Automation Anywhere in the market, what makes UiPath stand out?', 'start': 3921.789, 'duration': 5.843}, {'end': 3930.313, 'text': "So let's look at the advantages of UiPath.", 'start': 3928.412, 'duration': 1.901}, {'end': 3934.995, 'text': 'First, UiPath has an activity library.', 'start': 3931.914, 'duration': 3.081}, {'end': 3942.645, 'text': 'This library has several built-in activities and features like display message, input box and so on.', 'start': 3936.263, 'duration': 6.382}, {'end': 3945.605, 'text': 'This improves the customer experience.', 'start': 3943.745, 'duration': 1.86}, {'end': 3948.826, 'text': 'We will deal with these activities in the demo later.', 'start': 3946.506, 'duration': 2.32}, {'end': 3952.227, 'text': 'Next up is security.', 'start': 3950.467, 'duration': 1.76}, {'end': 3957.828, 'text': 'RPA deals with a variety of information like credit card numbers, financial information and passwords.', 'start': 3953.127, 'duration': 4.701}, {'end': 3964.39, 'text': 'UiPath offers extensive security since all the information can be encrypted and stored on a centralized server.', 'start': 3959.029, 'duration': 5.361}, {'end': 3967.297, 'text': 'Up next, we have recorders.', 'start': 3965.856, 'duration': 1.441}, {'end': 3974.522, 'text': 'So UiPath uses a micro recorder to record the user actions such as mouse clicks and keystrokes.', 'start': 3968.738, 'duration': 5.784}, {'end': 3980.006, 'text': 'Once the actions are recorded, they can be emulated using emulators for quick automation.', 'start': 3975.323, 'duration': 4.683}, {'end': 3982.548, 'text': 'Third party integration.', 'start': 3981.447, 'duration': 1.101}, {'end': 3988.192, 'text': 'UiPath can be integrated with third party plugins like IBM Watson and Google plugins.', 'start': 3983.669, 'duration': 4.523}, {'end': 3991.194, 'text': 'Then we have powerful debugging.', 'start': 3989.853, 'duration': 1.341}], 'summary': 'Uipath offers hyper-automation, activity library, security, recorders, third-party integration, and powerful debugging.', 'duration': 92.654, 'max_score': 3898.54, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE3898540.jpg'}, {'end': 4043.742, 'src': 'embed', 'start': 4019.654, 'weight': 10, 'content': [{'end': 4025.936, 'text': 'This product consists of all the necessary drag and drop activities and a robust UI to help develop bots of your choice.', 'start': 4019.654, 'duration': 6.282}, {'end': 4030.237, 'text': 'Now, the UiPath Studio consists of the GUI dashboard.', 'start': 4026.496, 'duration': 3.741}, {'end': 4035.359, 'text': 'It offers a visual dashboard with activities like send email, display message and so on.', 'start': 4030.918, 'duration': 4.441}, {'end': 4038.28, 'text': 'Then, we have types of recorders.', 'start': 4036.72, 'duration': 1.56}, {'end': 4043.742, 'text': 'UiPath Studio offers various types of recorders to record actions on multiple platforms.', 'start': 4039, 'duration': 4.742}], 'summary': 'Uipath studio: drag-and-drop activities, robust ui, visual dashboard, multiple recorders.', 'duration': 24.088, 'max_score': 4019.654, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE4019654.jpg'}, {'end': 4125.537, 'src': 'embed', 'start': 4073.919, 'weight': 16, 'content': [{'end': 4078.442, 'text': 'There are two types of robots, attended robots and unattended robots.', 'start': 4073.919, 'duration': 4.523}, {'end': 4082.884, 'text': 'Attended robots work with you to speed up service desk and help desk.', 'start': 4079.062, 'duration': 3.822}, {'end': 4086.146, 'text': 'It is used in activities where human involvement is the key.', 'start': 4083.645, 'duration': 2.501}, {'end': 4093.67, 'text': 'Unattended robots operate without human touch, maximizing cost and performance benefits for any variety of back office tasks.', 'start': 4087.047, 'duration': 6.623}, {'end': 4099.894, 'text': 'Lastly, we have the UiPath Orchestrator.', 'start': 4097.152, 'duration': 2.742}, {'end': 4108.165, 'text': 'The orchestrator is like a centralized entity where you can deploy, secure, manage all your automation tasks.', 'start': 4101.72, 'duration': 6.445}, {'end': 4110.327, 'text': 'Here are the steps involved.', 'start': 4109.225, 'duration': 1.102}, {'end': 4113.229, 'text': 'First, you create a bot.', 'start': 4111.027, 'duration': 2.202}, {'end': 4116.77, 'text': 'Now you create a project and publish it as a process for further use.', 'start': 4113.609, 'duration': 3.161}, {'end': 4122.755, 'text': 'Once a process is created, it is assigned to a specific robot to execute in an environment.', 'start': 4117.912, 'duration': 4.843}, {'end': 4125.537, 'text': 'This collectively constitutes a job.', 'start': 4123.696, 'duration': 1.841}], 'summary': 'Attended robots assist in service desk to speed up tasks, unattended robots maximize cost and performance benefits, uipath orchestrator manages automation tasks.', 'duration': 51.618, 'max_score': 4073.919, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE4073919.jpg'}, {'end': 4203.579, 'src': 'embed', 'start': 4172.555, 'weight': 18, 'content': [{'end': 4177.56, 'text': 'It takes care of the queues and holds information about the robot configuration and their assigned processes.', 'start': 4172.555, 'duration': 5.005}, {'end': 4186.529, 'text': "Now that we know what UiPath is, let's acquaint ourselves with its user interface and understand its components better.", 'start': 4179.966, 'duration': 6.563}, {'end': 4189.731, 'text': 'So this is what the typical interface looks like.', 'start': 4187.649, 'duration': 2.082}, {'end': 4192.212, 'text': 'First, we have the ribbon.', 'start': 4190.932, 'duration': 1.28}, {'end': 4196.615, 'text': 'It consists of three tabs, home, design and debug.', 'start': 4193.292, 'duration': 3.323}, {'end': 4203.579, 'text': 'Home is where you start a new project from predefined templates or open a project you recently worked on.', 'start': 4197.996, 'duration': 5.583}], 'summary': 'Uipath manages queues and robot configuration, with a ribbon interface.', 'duration': 31.024, 'max_score': 4172.555, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE4172555.jpg'}], 'start': 2981.985, 'title': 'Uipath for excel and csv file merging', 'summary': 'Demonstrates merging excel files with uipath, including automation and customization features, and merging csv files with uipath, resulting in the successful merging of 10 rows from each file, as well as providing an overview of uipath installation requirements, different editions, and an rpa technology overview.', 'chapters': [{'end': 3031.545, 'start': 2981.985, 'title': 'Merge excel files with uipath', 'summary': 'Demonstrates how to merge two excel files into a single file using uipath, enabling automation and customization through various templates and project options.', 'duration': 49.56, 'highlights': ['UiPath provides templates for different automation tasks, offering flexibility and customization.', 'Demonstrates the process of merging two excel files into a single file using UiPath.', 'Explains the options to open a new project or create a new project from a template in UiPath.', 'Describes the steps to open a blank project and create a new sequence in UiPath.']}, {'end': 3582.279, 'start': 3031.665, 'title': 'Merging files with uipath', 'summary': 'Demonstrates the process of merging two csv files using uipath, including steps such as reading the files, using assign and merge data table activities, writing the merged file, and sending it via email, resulting in the successful merging of 10 rows from each file into the output file, which is then sent via email.', 'duration': 550.614, 'highlights': ['The process involves merging two CSV files using UiPath, resulting in the successful merging of 10 rows from each file into the output file. The output file successfully merges 10 rows from each of the two input files, demonstrating the effectiveness of the merging process.', 'The steps include reading the files, using assign and merge data table activities, writing the merged file, and sending it via email. The process involves specific steps such as reading the input files, using assign and merge data table activities, writing the merged file, and sending it via email, showcasing a structured approach to merging and handling the data.', 'The final merged file is successfully sent via email, demonstrating the completion of the entire process. The completion of the process is evidenced by the successful sending of the merged file via email, indicating the successful execution of the merging and emailing activities.']}, {'end': 3848.146, 'start': 3583.663, 'title': 'Uipath installation and requirements', 'summary': 'Covers the hardware and software requirements for uipath, the different editions and profiles offered, and a step-by-step guide for installing uipath studio, with emphasis on the community edition and the selection of profiles.', 'duration': 264.483, 'highlights': ['UiPath offers two types of editions, community edition and enterprise edition. UiPath offers a community edition for developers and small teams, while the enterprise edition is further classified into three types: enterprise studio edition, enterprise cloud edition, and enterprise server edition.', "The CPU should at least have a processor of 1.4 GHz 32-bit configuration, or it's recommended to have a 1.8 GHz 64-bit configuration. The hardware requirements specify a minimum processor of 1.4 GHz for 32-bit configuration, or a recommended 1.8 GHz for 64-bit configuration.", 'If using Windows, the operating system should be of version 8.1 or 10, and the Windows Server should be of 2012, R2, 2016, or 2019 versions. For Windows users, the specified operating system versions include 8.1, 10, and the Windows Server versions of 2012, R2, 2016, or 2019.']}, {'end': 4418.692, 'start': 3848.146, 'title': 'Uipath: rpa automation & studio overview', 'summary': 'Provides an overview of uipath, an rpa technology founded in 2005, which offers end-to-end automation, drag and drop functionalities, and various tools such as uipath studio, robots, and orchestrator. it explains the advantages of uipath, including activity library, security, recorders, third-party integration, and powerful debugging, and describes the uipath architecture, user interface, and components. it also mentions companies like accenture, capgemini, cognizant, atos, and deloitte using uipath for automation.', 'duration': 570.546, 'highlights': ["UiPath was founded by Daniel Dines and Mariusz Styrka in 2005. UiPath's founding year and key figures, providing historical context.", "UiPath offers complete end-to-end automation, termed hyper-automation. UiPath's positioning as a hyper-automation tool, emphasizing its comprehensive automation capabilities.", "UiPath provides drag and drop functionalities to make it easy to use. UiPath's user-friendly interface, enhancing accessibility and ease of use.", "UiPath has an activity library with several built-in activities and features. Highlighting UiPath's activity library, emphasizing its range of built-in features.", "UiPath offers extensive security with encryption for sensitive information. Emphasizing UiPath's robust security measures, including encryption for sensitive data.", "UiPath uses a micro recorder to record user actions and emulators for quick automation. Describing UiPath's recording capabilities and use of emulators for efficient automation.", "UiPath can be integrated with third-party plugins like IBM Watson and Google plugins. Highlighting UiPath's compatibility with third-party plugins, such as IBM Watson and Google plugins.", 'UiPath Studio is the platform to create bots, offering drag and drop activities and a robust UI. Detailing the features of UiPath Studio as the platform for bot creation, including its drag and drop activities and robust UI.', 'UiPath robots include attended robots for human-involved tasks and unattended robots for back office tasks. Explaining the types of UiPath robots, distinguishing between attended and unattended robots and their respective functions.', 'UiPath Orchestrator is the centralized entity to deploy, secure, and manage all automation tasks. Describing the role of UiPath Orchestrator as a centralized entity for deploying, securing, and managing automation tasks.', "UiPath's user interface comprises the ribbon, tools, settings, recorder, scraping, user events, variables, project panel, activities panel, snippets panel, properties panel, outline panel, and output panel. Detailing the components of UiPath's user interface, providing a comprehensive overview of its various elements.", 'Companies like Accenture, Capgemini, Cognizant, Atos, and Deloitte are identified as users of UiPath for automation. Highlighting major companies using UiPath for automation, indicating its adoption and industry relevance.']}], 'duration': 1436.707, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE2981985.jpg', 'highlights': ['Demonstrates merging excel files with UiPath, offering flexibility and customization.', 'Explains the process of merging two excel files using UiPath.', 'Describes the steps to open a new project or create a new project from a template in UiPath.', 'Describes the process of merging two CSV files using UiPath, resulting in the successful merging of 10 rows from each file.', 'The process involves specific steps such as reading the input files, using assign and merge data table activities, writing the merged file, and sending it via email.', 'UiPath offers a community edition for developers and small teams, while the enterprise edition is further classified into three types.', 'The hardware requirements specify a minimum processor of 1.4 GHz for 32-bit configuration, or a recommended 1.8 GHz for 64-bit configuration.', 'For Windows users, the specified operating system versions include 8.1, 10, and the Windows Server versions of 2012, R2, 2016, or 2019.', 'UiPath was founded by Daniel Dines and Mariusz Styrka in 2005.', 'UiPath offers complete end-to-end automation, termed hyper-automation.', 'UiPath provides drag and drop functionalities to make it easy to use.', "Highlighting UiPath's activity library, emphasizing its range of built-in features.", "Emphasizing UiPath's robust security measures, including encryption for sensitive data.", "Describing UiPath's recording capabilities and use of emulators for efficient automation.", "Highlighting UiPath's compatibility with third-party plugins, such as IBM Watson and Google plugins.", 'Detailing the features of UiPath Studio as the platform for bot creation, including its drag and drop activities and robust UI.', 'Explaining the types of UiPath robots, distinguishing between attended and unattended robots and their respective functions.', 'Describing the role of UiPath Orchestrator as a centralized entity for deploying, securing, and managing automation tasks.', "Detailing the components of UiPath's user interface, providing a comprehensive overview of its various elements.", 'Highlighting major companies using UiPath for automation, indicating its adoption and industry relevance.']}, {'end': 5841.543, 'segs': [{'end': 4454.427, 'src': 'embed', 'start': 4421.333, 'weight': 0, 'content': [{'end': 4428.451, 'text': "Now, we'll do a demo to automate a task using UiPath Studio So here is what we are going to do in the demo.", 'start': 4421.333, 'duration': 7.118}, {'end': 4436.336, 'text': "We'll create an automated process to fetch data from a website wherein the bot would extract data like the name of the person,", 'start': 4429.412, 'duration': 6.924}, {'end': 4437.777, 'text': 'the phone number and the email id.', 'start': 4436.336, 'duration': 1.441}, {'end': 4442.26, 'text': 'This data will store it in an excel sheet and send it over an email.', 'start': 4438.877, 'duration': 3.383}, {'end': 4444.081, 'text': "Now let's get started.", 'start': 4443.22, 'duration': 0.861}, {'end': 4454.427, 'text': "Now to do this demo, we'll be using the fake name generator website to generate random data of people and store this data set in an excel sheet.", 'start': 4447.102, 'duration': 7.325}], 'summary': 'Automate task using uipath studio to extract and store data from a website in an excel sheet and email it.', 'duration': 33.094, 'max_score': 4421.333, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE4421333.jpg'}, {'end': 4562.328, 'src': 'embed', 'start': 4519.196, 'weight': 2, 'content': [{'end': 4529.964, 'text': 'after that I had to come back to this and copy each of these fields.', 'start': 4519.196, 'duration': 10.768}, {'end': 4530.405, 'text': 'so name.', 'start': 4529.964, 'duration': 0.441}, {'end': 4551.483, 'text': 'I had to take the phone number, so i would copy this, and similarly for the email address as well.', 'start': 4530.405, 'duration': 21.078}, {'end': 4553.704, 'text': 'for one record it is fine.', 'start': 4551.483, 'duration': 2.221}, {'end': 4560.627, 'text': 'what if you are asked to fetch 100 records or, say, 200 records, then this method is not at all feasible.', 'start': 4553.704, 'duration': 6.923}, {'end': 4562.328, 'text': 'it is time consuming and inefficient.', 'start': 4560.627, 'duration': 1.701}], 'summary': 'Manually copying fields for 100+ records is time-consuming and inefficient.', 'duration': 43.132, 'max_score': 4519.196, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE4519196.jpg'}, {'end': 4715.732, 'src': 'embed', 'start': 4637.009, 'weight': 4, 'content': [{'end': 4641.813, 'text': "So I'll go to my website, copy paste the URL.", 'start': 4637.009, 'duration': 4.804}, {'end': 4647.377, 'text': "I have to give this URL within double quotes, then I'll paste it.", 'start': 4641.833, 'duration': 5.544}, {'end': 4654.214, 'text': 'Now, we need to select the name of the browser where you want to open this website.', 'start': 4650.051, 'duration': 4.163}, {'end': 4660.178, 'text': "So, under input and browser type, I'll choose Chrome.", 'start': 4655.314, 'duration': 4.864}, {'end': 4664.62, 'text': 'Now, let me go ahead and run this file.', 'start': 4662.679, 'duration': 1.941}, {'end': 4670.764, 'text': 'So, under debug, I have run file.', 'start': 4666.041, 'duration': 4.723}, {'end': 4673.046, 'text': "I'll click on it.", 'start': 4670.784, 'duration': 2.262}, {'end': 4684.754, 'text': 'So as you can see, the website is automatically opened in a new window on Chrome.', 'start': 4680.751, 'duration': 4.003}, {'end': 4688.837, 'text': "I'll close this.", 'start': 4688.137, 'duration': 0.7}, {'end': 4697.104, 'text': 'The next step in the process is to tell the program how many records we want to fetch from the website.', 'start': 4692.16, 'duration': 4.944}, {'end': 4700.787, 'text': 'For this, we will create an input dialog box.', 'start': 4698.165, 'duration': 2.622}, {'end': 4712.19, 'text': "So under activities, I'll search for input So here you get the input dialog box.", 'start': 4701.808, 'duration': 10.382}, {'end': 4715.732, 'text': "I'll drag and drop it on the top.", 'start': 4713.571, 'duration': 2.161}], 'summary': 'Automated process opens website in chrome, fetches records using input dialog box.', 'duration': 78.723, 'max_score': 4637.009, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE4637009.jpg'}, {'end': 5036.466, 'src': 'embed', 'start': 4957.723, 'weight': 8, 'content': [{'end': 4963.729, 'text': "So I'll check for assign and I'll drag it onto the body.", 'start': 4957.723, 'duration': 6.006}, {'end': 4974.178, 'text': "So here I'll give val equals to val plus one.", 'start': 4966.051, 'duration': 8.127}, {'end': 4981.902, 'text': 'This will make sure the value of val increases by 1 every time there is a new record inserted.', 'start': 4977.099, 'duration': 4.803}, {'end': 4986.405, 'text': 'It will continue until the value of val no longer matches the total.', 'start': 4982.803, 'duration': 3.602}, {'end': 4992.43, 'text': 'So the next job is to extract information from the website.', 'start': 4989.728, 'duration': 2.702}, {'end': 4995.952, 'text': 'To do this, we will use the getFullText activity.', 'start': 4993.21, 'duration': 2.742}, {'end': 5000.295, 'text': "So I'll search for getFullText here.", 'start': 4998.574, 'duration': 1.721}, {'end': 5007.195, 'text': "and I'll drag it right below the assign activity.", 'start': 5004.113, 'duration': 3.082}, {'end': 5013.819, 'text': 'Now, you need to select the information which you want.', 'start': 5010.437, 'duration': 3.382}, {'end': 5016.56, 'text': 'So first, I want to get the name.', 'start': 5014.779, 'duration': 1.781}, {'end': 5022.264, 'text': "I'll click on the indicate element inside browser and then select the name of the person.", 'start': 5017.601, 'duration': 4.663}, {'end': 5029.208, 'text': "So I'll click on this and I click on the name.", 'start': 5023.725, 'duration': 5.483}, {'end': 5032.27, 'text': 'There you go.', 'start': 5031.869, 'duration': 0.401}, {'end': 5036.466, 'text': 'Now, we need to store this name in a variable.', 'start': 5033.365, 'duration': 3.101}], 'summary': 'Increase val by 1 for each new record; extract and store name using getfulltext activity.', 'duration': 78.743, 'max_score': 4957.723, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE4957723.jpg'}, {'end': 5366.845, 'src': 'embed', 'start': 5164.23, 'weight': 7, 'content': [{'end': 5169.071, 'text': 'Now we need to store the names, phone numbers and email IDs into an Excel sheet.', 'start': 5164.23, 'duration': 4.841}, {'end': 5172.131, 'text': 'For that we need to create a data table.', 'start': 5169.771, 'duration': 2.36}, {'end': 5178.616, 'text': "So I'll search for data table under activities Let me go ahead and do that.", 'start': 5173.711, 'duration': 4.905}, {'end': 5191.721, 'text': "So I'll choose build data table and drag it right below the input dialog box.", 'start': 5182.458, 'duration': 9.263}, {'end': 5197.423, 'text': 'Now this table has to be assigned to a variable.', 'start': 5194.462, 'duration': 2.961}, {'end': 5199.263, 'text': 'So let me do that.', 'start': 5198.423, 'duration': 0.84}, {'end': 5217.61, 'text': 'Let me give a variable name as fetch underscore data underscore table.', 'start': 5201.504, 'duration': 16.106}, {'end': 5231.28, 'text': 'similarly, the output also will give the same variable name, which is fetch underscore data underscore table.', 'start': 5217.61, 'duration': 13.67}, {'end': 5251.544, 'text': "one thing i need to tell you here is we change the variable type, So I'll select browse for types and look for data table, which is system.data.", 'start': 5231.28, 'duration': 20.264}, {'end': 5259.106, 'text': "I'll drill down and search for data table, which is this one.", 'start': 5251.564, 'duration': 7.542}, {'end': 5261.387, 'text': 'Click OK.', 'start': 5261.027, 'duration': 0.36}, {'end': 5268.47, 'text': 'We need to assign the column names to this data table.', 'start': 5265.208, 'duration': 3.262}, {'end': 5270.351, 'text': 'So let me now do that.', 'start': 5269.271, 'duration': 1.08}, {'end': 5277.095, 'text': "I'll uncheck all this and select the columns.", 'start': 5272.713, 'duration': 4.382}, {'end': 5282.318, 'text': "So we'll give the first column name as name itself.", 'start': 5278.196, 'duration': 4.122}, {'end': 5285.08, 'text': 'Click on OK.', 'start': 5284.38, 'duration': 0.7}, {'end': 5287.161, 'text': 'Select one more column.', 'start': 5286.121, 'duration': 1.04}, {'end': 5291.344, 'text': 'Give it as phone number.', 'start': 5288.262, 'duration': 3.082}, {'end': 5306.809, 'text': 'click ok and then we need the email address.', 'start': 5296.345, 'duration': 10.464}, {'end': 5313.591, 'text': "I'll hit ok.", 'start': 5306.809, 'duration': 6.782}, {'end': 5317.052, 'text': 'so we are done so.', 'start': 5313.591, 'duration': 3.461}, {'end': 5321.174, 'text': "first the data table is created and then we'll write this data to an excel file.", 'start': 5317.052, 'duration': 4.122}, {'end': 5326.495, 'text': 'After that, we need to create rows for the data table.', 'start': 5322.873, 'duration': 3.622}, {'end': 5332.998, 'text': 'For that, I will search for row under activities.', 'start': 5327.875, 'duration': 5.123}, {'end': 5340.801, 'text': "I'll search for row and I'll select add row.", 'start': 5333.798, 'duration': 7.003}, {'end': 5344.803, 'text': "I'll select add data row.", 'start': 5343.402, 'duration': 1.401}, {'end': 5361.243, 'text': "I'll place it right below where we have created all the variables.", 'start': 5358.362, 'duration': 2.881}, {'end': 5366.845, 'text': 'Now I want to add a row for the name, phone number and email address.', 'start': 5362.824, 'duration': 4.021}], 'summary': 'Creating a data table to store names, phone numbers, and email ids in excel.', 'duration': 202.615, 'max_score': 5164.23, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE5164230.jpg'}, {'end': 5540.918, 'src': 'embed', 'start': 5498.601, 'weight': 14, 'content': [{'end': 5516.551, 'text': "So I'll search for write CSV under activities and I'll drop it towards the end of the sequence right here.", 'start': 5498.601, 'duration': 17.95}, {'end': 5527.277, 'text': 'Now you need to give the location where you want to place this file on your system and give the source from where it will take the information.', 'start': 5520.493, 'duration': 6.784}, {'end': 5532.716, 'text': "So let's give the location where you want to place this file.", 'start': 5528.675, 'duration': 4.041}, {'end': 5535.117, 'text': "I'll place it on my desktop itself.", 'start': 5533.516, 'duration': 1.601}, {'end': 5538.598, 'text': "I'll name this as fetch.", 'start': 5536.397, 'duration': 2.201}, {'end': 5540.918, 'text': 'Save it.', 'start': 5540.518, 'duration': 0.4}], 'summary': "Using uipath, the speaker saves a csv file named 'fetch' on the desktop.", 'duration': 42.317, 'max_score': 5498.601, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE5498601.jpg'}, {'end': 5718.359, 'src': 'embed', 'start': 5630.546, 'weight': 11, 'content': [{'end': 5632.367, 'text': 'So we have the CSV file.', 'start': 5630.546, 'duration': 1.821}, {'end': 5633.047, 'text': 'Let me open it.', 'start': 5632.407, 'duration': 0.64}, {'end': 5645.815, 'text': 'You can see it has extracted 10 rows of data and three columns, namely name of the person, the phone number and the email address.', 'start': 5635.909, 'duration': 9.906}, {'end': 5653.742, 'text': 'So we are done with the first task of automatically generating data from a website.', 'start': 5649.659, 'duration': 4.083}, {'end': 5657.906, 'text': 'The next task is to send this file over email.', 'start': 5654.683, 'duration': 3.223}, {'end': 5662.63, 'text': 'Now to send an email, you need the SMTP activity.', 'start': 5659.047, 'duration': 3.583}, {'end': 5670.136, 'text': "So under Activities, I'll search for SMTP.", 'start': 5665.032, 'duration': 5.104}, {'end': 5675.841, 'text': "I'll drag it right below here.", 'start': 5674.38, 'duration': 1.461}, {'end': 5682.446, 'text': 'Now we need to configure this.', 'start': 5681.206, 'duration': 1.24}, {'end': 5689.027, 'text': "I'll be actually sending this email from someone else's email ID to my email ID.", 'start': 5684.347, 'duration': 4.68}, {'end': 5705.23, 'text': "So under to, I'll give my email address, which is within quotes, I'll type abhijeet.bhishwal at simplylearn.net.", 'start': 5690.348, 'duration': 14.882}, {'end': 5718.359, 'text': "I'll give a subject as automatic data extraction.", 'start': 5707.83, 'duration': 10.529}], 'summary': 'Extracted 10 rows of data with 3 columns. next task is to send the file over email using smtp activity.', 'duration': 87.813, 'max_score': 5630.546, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE5630546.jpg'}], 'start': 4421.333, 'title': 'Automating data extraction and processing with uipath', 'summary': 'Demonstrates automating data extraction, processing, and email sending using uipath studio, including fetching records, website data extraction, and email sending with detailed configurations, highlighting inefficiency of manual data entry for large volumes.', 'chapters': [{'end': 4562.328, 'start': 4421.333, 'title': 'Automating data extraction and processing with uipath', 'summary': 'Demonstrates the automation of data extraction from a website, including the name, phone number, and email id of individuals, storing it in an excel sheet, and sending it via email using uipath studio, highlighting the inefficiency of manual data entry for large volumes.', 'duration': 140.995, 'highlights': ['The demo showcases the automation of data extraction from a website, including the name, phone number, and email id of individuals, storing it in an Excel sheet, and sending it via email using UiPath Studio. Data extraction, automation, Excel sheet storage, email sending, UiPath Studio', 'Manually copying and pasting each detail onto an Excel sheet for multiple records is time-consuming and inefficient. Inefficiency of manual data entry, time-consuming process', 'Creating an Excel sheet manually for storing the data would involve creating columns for name, phone number, and email, and then copying each field for each record, which is not feasible for large volumes of data. Infeasibility of manual Excel sheet creation, need for column creation and data copying']}, {'end': 4839.007, 'start': 4563.595, 'title': 'Automating task with uipath studio', 'summary': 'Demonstrates how to automate the task of fetching records using uipath studio, including opening a website, inputting details, and utilizing a do while loop to fetch records repeatedly.', 'duration': 275.412, 'highlights': ['Demonstrates how to automate the task of fetching records using UiPath Studio UiPath is utilized to automate the task of fetching records; demonstrates the process of opening a website, inputting details, and utilizing a do while loop to fetch records repeatedly', 'Opening a website in a web browser and running the file in debug mode Uses UiPath Studio to open a website in a web browser, specifically in Chrome, and demonstrates running the file in debug mode', 'Creating an input dialog box to specify the number of records to fetch and using a do while loop to fetch records repeatedly Demonstrates creating an input dialog box to specify the number of records to fetch and utilizes a do while loop to fetch records repeatedly']}, {'end': 5259.106, 'start': 4842.189, 'title': 'Automating website data extraction', 'summary': 'Covers automating the process of fetching records from a website, including assigning variables, data type conversion, incrementing values, extracting information from the website, and storing the data in an excel sheet using uipath activities.', 'duration': 416.917, 'highlights': ['Using UiPath activities to automate the process of fetching records from a website Demonstrates the use of UiPath activities for automating website data extraction', 'Assigning and changing variable types, such as converting a string variable to an integer using the cint function Illustrates the process of assigning variables and changing their types for data manipulation', 'Incrementing the value of a variable by one for each new record inserted Explains the process of incrementing variable values to keep track of records', 'Using the getFullText activity to extract specific information from the website, such as name, phone number, and email address Detailing the usage of the getFullText activity to extract specific information from the website', 'Creating a data table and storing the extracted data into an Excel sheet Describes the creation of a data table and storing the extracted data in an Excel sheet']}, {'end': 5841.543, 'start': 5261.027, 'title': 'Automated data extraction and email sending', 'summary': 'Covers the process of automating data extraction from a website, creating a csv file with 10 rows of data and three columns, and sending the file over email using smtp activity with detailed configurations.', 'duration': 580.516, 'highlights': ["The process of creating a CSV file with 10 rows of data and three columns, namely name, phone number, and email address. {'rows': 10, 'columns': 3}", "Configuring SMTP activity to send an email with attachments, specifying the sender's and receiver's email IDs and the server name and port number. {'attachmentsCount': 1, 'portNumber': 465}", "Assigning column names to the data table, including 'name', 'phone number', and 'email address'. {'columnNames': ['name', 'phone number', 'email address']}", "Indicating the location for the CSV file, placing it on the desktop, and naming it 'fetch'. {'location': 'desktop', 'fileName': 'fetch.csv'}", "Adding rows to the data table for the name, phone number, and email address, and assigning the table name for writing the rows. {'rowsAdded': 1, 'table': 'fetch_data_table'}"]}], 'duration': 1420.21, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE4421333.jpg', 'highlights': ['Demonstrates automating data extraction, processing, and email sending using UiPath Studio', 'Automating data extraction from a website, storing it in an Excel sheet, and sending it via email', 'Inefficiency of manual data entry for large volumes, time-consuming process', 'Utilizing UiPath to automate the task of fetching records from a website', 'Opening a website in a web browser, running the file in debug mode', 'Creating an input dialog box to specify the number of records to fetch', 'Using UiPath activities for automating website data extraction', 'Assigning and changing variable types for data manipulation', 'Incrementing the value of a variable for each new record inserted', 'Using the getFullText activity to extract specific information from the website', 'Creating a data table and storing the extracted data into an Excel sheet', 'Creating a CSV file with 10 rows of data and three columns', 'Configuring SMTP activity to send an email with attachments', 'Assigning column names to the data table', 'Indicating the location for the CSV file and naming it', 'Adding rows to the data table for the name, phone number, and email address']}, {'end': 6716.425, 'segs': [{'end': 5940.562, 'src': 'embed', 'start': 5908.278, 'weight': 0, 'content': [{'end': 5909.959, 'text': 'What is UiPath Orchestrator?', 'start': 5908.278, 'duration': 1.681}, {'end': 5920.913, 'text': 'UiPath Orchestrator is a web application that allows you to orchestrate the execution of repetitive business process by UiPath robots.', 'start': 5912.009, 'duration': 8.904}, {'end': 5929.217, 'text': 'Orchestrator manages the creation, monitoring, scheduling and controlling of automated bots and process.', 'start': 5922.074, 'duration': 7.143}, {'end': 5935.38, 'text': 'It serves as a point of integration for third party solutions and applications.', 'start': 5930.257, 'duration': 5.123}, {'end': 5940.562, 'text': "It's a centralized forum for managing and controlling all software bots.", 'start': 5936.5, 'duration': 4.062}], 'summary': 'Uipath orchestrator is a web app for managing and controlling automated bots, integrating third-party solutions, and centralizing bot management.', 'duration': 32.284, 'max_score': 5908.278, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE5908278.jpg'}, {'end': 6051.255, 'src': 'embed', 'start': 6024.508, 'weight': 1, 'content': [{'end': 6030.59, 'text': 'Orchestrator is used with Attended robots to provide a centralized process deployment and logging medium.', 'start': 6024.508, 'duration': 6.082}, {'end': 6038.292, 'text': 'Unattended In virtual environments, robots can run unattended and automate a variety of processes.', 'start': 6032.35, 'duration': 5.942}, {'end': 6047.833, 'text': 'The orchestrator is in charge of remote execution, control, scheduling, and support for work queues in addition to the attended robot capabilities.', 'start': 6039.187, 'duration': 8.646}, {'end': 6051.255, 'text': 'Studio or Studio X.', 'start': 6049.174, 'duration': 2.081}], 'summary': 'Orchestrator enables centralized deployment and logging for attended robots, supporting remote execution and control.', 'duration': 26.747, 'max_score': 6024.508, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE6024508.jpg'}, {'end': 6104.96, 'src': 'embed', 'start': 6076.339, 'weight': 2, 'content': [{'end': 6079.021, 'text': "Let's look at the orchestrator user interface.", 'start': 6076.339, 'duration': 2.682}, {'end': 6092.352, 'text': 'Dashboard enables us to see charts and statistics illustrating usage information for all the orchestrator components, like process assets, queues,', 'start': 6080.843, 'duration': 11.509}, {'end': 6095.875, 'text': 'schedules, robots, jobs and transactions.', 'start': 6092.352, 'duration': 3.523}, {'end': 6098.854, 'text': "Let's look at the tenant context.", 'start': 6097.233, 'duration': 1.621}, {'end': 6104.96, 'text': 'To view and control the tenant-level entities in your orchestrator, pick tenant from the sidebar menu.', 'start': 6099.455, 'duration': 5.505}], 'summary': 'Orchestrator ui provides usage statistics for components like process assets, queues, schedules, robots, jobs, and transactions.', 'duration': 28.621, 'max_score': 6076.339, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE6076339.jpg'}, {'end': 6156.759, 'src': 'embed', 'start': 6130.901, 'weight': 4, 'content': [{'end': 6136.464, 'text': 'Robots A robot is an execution host that runs UiPath Studio process.', 'start': 6130.901, 'duration': 5.563}, {'end': 6142.428, 'text': 'You can add robots, edit them, display their status and license state,', 'start': 6137.285, 'duration': 5.143}, {'end': 6147.251, 'text': 'adjust the environment they are assigned to and change their runtime settings on the robots tab.', 'start': 6142.428, 'duration': 4.823}, {'end': 6150.934, 'text': 'You can also see the logs that a single robot has created.', 'start': 6147.872, 'duration': 3.062}, {'end': 6156.759, 'text': 'Process can be downloaded and executed automatically by robots using custom settings.', 'start': 6151.874, 'duration': 4.885}], 'summary': 'Uipath studio process can be run by robots, with features for managing and monitoring robots.', 'duration': 25.858, 'max_score': 6130.901, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE6130901.jpg'}], 'start': 5848.366, 'title': 'Uipath orchestrator and its functionality', 'summary': 'Introduces uipath orchestrator as a web application for orchestrating repetitive business processes by uipath robots, managing the entire robot fleet, with capabilities including provisioning, deployment, configuration, monitoring, and interconnectivity. it also provides an overview of orchestrator functionality, including managing robots, folders, users, roles, machines, packages, ml skills, audit, credential stores, webhooks, licensing, alerts, and settings.', 'chapters': [{'end': 6129.66, 'start': 5848.366, 'title': 'Uipath orchestrator overview', 'summary': 'Introduces uipath orchestrator as a web application for orchestrating the execution of repetitive business processes by uipath robots, managing the entire robot fleet, with its capabilities including provisioning, deployment, configuration, queues, monitoring, logging, and interconnectivity, and discusses its use cases for attended, unattended, non-production, studio, and studio x robots, as well as its user interface, dashboard, tenant context, and multi-tenancy features.', 'duration': 281.294, 'highlights': ['UiPath Orchestrator is a web application that allows you to orchestrate the execution of repetitive business process by UiPath robots. Introduces UiPath Orchestrator as a web application for orchestrating repetitive business processes.', 'Orchestrator manages the creation, monitoring, scheduling and controlling of automated bots and process. It serves as a point of integration for third party solutions and applications. Describes the role of Orchestrator in managing and controlling automated bots, as well as its integration capabilities.', 'Orchestrator is used with Attended robots to provide a centralized process deployment and logging medium. Unattended robots can run unattended and automate a variety of processes. Non-production Robots are similar to unattended robots, but they can only be used for research and development. Explains the use cases of Orchestrator with Attended, Unattended, and Non-production robots for centralized process deployment and automation.', 'Dashboard enables us to see charts and statistics illustrating usage information for all the orchestrator components, like process assets, queues, schedules, robots, jobs and transactions. Discusses the functionality of the Dashboard in providing usage information for orchestrator components.', 'To view and control the tenant-level entities in your orchestrator, pick tenant from the sidebar menu. With only one instance of the orchestrator, multi-tenancy allows you to isolate data. Describes the tenant context and multi-tenancy features for controlling tenant-level entities and isolating data.']}, {'end': 6716.425, 'start': 6130.901, 'title': 'Orchestrator functionality overview', 'summary': 'Provides an overview of orchestrator functionality, including managing robots, folders, users, roles, machines, packages, ml skills, audit, credential stores, webhooks, licensing, alerts, settings, and folder-specific automation tabs like process, jobs, triggers, logs, monitoring, queues, assets, storage buckets, and testing.', 'duration': 585.524, 'highlights': ['Robots The chapter explains the functions of robots, such as running UiPath Studio processes, managing robot settings, downloading and executing processes automatically, and configuring automatic process downloading, logging level, font smoothing, and resolution.', 'Folders It outlines the capabilities of classic and modern folders in Orchestrator, with classic folder functionality allowed by default and modern folder functionality requiring enabling by the host or tenant administrator.', 'Users The section describes users as individuals with access-dependent capabilities, whose views and control of Orchestrator are determined by granted access rights, and users can be developed and managed locally or in an external directory.', 'Roles It explains how the Roles tab in Orchestrator helps handle user permissions, defining the Orchestrator view based on assigned roles, and controlling view, edit, create, and delete permissions on all Orchestrator pages and modules.', 'Machines The machine page allows provisioning and controlling machines for registering robots with the Orchestrator, listing all currently operational machines, their forms, and enabling the creation of standard or template computers.']}], 'duration': 868.059, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE5848366.jpg', 'highlights': ['UiPath Orchestrator is a web application for orchestrating repetitive business processes by UiPath robots.', 'Orchestrator manages the creation, monitoring, scheduling, and controlling of automated bots and processes.', 'Dashboard enables us to see charts and statistics illustrating usage information for all the orchestrator components.', 'To view and control the tenant-level entities in your orchestrator, pick tenant from the sidebar menu.', 'Robots run UiPath Studio processes, manage robot settings, download and execute processes automatically, and configure automatic process downloading.']}, {'end': 8348.768, 'segs': [{'end': 6747.301, 'src': 'embed', 'start': 6718.366, 'weight': 3, 'content': [{'end': 6726.333, 'text': 'Action Catalogs Task catalogs are task containers that allow you to categorize your task using a variety of criteria.', 'start': 6718.366, 'duration': 7.967}, {'end': 6733.669, 'text': "The catalog where a task is stored is defined when the task is created using Studio's build type task operation.", 'start': 6727.284, 'duration': 6.385}, {'end': 6738.874, 'text': 'In Orchestrator, the catalog must be specified first.', 'start': 6735.391, 'duration': 3.483}, {'end': 6747.301, 'text': 'If you mention a catalog that has not been generated in Orchestrator, the task is created in Orchestrator without a catalog.', 'start': 6739.554, 'duration': 7.747}], 'summary': 'Action catalogs task catalogs categorize tasks in orchestrator for efficient management.', 'duration': 28.935, 'max_score': 6718.366, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE6718366.jpg'}, {'end': 6906.452, 'src': 'embed', 'start': 6875.262, 'weight': 4, 'content': [{'end': 6877.863, 'text': 'so after filling the details, click on provision.', 'start': 6875.262, 'duration': 2.601}, {'end': 6882.266, 'text': 'the tenant and the tenant admin are created and displayed in the tenants page.', 'start': 6877.863, 'duration': 4.403}, {'end': 6885.427, 'text': 'so, as you can see, the tenant is created.', 'start': 6882.266, 'duration': 3.161}, {'end': 6888.149, 'text': 'there is an option here users and groups.', 'start': 6885.427, 'duration': 2.722}, {'end': 6892.311, 'text': 'you can go to the users and you can see the different users.', 'start': 6888.149, 'duration': 4.162}, {'end': 6895.092, 'text': 'so this is my user, this is me.', 'start': 6892.311, 'duration': 2.781}, {'end': 6901.676, 'text': 'now you can go to the groups and see the different groups are located and their licenses.', 'start': 6895.092, 'duration': 6.584}, {'end': 6906.452, 'text': 'so now that we have created a tenant, I have named it tenant as admit.', 'start': 6901.676, 'duration': 4.776}], 'summary': "Created tenant 'admit' with users and groups.", 'duration': 31.19, 'max_score': 6875.262, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE6875262.jpg'}, {'end': 7063.525, 'src': 'embed', 'start': 7031.772, 'weight': 2, 'content': [{'end': 7041.7, 'text': 'so you will get the username, copy paste the username, enter the password and click on update and the unattended robot will get created.', 'start': 7031.772, 'duration': 9.928}, {'end': 7044.823, 'text': 'so that is how you create the unattended robot.', 'start': 7041.7, 'duration': 3.123}, {'end': 7052.243, 'text': "Now that we have connected robot to the orchestrator, let's open the UiPath Studio.", 'start': 7047.622, 'duration': 4.621}, {'end': 7056.043, 'text': "We'll create a workflow and then we'll run it using the robot.", 'start': 7052.743, 'duration': 3.3}, {'end': 7063.525, 'text': 'So now we have opened the UiPath Studio.', 'start': 7061.324, 'duration': 2.201}], 'summary': 'To create an unattended robot, use the username to enter the password and update, then connect the robot to the orchestrator and run a workflow in uipath studio.', 'duration': 31.753, 'max_score': 7031.772, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE7031772.jpg'}, {'end': 7231.317, 'src': 'embed', 'start': 7192.627, 'weight': 6, 'content': [{'end': 7196.849, 'text': 'so the name is blank process 3 and version is 1.0.60.', 'start': 7192.627, 'duration': 4.222}, {'end': 7202.563, 'text': "so let's go to the orchestrator in orchestrator.", 'start': 7196.85, 'duration': 5.713}, {'end': 7206.804, 'text': 'go to the my workflow folder context in this.', 'start': 7202.563, 'duration': 4.241}, {'end': 7207.744, 'text': 'go to my packages.', 'start': 7206.804, 'duration': 0.94}, {'end': 7214.966, 'text': 'if you go here, you can see refresh here.', 'start': 7207.744, 'duration': 7.222}, {'end': 7218.207, 'text': 'so here you can see blank process 3, the process.', 'start': 7214.966, 'duration': 3.241}, {'end': 7219.707, 'text': 'what we did now?', 'start': 7218.207, 'duration': 1.5}, {'end': 7223.648, 'text': 'it was published three minutes ago.', 'start': 7219.707, 'duration': 3.941}, {'end': 7227.508, 'text': "let's go to the process and the version.", 'start': 7223.648, 'duration': 3.86}, {'end': 7231.317, 'text': 'what we published was 1.0.16.', 'start': 7227.508, 'duration': 3.809}], 'summary': "The process 'blank process 3' version 1.0.60 was published three minutes ago.", 'duration': 38.69, 'max_score': 7192.627, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE7192627.jpg'}, {'end': 7333.69, 'src': 'embed', 'start': 7309.044, 'weight': 5, 'content': [{'end': 7315.909, 'text': 'as well as robot exception handling scheme and event logging for all exceptions and related transaction information.', 'start': 7309.044, 'duration': 6.865}, {'end': 7325.824, 'text': 'The system logs messages at each relevant stage in the process of resolving a business transaction and sends those logs to the orchestrator server.', 'start': 7316.917, 'duration': 8.907}, {'end': 7333.69, 'text': 'This, in turn, can be linked to the ELK stack, which is Elasticsearch log stack, and Kibana platform,', 'start': 7326.725, 'duration': 6.965}], 'summary': 'System logs messages at each relevant stage and sends to orchestrator server.', 'duration': 24.646, 'max_score': 7309.044, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE7309044.jpg'}, {'end': 7459.555, 'src': 'embed', 'start': 7409.814, 'weight': 0, 'content': [{'end': 7417.116, 'text': 'What is RE framework? The robotic enterprise framework is a state machine based project template.', 'start': 7409.814, 'duration': 7.302}, {'end': 7427.078, 'text': 'The template includes several ready to use state containers for launching applications, retrieving data, processing it and closing the transaction.', 'start': 7418.176, 'duration': 8.902}, {'end': 7434.89, 'text': 'These states are linked together by a series of transactions that cover almost every requirement in a typical automation scenario.', 'start': 7427.904, 'duration': 6.986}, {'end': 7440.815, 'text': 'Several workflows have been triggered, each of which deals with a different aspect of the project.', 'start': 7435.79, 'duration': 5.025}, {'end': 7452.084, 'text': "It's designed to incorporate all of the industry's best practices for logging, exception management, application initialization and other areas,", 'start': 7441.935, 'duration': 10.149}, {'end': 7455.827, 'text': 'showing it to handle even the most complex business situations.', 'start': 7452.084, 'duration': 3.743}, {'end': 7459.555, 'text': "Let's look at the features of RE framework.", 'start': 7457.594, 'duration': 1.961}], 'summary': 'The re framework is a state machine template with ready-to-use state containers for automation, incorporating industry best practices.', 'duration': 49.741, 'max_score': 7409.814, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE7409814.jpg'}, {'end': 7623.385, 'src': 'embed', 'start': 7596.732, 'weight': 7, 'content': [{'end': 7605.274, 'text': 'There are four key states in RE framework, that is initial state, get transaction data, process transaction and end process.', 'start': 7596.732, 'duration': 8.542}, {'end': 7611.702, 'text': 'Initial state, initialization, this is the point at which the procedure begins.', 'start': 7606.658, 'duration': 5.044}, {'end': 7620.389, 'text': "It's an event where the process initializes the settings and runs application tests to ensure that all of the prerequisites for the process start are met.", 'start': 7612.182, 'duration': 8.207}, {'end': 7623.385, 'text': 'So initialization transitions.', 'start': 7621.604, 'duration': 1.781}], 'summary': 'Re framework has 4 key states: initial, get transaction data, process transaction, and end process. initialization ensures prerequisites are met.', 'duration': 26.653, 'max_score': 7596.732, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE7596732.jpg'}, {'end': 8071.198, 'src': 'embed', 'start': 8036.41, 'weight': 8, 'content': [{'end': 8040.472, 'text': "when you're working with the orchestrator queues, the value should be zero.", 'start': 8036.41, 'duration': 4.062}, {'end': 8049.316, 'text': 'so this config file is stored in the data folder and it has three sheets settings, constants and assets.', 'start': 8040.472, 'duration': 8.844}, {'end': 8053.519, 'text': 'This is the queue name process, ABCQ.', 'start': 8051.377, 'duration': 2.142}, {'end': 8058.705, 'text': "Let's get back to the teamwork.", 'start': 8054.32, 'duration': 4.385}, {'end': 8067.937, 'text': 'so we are initializing system error.', 'start': 8065.836, 'duration': 2.101}, {'end': 8071.198, 'text': 'if the error is nothing, it will go to the next state.', 'start': 8067.937, 'duration': 3.261}], 'summary': 'Orchestrator queue value should be zero, config file has 3 sheets, processing queue name is abcq.', 'duration': 34.788, 'max_score': 8036.41, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE8036410.jpg'}, {'end': 8165.589, 'src': 'embed', 'start': 8140.191, 'weight': 9, 'content': [{'end': 8148.477, 'text': 'So basically, what this workflow does is this workflow outputs a setting dictionary with the key value pairs to be used in the project.', 'start': 8140.191, 'duration': 8.286}, {'end': 8153.961, 'text': 'Settings are referred from the local config file and then fetched from the orchestrator assets.', 'start': 8149.177, 'duration': 4.784}, {'end': 8156.803, 'text': 'Assets will overwrite the config file settings.', 'start': 8154.581, 'duration': 2.222}, {'end': 8165.589, 'text': 'setting in it all settings workflow invoke to initialize all settings and data for application and process used in this part.', 'start': 8157.563, 'duration': 8.026}], 'summary': 'Workflow outputs setting dictionary with key-value pairs for project.', 'duration': 25.398, 'max_score': 8140.191, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE8140191.jpg'}], 'start': 6718.366, 'title': 'Uipath orchestrator integration, workflow publishing, and robotic enterprise framework', 'summary': 'Provides a detailed guide on integrating uipath robot with orchestrator, publishing a workflow in orchestrator, and explaining the robotic enterprise (re) framework, with an emphasis on user roles, machine provisioning, robot connection, system logging, data storage, and dispatching data from an excel file.', 'chapters': [{'end': 7159.774, 'start': 6718.366, 'title': 'Uipath orchestrator integration', 'summary': 'Provides a detailed guide on integrating uipath robot with orchestrator, including creating task catalogs, configuring permissions and machines, adding a tenant, and connecting robots to the orchestrator, with an emphasis on user roles, machine provisioning, and robot connection.', 'duration': 441.408, 'highlights': ['The process of connecting UiPath robot with the Orchestrator is explained, detailing two methods of connection and the steps to create an unattended robot. The transcript provides a detailed guide on connecting UiPath robot to the orchestrator, explaining two methods of connection - signing in through UiPath Assistant or manually connecting. It also outlines the steps to create an unattended robot, emphasizing the importance of enabling this option for user-specific robot connections.', 'The creation of task catalogs in Orchestrator and their role in categorizing tasks is described, emphasizing the defining of catalogs during task creation in Studio and the necessity of specifying the catalog in Orchestrator. The chapter explains the creation of task catalogs in Orchestrator and their role in categorizing tasks, highlighting the importance of defining catalogs during task creation in Studio and the requirement to specify the catalog in Orchestrator.', 'The process of adding a tenant in UiPath Orchestrator, including the steps to provision a tenant and the creation of tenant admin, is detailed. The transcript details the process of adding a tenant in UiPath Orchestrator, providing step-by-step instructions on provisioning a tenant and creating a tenant admin, with an emphasis on the required details and the subsequent display of the created tenant.']}, {'end': 7408.354, 'start': 7159.774, 'title': 'Publishing workflow in orchestrator', 'summary': "Discusses the process of publishing a workflow in orchestrator, including the package details, orchestrator navigation, job execution, and the purpose of the framework, emphasizing the system's logging and data storage capabilities.", 'duration': 248.58, 'highlights': ['The purpose of the framework is to resolve a set of business transactions, including robot exception handling scheme and event logging for all exceptions and transaction information, linked to the ELK stack, serving as a blueprint for users (Transaction resolution details).', 'The version 1.0.60 of the blank process 3 was successfully published three minutes ago in the orchestrator, and it is available for execution (Publishing and version details).', "The process, 'blank process 3', was published with version 1.0.16, and the job execution was initiated with normal priority, displaying a message after successful completion (Job execution details).", 'A business process involves collecting, processing, and inputting data into or out of an IT resource, and can be classified into linear, iterative, and transactional processes based on the steps and data repetition (Business process classification details).']}, {'end': 8002.629, 'start': 7409.814, 'title': 'Robotic enterprise framework overview', 'summary': 'Explains the robotic enterprise (re) framework, a state machine-based project template, with ready-to-use state containers for launching applications, retrieving and processing data, and includes features like settings, logging, and business application exceptions. it also delves into the architecture of the re framework, highlighting the key states and transitions. additionally, the chapter provides a demo on dispatching data from an excel file, creating queue items, and understanding the working of each state in the re framework.', 'duration': 592.815, 'highlights': ['The RE framework is a state machine-based project template with ready-to-use state containers for launching applications, retrieving data, processing it, and closing the transaction, covering almost every requirement in a typical automation scenario. The RE framework provides ready-to-use state containers for various tasks in automation scenarios, ensuring efficiency and covering almost all requirements.', 'The RE framework incorporates industry best practices for logging, exception management, and application initialization, enabling it to handle even the most complex business situations. The RE framework incorporates industry best practices, ensuring robust handling of complex business situations.', 'The RE framework features settings for managing configuration values, a built-in logging mechanism for system workflows, and the handling of application and business exceptions during the execution of processes. The RE framework includes settings management, a built-in logging mechanism, and handles application and business exceptions during process execution.', 'The RE framework is implemented as a state machine, with key states including Initial State, Get Transaction Data, Process Transaction, and End Process, each with specific transitions based on system and application exceptions. The RE framework is implemented as a state machine with key states and transitions, ensuring smooth execution and handling of exceptions.', 'A demo on dispatching data from an Excel file, creating queue items, and understanding the working of each state in the RE framework is provided, showcasing practical application and understanding of the discussed concepts. The chapter provides a practical demo on dispatching data, creating queue items, and understanding the working of each state in the RE framework, offering hands-on application and understanding of the concepts.']}, {'end': 8348.768, 'start': 8002.629, 'title': 'Initializing system and orchestrator queues', 'summary': 'Details the process of initializing system settings and orchestrator queues, including the use of a config file with three sheets, the initialization of all settings workflow, and the workflow to get transaction data from different sources, with a focus on key value pairs and queue names.', 'duration': 346.139, 'highlights': ['The config file contains three sheets: settings, constants, and assets, with the recommendation to set the maximum retry number and orchestrator queue value to zero for working with orchestrator queues.', 'The initialize all settings workflow outputs a setting dictionary with key value pairs from the local config file and orchestrator assets, while the get transaction data workflow retrieves data from spreadsheets, databases, email, web API, or UiPath server.', 'The process of initializing system settings involves reading the config file and storing the key value pairs inside the dictionary variable outconfig, which contains all config excel file data.']}], 'duration': 1630.402, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE6718366.jpg', 'highlights': ['The RE framework provides ready-to-use state containers for various tasks in automation scenarios, ensuring efficiency and covering almost all requirements.', 'The RE framework incorporates industry best practices, ensuring robust handling of complex business situations.', 'The process of connecting UiPath robot with the Orchestrator is explained, detailing two methods of connection and the steps to create an unattended robot.', 'The creation of task catalogs in Orchestrator and their role in categorizing tasks is described, emphasizing the defining of catalogs during task creation in Studio and the necessity of specifying the catalog in Orchestrator.', 'The process of adding a tenant in UiPath Orchestrator, including the steps to provision a tenant and the creation of tenant admin, is detailed.', 'The purpose of the framework is to resolve a set of business transactions, including robot exception handling scheme and event logging for all exceptions and transaction information, linked to the ELK stack, serving as a blueprint for users (Transaction resolution details).', 'The version 1.0.60 of the blank process 3 was successfully published three minutes ago in the orchestrator, and it is available for execution (Publishing and version details).', 'The RE framework is implemented as a state machine, with key states including Initial State, Get Transaction Data, Process Transaction, and End Process, each with specific transitions based on system and application exceptions.', 'The config file contains three sheets: settings, constants, and assets, with the recommendation to set the maximum retry number and orchestrator queue value to zero for working with orchestrator queues.', 'The initialize all settings workflow outputs a setting dictionary with key value pairs from the local config file and orchestrator assets, while the get transaction data workflow retrieves data from spreadsheets, databases, email, web API, or UiPath server.']}, {'end': 10545.812, 'segs': [{'end': 8489.92, 'src': 'embed', 'start': 8430.817, 'weight': 0, 'content': [{'end': 8436.481, 'text': 'It is compatible with HTML, AJAX, Java, Silverlight and PDF.', 'start': 8430.817, 'duration': 5.664}, {'end': 8444.306, 'text': 'Automated Data Entry Data entry from an Excel spreadsheet to website can be automated in UiPath.', 'start': 8437.982, 'duration': 6.324}, {'end': 8447.288, 'text': 'It provides simple web testing.', 'start': 8445.667, 'duration': 1.621}, {'end': 8452.211, 'text': 'Without any programming knowledge, UiPath helps in designing a valid test.', 'start': 8447.728, 'duration': 4.483}, {'end': 8454.832, 'text': 'No coding is required.', 'start': 8453.632, 'duration': 1.2}, {'end': 8459.874, 'text': 'We can create automation with a simple to use graphical workflow designer.', 'start': 8455.253, 'duration': 4.621}, {'end': 8462.335, 'text': 'Playback precision.', 'start': 8461.335, 'duration': 1}, {'end': 8465.556, 'text': 'UiPath provides 100% playback precision.', 'start': 8462.515, 'duration': 3.041}, {'end': 8471.718, 'text': 'Web automation can be done regardless of the browser version, screen position or size.', 'start': 8466.096, 'duration': 5.622}, {'end': 8482.202, 'text': 'How does web automation work in UiPath? A built-in recorder in UiPath web automation can read and implement web-based activities.', 'start': 8473.039, 'duration': 9.163}, {'end': 8489.92, 'text': 'It uses attributes to identify web items and manipulates them accurately while keeping up with page changes.', 'start': 8483.138, 'duration': 6.782}], 'summary': 'Uipath offers 100% playback precision and allows web automation without coding.', 'duration': 59.103, 'max_score': 8430.817, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE8430817.jpg'}, {'end': 8601.065, 'src': 'embed', 'start': 8546.707, 'weight': 4, 'content': [{'end': 8552.492, 'text': 'So here you can see there are 27 results, 27 free resources available on the Simply Learns website.', 'start': 8546.707, 'duration': 5.785}, {'end': 8555.474, 'text': "So I'll scrape all of this data.", 'start': 8553.172, 'duration': 2.302}, {'end': 8564.702, 'text': "So using data scraping option in UiPath, I'll scrape the resource name along with the type, whether it's an article or video tutorial.", 'start': 8555.874, 'duration': 8.828}, {'end': 8567.224, 'text': "And along with that, I'll scrape the URL.", 'start': 8565.062, 'duration': 2.162}, {'end': 8575.03, 'text': "So I'll scrape all these three things and copy it in an Excel sheet and the Excel sheet over and mail, I'll send it to the customer.", 'start': 8567.884, 'duration': 7.146}, {'end': 8578.914, 'text': "so let's get started.", 'start': 8576.593, 'duration': 2.321}, {'end': 8582.896, 'text': "so let's jump into uipath studio and get started with the demo.", 'start': 8578.914, 'duration': 3.982}, {'end': 8586.338, 'text': "so let's create a new flow chart.", 'start': 8582.896, 'duration': 3.442}, {'end': 8598.664, 'text': "we'll name the flow chart as web automation, since we are showing this demo under web automation.", 'start': 8586.338, 'duration': 12.326}, {'end': 8601.065, 'text': 'so a new flow chart is created.', 'start': 8598.664, 'duration': 2.401}], 'summary': "27 free resources scraped from simply learns website for customer's excel sheet and mail.", 'duration': 54.358, 'max_score': 8546.707, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE8546707.jpg'}, {'end': 8673.377, 'src': 'embed', 'start': 8645.984, 'weight': 5, 'content': [{'end': 8654.326, 'text': 'click on chrome and if you want to continue installing ui path extension for chrome, please close all your chrome process, then click on ok.', 'start': 8645.984, 'duration': 8.342}, {'end': 8661.528, 'text': 'so then click on ok and your ui path extension for chrome will get installed.', 'start': 8654.326, 'duration': 7.202}, {'end': 8671.915, 'text': 'so since i have already installed, click on cancel When, after installing, when you open Chrome.', 'start': 8661.528, 'duration': 10.387}, {'end': 8673.377, 'text': 'so your screen will look like this', 'start': 8671.915, 'duration': 1.462}], 'summary': 'To install uipath extension for chrome, close all chrome processes, then click ok. cancel after installation for the screen to appear.', 'duration': 27.393, 'max_score': 8645.984, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE8645984.jpg'}, {'end': 8999.52, 'src': 'embed', 'start': 8961.774, 'weight': 3, 'content': [{'end': 8967.741, 'text': "So till here it's done where we are opening the Simply Learns website and searching for UiPath.", 'start': 8961.774, 'duration': 5.967}, {'end': 8973.268, 'text': "Next what we'll do is we will scrape the data.", 'start': 8969.063, 'duration': 4.205}, {'end': 8976.752, 'text': "So we'll rename it as data scraping.", 'start': 8974.189, 'duration': 2.563}, {'end': 8986.935, 'text': "we'll open the sequence.", 'start': 8985.674, 'duration': 1.261}, {'end': 8995.058, 'text': 'so data scraping is something where we extract structured data from a browser, application or a document to a data table.', 'start': 8986.935, 'duration': 8.123}, {'end': 8997.959, 'text': "so we'll click on data scraping.", 'start': 8995.058, 'duration': 2.901}, {'end': 8999.52, 'text': "so we'll open the browser.", 'start': 8997.959, 'duration': 1.561}], 'summary': 'Opening simply learns website, searching for uipath, and performing data scraping from the browser.', 'duration': 37.746, 'max_score': 8961.774, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE8961774.jpg'}, {'end': 9460.987, 'src': 'embed', 'start': 9427.002, 'weight': 10, 'content': [{'end': 9431.466, 'text': 'Only workflows running under the current user context can decrypt the password.', 'start': 9427.002, 'duration': 4.464}, {'end': 9435.21, 'text': 'So go to the password and enter your email ID password.', 'start': 9431.967, 'duration': 3.243}, {'end': 9452.98, 'text': 'and, in the result, create a new variable and store the password in a variable so that your password is encrypted, and name the variable as password.', 'start': 9439.628, 'duration': 13.352}, {'end': 9456.163, 'text': 'short form something password.', 'start': 9452.98, 'duration': 3.183}, {'end': 9460.987, 'text': 'and next activity we need is send smtp mail message.', 'start': 9456.163, 'duration': 4.824}], 'summary': 'Workflows decrypt password under user context, encrypt email id password, and send smtp mail.', 'duration': 33.985, 'max_score': 9427.002, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE9427002.jpg'}, {'end': 9731.318, 'src': 'embed', 'start': 9680.811, 'weight': 7, 'content': [{'end': 9683.352, 'text': "I'll scrape the course name, the type and the URL.", 'start': 9680.811, 'duration': 2.541}, {'end': 9689.434, 'text': "Then in the Excel application scope, I'll copy all the scrape data in an Excel file.", 'start': 9683.952, 'duration': 5.482}, {'end': 9691.575, 'text': "So I'll use an Excel application scope.", 'start': 9689.734, 'duration': 1.841}, {'end': 9692.635, 'text': 'I have created a file.', 'start': 9691.595, 'duration': 1.04}, {'end': 9694.956, 'text': "So in that file, I'll write the scrape data.", 'start': 9692.955, 'duration': 2.001}, {'end': 9697.789, 'text': 'in the second sequence.', 'start': 9696.129, 'duration': 1.66}, {'end': 9707.671, 'text': 'then finally, in the third sequence, I am using the get password activity and send SMTP mail message and I am sending it over an email.', 'start': 9697.789, 'duration': 9.882}, {'end': 9713.033, 'text': 'I am sending the excel file as an attachment with an email to the customer.', 'start': 9707.671, 'duration': 5.362}, {'end': 9720.954, 'text': 'this message box simply indicates that the mail has been successfully sent.', 'start': 9713.033, 'duration': 7.921}, {'end': 9727.897, 'text': "ok, now let me save and click on run, So I'll close the previous browser.", 'start': 9720.954, 'duration': 6.943}, {'end': 9731.318, 'text': 'Let me save and click on run.', 'start': 9729.317, 'duration': 2.001}], 'summary': 'Scrape course data, write to excel, send as email attachment', 'duration': 50.507, 'max_score': 9680.811, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE9680811.jpg'}, {'end': 9914.773, 'src': 'embed', 'start': 9890.123, 'weight': 11, 'content': [{'end': 9899.795, 'text': 'Excel automation improves quality in several ways, including eliminating human error, increasing consistency and accuracy,', 'start': 9890.123, 'duration': 9.672}, {'end': 9904.962, 'text': 'the ability to create more complex projects and the detection of mistakes along the way.', 'start': 9899.795, 'duration': 5.167}, {'end': 9914.773, 'text': "Improved Safety Excel allows you to protect your work, whether it's to prevent someone from opening a workbook without a password,", 'start': 9906.05, 'duration': 8.723}], 'summary': 'Excel automation enhances quality by eliminating human error, increasing consistency and accuracy, and detecting mistakes, improving safety by enabling protection of work with passwords.', 'duration': 24.65, 'max_score': 9890.123, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE9890123.jpg'}, {'end': 9981.039, 'src': 'embed', 'start': 9943.202, 'weight': 12, 'content': [{'end': 9945.844, 'text': "Let's look how to install an Excel package.", 'start': 9943.202, 'duration': 2.642}, {'end': 9948.847, 'text': "Let's jump into the UiPath Studio.", 'start': 9946.565, 'duration': 2.282}, {'end': 9957.179, 'text': 'To install an Excel package, go to the Manage Packages You can see the packages that are installed.', 'start': 9949.227, 'duration': 7.952}, {'end': 9962.926, 'text': 'Go to all packages and search for UiPathXL Activities.', 'start': 9957.74, 'duration': 5.186}, {'end': 9977.098, 'text': 'By default an updated version will be installed.', 'start': 9974.457, 'duration': 2.641}, {'end': 9981.039, 'text': 'If the Excel package is not installed you can install it from here.', 'start': 9977.458, 'duration': 3.581}], 'summary': 'Installing excel package in uipath studio, including searching and updating packages.', 'duration': 37.837, 'max_score': 9943.202, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE9943202.jpg'}, {'end': 10092.397, 'src': 'embed', 'start': 10059.601, 'weight': 13, 'content': [{'end': 10064.142, 'text': 'So we will create an Excel automation to represent the number of cases in charts.', 'start': 10059.601, 'duration': 4.541}, {'end': 10071.604, 'text': "It's easy to understand looking at the charts rather than looking at the huge numbers.", 'start': 10066.703, 'duration': 4.901}, {'end': 10075.005, 'text': 'Then we will upload the file on the drive.', 'start': 10073.104, 'duration': 1.901}, {'end': 10079.284, 'text': "So let's jump into the UiPath Studio and get started.", 'start': 10076.061, 'duration': 3.223}, {'end': 10083.368, 'text': 'This is the Excel file which I have created.', 'start': 10081.246, 'duration': 2.122}, {'end': 10092.397, 'text': 'It has all the number of cases in these five states in the year 2021 in the month of Jan, Feb, March and April.', 'start': 10084.269, 'duration': 8.128}], 'summary': 'Automate excel to represent case data in charts for 5 states in 2021.', 'duration': 32.796, 'max_score': 10059.601, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE10059601.jpg'}, {'end': 10201.593, 'src': 'embed', 'start': 10168.01, 'weight': 8, 'content': [{'end': 10175.733, 'text': 'So Excel application scope, what it does is it opens an Excel workbook and sets the scope for Excel activities.', 'start': 10168.01, 'duration': 7.723}, {'end': 10181.895, 'text': 'When this activity is completed, the specified workbook and the Excel application are closed.', 'start': 10176.453, 'duration': 5.442}, {'end': 10189.678, 'text': 'When the workbook application variable is specified in the output, workbook activities field, the spreadsheet is not closed.', 'start': 10182.395, 'duration': 7.283}, {'end': 10201.593, 'text': 'after this drag and drop create table activity.', 'start': 10191.869, 'duration': 9.724}], 'summary': 'Excel application scope opens workbook, sets scope, and closes workbook after activity completion.', 'duration': 33.583, 'max_score': 10168.01, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE10168010.jpg'}], 'start': 8348.768, 'title': 'Uipath web automation and excel benefits', 'summary': 'Covers web automation in uipath, demonstrating data scraping, creating web automation flow chart, automating data scraping and emailing, and explaining excel automation benefits with a demo, resulting in improved production rates and reduced lead time.', 'chapters': [{'end': 8567.224, 'start': 8348.768, 'title': 'Web automation in uipath', 'summary': 'Discusses the process of web automation in uipath, including its features and functionality, such as compatibility with various web technologies, automated data entry, and playback precision. it also highlights the demonstration of data scraping from a website using uipath.', 'duration': 218.456, 'highlights': ["UiPath is compatible with HTML, AJAX, Java, Silverlight and PDF. UiPath's compatibility with various web technologies allows for versatile web automation, enhancing the scope of automated tasks and actions.", "Data entry from an Excel spreadsheet to website can be automated in UiPath. UiPath's capability to automate data entry from Excel to a website streamlines the process and reduces manual effort, leading to increased efficiency.", "Web automation can be done regardless of the browser version, screen position or size. UiPath's web automation is not limited by browser characteristics or interface variations, ensuring consistent performance across diverse web environments.", "Using data scraping option in UiPath, I'll scrape the resource name along with the type, whether it's an article or video tutorial, and the URL. The demonstration showcases the data scraping functionality in UiPath, emphasizing its ability to extract specific data elements, such as resource names, types, and URLs, from a website."]}, {'end': 9131.838, 'start': 8567.884, 'title': 'Uipath web automation demo', 'summary': 'Covers the process of creating a web automation flow chart in uipath studio, including installing browser extensions, opening a browser, maximizing the window, entering a search query, clicking on options, and scraping structured data, extracting 27 resources with details like resource name, type, and url.', 'duration': 563.954, 'highlights': ['Scraping structured data The process of data scraping is explained, where 27 resources are extracted with details like resource name, type, and URL, with the option to extract correlated data and handle multiple pages if required.', 'Installing browser extensions Demonstrates the installation of UiPath extensions for Chrome, including the process of enabling the extension and ensuring the installation is successful.', 'Creating a web automation flow chart Explains the steps involved in creating a flow chart for web automation in UiPath Studio, including naming the flow chart, setting a start node, and adding activities like opening a browser, maximizing the window, and entering a search query.']}, {'end': 9785.097, 'start': 9131.938, 'title': 'Automating data scraping and emailing', 'summary': 'Presents the process of scraping data from a website, writing it to an excel sheet, and sending it as an email attachment, resulting in the successful mailing of course details.', 'duration': 653.159, 'highlights': ['The process involves scraping data from a website, writing it to an Excel sheet, and sending it as an email attachment. The chapter describes the workflow of scraping data, writing it to an Excel sheet, and sending it as an email attachment, outlining the key steps and their sequence.', "The Excel application scope activity opens an Excel workbook, providing a scope for Excel activities and creating a new file if it doesn't exist. The Excel application scope activity opens an Excel workbook, provides a scope for Excel activities, and creates a new file if it doesn't exist, ensuring efficient data handling in Excel.", 'The Send SMTP mail message activity sends an email message using the SMTP protocol and attaches the Excel file containing the scraped data. The Send SMTP mail message activity sends an email message using the SMTP protocol and attaches the Excel file containing the scraped data, ensuring the successful delivery of the course details via email.', 'The Get Password activity encrypts the email ID password for secure transmission in the workflow. The Get Password activity encrypts the email ID password for secure transmission, ensuring the confidentiality of the email credentials during the workflow.']}, {'end': 10545.812, 'start': 9786.178, 'title': 'Excel automation benefits and demo', 'summary': 'Explains the benefits of excel automation, including higher production rates, improved product quality, safety, reduced labor, and lead time reduction, and details the process of creating an excel automation project using uipath studio, including installing excel packages, utilizing commonly used excel activities, and creating bar and pie charts from an excel sheet.', 'duration': 759.634, 'highlights': ['Excel automation provides higher production rates and increased productivity, improving quality, and reducing lead time, thus saving many hours spent manually completing tasks.', 'UiPath Studio allows the installation of Excel packages, such as UiPathXL Activities, and provides commonly used Excel activities like Read range, select range, save workbook, autofill range, copy paste range, insert and delete columns, filters, and VLOOKUP.', 'The demo showcases creating an Excel automation project using UiPath Studio, including installing required packages like UiPath Excel Activities, UiPath gsuit.activities, and balareva-xl-activities, and the process of creating bar and pie charts from an Excel sheet.', 'Excel application scope opens an Excel workbook and sets the scope for Excel activities, while create table activity and bar chart creation outside the Excel application scope are demonstrated in the demo.']}], 'duration': 2197.044, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE8348768.jpg', 'highlights': ['UiPath is compatible with HTML, AJAX, Java, Silverlight and PDF, enhancing the scope of automated tasks and actions.', 'Data entry from an Excel spreadsheet to website can be automated in UiPath, leading to increased efficiency.', 'Web automation in UiPath is not limited by browser characteristics or interface variations, ensuring consistent performance.', 'The demonstration showcases the data scraping functionality in UiPath, emphasizing its ability to extract specific data elements from a website.', 'The process of data scraping is explained, where 27 resources are extracted with details like resource name, type, and URL.', 'Demonstrates the installation of UiPath extensions for Chrome, ensuring the successful installation.', 'Explains the steps involved in creating a flow chart for web automation in UiPath Studio.', 'The chapter describes the workflow of scraping data, writing it to an Excel sheet, and sending it as an email attachment.', "The Excel application scope activity opens an Excel workbook, providing a scope for Excel activities and creating a new file if it doesn't exist.", 'The Send SMTP mail message activity sends an email message using the SMTP protocol and attaches the Excel file containing the scraped data.', 'The Get Password activity encrypts the email ID password for secure transmission in the workflow.', 'Excel automation provides higher production rates and increased productivity, improving quality, and reducing lead time.', 'UiPath Studio allows the installation of Excel packages, such as UiPathXL Activities, and provides commonly used Excel activities.', 'The demo showcases creating an Excel automation project using UiPath Studio, including installing required packages and the process of creating bar and pie charts from an Excel sheet.', 'Excel application scope opens an Excel workbook and sets the scope for Excel activities, while create table activity and bar chart creation outside the Excel application scope are demonstrated in the demo.']}, {'end': 11765.144, 'segs': [{'end': 10694.97, 'src': 'embed', 'start': 10661.714, 'weight': 0, 'content': [{'end': 10663.574, 'text': 'Next up is RPA growth projections.', 'start': 10661.714, 'duration': 1.86}, {'end': 10672.662, 'text': "Now looking at the curve, both RPA's software and services increased by huge amounts between 2016 and 2020 and beyond.", 'start': 10664.798, 'duration': 7.864}, {'end': 10682.867, 'text': 'According to Nexon Day Research, knowledge and work automation could have an economic impact of about 5-7 trillion US dollars by the year 2025.', 'start': 10673.382, 'duration': 9.485}, {'end': 10688.33, 'text': 'It will touch more than 230 million knowledge workers, which constitute up to 9% of the global workforce.', 'start': 10682.867, 'duration': 5.463}, {'end': 10694.97, 'text': 'Now. any company which is labor intensive, where people are performing high volume, high transaction functions,', 'start': 10689.127, 'duration': 5.843}], 'summary': 'Rpa software and services grew significantly from 2016 to 2020, with projected $5-7 trillion economic impact by 2025, affecting 230m workers (9% of global workforce).', 'duration': 33.256, 'max_score': 10661.714, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE10661714.jpg'}, {'end': 10754.468, 'src': 'embed', 'start': 10727.698, 'weight': 2, 'content': [{'end': 10731.221, 'text': 'However, there are a few common responsibilities of an RPA developer.', 'start': 10727.698, 'duration': 3.523}, {'end': 10733.223, 'text': "Let's go ahead and check them out.", 'start': 10731.741, 'duration': 1.482}, {'end': 10737.086, 'text': 'Now the first one is strategic planning skills.', 'start': 10734.944, 'duration': 2.142}, {'end': 10740.79, 'text': 'Now planning is a crucial phase in any development lifecycle.', 'start': 10737.747, 'duration': 3.043}, {'end': 10746.803, 'text': 'The RPA developer, regardless of the designation, should possess the aptitude to ensure strategic planning.', 'start': 10741.4, 'duration': 5.403}, {'end': 10751.686, 'text': 'Planning includes the design, development and implementation of RPA systems.', 'start': 10747.624, 'duration': 4.062}, {'end': 10754.468, 'text': 'This also helps streamline the business.', 'start': 10752.327, 'duration': 2.141}], 'summary': 'Rpa developers need strategic planning skills for design, development, and implementation of rpa systems to streamline business.', 'duration': 26.77, 'max_score': 10727.698, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE10727698.jpg'}, {'end': 10922.475, 'src': 'embed', 'start': 10894.114, 'weight': 1, 'content': [{'end': 10897.797, 'text': 'And a Data Analyst earns around 62,000 US dollars per annum.', 'start': 10894.114, 'duration': 3.683}, {'end': 10904.283, 'text': 'Moving on to India, the average salary of an RPA Developer is around 5,98,000 rupees.', 'start': 10898.458, 'duration': 5.825}, {'end': 10911.233, 'text': 'That of a Senior Consultant A senior RPA developer and an RPA lead developer is around 14 lakhs per annum.', 'start': 10904.984, 'duration': 6.249}, {'end': 10916.274, 'text': 'And the average salary of an RPA business analyst is around 5 lakhs 40 thousand rupees.', 'start': 10911.993, 'duration': 4.281}, {'end': 10922.475, 'text': 'Now let me quickly run you through a sample resume of an RPA developer.', 'start': 10918.514, 'duration': 3.961}], 'summary': 'Data analyst earns $62,000/year, rpa developer in india earns ₹5,98,000, and senior rpa developer earns ₹14,00,000/year.', 'duration': 28.361, 'max_score': 10894.114, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE10894114.jpg'}, {'end': 11084.686, 'src': 'embed', 'start': 11050.24, 'weight': 3, 'content': [{'end': 11054.864, 'text': 'UiPath is a robotic process automation tool for large-scale end-to-end automation.', 'start': 11050.24, 'duration': 4.624}, {'end': 11061.389, 'text': 'For an accelerated business change, it provides solution for business to automate routine office activities.', 'start': 11055.745, 'duration': 5.644}, {'end': 11067.274, 'text': 'It uses a variety of methods to transform tedious tasks into automated process.', 'start': 11062.75, 'duration': 4.524}, {'end': 11070.837, 'text': 'What are the different components in UiPath?', 'start': 11068.775, 'duration': 2.062}, {'end': 11074.76, 'text': 'UiPath consists of three components, mainly UiPath Studio.', 'start': 11070.957, 'duration': 3.803}, {'end': 11084.686, 'text': 'UiPath Studio is a user-friendly interface that allows users to visually plan and design various automation process through diagrams using the drag and drop functionality.', 'start': 11075.479, 'duration': 9.207}], 'summary': 'Uipath is a tool for large-scale automation, offering uipath studio for visually planning and designing automation processes.', 'duration': 34.446, 'max_score': 11050.24, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE11050240.jpg'}, {'end': 11299.116, 'src': 'embed', 'start': 11272.507, 'weight': 5, 'content': [{'end': 11276.89, 'text': 'They work on the same workstation as a human user and is triggered by user events.', 'start': 11272.507, 'duration': 4.383}, {'end': 11285.857, 'text': 'Unattended robots Unattended robots are those that do not require human supervision to perform tasks.', 'start': 11278.992, 'duration': 6.865}, {'end': 11291.801, 'text': 'They run in virtual environments without human control and can automate any number of processes.', 'start': 11286.477, 'duration': 5.324}, {'end': 11299.116, 'text': 'What are the features of UiPath? Drag and drop workflow.', 'start': 11295.324, 'duration': 3.792}], 'summary': 'Uipath features include unattended robots operated in virtual environments and capable of automating numerous processes with drag and drop workflow.', 'duration': 26.609, 'max_score': 11272.507, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE11272507.jpg'}, {'end': 11345.375, 'src': 'embed', 'start': 11320.085, 'weight': 4, 'content': [{'end': 11325.408, 'text': 'The user can use this function to record actions and transform them into an automated process series.', 'start': 11320.085, 'duration': 5.323}, {'end': 11328.604, 'text': 'Inbuilt Activities in UiPath.', 'start': 11326.903, 'duration': 1.701}, {'end': 11337.03, 'text': 'UiPath comes with over 300 built-in activities covering a wide range of process automation and application integrated design tasks.', 'start': 11329.265, 'duration': 7.765}, {'end': 11345.375, 'text': 'You can find these activities in Activities pane, which covers most design tasks such as data extraction, data entry and automation.', 'start': 11337.83, 'duration': 7.545}], 'summary': 'Uipath offers over 300 built-in activities for process automation and application design tasks.', 'duration': 25.29, 'max_score': 11320.085, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE11320085.jpg'}, {'end': 11646.512, 'src': 'embed', 'start': 11609.679, 'weight': 6, 'content': [{'end': 11612.36, 'text': 'Explain the different types of automation in UiPath.', 'start': 11609.679, 'duration': 2.681}, {'end': 11621.018, 'text': 'Excel Automation Excel Automation is a useful tool for sorting, deleting, retrieving, and analyzing data.', 'start': 11613.456, 'duration': 7.562}, {'end': 11625.499, 'text': 'It is simple to migrate and integrate data into platforms.', 'start': 11621.678, 'duration': 3.821}, {'end': 11634.561, 'text': 'Studio X has a strong integration with Microsoft Excel and ships with several activities that automate Excel tasks.', 'start': 11626.639, 'duration': 7.922}, {'end': 11646.512, 'text': 'Mail automation enables task automation with emails from the Outlook desktop application Gmail and Outlook 365.', 'start': 11637.688, 'duration': 8.824}], 'summary': 'Uipath offers excel automation for data analysis and integration, and mail automation for task automation with outlook and gmail.', 'duration': 36.833, 'max_score': 11609.679, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE11609679.jpg'}], 'start': 10545.812, 'title': 'Rpa development and uipath automation', 'summary': "Provides an overview of rpa development, including roles, skills, growth projections, and salaries, with key data points such as the economic impact of rpa by 2025 and average salaries for various rpa roles. additionally, it highlights uipath's role in automating business processes, explaining its components and different automation workflows and features.", 'chapters': [{'end': 10916.274, 'start': 10545.812, 'title': 'Rpa developer: roles, skills, and salaries', 'summary': 'Provides an overview of rpa development, including roles, skills, growth projections, and salaries, with key data points such as the economic impact of rpa by 2025 and average salaries for various rpa roles in the us and india.', 'duration': 370.462, 'highlights': ['RPA growth projections indicate an economic impact of about 5-7 trillion US dollars by 2025, potentially affecting over 230 million knowledge workers. According to Nexon Day Research, knowledge and work automation could have an economic impact of about 5-7 trillion US dollars by the year 2025, potentially affecting over 230 million knowledge workers, constituting up to 9% of the global workforce.', 'Average RPA Developer salaries in the US range from 68,000 to 99,000 US dollars per annum, while in India, the average salary for an RPA Developer is around 5,98,000 rupees. In the US, an RPA developer earns around 76,000 US dollars per year, a senior consultant earns around 99,000 US dollars per year, an RPA process architect earns an average salary of 95,000 US dollars, and a senior RPA developer earns an average salary of 92,000 US dollars. In India, the average salary of an RPA Developer is around 5,98,000 rupees.', 'Key skills for RPA developers include strategic planning, strong analytical and problem-solving skills, experience in programming languages, RPA tools, and cognitive platforms, as well as communication and SQL exposure. Key skills for RPA developers include strategic planning, strong analytical and problem-solving skills, experience in programming languages such as C, C++, Python, Ruby, Java, or .NET, hands-on experience with RPA tools and cognitive platforms such as Blue Prism, Automation Anywhere, UiPath, Open Spam, etc., as well as communication skills and exposure to SQL.']}, {'end': 11027.173, 'start': 10918.514, 'title': 'Rpa developer resume tips', 'summary': 'Provides guidance on creating an rpa developer resume, highlighting the importance of including general information, experience, educational background, technical and non-technical skills, and the caution against dishonesty.', 'duration': 108.659, 'highlights': ['Include general information, experience, educational background, technical and non-technical skills in the resume', 'Mention RPA tools and programming languages in technical skills section', 'Emphasize the importance of not lying on the resume', 'Provide LinkedIn profile link and GitHub link in the resume', 'Mention university, degree in computer science, and GPA in educational background']}, {'end': 11171.86, 'start': 11027.633, 'title': 'Uipath: rpa tool & interview questions', 'summary': 'Highlights the role of uipath in automating business processes, explaining its components such as studio, robot, and orchestrator, and the different workflows like sequences and flowcharts.', 'duration': 144.227, 'highlights': ['UiPath is a robotic process automation tool for large-scale end-to-end automation, providing solutions for automating routine office activities. UiPath serves as a tool for large-scale end-to-end automation, which aids in automating routine office activities, accelerating business change.', 'UiPath consists of three main components: UiPath Studio, UiPath Robot, and UiPath Orchestrator. The three main components of UiPath are Studio, Robot, and Orchestrator, each serving specific functions in the automation process.', 'UiPath Studio allows users to visually plan and design various automation processes through diagrams using the drag and drop functionality. UiPath Studio provides a user-friendly interface for visually planning and designing automation processes through diagrams using drag and drop functionality.', 'UiPath Robots are used to translate strategies into tasks that are then executed, assigning various tasks and carrying them out automatically. UiPath Robots play a crucial role in translating strategies into tasks, which are then executed automatically, mimicking human tasks without human interference.', 'UiPath Orchestrator is a web-based application with features for deploying, monitoring, scheduling, and controlling automated bots and processes. The UiPath Orchestrator, as a web-based application, facilitates deploying, monitoring, scheduling, and controlling automated bots and processes.']}, {'end': 11574.882, 'start': 11173.481, 'title': 'Uipath robot and automation', 'summary': 'Provides an overview of uipath robot and its components, including the difference between attended and unattended robots, features of uipath, different recording options, managed packages, and the process of publishing a project in uipath studio.', 'duration': 401.401, 'highlights': ['UiPath offers over 300 built-in activities for process automation and application integration. UiPath comes with over 300 built-in activities covering a wide range of process automation and application integrated design tasks.', 'Unattended robots in UiPath can automate tasks in virtual environments without human control. Unattended robots are those that do not require human supervision to perform tasks. They run in virtual environments without human control and can automate any number of processes.', 'The process of publishing a project in UiPath involves creating a new project, clicking on the publish option, selecting the location, and receiving a notification once the project is successfully published. To publish a project in UiPath, first create a new project. Then in the design ribbon tab, click publish. The publish window will open. In the package properties tab, enter the name for package, then click next. In the publish options tab, select the location where you want to publish your project. And finally, the information dialog box displays.']}, {'end': 11765.144, 'start': 11578.802, 'title': 'Uipath automation and data scraping', 'summary': 'Explains data scraping and screen scraping, different types of automation in uipath including excel, mail, word, powerpoint, file, and csv automation, with specific details such as the integration with microsoft excel, activities for mail automation, and various read and write activities for excel and csv.', 'duration': 186.342, 'highlights': ['The chapter explains the different types of automation in UiPath, including Excel, Mail, Word, PowerPoint, File, and CSV automation, with specific details such as the integration with Microsoft Excel, activities for mail automation, and various read and write activities for Excel and CSV.', 'Studio X has a strong integration with Microsoft Excel and ships with several activities that automate Excel tasks, such as sorting, deleting, retrieving, and analyzing data.', 'Mail automation enables task automation with emails from the Outlook desktop application Gmail and Outlook 365, with activities that use data from the account inside the resource activity after adding the account to the automation as a resource using a use Outlook 365, Gmail, or desktop Outlook app activity.', 'In CSV automation, add CSV activities inside the Use Excel File activity, where the Excel file is defined to move data between CSV and Excel, with specific read and write activities like Read range, Read cell, Read CSV, Write range, Write cell, and Write CSV.']}], 'duration': 1219.332, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE10545812.jpg', 'highlights': ['RPA growth projections indicate an economic impact of about 5-7 trillion US dollars by 2025, potentially affecting over 230 million knowledge workers.', 'Average RPA Developer salaries in the US range from 68,000 to 99,000 US dollars per annum, while in India, the average salary for an RPA Developer is around 5,98,000 rupees.', 'Key skills for RPA developers include strategic planning, strong analytical and problem-solving skills, experience in programming languages, RPA tools, and cognitive platforms, as well as communication and SQL exposure.', 'UiPath is a robotic process automation tool for large-scale end-to-end automation, providing solutions for automating routine office activities.', 'UiPath offers over 300 built-in activities for process automation and application integration.', 'Unattended robots in UiPath can automate tasks in virtual environments without human control.', 'The chapter explains the different types of automation in UiPath, including Excel, Mail, Word, PowerPoint, File, and CSV automation, with specific details such as the integration with Microsoft Excel, activities for mail automation, and various read and write activities for Excel and CSV.']}, {'end': 13939.811, 'segs': [{'end': 11887.596, 'src': 'embed', 'start': 11770.789, 'weight': 0, 'content': [{'end': 11780.278, 'text': 'What is an Excel application scope? Excel application scope opens an Excel workbook and sets the scope for Excel activities.', 'start': 11770.789, 'duration': 9.489}, {'end': 11786.524, 'text': 'When this activity is completed, the specified workbook and Excel application are closed.', 'start': 11781.199, 'duration': 5.325}, {'end': 11799.306, 'text': 'What is an orchestrator? UiPath Orchestrator is a web application that orchestrates the execution of repetitive process.', 'start': 11790.822, 'duration': 8.484}, {'end': 11806.89, 'text': 'It manages the creation, monitoring, scheduling and controlling of bots and process.', 'start': 11802.507, 'duration': 4.383}, {'end': 11810.891, 'text': 'It can manage the entire robot fleet.', 'start': 11808.09, 'duration': 2.801}, {'end': 11816.514, 'text': 'Name some orchestrator capabilities.', 'start': 11814.593, 'duration': 1.921}, {'end': 11823.985, 'text': 'Provisioning Provisioning establishes and maintains the connection between the robots and the web application.', 'start': 11818.015, 'duration': 5.97}, {'end': 11830.746, 'text': 'Deployment ensures that it delivers the correct package versions to the assigned robots for execution.', 'start': 11824.885, 'duration': 5.861}, {'end': 11838.008, 'text': 'Configuration looks after the maintenance and delivery of robot environments and process configuration.', 'start': 11831.807, 'duration': 6.201}, {'end': 11844.049, 'text': 'Queues Queues ensures that it automatically distributes the workload across robots.', 'start': 11838.968, 'duration': 5.081}, {'end': 11850.912, 'text': 'Monitoring manages user permissions and keeps track of robot recognition details.', 'start': 11845.149, 'duration': 5.763}, {'end': 11856.235, 'text': 'Logging Logs are stored and indexed in an SQL database.', 'start': 11851.993, 'duration': 4.242}, {'end': 11862.618, 'text': 'Explain process, job, asset and queue.', 'start': 11859.756, 'duration': 2.862}, {'end': 11870.451, 'text': 'The process page allows you to build a new process from uploaded packages,', 'start': 11865.33, 'duration': 5.121}, {'end': 11876.033, 'text': 'managing existing process and keep all of your process up to date with the latest package version.', 'start': 11870.451, 'duration': 5.582}, {'end': 11882.815, 'text': 'Jobs On an UiPath robot, a job represents the execution of procedure.', 'start': 11877.853, 'duration': 4.962}, {'end': 11887.596, 'text': 'It can start the execution of job in either attended or unattended mode.', 'start': 11883.255, 'duration': 4.341}], 'summary': 'Uipath features include excel application scope, orchestrator capabilities like provisioning, deployment, configuration, queues, monitoring, and logging. it also explains process, job, asset, and queue.', 'duration': 116.807, 'max_score': 11770.789, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE11770789.jpg'}, {'end': 11949.758, 'src': 'embed', 'start': 11915.299, 'weight': 5, 'content': [{'end': 11919.382, 'text': 'They allow you to store unique information that the robots can easily access.', 'start': 11915.299, 'duration': 4.083}, {'end': 11929.829, 'text': 'How to connect a robot to the orchestrator? Step 1 open UiPath assistant.', 'start': 11923.665, 'duration': 6.164}, {'end': 11933.151, 'text': 'Step 2 sign in the UiPath orchestrator.', 'start': 11930.709, 'duration': 2.442}, {'end': 11936.813, 'text': 'Step 3 create a tenant.', 'start': 11935.252, 'duration': 1.561}, {'end': 11940.936, 'text': 'Step 4 connect the robot to the orchestrator.', 'start': 11938.194, 'duration': 2.742}, {'end': 11943.918, 'text': 'And Step 5 check the status.', 'start': 11941.736, 'duration': 2.182}, {'end': 11946.616, 'text': 'It shows connected and licensed.', 'start': 11944.875, 'duration': 1.741}, {'end': 11949.758, 'text': "So let's see a demo of how to do this.", 'start': 11947.517, 'duration': 2.241}], 'summary': 'Uipath allows easy access to unique info. connect robot to orchestrator in 5 steps, showing connected and licensed status.', 'duration': 34.459, 'max_score': 11915.299, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE11915299.jpg'}, {'end': 12178.757, 'src': 'embed', 'start': 12110.429, 'weight': 6, 'content': [{'end': 12113.27, 'text': "So, let's go to the orchestrator.", 'start': 12110.429, 'duration': 2.841}, {'end': 12124.611, 'text': 'Here you can see this is the tenant context.', 'start': 12122.469, 'duration': 2.142}, {'end': 12132.476, 'text': 'To view and control the tenant level entities in the orchestrator, you can pick the tenant from the sidebar menu.', 'start': 12127.313, 'duration': 5.163}, {'end': 12136.699, 'text': 'From the sidebar menu, pick any available folder.', 'start': 12134.238, 'duration': 2.461}, {'end': 12137.86, 'text': 'So these are the folders.', 'start': 12136.819, 'duration': 1.041}, {'end': 12142.764, 'text': 'Pick any available folder to view and control the entities within that folder.', 'start': 12138.381, 'duration': 4.383}, {'end': 12145.586, 'text': 'So this is with respect to the folder context.', 'start': 12143.304, 'duration': 2.282}, {'end': 12157.034, 'text': 'What is an RE framework? The Robotic Enterprise Framework is a state machine based project template.', 'start': 12148.708, 'duration': 8.326}, {'end': 12162.577, 'text': 'It allows to handle even the most complex business situations.', 'start': 12159.296, 'duration': 3.281}, {'end': 12172.262, 'text': "It's designed to incorporate all of the industry's best practices for logging, exception management, application initialization and other areas.", 'start': 12163.278, 'duration': 8.984}, {'end': 12178.757, 'text': 'What are the features of RE Framework? Settings.', 'start': 12173.703, 'duration': 5.054}], 'summary': 'The orchestrator allows control of tenant level entities. re framework handles complex business situations and incorporates industry best practices.', 'duration': 68.328, 'max_score': 12110.429, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE12110429.jpg'}, {'end': 12282.575, 'src': 'embed', 'start': 12249.716, 'weight': 8, 'content': [{'end': 12258.663, 'text': 'After creating a sequence, we need a few activities like read CSV activity, assign activity data table activity and write CS file activity.', 'start': 12249.716, 'duration': 8.947}, {'end': 12262.305, 'text': "So we'll drag and drop all these activities and do the process.", 'start': 12259.343, 'duration': 2.962}, {'end': 12265.788, 'text': "Then we'll run the sequence and see the output.", 'start': 12262.966, 'duration': 2.822}, {'end': 12270.852, 'text': "So let's jump into the UiPath Studio and start with the workflow.", 'start': 12266.549, 'duration': 4.303}, {'end': 12280.053, 'text': 'So we are in the UiPath Studio.', 'start': 12278.211, 'duration': 1.842}, {'end': 12282.575, 'text': 'I have already created a sequence.', 'start': 12281.154, 'duration': 1.421}], 'summary': 'In uipath studio, create sequence, perform activities like read csv, assign data table, and write csv, then run the sequence.', 'duration': 32.859, 'max_score': 12249.716, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE12249716.jpg'}, {'end': 12716.014, 'src': 'embed', 'start': 12686.293, 'weight': 9, 'content': [{'end': 12694.697, 'text': 'after you have created a file, drag and drop, get password activity, then drag and drop a smtp mail message activity.', 'start': 12686.293, 'duration': 8.404}, {'end': 12699.1, 'text': 'so basically, these two activities are used to send a file over mail.', 'start': 12694.697, 'duration': 4.403}, {'end': 12700.965, 'text': 'then run the sequence.', 'start': 12699.844, 'duration': 1.121}, {'end': 12704.507, 'text': "So we'll jump into the UiPath Studio and see.", 'start': 12701.705, 'duration': 2.802}, {'end': 12713.032, 'text': 'So this was the previous question which we answered how to merge to excel files.', 'start': 12708.189, 'duration': 4.843}, {'end': 12716.014, 'text': 'So the same file we will send it over a mail.', 'start': 12713.573, 'duration': 2.441}], 'summary': "Use 'drag and drop' to send a file via 'smtp mail message activity' in uipath studio.", 'duration': 29.721, 'max_score': 12686.293, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE12686293.jpg'}, {'end': 13057.1, 'src': 'embed', 'start': 13027.686, 'weight': 10, 'content': [{'end': 13033.072, 'text': 'If a transaction item has been processed, the process moves on to the next transaction item available.', 'start': 13027.686, 'duration': 5.386}, {'end': 13036.836, 'text': 'End process state.', 'start': 13035.935, 'duration': 0.901}, {'end': 13043.543, 'text': 'The procedure is completed and the applications open during automations are closed in the end process state.', 'start': 13037.797, 'duration': 5.746}, {'end': 13052.218, 'text': "Let's jump into the UiPath Studio and see the different transitions in robotic enterprise framework.", 'start': 13044.838, 'duration': 7.38}, {'end': 13057.1, 'text': 'So this is the robotic enterprise framework.', 'start': 13054.898, 'duration': 2.202}], 'summary': 'Robotic enterprise framework transitions and process completion in uipath studio.', 'duration': 29.414, 'max_score': 13027.686, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE13027686.jpg'}, {'end': 13245.335, 'src': 'embed', 'start': 13175.397, 'weight': 4, 'content': [{'end': 13183.92, 'text': 'You can create and modify Google Calendar events, manage Google Drive files, read and send Gmail messages and create new Google Sheets,', 'start': 13175.397, 'duration': 8.523}, {'end': 13187.721, 'text': 'Spreadsheets and Google Documents with the Google G Suite Activity package.', 'start': 13183.92, 'duration': 3.801}, {'end': 13199.685, 'text': 'What are selectors and wildcards in UiPath? Wildcards are the symbols that enable you to replace zero or multiple characters in a string.', 'start': 13190.558, 'duration': 9.127}, {'end': 13204.448, 'text': 'This can be quite useful when dealing with dynamically changing attributes in a selector.', 'start': 13200.025, 'duration': 4.423}, {'end': 13210.283, 'text': 'Selectors UiPath Studio uses what we call selectors.', 'start': 13206.641, 'duration': 3.642}, {'end': 13217.988, 'text': 'They store the attributes of graphical user interface element and its parents in the shape of an XML fragment.', 'start': 13210.664, 'duration': 7.324}, {'end': 13222.712, 'text': 'The selector aids in the automatic generation of the selection by utilizing wildcards.', 'start': 13218.269, 'duration': 4.443}, {'end': 13229.516, 'text': 'What is a machine? Explain standard machine and machine template.', 'start': 13225.974, 'duration': 3.542}, {'end': 13237.368, 'text': 'The machine page allows you to provision and manages machines to use them to register robots with orchestrator.', 'start': 13231.423, 'duration': 5.945}, {'end': 13241.251, 'text': 'It displays the types of machine that we currently in use.', 'start': 13238.289, 'duration': 2.962}, {'end': 13245.335, 'text': 'It enables you to design your machine by the standard or template.', 'start': 13241.772, 'duration': 3.563}], 'summary': 'Google g suite activity package enables managing events, files, and messages. uipath uses selectors with wildcards for dynamic attributes. machine page provisions and manages machines for robot registration.', 'duration': 69.938, 'max_score': 13175.397, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE13175397.jpg'}, {'end': 13325.097, 'src': 'embed', 'start': 13296.136, 'weight': 14, 'content': [{'end': 13303.942, 'text': 'such as waiting for a specific application to start or for some information to be processed before using it in the another activity.', 'start': 13296.136, 'duration': 7.806}, {'end': 13313.053, 'text': 'The DoActivity allows you to run a specific piece of automation while a condition is met.', 'start': 13307.691, 'duration': 5.362}, {'end': 13318.014, 'text': 'The project exits the loop when the specified condition is no longer completed.', 'start': 13314.093, 'duration': 3.921}, {'end': 13325.097, 'text': 'This activity can be used to iterate through all the array elements or execute a specific action multiple times.', 'start': 13318.414, 'duration': 6.683}], 'summary': 'Doactivity enables running automation based on conditions, including iterating through array elements and executing actions multiple times.', 'duration': 28.961, 'max_score': 13296.136, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE13296136.jpg'}, {'end': 13398.533, 'src': 'embed', 'start': 13370.818, 'weight': 15, 'content': [{'end': 13376.663, 'text': 'How to create chart in Excel? Step one, create a new sequence.', 'start': 13370.818, 'duration': 5.845}, {'end': 13383.306, 'text': 'Go to the UiPath Studio and create a new sequence and then drag and drop the following activities.', 'start': 13376.943, 'duration': 6.363}, {'end': 13391.21, 'text': 'To create a chart, we need to use Excel application scope, create table activity and bar chart and pie chart activity,', 'start': 13383.626, 'duration': 7.584}, {'end': 13393.651, 'text': 'depending on which type of charts you want to create.', 'start': 13391.21, 'duration': 2.441}, {'end': 13398.533, 'text': 'Then at last, after completing, then run the sequence.', 'start': 13395.732, 'duration': 2.801}], 'summary': 'Create excel chart using uipath studio with excel application scope, create table activity, and bar chart/pie chart activity.', 'duration': 27.715, 'max_score': 13370.818, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE13370818.jpg'}], 'start': 11770.789, 'title': 'Uipath orchestrator and automation functions', 'summary': 'Explains the functions of uipath orchestrator, including provisioning, deployment, configuration, queues, monitoring, and logging, and describes various automation processes related to excel, google workspace, and machine management in uipath, covering steps, features, and activities for effective automation.', 'chapters': [{'end': 11914.427, 'start': 11770.789, 'title': 'Uipath orchestrator and excel application scope', 'summary': 'Explains the functions of uipath orchestrator, including provisioning, deployment, configuration, queues, monitoring, and logging, and describes excel application scope and its role in opening and closing excel workbooks.', 'duration': 143.638, 'highlights': ['UiPath Orchestrator manages the creation, monitoring, scheduling, and controlling of bots and process. UiPath Orchestrator oversees the entire robot fleet, handling the creation, monitoring, scheduling, and control of bots and processes.', 'Queues automatically distribute the workload across robots. Queues ensure automatic workload distribution across robots, optimizing process efficiency.', 'Excel application scope opens an Excel workbook and sets the scope for Excel activities. Excel application scope is responsible for opening Excel workbooks and defining the scope for Excel activities.', 'Jobs on a UiPath robot represent the execution of procedures in either attended or unattended mode. In UiPath, jobs on robots execute procedures in attended or unattended mode, enhancing operational flexibility.', 'Assets are shared variables or credentials used across multiple automation projects. Assets in UiPath are shared variables or credentials that can be utilized across various automation projects, promoting reusability and consistency.']}, {'end': 12956.383, 'start': 11915.299, 'title': 'Connecting robots to uipath orchestrator', 'summary': 'Explains how to connect a robot to the uipath orchestrator, including steps to open uipath assistant, sign in to the orchestrator, create a tenant, connect the robot, and check the status, with additional information on tenant and folder contexts, the re framework features, and merging excel files.', 'duration': 1041.084, 'highlights': ['Steps to connect a robot to the UiPath Orchestrator The chapter outlines the steps to connect a robot to the UiPath Orchestrator, including opening UiPath Assistant, signing in to the Orchestrator, creating a tenant, connecting the robot, and checking the status.', 'Tenant and folder contexts in UiPath Orchestrator It explains the tenant context for viewing and controlling tenant-level entities and the folder context for managing entities within a data folder.', 'Features of the RE Framework The chapter details the features of the Robotic Enterprise Framework (RE Framework), including settings, logging, business exceptions, and application exceptions.', 'Merging Excel files using UiPath Studio It provides a detailed demonstration of merging two Excel files into a single file using UiPath Studio, including steps to create a sequence, use activities like read CSV, assign, data table, and write CSV, and run the sequence.', 'Sending a file over email using UiPath Studio The chapter demonstrates sending a file over email using UiPath Studio, involving the use of activities such as get password and SMTP mail message, along with attaching the file and running the sequence.']}, {'end': 13222.712, 'start': 12956.383, 'title': 'Uipath g suite activity & re framework', 'summary': 'Covers the re framework states and transitions, including the initialization, get transaction, process transaction, and end process states, with the uipath g suite activity package aiding in the automation of google workspace applications and an explanation of selectors and wildcards in uipath.', 'duration': 266.329, 'highlights': ['There are four key states in RE framework The RE framework comprises four key states: initial state, get transaction state, process transaction state, and end process state.', 'The UiPath G Suite Activity package automates Google Workspace applications The UiPath G Suite Activity package facilitates the automation of Google Workspace applications, including Google Calendar, Google Drive, Google Sheets, Gmail, and Google Docs, for tasks such as creating and modifying events, managing files, reading and sending messages, and creating spreadsheets and documents.', 'Selectors in UiPath utilize wildcards for automatic selection generation UiPath Studio employs selectors, which store the attributes of GUI elements in an XML format, utilizing wildcards for automatic selection generation to handle dynamically changing attributes.']}, {'end': 13939.811, 'start': 13225.974, 'title': 'Uipath: machines, activities, excel charts', 'summary': 'Covers creating and managing machines in uipath, explaining delay, do, if, and switch activities, and demonstrating the creation of excel charts and file uploads in uipath, emphasizing the usage of various uipath activities and excel package installations.', 'duration': 713.837, 'highlights': ['Creating and managing machines in UIPath The machine page allows you to provision and manage machines to register robots with orchestrator, enabling the design of machines by standard or template, facilitating the connection of robots to standard machines or machine templates.', 'Explanation of delay, do, if, and switch activities in UIPath The delay activity allows pausing automation for precise timing, the do activity runs automation while a condition is met, the if activity makes decisions based on variable values, and the switch activity categorizes data based on predefined cases.', 'Demonstration of creating Excel charts and file uploads in UIPath The process involves creating a new sequence in UIPath Studio, using Excel application scope, create table activity, bar chart, and pie chart activity to create charts, and G Suite application and upload file activity for file uploads, emphasizing the need for specific package installations.']}], 'duration': 2169.022, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/kg15yZiBGxE/pics/kg15yZiBGxE11770789.jpg', 'highlights': ['UiPath Orchestrator manages the creation, monitoring, scheduling, and controlling of bots and processes.', 'Queues automatically distribute the workload across robots, optimizing process efficiency.', 'Excel application scope opens an Excel workbook and sets the scope for Excel activities.', 'Jobs on a UiPath robot represent the execution of procedures in either attended or unattended mode.', 'Assets in UiPath are shared variables or credentials that can be utilized across various automation projects, promoting reusability and consistency.', 'Steps to connect a robot to the UiPath Orchestrator, including opening UiPath Assistant, signing in to the Orchestrator, creating a tenant, connecting the robot, and checking the status.', 'Tenant and folder contexts in UiPath Orchestrator for managing entities within a data folder.', 'Features of the Robotic Enterprise Framework (RE Framework) including settings, logging, business exceptions, and application exceptions.', 'Merging Excel files using UiPath Studio, including steps to create a sequence, use activities like read CSV, assign, data table, and write CSV, and run the sequence.', 'Sending a file over email using UiPath Studio, involving the use of activities such as get password and SMTP mail message, along with attaching the file and running the sequence.', 'The RE framework comprises four key states: initial state, get transaction state, process transaction state, and end process state.', 'The UiPath G Suite Activity package facilitates the automation of Google Workspace applications, including Google Calendar, Google Drive, Google Sheets, Gmail, and Google Docs.', 'UiPath Studio employs selectors, which store the attributes of GUI elements in an XML format, utilizing wildcards for automatic selection generation to handle dynamically changing attributes.', 'The machine page allows you to provision and manage machines to register robots with orchestrator, enabling the design of machines by standard or template, facilitating the connection of robots to standard machines or machine templates.', 'The delay activity allows pausing automation for precise timing, the do activity runs automation while a condition is met, the if activity makes decisions based on variable values, and the switch activity categorizes data based on predefined cases.', 'The process involves creating a new sequence in UIPath Studio, using Excel application scope, create table activity, bar chart, and pie chart activity to create charts, and G Suite application and upload file activity for file uploads, emphasizing the need for specific package installations.']}], 'highlights': ['UiPath is the leading RPA tool for large-scale automation.', 'RPA UI path is a highly growing and in-demand field with a focus on UiPath as a leading automation tool.', 'The course covers RPA concepts, real-time examples, tool comparison, installation tutorials, orchestrator, web and Excel automation, and developer salaries.', "McKinsey's research projects that knowledge and work automation could have a substantial economic impact of $5-7 trillion by 2025, affecting over 230 million knowledge workers.", 'RPA can lead to cost reduction of up to 65% for domestic businesses, as stated by NASSCOM.', 'RPA provides the capability to swiftly and easily automate business processes, facilitating digital transformation.', 'RPA offers a higher Return on Investment (ROI) by delivering positive returns within quarters rather than years.', 'RPA can lead to decreased average handling time, improving the customer experience and ensuring continuous business operations.', 'RPA adoption provides organizations with a visible Return on Investment (ROI), addressing the challenge of quantifying gains.', 'RPA has substantial growth projections with a potential economic impact of 5-7 trillion dollars by 2025, touching more than 230 million knowledge workers, constituting about 9% of the global workforce.', 'RPA vendors such as Blue Prism, Automation Anywhere, and UiPath offer free tiers, which helps lower the total cost of ownership and does not require rip and replace of existing infrastructures.', "RPA assists in data migration with accuracy, speed, and continuous updating of software, contributing to the growth of new jobs and not jeopardizing existing employees' jobs.", 'RPA in financial services automates invoice generation, payment tracking, order processing, and data entry, resulting in prompt payments and improved customer experience.', 'RPA optimizes HR service by automating onboarding paperwork, resume screening, attendance management, and talent acquisition, allowing more time for valuable tasks.', 'UiPath Orchestrator: web-based app for managing automated bots and processes', 'Comparison of RPA tools based on learning, with Blue Prism requiring programming knowledge, UiPath enabling visual automation process design, and Automation Anywhere offering drag and drop features for beginners', 'RPA bots are utilized in various industries such as banking, healthcare, and trading to automate tasks, improve productivity, and reduce operational costs', 'Comparison of RPA tools based on base technologies, with Blue Prism based on C-sharp, UiPath on Microsoft vendors, and Automation Anywhere on modern Java technologies', 'UiPath Studio: user-friendly interface for planning and designing automation processes', 'Demonstrates merging excel files with UiPath, offering flexibility and customization.', 'UiPath offers a community edition for developers and small teams, while the enterprise edition is further classified into three types.', 'UiPath was founded by Daniel Dines and Mariusz Styrka in 2005.', 'UiPath provides drag and drop functionalities to make it easy to use.', 'Demonstrates automating data extraction, processing, and email sending using UiPath Studio', 'UiPath Orchestrator is a web application for orchestrating repetitive business processes by UiPath robots.', 'The RE framework provides ready-to-use state containers for various tasks in automation scenarios, ensuring efficiency and covering almost all requirements.', 'The process of connecting UiPath robot with the Orchestrator is explained, detailing two methods of connection and the steps to create an unattended robot.', 'UiPath is compatible with HTML, AJAX, Java, Silverlight and PDF, enhancing the scope of automated tasks and actions.', 'Data entry from an Excel spreadsheet to website can be automated in UiPath, leading to increased efficiency.', 'Web automation in UiPath is not limited by browser characteristics or interface variations, ensuring consistent performance.', 'The demonstration showcases the data scraping functionality in UiPath, emphasizing its ability to extract specific data elements from a website.', 'RPA growth projections indicate an economic impact of about 5-7 trillion US dollars by 2025, potentially affecting over 230 million knowledge workers.', 'Average RPA Developer salaries in the US range from 68,000 to 99,000 US dollars per annum, while in India, the average salary for an RPA Developer is around 5,98,000 rupees.', 'UiPath is a robotic process automation tool for large-scale end-to-end automation, providing solutions for automating routine office activities.', 'UiPath offers over 300 built-in activities for process automation and application integration.', 'Unattended robots in UiPath can automate tasks in virtual environments without human control.', 'UiPath Orchestrator manages the creation, monitoring, scheduling, and controlling of bots and processes.', 'Queues automatically distribute the workload across robots, optimizing process efficiency.', 'Excel application scope opens an Excel workbook and sets the scope for Excel activities.', 'Jobs on a UiPath robot represent the execution of procedures in either attended or unattended mode.', 'Assets in UiPath are shared variables or credentials that can be utilized across various automation projects, promoting reusability and consistency.']}