Course Overview
In this course, students will learn Microsoft Power Platform by analysing data, building apps, automating processes, and integrating AI in the business. This course provides end-to-end business solutions.
Course Objectives
How to create an interactive report.
How to develop an automation flow.
How to develop the business app.
How to integrate modern AI into your daily work
Duration: 5 Days
Outlines
--Day 1
Module 1 Power BI
(9:00 AM- 12:00 PM)
Extract data from multiple sources in Power BI o Extract from CSV o Extract from Excel o Extract from JSON o Extract from Database o Extract from public website
Clean, Transform, and Load Data in Power BI o Transpose o Unpivot o Merge combine o Append combine o Split o Format
Lunch (12:00 PM-1:00 PM)
(1:00 PM- 5:00 PM)
Data Model in Power BI o Primary and foreign key columns o Relationship cardinality o Cross filtering
Calculations using DAX in Power BI
--Day 2
(9:00 AM- 12:00 PM)
Create Reports in Power BI
Create Dashboards in Power BI
Row Level Security
Perform Advanced Analytics in Power BI
Lunch (12:00 PM-1:00 PM)
Module 2 Power APP
(1:00 PM- 5:00 PM)
Getting Started with PowerApps canvas app
Branding and Media
Writing a Formula in Power App
--Day 3
(9:00 AM- 12:00 PM)
Dataverse
Develop Model-Driven App
Power Page to develop a website
Lunch (12 PM-1:00 PM)
Module 3 Power Automate
(1:00 PM- 5:00 PM)
Overview of Business process and flow create a cloud flow
Introduction to Microsoft Forms
Microsoft form to trigger the flow o Condition o Loops o Approval
--Day 4
(9:00 AM- 12:00 PM)
Introduction to desktop flow
A combination of cloud and desktop flow (project to do
Lunch (12 PM-1:00 PM)
AI integration in Power Automate (1:00 PM-5:00 PM) o Extract the feedback sentiment from Excel (project to do)
--Day 5
Module 4 AI Use Cases
(9:00 AM-12 PM)
Overview of Copilot generative AI
Integrate AI text analysis in Power BI and Power
Video indexer
Lunch (12 PM-1:00 PM)
More Advanced AI (1:00 PM-5:00 PM) o Extract info from documents (invoice, PO, Receipt) o Face info service from Image o Create a customized chatbot based on your data (project to do)
Q&A
Programme scope, delivery arrangements and suitability are confirmed during enquiry.