Dimensions and measures, calculated fields, DAX basics, LOD expressions, data models, filters and dashboard design.
35 cards · basic cards · AI-written, checked twice. Edit anything.
- What is the primary difference between a dimension and a measure?
Show answer
A dimension is a categorical or descriptive field; a measure is a quantitative field that can be aggregated.- Which of the following is a dimension: Product, Quantity Sold, Date, Revenue?
Show answer
Product and Date are dimensions (categorical); Quantity Sold and Revenue are measures.- In Tableau, what is the difference between a discrete field and a continuous field?
Show answer
Discrete fields are categorical and show as blue pills; continuous fields are numerical and show as green pills.- What is aggregation in the context of measures?
Show answer
Combining multiple values of a measure into a single value using functions like SUM, AVG, or COUNT.- Can a field be used as both a dimension and a measure?
Show answer
Yes, a numeric field can be used as either, depending on whether you aggregate it (measure) or group by it (dimension).- What is a calculated field?
Show answer
A field created from an expression or formula using other fields in the dataset.- How do you create a calculated field in Tableau?
Show answer
Right-click in the Dimensions or Measures area, select Create Calculated Field, then enter a formula.- What is the key difference between a measure and a calculated column in Power BI?
Show answer
A measure is evaluated in filter context and returns a scalar; a calculated column is evaluated in row context and returns a value per row.- Give one example of a calculated field you might create in a retail dataset.
Show answer
Profit Margin (calculated as [Profit] / [Revenue]), Discount Percentage, or Days Since Purchase.- What does DAX stand for?
Show answer
Data Analysis Expressions- What is the CALCULATE function in DAX used for?
Show answer
To evaluate an expression in a modified filter context, allowing you to override or add filters to a calculation.- In DAX, what is filter context?
Show answer
The set of filters that determine which rows from the data model are used in a calculation.- In DAX, what is row context?
Show answer
The current row being evaluated when a formula is applied to each row individually in a calculated column.- Write a simple DAX formula that sums a Sales amount column regardless of applied filters.
Show answer
=CALCULATE(SUM(Sales[Amount]), ALL(Sales))- What does LOD stand for in Tableau?
Show answer
Level of Detail
FlashKeepers