Tableau Dimensions and Measures EXPLAINED |

[@DataWithBaraa]

If you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE --------------------------------- ⏱ TIMESTAMPS ⏱ --------------------------------- 00:00 Introduction to Dimensions and Measures 02:41 Is Field a Dimension or Measure? 06:55 How to Identify Dimensions & Measures 09:25 Change Between Dimensions and Measures 13:25 The Secret Formula 17:25 Summary: Dimensions vs Measures Enjoy :)

[@echoexplore4190]

what would u consider dimension risk class average spend? ie we could plot for a scatterplot risk class average spend, and actual spend and have colour being risk class superclass... we could also plot spend-average spend, its a bit odd

[@CuriousBeing-2037]

I watched several KZbinrs' explanations on this topic, and no one did it better than you! Thank you so much for a very comprehensive video, Baara

[@madhanparthasarathy9013]

The best explanation i've seen yet for visual learners!

[@rabb1t290]

Without any doubt, your videos are far better than many paid courses.

[@anamaria8430011]

I love the way that you explain in your videos It makes easy to understand everything about complicated things in tableau.

[@shubhamawale4881]

Thanks for your valuable content. I have a problem when I load the data some fields such as discount, profit, and sales show data type as a string, and when I change it to a number it becomes null. IDK why?

[@betterthanperfect8931]

Actually one of the best tabluea content 👌🏾 Keep going bro 💪

[@Beibarys-x9v]

This video was very informative! The explanation of dimensions and measures in Tableau was clear, and the guidance on how to assign fields was super helpful. Great job breaking it down-thank you!

[@wpackard7399]

I really appreciate your videos, I have the same issue as others where the sales and profit are set as s string and when changed to number I get "null", I am using the lates EU data sets. Any help would be appreciated.

[@DataWithBaraa]

I'm happy you liked my video, about the issue you mentioned i made a small video to solve the issue kzbin.info/www/bejne/hZvFfJ2BjcutoZYsi=HRr8qBt5q_AKYDP9

[@Sarang-g9w]

Thanks a lot .. excellent teaching

[@lancer876]

Excellent way to explain what measures and dimensions are! Thank you.

[@bassimahmed5004]

That is really amazing; you are the best ever You make everything simple. I watched more than 20 videos today; i can not stop.😅😍

[@TasneemShahid-iu1mo]

you are a genius!!!! this is absolutely gold. explained beautifully. Thank you so much

[@DataWithBaraa]

Wow, thank you!

[@MelanieRose345]

You are literally the best :) love your explanation

[@KayvanHedayati]

Wow, Thanks a lot! You are the best!

[@DataWithBaraa]

You are amazing for saying that thanks 🙏

[@arnavsood-kx7iy]

one of the best animation-based videos to understand some aspects of dimensional modeling. Hope in the future you will create a dedicated course on data modeling on education platforms like Udemy etc.

[@GhaithAhmad-e7s]

You are Greate ...

[@MrMoggz]

Thanks for this great free tutorial. How do you decide what should be in column vs what should be in the row? Is it recommended that Dimensions to be put in the columns and measures in the row ?

[@equiwave80]

Hi Bara, Thanks for this great video. I had a doubt regarding Dimensions. You had mentioned in the summary that Dimensions cannot be aggregated. Any categorical dimension e.g: Segment of Sample Superstore dataset) can be aggregated by right-clicking the field in the view and selecting Measure > either Minimum, Maximum, Count, Count (Distinct). Although it does not always makes sense to aggregate a non-numeric dimension. Kindly confirm the same or am I missing something here. Regards, Deepak.

[@DataWithBaraa]

Hi Deepak, I really appreciate your nice feedback. Regarding your question, when you choose 'Measure' and then select an aggregate function, you're essentially converting a dimension into a measure. If Tableau allows the aggregation of dimensions, they would skip the 'Measure' step and directly provide the aggregate functions. So, to answer your question, it's not possible to aggregate dimensions. I hope this helps, enjoy your day !

[@MelanieRose345]

Thank you very much!:)

[@perfectionist6624]

Hi Bara, When will you upload SQL advance full tutorial video?

[@DataWithBaraa]

Hi, I will do it once Tableau Course is done, maybe by September this year :)

[@SketchShiftbylokesh]

Good content.

[@loveforall9278]

Hi , Thank you for the amazing videos! I have Question.Dates filed are non numerical but we can perform aggregation on it right ? E.g : Avg time to ship the product..etc. can we make the field as measure ? Thank you!

[@asrartiqaniyah]

thank you a lot.. just to mention, the sales data type in " theTableau-Sales-Dataset-Small\Sales Dataset" is string but it's number in your video. I changed it to number but all values turned into null. could you please help me with this issue.

[@DataWithBaraa]

Thank you 🙏 I will check it and try tomorrow again to download the files.

[@jhjs08]

I really enjoy these videos. But Sales and profit and more of the data in the Orders table are defaulted in string and could not beaggregated. If I change to decimal, the data turns into null. How can I solve this?

[@DataWithBaraa]

Hi I am really happy that you like my content, can please give me an example of sales here in comment to understand the format you see. Thanks 🙏

[@fikriymamo]

good

[@echoexplore4190]

nice video, apart from video it would be great to also consider: dimension (key, attribute), key would identify a unique member as its base case attribute would identify a property ie customer id: key customer name: dimension (bob smith) social security number:key or honestly for the keys we never want aggregated by we could consider composite keys this then forces dimension to be attributes or quality, smoking/non-smoking etc thresholded measures such as bucket for claims or risk category start to blur the line between measure and dimension, but i think might be their own special class of dimension as they are 'measure ferived dimensions' maybe umm quantitative dimension? boolean flag-likes for like row active, final/inflight/not started, is test, is train or dimension test/train are a bit weird, as these are for external processes... hmmm

[@SanjaykumarGollavilli.]

count of customer_ID is an aggregation, but still we call it dimension.

[@MelanieRose345]

مكنة و الله