About
Jonathon Silva is a Power Platform Expert, Trainer and Consultant at Pragmatic Works. He has a decade of experience as a high school teacher, which he leverages to design and deliver engaging and practical training courses. Jonathon is also a Microsoft Certified Trainer and a Lead Instructor and Train-the-Trainer for Microsoft in a Day events, such as Automation in a Day (Power Automate), App in a Day (Power Apps) and Dashboard in a Day (Power BI). He is also a Power Automate Specialist who creates and shares valuable content on blog and YouTube platforms, offering guidance and insights on how to build effective workflows, apps, reports, and SharePoint sites.Certifications
PL-300: Power BI Data Analyst Associate
Microsoft
PL-100: Power Platform App Maker Associate
Microsoft
Microsoft Certified Trainer
Microsoft
DP-900: Azure Data Fundamentals
Microsoft
PL-900: Power Platform Fundamentals
Microsoft
DA-100: Power BI Data Analyst Associate
Microsoft
PL-600: Power Platform Solution Architect Expert
Microsoft
PL-200: Power Platform Functional Consultant Associate
Microsoft
PL-400: Power Platform Developer Associate
Microsoft
PL-500: Power Automate RPA Developer Associate
Microsoft
Course
Advanced Power Automate
Having a deeper understanding of what is possible with Power Automate can expand the possible methods you use to automate simple and complex tasks. In this class you will learn how to go beyond the basics with Power Automate by learning how to build dynamic flows, create complex reoccurring flow and understand how Flow integrates with other products.
Course
App In A Snap: Culture Shoutout App
In this course, learn how to develop a Canvas App in Microsoft Teams from the ground up. The application you build will be used to allow internal employees of your organization to promote one another in a positive work-culture environment.
You will learn the fundamentals of app building from design, viewing data, creating data, updating data, and deleting data. The major building blocks of all canvas app development are covered and will give you great knowledge to build your own applications.
Course
Power Automate Beginner
Power Automate empowers citizen developers to craft and automate workflows in the cloud with ease. In this class, we'll dive into Power Automate's capabilities, showing you how to automate tasks and simplify your workflow. You'll learn to create flows, integrate Microsoft and third-party services, and use advanced features like process approvals. By the end, you'll confidently implement Power Automate to enhance efficiency and focus on high-value tasks. Join us to master Power Automate and transform your work processes with our expert-led course.
Course
Introduction to RPA with Power Automate Desktop
This course is designed to introduce you to Robotic Process Automation with Power Automate Desktop. You will learn how to use the desktop and web recorder within Power Automate Desktop (PAD) and some of the most common actions and options used within the application.
Course
Learn with the Nerds - Excel to Power BI (Recorded Live Event)
For decades, Excel has been the primary reporting tool of choice for businesses to develop data analytics solutions. While those skills are still important, learning Power BI opens you up to a more interactive and visually appealing experience by offering more powerful analytics and reporting features.
In this session, Jonathon Silva will teach you about some of the most advanced capabilities available in Excel, and how to bridge those skills into a new world within Microsoft Power BI where manual, complex, and arduous reports are a thing of the past. You’ll also learn how Excel and Power BI best work together and understand the migration path to take your existing Excel work into Power BI.
Prerequisites: (to follow along or review later)
✔️ Install Power BI Desktop (https://tinyurl.com/33rcb3rn)
✔️ Download student files: [Learn with the Nerds - Excel to Power BI](https://learning.pragmaticworkstraining.com/api/upload/get/abd7ff16-d98f-4754-b206-dde4b293d712.zip)
After you finish this course:
📄 If you have completed this class and would like a certificate, fill out this form - https://share.hsforms.com/1JYYgjCoITT-7M3O8SMRTjg8xue
- 0:00 - Intro
- 4:31- Session starts
- 22:31 - Power Query Explanation and Import Files from a Folder
- 41:15 - PowerPivot and the Data Model in Excel
- 49:15 - Power Query: Using Unpivot
- 58:16 - Power Query: Splitting Column by Delimiter and Fill Down
-
- Full Report Demo:
- 1:10:32 - Part 1: Data Cleansing in Power Query
- 1:54:48 - Part 2: Data Modeling
- 2:02:50 - Migrating from Excel to Power BI
- 2:09:35 - Part 3: Data Visualizations
- 2:29:27 - Part 4: Publishing a Power BI Report
-
- 2:36:03 - Using Analyze in Excel
- 2:50:15 - Adding Excel charts to a Power BI Dashboard and App
Course
Learn with the Nerds - Power Automate Beginner to Pro (Recorded Live Event)
Overview:
Power Automate is an automation tool designed for Citizen Developers to build and automate workflow processes in the cloud and/or on-premises. The ultimate goal of Power Automate is to give you back time. Time that you would have normally spent performing tedious tasks can now be automated, allowing you to focus more on strategic work that makes a bigger impact to your organization.
What You’ll Learn:
- Understanding Flow Triggers
- Creating Flows with Conditional Logic
- Designing Approval Flows
- Building RPA solutions with Power Automate Desktop
- Power Automate Administration
- 0:00 Intro
- 19:47 Using Power Automate Templates
- 35:20 Creating a Power Automate Flow from Scratch
- 56:24 Using the Condition Action in a Flow
- 1:12:04 Best Practice Using Trigger Conditions Instead
- 1:26:41 Pragmatic Works Training Offerings
- 1:31:04 Approval Flows
- 1:46:44 Power Automate Desktop Flows
- 2:12:55 Adding Variables to Desktop Flows
- 2:39:12 Running Desktop Flows Inside Cloud Flows
- 2:49:48 Using Solutions
Course
Learn with the Nerds - RPA with Power Automate Desktop (Recorded Live Event)
In this Learn With The Nerds webinar, you will learn how you can use Microsoft Power Automate Desktop to automate repetitive and mundane tasks. Follow along as Jonathon details some of the amazing capabilities of Robotic Process Automation (RPA), allowing you to build bots to record and automate your repetitive tasks in a user-friendly, drag-and-drop environment without any coding background. With its RPA actions, Power Automate Desktop is stocked full of actions that make desktop recording and web scraping accessible to business users of all backgrounds and skill sets.
Throughout the event, you will learn not only how to design a desktop flow from scratch by using the desktop recorder, but also how to build a fully functioning flow complete with variables, conditions, loops, and Excel automation. Join us to begin your journey toward becoming more productive with your time by optimizing your workflows and time-consuming tasks.
What You'll Learn:
- Designing a desktop flow from scratch
- Understanding variables
- Conditions and Loops
- Working with Excel
- Web Automation
To view this video, you will need to [create a free trial account](https://learning.pragmaticworkstraining.com/freeTrial?redirect=https://learning.pragmaticworkstraining.com/course/lwtn-rpa-with-power-automate).
Course
Modern Excel Analyst in a Day
The workshop aims to bring awareness of advanced capabilities available in Excel, to empower Modern Excel analysts to see what’s possible, to explore how Excel & Power BI are best used together and how Excel & Power BI can be integrated in Microsoft Teams & SharePoint Online.
Upon completion of this workshop attendees will:
- **Have Awareness** of Power Query & Power Pivot in Excel (Modern Excel)
- **Learn** how Power Query & Power Pivot in Excel can improve efficiency, provide reusable seamless solutions and transform existing manual reporting into actionable insights
- **Understand** how Modern Excel maps into Power BI Desktop
- ******Identify****** opportunities to use Excel & Power BI together
- **Integrate** Excel & Power BI solutions into Microsoft Teams & SharePoint
Course
Automation in a Day
Automation in a Day is a beginner-level training is designed for everyone to learn automation. No matter if you are a business expert or IT developer, you will learn to develop RPA-based automation in a single day using Desktop flows.
Automation in a Day consists of lab exercises that guide you through building a modern end to end business RPA scenario to process incoming invoices. To learn how you can successfully build automation for your business processes using Power Automate for your business’s automation needs.
At the end of the day, you will be able to:
- Use Power Automate capabilities such as Desktop flows and connectors to automate a business process
- Take advantage of form processing models developed in AI Builder
Course
PL-900: Microsoft Power Platform Fundamentals Review
Unlock the potential of the Microsoft Power Platform with our comprehensive course designed to prepare you for the PL-900 certification exam. This course covers the fundamentals of the Power Platform, including its core components and capabilities. You'll learn how to leverage the Power Apps, Power Automate, Power BI, and Copilot Studio to drive business value and improve productivity. This course will discuss real-world scenarios to ensure you have the skills and knowledge to pass the PL-900 exam and earn your Microsoft Power Platform Fundamentals certification.
Course
Power Automate Approvals
Unlock the full potential of Power Automate Approvals in this comprehensive course, designed to guide you from foundational setup to advanced workflows. You’ll learn how to integrate tools like SharePoint, Microsoft Teams, and Outlook to create dynamic, efficient approval processes tailored to your needs.
Course
Intergalactic Learn With The Nerds Day - Building Power Automate Approvals
Join Jonathon to learn how to streamline your approval processes using Power Automate. Discover how to create, manage, and track approvals efficiently, ensuring seamless workflows and enhanced productivity.
Course
Learn With The Nerds - Creating Autonomous Agents with Copilot Studio
Join Jonathon Silva for an in-depth session on building autonomous agents in Copilot Studio. Learn how to design agents that can make decisions, complete tasks, and adapt to dynamic scenarios with minimal human intervention. This session covers planning workflows, integrating AI capabilities, and connecting to external data sources to enhance your agents’ functionality. By the end, you’ll understand how to create powerful, self-operating solutions that can streamline processes, improve efficiency, and transform your approach to automation.
Course
Power Apps Galleries
Build beautiful, useful galleries in Power Apps that help people actually find what they need. In this course, Jonathon Silva shows you how to turn rows of data into clear, scrollable experiences with search, sort, and filters that feel fast and friendly. You’ll explore common gallery types and layouts, add images and icons, and use simple design choices—like spacing, typography, and color—to make your apps easy to skim on desktop or mobile.
Popular articles by Jonathon Silva
.jpg?width=385&height=200&name=Eans%20YouTube%20Thumbnails%20(4).jpg)
What our clients say
Popular on-demand courses
Pragmatic Works On-Demand Learning courses offer beginner to advanced classes taught by Microsoft MVPs and authors.
.svg)
Get our special offers directly to your email
.png?width=564&height=618&name=Vector%20(2).png)
-2.png?width=380&height=384&name=Vector%20(14)-2.png)