For Business & IT Professionals

Power Apps + Power Automate = Smart, AI-Powered Automation
The Future of No-Code Automation

Automation is no longer optional. As businesses embrace AI-driven efficiency, professionals who can build apps and automate workflows will lead the way. Whether in IT, operations, or strategy, mastering these no-code tools helps you remove inefficiencies, connect disconnected systems, and keep business processes on autopilot—without waiting on developers.

Tools You'll Learn

Application Development Tools

Power Apps

Automation Tools

Power Automate

In just 2 weeks, you'll be able to:

Build apps like a pro (without coding) – Create custom apps to solve real workplace problems.

Make your tools talk to each other – Connect Excel, SharePoint, Teams, and more—zero hassle.

Ditch the manual work – Automate approvals, data entry, and repetitive tasks effortlessly.

Fix slow processes for good – Speed up approvals, reporting, and workflows with automation.

Be the go-to automation expert – Save time, reduce errors, and make work actually flow.

In just 2 weeks, you'll be able to:

Build apps like a pro (without coding) – Create custom apps to solve real workplace problems.

Make your tools talk to each other – Connect Excel, SharePoint, Teams, and more—zero hassle.

Ditch the manual work – Automate approvals, data entry, and repetitive tasks effortlessly.

Fix slow processes for good – Speed up approvals, reporting, and workflows with automation.

Be the go-to automation expert – Save time, reduce errors, and make work actually flow.

Ideal For:

Citizen Developers

Building internal tools without coding

Finance & Operations

Streamlining invoice processing & expense approvals

IT & Automation Specialists

Creating apps & automating tasks with Power Automate

Sales & Customer Support

Automating follow-ups, CRM updates, and notifications

HR & Admin Teams

Automating approvals, leave requests, and onboarding

Quick brush-up with Excel

Excel is to BI what wireframing is to application development. Brush up your Excel skills with 60+ formulas, pivots, charts & dashboards to quickly build a POC with small data before investing your time in building complex BI reports with big datasets.

Advanced Calculation with DAX

Add analytical power to your Power BI model that is not available in the data as-is, using DAX. The goal of this section is to teach you basic to advance features of DAX, providing the knowledge to write formulas for common and advanced business scenarios.

Model-building with Power Pivot

Explore the most powerful tool to build data models, forecast estimates, perform what-if-analysis scenario etc. If you are yet to have the Power BI license, you would still be able to create powerful & blended reports and share it internally using Power Pivot.

Data warehousing using MS-SQL

Data for Power BI can come from many sources, but often the data is hosted in SQL Server. This section will teach you how to write accurate, effective, and robust T-SQL code- the right way and also understand the logic behind the same.

Architect Power BI Solution

This section will help you put together Excel, VBA, Power BI, DAX, Power Query and SQL to architect the best BI solution. You'll also learn to publish, securely share reports including row level permissions along with BI administrative tasks like setting up data gateways etc.

Visualization with Power BI

Getting started with Power BI is simple. Then, once you want to leverage its full potential, you need a different set of skills. Learn how to develop these skills, unlock more insights through better data analysis and visualization with this section.

M-Programming with Power Query

During this section, you'll learn how to perform advanced data transformations not available in the Query Editor. We will discuss how to leverage the embedded PowerBI programming language (M) to achieve this.

ETL with SSIS

Extract - Transform - Load. Extract Data from multiple data sources, transform it with SSIS inbuilt transformation options or use M-Programs with SSIS and, Load it to the Reporting Database or Data Warehouse for generating dynamic BI Reports.

Ad-hoc Automations using VBA

When company environment doesn't support Power Apps, it is tools like VBA which comes to rescue. This section will explore the power of VBA and help you automate processes or tasks which otherwise is not possible using Power BI tools.

A snapshot of what you'll be learning in 2-weeks.

Course Syllabus Overview

Power Apps

INTRODUCTION TO POWER APPS

Overview of Power Apps

What is Power Apps?
Benefits and use cases
Types of Power Apps: Canvas, Model-Driven, and Portal Apps

Getting Started

Setting up your Power Apps environment
Navigating the Power Apps interface

DATA INTEGRATION AND MANAGEMENT

Connecting to Data Sources

Introduction to connectors
Connecting to common data sources (SharePoint, Excel, SQL Server, etc.)

Managing Data

Understanding data tables and collections

BUILDING YOUR FIRST CANVAS APP

Basics of Canvas Apps

Understanding Canvas Apps
Creating a simple Canvas App
Adding screens and navigation
Creating simple app to view details from data source.
Using simple forms to display and edit data

ADVANCED CANVAS APP FEATURES

User Experience Design

Designing responsive layouts
Using themes and templates
Best practices for user interface design

Working with Controls

Using different types of controls like
Button
Text input
Drop down
Combo Box
Date picker
List box
Radio
Text label
Vertical gallery
Horizontal gallery
Flexible height gallery
Blank Vertical gallery
Blank Horizontal gallery
Blank Flexible height gallery
Data table
Horizontal container
Vertical container
Container
Image
Icons
Shapes
Working with control properties

Working with Variables

Global variables
Context variable
Collections

Using formulas for dynamic form management

Functions to be used in forms
SubmitForm
EditForm
Clear
ClearCollect
Collect
Filter
If
Navigate
NewForm
Notify
Patch
Refresh
Search
Set
Text
ThisItem
Value

Advanced Controls and Features

Working with media (images, videos)
Implementing charts and graphs
Using Power Automate for workflows

Understanding the Common Data Service (Dataverse)

Creating entities and relationships
Building a simple Model-Driven App

SECURITY AND ADMINISTRATION

Security in Power Apps

