Prepare to revolutionize your data universe! Are you tired of battling against disruptive data silos that sabotage your organization’s natural flow? Have you grown weary of futile attempts to construct a data warehouse or lakehouse, realizing the colossal waste of time and energy? And let’s not forget those individuals lost in the labyrinth, desperately seeking access to the elusive data required for their crucial reports. Fear not, for salvation has arrived in the form of Microsoft Fabric! Microsoft Fabric is the veritable holy grail of analytics solutions, encompassing a breathtaking array of full-service capabilities. Behold the marvel of seamless data movement, awe-inspiring data lakes, and the sheer power of data engineering, integration, science, real-time analytics, and business intelligence all in one extraordinary package. Delve into the boundless possibilities of Power BI, Synapse, and Data Factory as you unlock the mysteries of this groundbreaking offering. Whether you’re a daring data engineer, a visionary scientist, a sharp-witted analyst, or even a wordsmith weaving reports, Microsoft Fabric unveils a world of limitless potential. Prepare to be mesmerized as we unravel the enigmatic wonders of OneLake, the crown jewel of Microsoft Fabric. Within this lake-centric architectural masterpiece, data professionals and the business elite unite, forging an unbreakable bond of collaboration on daring data projects. Get ready to transcend the ordinary and embrace the extraordinary. Microsoft Fabric awaits, ready to propel your organization into an exhilarating new era of data-driven success!
Overview
COURSE DIFFICULTY
COURSE DURATION
1h 1m
Skills Learned
After completing this online training course, students will be able to:
Create automated workflows using Power Automate
Automate desktop applications using RPA capabilities
Use variables and control actions for complex logic
Power Automate Developers, Excel Power Users, Business Analysts
None
01. Getting Started
02. Power Automate Desktop Overview
03. Building Your First Desktop Flow
04. Making Flows Dynamic with Variables (Flow Variables, Input and Output Variables)
05. Making Flows Dynamic with Variables (Using Set Variable)
06. Conditions and Looping Actions (Basic Conditions - IF and ELSE)
07. Conditions and Looping Actions (Basic Conditions - SWITCH and CASE)
08. Conditions and Looping Actions (Simple Loop and Loop Condition)
09. Conditions and Looping Actions (FOR EACH Loops)
10. Common Design Patterns (Working with Excel)
11. Common Design Patterns (Web Automation)
12. Common Design Patterns (Working with Files and Folders)
13. Common Design Patterns (Working with PDFs)
14. Flow Design Best Practices (UI Elements, Naming Conventions, and Comments)
15. Flow Design Best Practices (Subflows)
16. Troubleshooting (Breakpoints, Disabling Tasks, and Run from Action)
17. Troubleshooting (Wait and Message Box)
18. Running Desktop Flows in the Cloud (Machine Connection and Data Gateway)
19. Running Desktop Flows in the Cloud (Machine Connection - Intro to Cloud Flows)
20. Running Desktop Flows in the Cloud (Cloud Flow Design)
21. Running Desktop Flows in the Cloud (Cloud Flows and Desktop Flows Together)
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Create automated workflows using Power Automate
Automate desktop applications using RPA capabilities
Use variables and control actions for complex logic
WHO SHOULD ATTEND
Power Automate Developers, Excel Power Users, Business Analysts
PREREQUISITES
None
COURSE OUTLINE
01. Getting Started
02. Power Automate Desktop Overview
03. Building Your First Desktop Flow
04. Making Flows Dynamic with Variables (Flow Variables, Input and Output Variables)
05. Making Flows Dynamic with Variables (Using Set Variable)
06. Conditions and Looping Actions (Basic Conditions - IF and ELSE)
07. Conditions and Looping Actions (Basic Conditions - SWITCH and CASE)
08. Conditions and Looping Actions (Simple Loop and Loop Condition)
09. Conditions and Looping Actions (FOR EACH Loops)
10. Common Design Patterns (Working with Excel)
11. Common Design Patterns (Web Automation)
12. Common Design Patterns (Working with Files and Folders)
13. Common Design Patterns (Working with PDFs)
14. Flow Design Best Practices (UI Elements, Naming Conventions, and Comments)
15. Flow Design Best Practices (Subflows)
16. Troubleshooting (Breakpoints, Disabling Tasks, and Run from Action)
17. Troubleshooting (Wait and Message Box)
18. Running Desktop Flows in the Cloud (Machine Connection and Data Gateway)
19. Running Desktop Flows in the Cloud (Machine Connection - Intro to Cloud Flows)
20. Running Desktop Flows in the Cloud (Cloud Flow Design)
21. Running Desktop Flows in the Cloud (Cloud Flows and Desktop Flows Together)
