search

RohitDhankar / DigitalCognition_OldRepo_ARCHIVED

DC is being developed to be a generic BI tool. Product preview here :- https://www.youtube.com/channel/UC9J9N9CNv15s9U9Aejpza6g/videos
2 stars 1 forks source link

Reports to be created with TableAu like Dimensions and Measures #27

Open RohitDhankar opened 5 years ago

RohitDhankar commented 5 years ago

Understanding dimensions and measures

Tableau divides the data in two main types: dimensions and measures. Dimensions are usually those fields that cannot be aggregated; measures, as its name suggests, are those fields that can be measured, aggregated, or used for mathematical operations. Dimension fields are usually used for row or column headings; measures are usually used for plotting or giving values to the sizes of markers.

RohitDhankar commented 5 years ago

Further reading suggested - Source TableAu ---

Dimensions and Measures – are both COLUMNS from our DataSet MEASURES --->> We can SUM , AGGREGATE , AVERAGE , basically numbers. DIMENSIONS --->> We want to use for SEGMENTATION and CLASSIFICATION of the MEASURES

In Tableau there are four possible modes when dealing with your measurement fields which result in a different layout or result. They are a) continuous aggregate measure, b) discrete aggregate measure, c) continuous disaggregate measure, d) discrete disaggregate measure. B and D are considered dimensions by Tableau.

TableAu - will color code the DISCRETE and CONTINUOUS variables - Blue and Green