Creating a Dynamic Dashboard in Tableau: A Step-by-Step Guide for Aspiring Data Analysts

1) Dataset link:
drive.google.c...
2) Flaticon website:
www.flaticon.com/
3) Text boxes coordinates and dimensions:
drive.google.c...
4) How to create Buttons filter video link:
• Tableau Tutorial: Crea...

[@mannyuruchurtu318]

This is a great video! FYI a quick tip for your data prep. You can use the formula =text([Date],"mmm") to pull the month abbreviation vs using the choose function and typing out all the months.

[@AnalyticsExplorers]

Great! Thanks for your information and your valuable feedback.

[@lazytocook]

very excellent step by step guide dashboard

[@AnalyticsExplorers]

Thanks alot for your feedback❤

[@oluwatoyinogunyemi]

thank you for this video, the dataset am using has an age column but Tableau is not showing it as actual age but some number in hundred formats. e.g. instead of showing 20, it's showing it as a sum(age) of 1200. how can I format it? thanks

[@AnalyticsExplorers]

Describe in more detail what do you want to draw or what is your desired outcome

[@oluwatoyinogunyemi]

@@AnalyticsExplorers Site COLON
AGE is showing 16586 which is the sum values instead of 60years so how can I format it to show 60years

[@AnalyticsExplorers]

I mean what you are trying to achieve.
Do you want for example to draw a bar chart with ages on an axis. Do you want to find the average age and put it into a card box. What is you final output?

[@oluwatoyinogunyemi]

@@AnalyticsExplorers I want to draw a bar chart with age on the axis

[@AnalyticsExplorers]

@@oluwatoyinogunyemi it seems that you want to draw a bar chart with the age as the x axis against other dependent variable. If so, you need after putting the age in the columns field, press the dropdown arrow next to the age name and choose dimension instead of measure.

[@nouamandehmani]

this is so good thank you so much , i have a question since i am new to Tableau and data analytics : if i am working on SQL with multiple tables which will require using "Joins " after cleaning that tables in SQL , do i need to upload all the tables to Tableau or what is the best practice for this purpose ? thank you in advance

[@AnalyticsExplorers]

When dealing with both SQL and Tableau, the best practice is to perform all your analysis in sql and answer all your questions. Then, you export the final results of each query as a csv file which can be imported into tableau. You can after that use those csv files to create your charts.

[@AnalyticsExplorers]

In the upcoming days, I will upload a full portfolio project using SQL and Tableau integration. Wait for it!