
Microsoft Certified Azure Data Fundamentals (DP-900) Exam Guide
By :

Analytical models give you a structure for the data you want to analyze. In the following sections, we will explore some core concepts, such as cubes and schemas.
Analytical models are based on related data tables that contain the following properties:
A typical data table in a business context often contains quantitative sales metrics (measures), such as revenue or quantity, and categorical dimensions, such as product, customer, and time. With this data, analysts can perform in-depth analyses to derive insights, such as the total revenue by an individual customer or the monthly number of items sold by a product.
Conceptually, a model becomes a multidimensional cube, and at any point at which...