Students will learn,

• How to configure and set up a reporting and analytics environment that integrates with Dynamics 365 data
• Build custom reports
• Create stunning dashboards by integrating PowerBI with Dynamics 365
• Configure and deploy the AI features of Dynamics 365

Citizen developers and technical users, providing the skills required to create reports, custom visualizations and implement the AI features of Dynamics 365.

Students should have an existing working knowledge of Microsoft Dynamics 365. As a minimum, students should attend the prerequisite course Introduction to Microsoft Dynamics 365.

Module 1: Introduction
This module introduces the concept of building an analytics environment for Microsoft Dynamics 365 and Power Apps. You will learn about the tools and resources that are available as well as best practice methodologies and fundamentals.

Lessons

• Objectives
• Analytics Overview
• Tools and Possibilities
• SQL Reports
• Power BI
• Dynamics 365 Artificial Intelligence
• The Power Apps AI Builder

Module 2: Analytics Options
This module presents the various options available in Dynamics 365 and Power Apps for analyzing data.

Lessons

• Objectives
• SQL Reports and the Dataverse
• Connecting Power BI to the Dataverse
• Dynamics 365 AI - Sales Insights
• Dynamics 365 AI - Customer Service Insights
• The Power Apps AI Builder

Module 3: SQL Reports with Dataverse Data
In this module you will learn about the process to create custom reports, how to configure your reporting environment and how to use the different tools available for building custom SQL reports that connect to data in the Dataverse.

Lessons

• Objectives
• Introduction to custom Reporting
• The TDS Endpoint
• Setting up the environment
• Building custom Reports in SQL

Module 4: Power BI Reports and Dashboards
In this module you will learn how to connect Power BI to Dynamics 365, bring data in the Dataverse into a Power BI dataset, build custom Power BI reports and dashboards, and surface Power BI Dashboards inside Dynamics 365 Model-driven Apps.

Lessons

• Objectives
• Introduction to Power BI
• Connecting Power BI to the Dataverse
• Building a dataset in Power BI
• Creating Power BI Dashboards
• Sharing and surfacing Power BI Dashboards in Dynamics 365

Module 5: Dynamics 365 Artificial Intelligence
This module introduces you to the AI features of Dynamics 365. You will learn how to configure Customer Insights, Sales Insights and Customer Service Insights in Dynamics 365.

Lessons

• Objectives
• Introduction to Dynamics 365 Insights
• Configuring Customer Insights
• Configuring Sales Insights
• Configuring Customer Service Insights

Module 6: The AI Builder
This module introduces you to the AI Builder in Power Apps. You will learn how to configure the AI Builder by building AI Models that showcase practical implementation of Form processing, Object Detection, Prediction, Text Classification and Entity Extraction.

Lessons

• Objectives
• Introduction to the AI Builder
• Form Processing
• Object Detection
• Prediction
• Text Classification
• Entity Extraction