# TABLEAU 10 TRAINING | SEP 15 - OCT 07 | RAMANATHAN

Discussion in 'Big Data and Analytics' started by Nishant_Singh, Sep 14, 2018.

1. ### Nishant_Singh Well-Known Member Simplilearn Support

Joined:
Aug 1, 2018
Messages:
159
9
Hi Learner,

This thread is blocked for you to discuss the query and concepts related to Tableau Desktop 10 Qualified Associate course.

Happy Learning!!

Regards,
Team Simplilearn

#1
2. ### _40114 New Member

Joined:
Sep 12, 2018
Messages:
1
0

Thanks Nishant.. i was expecting for some assignment (to be completed) to be uploaded here ( as per our instructor - Ram).. So should i expect that would happen later on?

#2
3. ### Priyanka_Mehta Well-Known Member Simplilearn Support

Joined:
May 25, 2017
Messages:
883
58
Hi Navneet,

This is to inform you that, by end of the day, all the data will be uploaded on the dedicated google drive link mentioned below:

Also, if any additional comments are needed, Ramanathan will be adding it up here by end of the day for sure.

#3
4. ### Ramanathan Somasundaram(4123) Active Member Alumni

Joined:
Oct 13, 2011
Messages:
49
6
Hi All,

Sorry to keep you waiting. Hope you are having some fun time learning Tableau. Here you go with the first exercise of the class.

Exercise 1:

Perform Joins and blends, whichever is relevant in the sample superstore database to identify below!
1) Which region has more sales of Furniture category?
2) Which region has the lowest returns for the orders in 2016? What is the number of returns for that region?
3) Which category & sub category combination has recorded the most number of returns?
4) Which product has generated more profit?
5) Perform a split in customer name field into first name and last name. Identify the most commonly used first name.

Regards,
Ram

#4
_3125 likes this.
5. ### Debasish Dasgupta Customer Customer

Joined:
Sep 21, 2017
Messages:
6
0
Hi Ram I have done the exercises for Tableau. Tried to Upload the file but cannot. Please let me know if I have to submit the same from where. I cannot upload a .zip file here giving error.

#5

Joined:
Sep 21, 2017
Messages:
6
0

#6

Joined:
Sep 7, 2018
Messages:
11
1

#7

Joined:
Sep 7, 2018
Messages:
11
1
9. ### _38213 New Member

Joined:
Aug 23, 2018
Messages:
1
0
Hi Ram.

This is my worksheet for exercise 1
https://public.tableau.com/profile/...7#!/vizhome/Excercise-1_1/MostNumberofreturns

when i am converting dimension to a measure , for example i have changed returned dimension(Referring to sample super store - Returns) to a measure in the data pane , once i do this change automatically tableau will set (count of distinct for the measure created) , can you please guide me on how to change this default setting in the data pane so that i get only count instead of count of distinct because if i pull this measure to marks area or rows/columns i end up manually changing from count of distinct to count .

Thanks
Krishna

#9
10. ### Ramanathan Somasundaram(4123) Active Member Alumni

Joined:
Oct 13, 2011
Messages:
49
6
Hi Krishna,

I understood that you are trying to convert a dimension to a measure. While a number data type can be automatically converted, you cannot just convert a text to measure for the obvious reasons where you cannot do any aggregations. Hence when you convert a text dimension into measure, it will convert it into numbers by putting some aggregations like Min, Max, Count or Count distinct to it.

Regards,
Ram

#10
11. ### Ramanathan Somasundaram(4123) Active Member Alumni

Joined:
Oct 13, 2011
Messages:
49
6
Exercise for Session 2:

All questions are with regards to Sample Superstore data set.
1. Create a dynamic set using parameter defined by user and create a graph to show the top profitable products by category and region.
2. Create a graph to show the products which was ordered maximum quantity/no of times
3. Which product is taking more time to get delivered on on average
4. Identify the product which took maximum number of days to ship under first class ship mode
5. Create a word cloud to show the state with maximum sales

#11
12. ### _39668 Member

Joined:
Sep 7, 2018
Messages:
8
0

Hi Ram,

Please find my solution for Exercise 1 in the blow link -

https://public.tableau.com/profile/...eSuperStore-Goutami/RegionVsSales?publish=yes

Thanks,
Goutami

#12

Joined:
Sep 7, 2018
Messages:
11
1
#13

Joined:
Oct 26, 2017
Messages:
1
0
#14

Joined:
Oct 13, 2011
Messages:
49
6
#15

Joined:
Oct 13, 2011
Messages:
49
6
#16
17. ### Ramanathan Somasundaram(4123) Active Member Alumni

Joined:
Oct 13, 2011
Messages:
49
6
Hi Kshitij,

Now that we have covered visualizations, you have to be sure of what chart serves what purpose. The bubble charts and tree maps may not be sufficient when the questions are straight forward. Also the question number 1, the chart is to be on the products level. Otherwise, good creativity. Keep learning.

#17
_14428 likes this.

Joined:
Sep 7, 2018
Messages:
11
1
#18
19. ### Ramanathan Somasundaram(4123) Active Member Alumni

Joined:
Oct 13, 2011
Messages:
49
6
Hi All,

Dataset: Sample Superstore

1. How many city names are common between two states?
2. Which are the states that lost money?
3. What is the trend of profit in central region by every quarter?
4. Use Calculated fields to split Customer ID and find out how many names share same initials (Hint - the alphabets in customer ID)
5. Create a unit chart to show the sale of products by sub category for the year 2017. Use region as color marks and number of quantity as details. Also try displaying 1 mark (any shape) for 25 quantity.

#19

Joined:
Sep 7, 2018
Messages:
11
1
Thanks Ram

- Sateesh

#20

Joined:
Oct 30, 2017
Messages:
5
0

Joined:
Sep 7, 2018
Messages:
11
1
#22

Joined:
Jun 29, 2018
Messages:
1
0
#23

Joined:
Oct 13, 2011
Messages:
49