Microsoft Intune Data Warehouse data model
The Intune Data Warehouse samples data daily to provide a historical view of your continually changing environment of mobile devices. The view is composed of related entities in time.
Entities: Entity sets
The warehouse exposes data in the following high-level areas:
- App protection enabled apps and usage
- Enrolled devices, properties, and inventory
- Apps and software inventory
- Device configuration and compliance policies
These areas contain the entities that are meaningful to your Intune environment. You find details about the entity sets in the following topics:
- Intune Management Extension
- Mobile App Management (MAM)
- Current User
- User Device Associations
Relationships: Star-schema model
The warehouse organizes the entities in relationships that are meaningful to the type of questions you want to ask. For example, you can review the number of installations of an in-house developed Android application. The structure of the data warehouse enables you to gain insight into your mobile environment. In turn, analytics tools, such as Microsoft Power BI, can use the Data Warehouse data model to create visualizations and dynamic dashboards.
The entities and relationships use a star-schema model. A star-schema correlates facts over the dimension of time. A fact in the context of the model is a quantitative measurement such as the number of devices, number of apps, or time of enrollment. Fact tables store a lot of data. They can get very large, and so they typically limit information to 30 days. A dimension provides context to the facts. Where the fact measures what happened, the dimensions indicate to whom it happened. Dimension tables, such as the like the User table are smaller and can retrain data for longer periods of time= than fact tables.
A star-schema model is optimized for flexibility and data analysis so that you can create the reports needed to understand your evolving mobile environment.
Time: Daily snapshots
The warehouse is downstream from your Intune data. Intune takes a daily snapshot at Midnight UTC and stores the snapshot in the warehouse. The duration of held snapshots vary from fact table to fact table. Some may hold seven days, others 30 days, and some even longer durations.
- To learn more about how the data warehouse tracks a user's lifetime in Intune, see User lifetime representation in the Intune Data Warehouse.
- To learn more about working with data warehouses in the Create First Data WareHouse.
- To learn more about working with Power BI and a data warehouse in Create a new Power BI report by importing a dataset.
We'd love to hear your thoughts. Choose the type you'd like to provide:
Our feedback system is built on GitHub Issues. Read more on our blog.