Microsoft Tenant Data Analytics

The xViz Performance Flow visual provides an interactive and intuitive way to analyze Microsoft Graph API for Tenant Data Analytics.

xViz Performance Flow - Tenant Data AnalyticsxViz

Demo report | Microsoft Tenant Data Analytics using xViz Performance Flow

Refer to the Importing Microsoft Graph API with Power Query documentation for guidance on fetching Microsoft Entra ID data into Power BI.

Visualize the Microsoft Graph API using the xViz Performance Flow visual:

1. Now, import xViz Performance Flow from Microsoft AppSource into your report.

If this is your first time working with custom visuals, then here are the steps to import a custom visual from Microsoft AppSource.

1. Next, populate the data fields in the visual with the relevant columns as shown below:

Image 1: Populate data fields

1. Navigate to the Map Field option in the top ribbon and map these newly populated columns to the Map Field, as shown in the image below:

Image 2: Map newly added column in the Map Field

1. As a result, the organization chart is created using Microsoft Entra ID (formerly Azure Active Directory) data with the xViz Performance Flow Visual in Power BI.

Image 3: Organization Chart in xViz Performance Flow

The data presented in the report is a sample dataset created for demonstration purposes. It closely resembles the data obtained from Microsoft Entra ID (formerly known as Azure Active Directory).

The visual provides powerful insights for analyzing Microsoft Tenant Data with the following features:

1. KPI & Variance:

The visual displays the storage used on each employee card, providing a clear overview of individual usage. By incorporating the allocated storage, it automatically calculates the variance, allowing for quick insights into storage discrepancies directly on the card.

Image 4: KPI & Variance in xViz Performance Flow

For detailed information on displaying KPIs and their variance on employee cards, refer to this documentation - KPI & Variance

2. Conditional Formatting:

Conditional formatting in the Performance Flow visual enables the identification and highlighting of IT-related issues, such as low storage, through customizable data-driven rules. For example, employee cards can be marked with a warning sign or a red border when storage usage exceeds a set threshold. Additionally, other rules and formatting options can be applied to tailor the visual appearance based on specific IT performance criteria.

Image 5: Conditional Formatting in xViz Performance Flow

For detailed information on Conditional Formatting, which allows you to highlight nodes based on specific conditions, refer to this documentation - Conditional Formatting

3. Custom Template:

Custom templates with advanced DAX techniques simplify app usage tracking and license management, enabling easy monitoring, optimization, and allocation of resources.

Image 6: Custom Template in xViz Performance Flow