About Power Platform Course
Power Platform Course Content
Module1: Overview of Microsoft Power BI
- Power BI Tools
- Power BI Installation and Connecting to the Data
- Locale utilized in Curriculum
- Working with Query Editor
- Working with a data model and creating the visualization
Module2: Power BI Desktop
- Introduction to Workflow in the Power BI Desktop
- Different Views of the data model
- Exploring the Query Editor Interface
- Required the Power BI Settings
Module3: Query Editor
- Introduction to Query Editor
- About Attached Data
- Connecting to the Power BI Desktop to the Data
- Appending Queries and Editing Rows
- Replacing Values and Editing Columns
- Pivoting and Unpivoting Data
- Formatting Data
- Creating a new group for queries
- Star Schema
- Referencing and Duplicating Queries
- Entering the Data Manually
- Merging the Queries
- Extracting Information and Duplicating Columns
- Creating the Conditional Columns
- Performing the fundamental Mathematical Operations
- Loading the Data and Improving the Performance in the Data Model
Module4: Data and Relationship Views
- Data Model & Query Editor
- Overview of Relationships
- Editing the Relationships
- Cardinality
- Many-to-Many Relationship & Cross Filter Section
- Active Properties
- DAX & M-Language
- DAX, Measures, and Calculated Fields
- Data Categorization
- DAX will include the complex functions like SUM, SUMX, ALL EXCEPT, RELATED, CONCATENATE, LOOKUPVALUE, DATEADD, IF, DIVIDE, SEARCH, etc.
- Categorizing the Data
Module5: Working in Report View for Visualizing the Results
- Creating the Visuals
- Report View Interface
- Adding the tooltips and markings/interactions
- Drill-Down & Hierarchies
- Formatting Sorting & Charts
- Data Color
- Overview of Slicers
- Tables & Treemaps
- Multi-row cards
- Types of Filters
- Combined waterfalls & visuals
Module6: Power BI Mobile & Power BI Service
- Importance of Power BI Service
- Comparing Power BI Premium & Free
- Logging into the Power BI Service
- Introduction to Interface
- Importing the data from the Desktop to the service
- Working on the Reports
- Dataset Menu
- Introduction to Dashboards
- Gateways & Workspace
- Gateways Installation - Personal & On-site
- Working alone and Collaborating with the Colleagues
- Collaborating in the App Workspace
- Publishing the Application
- Sharing the Results
- Content Packs from the online services
- Overview of Power BI Mobile
- Excluding the dataset from the sharing
Module7: Other Data Sources
- JSON Data
- Importing the Data from the remaining APIs
- Configuring the SQL Server
- Importing the Data from the SQL Server
Module1: Introduction to Power Apps
- Overview of Power Apps
- Kinds of Power Apps
- Building Blocks of Power Apps
Module2: Overview of Power Apps
- Overview of Canvas App
- Building Blocks of Canvas App
- Overview of Canvas App Studio
Module3: Getting Started with the Power Apps
- Creating the App from Template
- Creating the Blank Canvas App
- Kinds of Screens in the Canvas App
- Reordering and Renaming Screen
- Properties of Canvas App Screen
Module4: Canvas Examples and Controls
- Different Kinds of Controls
- Selecting & Adding a Control
- Renaming the unique name of the control
- Reordering, Moving, and Resizing the Controls
- Modifying the label text or the button
- Configuring the Control from the toolbar
- Configuring the Control from the properties tab
- Configuring the Control from the formula bar
Module5: Controlling the Properties of Power Apps
- Properties of Various Controls
- Configuring and Adding the Controls in the Canvas
Module6: Notifications and Navigations
- Navigating functions and their Parameters
- Notifying Functions and their parameters
Module7: Connectors of Power Apps
- Explaining the Power Apps Connectors
- Different Kinds of Connectors in Power Apps
- Using the MS Excel as the data source
Module8: SharePoint Online
- Creating the SharePoint List and Size
- Using the SharePoint as the data source in Power Apps
Module9: Gallery, Form, Date Table
- What are Data Table, Form, and Gallery
- Difference between Data Table & Gallery
- Different Kinds of Galleries in Canvas
- Customizing the gallery controls and forms
Module10: Sorting & Searching
- Search Functions & its parameters
- Implementing the Search Functions
- Sorting Functions & its Parameters
Module11: Customizing the SharePoint form through Power Apps
- Customizing the SharePoint form through Power Apps
- Publishing and Saving the list form back to our SharePoint
- Viewing the list form in SharePoint
Module12: Logical Condition in Power Apps
- If - Else Condition & Its Implementation
- Implementation of “Nested If - Else”
- Implementing Switch Conditions
- Examples
- Modifications to the Data as per user inputs
- Hide and show controls as per user inputs
Module13: Power Apps Variables
- Power Apps Variables
- Different types of Variables in Power Apps
- Scope of PowerApps Variables
- Applications of PowerApps Variables
- Creating the Dynamic Sort
Module14: Advance Formulas of Power Apps
- Creating the Custom Forms and Utilising the path function to submit the data
- Utilizing the UpdateIf function for updating the record
- Filter and Lookup Function in PowerApps
- Differentiating Lookup, Search, and Filter
- Cascading the Dropdowns
Module15: Collections in Power Apps
- Define Collection
- Creating a Collection
- Differences between Clear Collect & Collect
- Application of the Collection
Module16: Components of Power Apps
- Power Apps Components
- Creating the Components
- Applications of Components
Module17: Custom Alerts & Popups in Power Apps
- Creating Popups and Custom Alerts
Module18: Versioning
- Define Versioning
- Restoring a Version
Module19: Sharing the Power Apps
Module20: Export or Import Power Apps
Module 21: Overview of Dataverse
- Introduction to Microsoft Dataverse
- Different types of Tables in Dataverse
- Creating the Table in Dataverse
- Forms and Views in Dataverse
- Relationships in Dataverse
- Dashboards and Charts
Module22: Overview of Model-Driven Power Apps
- Model-Driven Power Apps
- Site map and Mapping the Dataverse Table
- Creating the Views and Forms in Model-Driven Apps
- Business Roles in Model-Driven Apps
- Creating the Charts and Dashboards in Model-Driven Apps
Module23: Power Automate
- Introduction to Power Automate
- Kinds of Power Automate Flows
- Triggers and Actions
- Power Automate Connectors
- Sending the Email Notifications
- Conditions in Power Automate
- Approval Process in Power Automate
Module1: Overview of Power Automate
- Define Power Automate
- Introduction to Power Automate Flows and its different kinds
- Different Connectors in the Power Automate
- Power Platform Admin Center
Module2: Create Flows and Troubleshooting
- Creating Flow that automatically saves the email attachments
- Creating a Flow that sends the automatic reminders
- Moving the data continuously between the multiple systems through Flows
- Creating business process flows for automating the enterprise process
Module3: Power Automate Integration with the Office 365 Services
- Using Flows with Approvals
- Using the Flows with the Office 365 Outlook email
- Using Flows with the Sharepoint
- Using Flows with the MS Forms and MS Teams
Module4: Personal Automation through Power Automate Desktop
- Recording the Actions and Steps on desktop
- Working with the files stored in the local machine folder
- Extracting Data from websites and videos
- Robotic Process Automation in Microsoft Environment
Module5: AI Builder and Process Mining in the Power Automate
- Creating Custom Connectors
- Train a pre-built AI template for using
- Building and Training our personal AI bot in the Power Automate
- Process Mining in Power Automate