Understanding security roles and permissions

Implementing data security

App Management

Managing app versions
Publishing and sharing apps

BEST PRACTICES AND ADVANCED TOPICS

Performance Optimization
Tips for improving app performance
Debugging and troubleshooting techniques
Real-World Use Cases

REALTIME PROJECTS

Project 1: Employee Leave Request App
Project 2: Inventory Management App
Project 3: Customer Feedback App
Project 4: Project Management Dashboard
Project 5: Sales Order Processing App

Power Automate

INTRODUCTION TO POWER AUTOMATE

Overview of Power Automate

What is Power Automate?
Benefits and use cases
Types of flows: Cloud Flows, Desktop Flows, and Business Process Flows

Getting Started

Setting up your Power Automate environment
Navigating the Power Automate interface

CREATING YOUR FIRST FLOW

Basics of Flow Creation

Understanding triggers and actions
Creating a simple flow
Running and testing flows

Flow Templates

Using predefined templates
Customizing template flows
Best practices for using templates

WORKING WITH CONNECTORS

Introduction to Connectors

Understanding connectors and their roles
Connecting to common data sources (SharePoint, OneDrive, Outlook, etc.)

Advanced Data Integration

Using premium connectors
Connecting to SQL Server, Azure, and other advanced data sources

ADVANCED FLOW FEATURES

Conditions and Loops

Implementing conditional logic
Using loops for repetitive tasks

Approvals and Notifications

Creating approval workflows
Sending email and mobile notifications
Error Handling and Troubleshooting

Managing errors in flows

Debugging and troubleshooting techniques

DESKTOP FLOWS (RPA)

Introduction to Desktop Flows

Understanding Robotic Process Automation (RPA)
Setting up Power Automate Desktop

Building Desktop Flows

Recording desktop actions
Automating desktop applications

Advanced Desktop Flow Features

Using conditions and loops in desktop flows
Integrating with cloud flows

BUSINESS PROCESS FLOWS

Introduction to Business Process Flows

Understanding business process automation
Creating a simple business process flow

Customizing Business Process Flows

Defining stages and steps
Implementing business rules and logic

Advanced Business Process Flow Features

Using custom entities and fields
Integrating with Power Apps

PROJECTS

Power Automate Projects

Project 1: Automated Invoice Approval Workflow
Project 2: Employee Onboarding Automation
Project 3: Social Media Post Scheduler
Project 4: Customer Support Ticketing System
Project 5: Monthly Sales Report Automation

Desktop Flows (RPA)

Project 1: Automated Data Entry from Emails
Project 2: Invoice Processing and Archiving
Project 3: Automated Report Generation
Project 4: Customer Account Reconciliation
Project 5: Automated Data Migration

System Requirements

Power BI Desktop

Free & Downloadable from Microsoft Store App
Excel 2016 & above with PowerPivot

Available with Office 365 subscriptions that include desktop versions of Excel for Windows.
MS-SQL Server

https://www.microsoft.com/en-us/sql-server/sql-server-downloads

Kindly install Developer Edition as it is full-featured free edition, licensed for use as a development and test database in a non-production environment.
SQL Server Management Studio (SSMS)

Download and install SSMS from https://learn.microsoft.com/en-us/ssms/download-sql-server-management-studio-ssms
Power Automate & Power Apps

Power Apps
https://www.microsoft.com/en-us/power-platform/products/power-apps
Sign-up for free developer plan

Power Automate
https://www.microsoft.com/en-us/power-platform/products/power-automate
Sign-up for a free 30-day trial
Secondary Monitor (optional, but recommended)

Having a secondary monitor will greatly assist in following the pace of the trainer. It allows you to view instructions and your own workspace simultaneously, enhancing your learning experience.

Taught by Microsoft Certified Trainers

All our classes are live,
hands-on and with
real-trainers.

Power Apps & Power Automate Projects.

Real-time Projects (Practical Application)

Experience automation beyond theory. Work on real-world projects that help you design custom business apps, streamline workflows, and connect systems—ensuring you can implement automation solutions from day one.

Power Apps

Power Automate

Employee Leave Request App

Design a user-friendly app for employees to submit leave requests. Automate approval workflows, track balances, and integrate with SQL databases for real-time leave management.

Sales Order Management App

Build an interactive app for sales teams to create, update, and track orders. Integrate with SQL to retrieve customer data and Power Automate to generate invoices and email confirmations.

Helpdesk System

Develop a mobile-friendly app where customers can log support tickets. Use Power Automate to assign cases, send updates, and generate Power BI reports for service performance tracking.

Expense Reimbursement Tracker

Create an app for employees to submit expense claims with receipt uploads. Automate approval workflows, validate entries against company policies, and generate real-time reimbursement status updates.

Inventory & Asset Management App

Design a system to track inventory and company assets, with barcode scanning capabilities. Connect to a SQL database for real-time stock updates and automate notifications for low inventory levels.

Automated Report Distribution

Schedule and distribute Power BI reports to stakeholders via email or Microsoft Teams. Trigger updates based on data refresh cycles or predefined conditions.

Customer Onboarding Workflow

Streamline new customer onboarding by automating email confirmations, database entry creation in SQL, and document approvals through SharePoint integration.

Invoice Processing & Approval

Extract data from email attachments, validate invoice details against SQL records, and automate approval requests via Teams or Outlook.

Automated Data Entry & Sync

Integrate multiple data sources (Excel, SharePoint, SQL) to automate data entry and keep records synchronized across different systems.

Real-Time Alerts & Notifications

Set up automated alerts for critical business events, such as exceeding sales targets, system downtime, or low inventory, with notifications sent via Teams, email, or mobile push alerts.