• Introduction to Power BI

            1. Introduction to Power BI

            2. Downloading Power BI

• Setting up Power BI Environment

            1. Adjusting Settings

            2. Introducing Power BI Desktop

•  Power BI Front-End vs. Back-End

             1. Types of Data Connectors

             2. The Power Query Editor

•  Connecting to Data Sources

              1. Connecting to a Database

              2.  Data QA & Profiling Tools

              3. Text, Numerical, and Date Tools

• Data Modeling in Power BI

            1. Data Modeling 101

            2. Creating and Managing Table Relationships

            3. Star & Snowflake Schemas

• DAX and Calculated Fields

            1. Introduction to DAX Calculated Columns and Measures

            2. Using CALCULATE, ALL, and FILTER Functions

            3. Time Intelligence Patterns

• Creating Dashboards and Visualizations

            1. Building & Formatting Charts (Bar, Line, KPI)

            2. Table & Matrix Visuals

            3. Adding Bookmarks and Custom Navigation

• Advanced Power BI Features

           1. Anomaly Detection, Smart Narratives, and Q&A Visuals

• Introduction to Power Automate

           1. What is Power Automate?

           2. Environment Setup

• Understanding Flows

           1. Types of Flows

           2. Creating Your First Flow

• Flow Features and Components

           1. Dynamic Content

           2. Using Expressions

• Automated and Approval Flows

           1. Automated Cloud Flows

           2. Creating Approval Flows

• Advanced Tools and Features

           1. Connecting SharePoint Lists to Power Automate

           2. Setting Up Alerts and Notifications

• Advanced Automation

           1. HTTP Requests to SharePoint Lists

           2. Parsing Emails for Automation

           3. Using Custom Connectors for External Integrations 

• Introduction to Power Apps

           1. What is Power Apps?

           2. Setting Up the Environment

• Power Apps Fundamentals

           1. Actions and Navigation

           2. Using Variables

• Connecting and Managing Data

           1. Setting Up Data Sources

           2. Working with Galleries, View Forms, and Edit Forms

• Building User Interfaces

           1. Using Forms as Input UI

           2. Conditional Formatting and Validation

• Integration with Power Automate

           1. Running Power Automate Workflows from Power Apps

           2. Two-Way Communication between Power Apps and Power           Automate

• AI Builder Integration

           1. Using Prebuilt AI Models

           2. Creating Custom AI Models and Integrating with Power Apps

• Introduction to SharePoint 

           1. Overview of SharePoint Features

           2. Setting Up Your Environment

• Document Management

           1. Site Layout and Creating a Document Library

• Working with Pages and Lists

           1. SharePoint Lists: Creating Lists, Adding Columns, and Importing Data

           2. List Benefits: Public Records, Validation, Formatting, and Alerts

• User Management

          1. Managing Permissions and Access Levels

• AI Builder Integration

           1. Overview of AI Builder

           2. Using Prebuilt AI Models for Automation

           3. Creating Custom AI Models for Business Needs

           4. Integrating AI Models with Power Apps and Power Automate

• Connecting Power Platform Components

           1. Integrating Power BI, Power Automate, Power Apps, and SharePoint

• Data Sync and Automation

           1. Integrating Dataverse for Unified Data Storage and Management

           2. Syncing Data Using Power Automate and Excel Online

           3. Connecting REST APIs to Power Apps

           4. Using Dataverse for Data Integration

• Building End-to-End Solutions

           1. Building a Sample Application: Dog Walkers United

           2. Integrating Power Apps, SharePoint, and Power Automate for Full Functionality

• Introduction to SQL

           Overview of SQL and Its Uses

• SQL Fundamentals

           Writing Basic SQL Queries

• Advanced SQL Concepts

            Data Manipulation and Reporting

• Integration with Power Platform

          1. Integrating SQL with Power Apps

          2. Using SQL with Power Automate for Data Processing

• Power Platform Governance

           1. Best Practices for Governance and Compliance

           2. Administering the Power Platform Environment

• Security and Data Protection

            1. Role-Based Security in Power Apps

            2. Data Loss Prevention (DLP) Policies

            3. Application Lifecycle Management (ALM) for Power Platform