The Power Query course is designed to help you understand how Power Query can be used for self-service data extraction and manipulation. This is a hands on class that will start with the basics of Power Query, but take you all the way through what is possible when you write your own M queries from scratch. The goal is to show you how Power Query can be used to solve what would seem to be complicated data problems in the easiest possible way. You will also learn how queries you design can be shared with others in your organization.
Overview
COURSE DIFFICULTY
COURSE DURATION
3h 49m
Skills Learned
After completing this online training course, students will be able to:
Build interactive dashboards and reports in Power BI
Transform and prepare data for analysis
Publish and share reports through Power BI Service
Create automated workflows using Power Automate
Power Apps Developers, Power Automate Developers, BI Developers, Data Analysts
None
01. Intro to Power Platform for Teams
02. Power Apps For Teams (Create a Dataverse Instance)
03. Power Apps For Teams (Customize The App Part 1)
04. Module 02C: Power Apps For Teams (Customize The App Part 2)
05. Module 02D: Power Apps For Teams (Publishing and Sharing The App)
06. Module 03A: Power Automate For Teams (Create A Flow In Teams)
07. Module 03B: Power Automate For Teams (Create An Approval Flow In Teams)
08. Module 03C: Power Automate For Teams (Create An Approval Notification In Teams)
09. Power Virtual Agents For Teams (Create A Chatbot In Teams)
10. Power Virtual Agents For Teams (Personalize Greeting and Create Topics)
11. Power Virtual Agents For Teams (Integrate Flows Into Chatbots)
12. Power Virtual Agents For Teams (Publishing and Sharing Your Chatbot)
13. Power BI For Teams (Connect To Dataverse and Transform Data)
14. Power BI For Teams (Building Your Report In Teams)
15. Power BI For Teams (Using Your Report In Teams)
16. Power Platform For Teams Wrap Up
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Build interactive dashboards and reports in Power BI
Transform and prepare data for analysis
Publish and share reports through Power BI Service
Create automated workflows using Power Automate
WHO SHOULD ATTEND
Power Apps Developers, Power Automate Developers, BI Developers, Data Analysts
PREREQUISITES
None
COURSE OUTLINE
01. Intro to Power Platform for Teams
02. Power Apps For Teams (Create a Dataverse Instance)
03. Power Apps For Teams (Customize The App Part 1)
04. Module 02C: Power Apps For Teams (Customize The App Part 2)
05. Module 02D: Power Apps For Teams (Publishing and Sharing The App)
06. Module 03A: Power Automate For Teams (Create A Flow In Teams)
07. Module 03B: Power Automate For Teams (Create An Approval Flow In Teams)
08. Module 03C: Power Automate For Teams (Create An Approval Notification In Teams)
09. Power Virtual Agents For Teams (Create A Chatbot In Teams)
10. Power Virtual Agents For Teams (Personalize Greeting and Create Topics)
11. Power Virtual Agents For Teams (Integrate Flows Into Chatbots)
12. Power Virtual Agents For Teams (Publishing and Sharing Your Chatbot)
13. Power BI For Teams (Connect To Dataverse and Transform Data)
14. Power BI For Teams (Building Your Report In Teams)
15. Power BI For Teams (Using Your Report In Teams)
16. Power Platform For Teams Wrap Up
