Dimensions:- In a star schema, the entities by which you aggregate or slice measures are called dimensions. Dimensions are the descriptive attributes or perspectives of the data that provide the context for the measures (also known as facts) in the model.
For example, in a sales data star schema, the dimensions could be time, product, store location, and customer. These dimensions provide context for the sales measures such as total sales, units sold, and revenue. By aggregating or slicing the measures by different dimensions, you can gain insights into the data from different perspectives.
In an analytical model designed as a star schema, the entities by which you aggregate or slice measures are called dimensions.
A star schema is a type of data modeling technique commonly used in data warehousing and business intelligence applications. It organizes data into a central fact table surrounded by multiple dimension tables. The fact table contains measures or numerical values that represent the business metrics or facts, such as sales amount or quantity. The dimension tables contain the descriptive attributes or context information related to the facts, such as date, product, customer, or location.
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.DP-900 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
coolbru
Highly Voted 1 year, 9 months agoKarbabu
Most Recent 9 months, 2 weeks agofiksarion
1 year, 5 months ago