Introduction
Part I. Building Line of Business Applications with PowerApps
1. Introduction to PowerApps
2. Building Your First PowerApp
3. Exploring PowerApps Screens and Controls
4. Working with PowerApps Expressions
5. Leveraging Variables and Collections
6. Securing and Sharing Apps
7. Managing Power Apps
8. Common Data Services and Model-Driven Apps
Part II. Task Automation with Microsoft Flow
9. Introduction to Power Automate
10. Building Your First Flow
11. Exploring Different Trigger Types
12. Working with Flow Expressions
13. Building Conditional Flows
14. Designing Approval Flows
15. Administering Power Automate
Part III. Dashboards, Reporting, and Analytics with Power BI
16. Introduction to Power BI
17. Connecting to Data
18. Defining Data Cleansing Business Rules with the Power Query Editor
19. Data Model Design
20. Extending Your Data Model with DAX Calculations
21. Report Writing Basics
22. Designing Interactive Reports
23. Data Storytelling with Power BI
24. Sharing Power BI Solutions
25. Administering Power BI
Part IV. Integrating the Power Platform Tools Together
26. Power Platform Integration in PowerApps
27. Power Platform Integration in Microsoft Flow
28. Power Platform Integration in Power BI
29. Designing a Fully Integrated Power Platform Solution
Mitchell Pearson is a business intelligence consultant and the training content manager for Pragmatic Works. He has authored books on SQL Server and Power BI, and spends his time at Pragmatic Works developing new courses on business intelligence and Microsoft Azure. He has experience developing enterprise-level BI solutions using the full suite of products offered by Microsoft (SSRS, SSIS, SSAS, Power BI, and Azure). He is active in the community, running the local Power BI user group, presenting at SQL Saturday events and at PASS virtual chapters, and in giving free webinars for Pragmatic Works.
Brian Knight is a Power Apps MVP, founder of Pragmatic Works, and co-founder of SQLServerCentral.com and JumpstartTV.com. He won the CEO of the year award given by the Jacksonville Business Journal, and Pragmatic Works has ranked up on the top growing companies in the country for many years in a row. He runs the local SQL Server usergroup in Jacksonville (JSSUG), is a contributing columnist for SQL Server Standard, maintains a regular column for the database website SQLServerCentral.com, and does regular webcasts at Jumpstart TV. He has co-authored and authored more than nine SQL Server books. He has spoken at conferences such as PASS, SQL Connections, and TechEd, and at many Code Camps.
Devin Knight is a Microsoft Data Platform MVP and Vice President of Training at Pragmatic Works. He is an author of eight SQL Server, Power Platform, and BI books. You can find him speaking at conferences such as the Microsoft Business Application Summit, PASS Summit, SQL Saturdays, and Code Camps. He is also a contributing member to several virtual user group chapters. Making his home in Jacksonville, FL, He contributes locally at the Jacksonville Power BI User Group.
Manuel Quintana is a training content manager at a Pragmatic Works. Previously, he was a senior manager working in the hotel industry. He joined the Pragmatic Works team in 2014 with no knowledge in the business intelligence space, but now speaks at SQL Saturdays and SQL Server user groups locally and virtually. He also teaches various BI technologies to many Fortune 500 companies on behalf of Pragmatic Works. Since 2014, he has called Jacksonville, Florida home, and before that Orlando, but he was born on the island of Puerto Rico and loves to go back and visit his family. When he is not working on creating new content for Pragmatic Works, you can probably find him playing board games or watching competitive soccer matches.
