Explore digital courses

A data model workshop is part of Success by Design. This module will provide a basic description of data modeling for Microsoft Dynamics 365 and insight into how you can conduct a data model workshop.

Units in this learning path:

• 1 Introduction
• Overview
• 2 Workshops
• 2 1 Out of Box Custom Tables
• 2 2 Table Configuration
• 3 Check
• 4 Summary

Products: Dynamics 365, Dynamics Sales, Customer Insights Journeys, Dynamics Customer Service, Dynamics Field Service, Dynamics Finance, Dynamics Scm, Dynamics Project Operations, Dynamics Commerce, Dynamics Human Resources

Roles: Solution Architect, Functional Consultant

Level: Advanced

Subjects: Data Modeling, Business Applications

Duration: 61 minutes

Learn dimensional schema types, fact and dimension table design, and slowly changing dimension patterns for analytics workloads in Microsoft Fabric.

Units in this learning path:

• Introduction
• Describe Schema Types
• Design Fact Tables
• Design Dimension Tables
• Implement Slowly Changing Dimensions
• Exercise
• Knowledge Check
• Summary

Products: Fabric

Roles: Data Analyst, Data Engineer

Level: Intermediate

Subjects: Data Modeling

Duration: 63 minutes

Learn to design and deliver Power BI reports using a user-centered process that emphasizes actionable insights, visual appeal, and production-ready development aligned with stakeholder needs.

Modules in this learning path:

• Power Bi Effective Requirements
• Power Bi Effective Reports
• Power Bi Effective User Experience
• Perform Analytics Power Bi

Products: Power Bi

Roles: Data Analyst, Business Analyst

Level: Intermediate

Subjects: Data Visualization

Duration: 307 minutes

Good modeling practices lead to scalable semantic models that simplify analysis and reporting of large, complex data, enhancing Power BI reports for an optimal user experience.

Units in this learning path:

• Introduction
• Storage Modes
• Large Data
• Relationships
• Dax Optimizations
• Dynamic Elements
• Exercise
• Knowledge Check
• Summary

Products: Fabric, Power Bi

Roles: Data Analyst, Data Engineer

Level: Advanced

Subjects: Data Modeling

Duration: 69 minutes

Design semantic models for scale in Microsoft Fabric. Choose storage modes, design star schema relationships, create scalable calculation patterns, and configure settings for large datasets and concurrent consumption.

Units in this learning path:

• Introduction
• Storage Modes
• Relationships
• Dynamic Elements
• Enterprise Settings
• Exercise
• Knowledge Check
• Summary

Products: Fabric, Power Bi

Roles: Data Analyst, Data Engineer

Level: Intermediate

Subjects: Data Modeling

Duration: 65 minutes

Do you want to learn how to build the data model for a report in Microsoft Dynamics 365 Business Central? This module will discuss the different components of a report data model.

Units in this learning path:

• 1 Introduction
• 2 Create Report Data Items
• 3 Add Columns Report Dataset
• 4 Link Order Indent Data Items
• Use Query
• 5 Check
• 6 Summary

Products: Dynamics 365, Dynamics Business Central

Roles: Developer

Level: Intermediate

Subjects: Data Modeling

Duration: 48 minutes

This course will get you started on thinking serverless. It will introduce you to key Amazon Web Services (AWS) services and patterns that you will want to use to design event-driven architectures. In this course, you will learn about the concepts…

Learn how to develop AI solutions using Azure Cosmos DB for NoSQL, including vector search and query optimization for RAG pipelines and semantic retrieval.

Modules in this learning path:

• Build Query Azure Cosmos Db
• Implement Vector Search Azure Cosmos Db
• Optimize Query Performance Azure Cosmos Db

Products: Azure Cosmos Db

Roles: Developer

Level: Intermediate

Subjects: Databases, Artificial Intelligence

Duration: 252 minutes

Learn how to develop AI solutions using Azure Database for PostgreSQL, including vector search with pgvector for RAG pipelines and semantic retrieval.

Modules in this learning path:

• Build Query Azure Database Postgresql
• Implement Vector Search Azure Database Postgresql
• Optimize Vector Search Azure Database Postgresql

Products: Azure Database Postgresql

Roles: Developer

Level: Intermediate

Subjects: Databases, Artificial Intelligence

Duration: 294 minutes

Learn how GitHub Copilot and the PostgreSQL extension improve SQL development workflows in Visual Studio Code.

Units in this learning path:

• Introduction
• Understand Postgresql Extension
• Understand Github Copilot Integration
• Generate Refine Queries
• Exercise Enhance Postgresql Development Github Copilot
• Knowledge Check
• Summary

Products: Azure, Azure Database Postgresql

Roles: Developer, Data Engineer

Level: Intermediate

Subjects: Databases, Artificial Intelligence, Cloud Computing

Duration: 56 minutes

Learn how to create modern REST data API for Azure SQL Database. We'll delve into Data API Builder, a powerful cross-platform that simplifies the creation of endpoints for your Azure SQL Database. With features like automatic query generation, granular security controls, and seamless integration with other Azure services, the Data API Builder can effortlessly transform your database into a versatile API.

Units in this learning path:

• Introduction
• Use Data API Builder for Azure SQL Database
• Develop a Data API Using Static Web App
• Develop a Data API Using Azure Web Apps
• Exercise Develop Data API SQL Database
• Knowledge Check
• Summary

Products: Azure SQL Database, Azure

Roles: Developer, Solution Architect

Level: Intermediate

Subjects: Databases, Cloud Computing

Duration: 65 minutes

Learn how to develop data-driven applications by using Microsoft Azure SQL Database. DP-3020

Modules in this learning path:

• Get Started SQL Database Application Development
• Develop Azure SQL Database
• Develop Data API Azure SQL Database
• Explore Data Manipulation Azure SQL Database
• Explore Security Practices Azure SQL Database

Products: Azure SQL Database, Azure

Roles: Developer, Solution Architect

Level: Intermediate

Subjects: Databases, App Development, Artificial Intelligence

Duration: 355 minutes