資料倉儲資料模型Data Warehouse data model

Intune 資料倉儲會每日對資料進行抽樣,以提供行動裝置之持續變更中環境的歷程檢視。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 things in time.

項目:實體集Things: 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

這些區域包含對您的 Intune 環境有意義的實體或項目。These areas contain the entities, or things, that are meaningful to your Intune environment. 您可在下列主題中找到有關實體集的詳細資訊:You find details about the entity sets in the following topics:

關聯性:星狀結構描述模型Relationships: Star-schema model

針對您要詢問的問題類型,倉儲會以有意義的關聯性來組織實體。The warehouse organizes the entities in relationships that are meaningful to the type of questions you want to ask. 例如,您可以檢閱內部開發之 Android 應用程式的安裝數量。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. 接著,Microsoft Power BI 這類分析工具可以使用資料倉儲資料模型來建立視覺效果和動態儀表板。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. 它們可能變得非常大,因此它們通常將資訊限制在 30 天。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. 維度資料表 (如 User 資料表) 比較小,可保存比事實資料表更長時間的資料。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

倉儲是您 Intune 資料的下游。The warehouse is downstream from your Intune data. Intune 於 UTC 的午夜擷取每日快照集並儲存在倉儲。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. 有些可能保留 7 天,有些可能保留 30 天,或甚至更長的期間。Some may hold seven days, others 30 days, and some even longer durations.

後續步驟Next steps