Learn Organizational Reporting service developer reference documentation
This article provides information for developers and requestors implementing the Microsoft Learn Organizational Reporting service. We also recommend checking out the Learn Organizational service best practices article, Release notes, and Frequently asked questions to support your development journey.
Data dictionary
Tenant-specific datasets
Tenant-specific data is provided by the Achievements, Certifications, Progress, and Users data sets.
Important
The userId in the tenant-specific data is the Learn profile user identifier, which is different than the Microsoft Entra ObjectId.
To get Progress records with displayName for users in your tenant:
- Join your own Microsoft Entra data
objectIdwith the tenant-specific Users datasetAADObjectId - Join the tenant-specific Users dataset
userIdto the ProgressuserId - Select your own Microsoft Entra data
displayNameand applicable progress data.
When you Download user details in Microsoft Entra admin center, the export will include displayName and other properties in CSV format.
Achievements
The Achievements dataset contains information about all the awards the users in this tenant have earned, typically as a result of completing modules and learning paths. Upon module completion, users will earn a badge and upon learning path completion, they'll earn a trophy.
User Achievements are shown on the live site by viewing a user's profile. (Example)
| tenantId | userId | awardReason | awardType | awardUid | SourceType | SourceUid | AwardedOn |
|---|---|---|---|---|---|---|---|
| {guid} | {guid} | badge.module.basic.completed | Badge | learn.intro-to-compute.badge | Module | learn.intro-to-compute | {datetimeoffset} |
| {guid} | {guid} | trophy.path.basic.completed | Trophy | learn.cloud-foundations.trophy | LearningPath | learn.cloud-foundations | {datetimeoffset} |
Applied Skills
The Applied Skills dataset contains information about all the Applied Skills the users in this tenant have earned, typically as a result of completing lab sessions. Upon successful lab session completion, users may earn a skill.
| tenantId | userId | appliedSkillsUid | labProfileName | examScoredDate |
|---|---|---|---|---|
| {guid} | {guid} | applied-skill.build-azure-ai-vision-solution | APL-3004: Build an Azure AI Vision solution | {datetime} |
| {guid} | {guid} | applied-skill.build-collaborative-apps-microsoft-teams | APL-4001: Build collaborative apps for Microsoft Teams | {datetime} |
Certifications
The Certifications dataset contains information about all the certifications the users in this tenant have earned that are still active or have expired in the last two years, as a result of completing one or more exams (as required for the certification).
| tenantID | userId | AwardType | TranscriptName | SourceUid | AwardedOn | CertificationStartDate | CertificationEndDate | StayCurrentEligibilityStartDate |
|---|---|---|---|---|---|---|---|---|
| {guid} | {guid} | Certification | Microsoft Certified: Azure AI Engineer Associate | certification.azure-ai-engineer | {int} | {int} | {int} | {int} |
| {guid} | {guid} | Certification | Microsoft Certified: Power Platform Fundamentals | certification.power-platform-fundamentals | {int} | {int} | {int} | {int} |
Date {int} values are formatted as YYYYMMDD.
Progress
The Progress dataset contains information about how many XP points the users in this tenant have earned from completing pieces of content (such as individual units, full modules, and learning paths). Not all content is equal, so users may earn more points if it contained interactivity, or if they completed a knowledge check 100% the first time.
| tenantId | userId | XPReason | SourceType | SourceUid | XP | AwardedOn |
|---|---|---|---|---|---|---|
| {guid} | {guid} | points.unit.basic.completed | Unit | learn.intro-to-compute.1-introduction | 100 | {datetimeoffset} |
| {guid} | {guid} | points.module.basic.completed | Module | learn.create-azure-account | 200 | {datetimeoffset} |
| {guid} | {guid} | points.path.basic.completed | LearningPath | learn.cloud-foundations | 2100 | {datetimeoffset} |
Users
The Users dataset contains information of all the users referenced in the other tenant-specific datasets. Notice this dataset doesn't contain any PII information. The userId is the Learn profile user identifier, which is different than the Microsoft Entra ObjectId (AADObjectId). When you're reporting, you'll need to join this data to your list of Microsoft Entra users in order to see a more holistic list of user information against the other data.
| tenantId | userId | AADObjectId | CreatedOn |
|---|---|---|---|
| {guid} | {guid} | {guid} | {datetime} |
Microsoft Learn datasets
Microsoft Learn data (not specific to an individual tenant) is provided by the HierarchyAppliedSkills, HierarchyCertification, HierarchyLearningPath, HierarchyLearningPathModule, HierarchyModule, and HierarchyUnit data sets.
HierarchyAppliedSkills
The HierarchyAppliedSkills dataset contains catalog information about all the Applied Skills in Microsoft Learn.
To learn more about Applied Skills and how they relate to other content types, view the Applied Skills section in the Learn content types article.
| appliedSkillsUid | title | url | levels | products | roles | subjects | tasks |
|---|---|---|---|---|---|---|---|
| applied-skill.build-azure-ai-vision-solution | Build an Azure AI Vision solution | /credentials/applied-skills/build-azure-ai-vision-solution/ | ["intermediate"] | ["azure-computer-vision"] | ["developer","ai-engineer","maker"] | ["artificial-intelligence"] | ["Create a computer vision resource","Analyze images","Create a custom image analysis model","Train and evaluate the model","Consume a custom model"] |
| applied-skill.build-collaborative-apps-microsoft-teams | Build collaborative apps for Microsoft Teams | /credentials/applied-skills/build-collaborative-apps-microsoft-teams/ | ["intermediate"] | ["office-teams","ms-graph","entra-id","ms-copilot"] | ["developer"] | ["backend-development","frontend-development","custom-app-development"] | ["Build a bot","Create a messaging extension","Build webhooks","Create a Teams tab","Integrate Microsoft Graph into a Teams app","Distribute a Teams app"] |
HierarchyCertification
The HierarchyCertification dataset contains catalog information about all the Certifications in Microsoft Learn.
To learn more about certifications and how they relate to other content types, view the Certification section in the Learn content types article.
| certificationUid | type | title | summary | url | iconUrl | levels | products | roles | exams |
|---|---|---|---|---|---|---|---|---|---|
| certification.azure-administrator | 0 | Microsoft Certified: Azure Administrator Associate | Azure administrators implement, manage, and monitor an organization's Microsoft Azure environment. | /certifications/azure-administrator/ | /media/learn/certification/badges/microsoft-certified-associate-badge.svg | ["intermediate"] | ["azure","azure-virtual-machines","azure-storage","azure-active-directory","azure-virtual-network","azure-resource-manager"] | ["administrator"] | ["exam.az-104"] |
HierarchyLearningPath
The HierarchyLearningPath dataset contains catalog information about all learning paths on Microsoft Learn.
To learn more about learning paths and how they relate to other content types, view the Learning paths section in the Learn content types article.
| LearningPathUid | title | url | durationInMinutes | points | iconUrl | levels | products | roles | languages |
|---|---|---|---|---|---|---|---|---|---|
| learn.create-serverless-applications | Create serverless applications | /training/paths/create-serverless-applications/ | 517 | 1925 | /training/achievements/create-serverless-applications.svg | ["beginner","intermediate"] | ["azure","azure-functions","azure-portal","azure-cosmos-db","azure-storage","azure-cloud-shell"] | ["developer","student"] | ["powershell"] |
HierarchyLearningPathModule
The HierarchyLearningPathModule dataset contains the mapping of modules to learning paths. (Note: A module can be a part of multiple learning paths.)
To learn more about modules and learning paths and how they relate to other content types, view the Module section and Learning path section in the Learn content types article.
| LearningPathUid | ModuleUid |
|---|---|
| learn.security-ops-sentinel | azure.query-data-sentinel |
| learn.architect-data-platform | learn.access-data-with-cosmos-db-and-sql-api |
HierarchyModule
The HierarchyModule dataset contains catalog information about all modules (courses).
To learn more about modules and how they relate to other content types, view the Module section in the Learn content types article.
| moduleUid | title | url | iconUrl | durationInMinutes | points | levels | products | roles | languages |
|---|---|---|---|---|---|---|---|---|---|
| learn.languages.powershell-write-first | Write your first PowerShell code | /training/modules/powershell-write-first/ | /training/achievements/powershell/powershell-write-first-code.svg | 17 | 200 | ["beginner"] | ["dotnet"] | ["developer","student"] | ["powershell"] |
HierarchyUnit
The HierarchyUnit dataset contains catalog information about all Units (pieces of modules).
To learn more about units and how they relate to other content types, view the Units section in the Learn content types article.
| unitUid | title | url | durationInMinutes | points | moduleUid |
|---|---|---|---|---|---|
| learn.azure.query-data-sentinel.1-introduction | Introduction | /training/modules/query-data-sentinel/1-introduction/ | 5 | 100 | azure.query-data-sentinel |
| learn.azure.query-data-sentinel.2-exercise-setup | Exercise - Query and visualize data with Azure Sentinel Workbooks | /training/modules/query-data-sentinel/2-exercise-setup/ | 10 | 100 | azure.query-data-sentinel |
Next steps
Review the resources below to help you on your development journey: