Tableau | May 12 - Jun 3

Discussion in 'Big Data and Analytics' started by Priyanka_Mehta, May 12, 2018.

  1. Priyanka_Mehta

    Priyanka_Mehta Well-Known Member
    Simplilearn Support

    Joined:
    May 25, 2017
    Messages:
    572
    Likes Received:
    37
    Hello All,

    Greetings from Simplilearn!!

    Let us have a discussion about the course, explore the course here and try to resolve all our queries related to the same.

    Happy Learning!!

    Regards,
    Priyanka
    GTA - Simplilearn
     
    #1
    _29583 likes this.
  2. Priyanka_Mehta

    Priyanka_Mehta Well-Known Member
    Simplilearn Support

    Joined:
    May 25, 2017
    Messages:
    572
    Likes Received:
    37
    #2
  3. Priyanka_Mehta

    Priyanka_Mehta Well-Known Member
    Simplilearn Support

    Joined:
    May 25, 2017
    Messages:
    572
    Likes Received:
    37
    #3
  4. _29215

    _29215 Member

    Joined:
    Apr 13, 2018
    Messages:
    3
    Likes Received:
    0
    For Atlanta time the training is starting @10:00 Am on 5/12/2018 Sat. Is that right?
    Also which webex link has to be used for the training?
     
    #4
  5. _27004

    _27004 Member

    Joined:
    Mar 23, 2018
    Messages:
    2
    Likes Received:
    1
    Hi,

    How do I start today's session? What are the steps?
     
    #5
  6. _27004

    _27004 Member

    Joined:
    Mar 23, 2018
    Messages:
    2
    Likes Received:
    1
    #6
    _29151 likes this.
  7. Priyanka_Mehta

    Priyanka_Mehta Well-Known Member
    Simplilearn Support

    Joined:
    May 25, 2017
    Messages:
    572
    Likes Received:
    37
  8. Naveen Naveen_4

    Joined:
    Jul 4, 2016
    Messages:
    2
    Likes Received:
    0
    Chapter 1 - Exercise Answer..

    1. Technology Category has the highest sales in East region

    2. South - Least Sales in Office Supplies category

    upload_2018-5-13_23-28-48.png
     
    #8
  9. Naveen Naveen_4

    Joined:
    Jul 4, 2016
    Messages:
    2
    Likes Received:
    0
    Chapter 2 - Guided Exercise Answer:

    1. She should consider Excel Tool to prepare the data for analysis.

    2.She should use "Blend" to combine the data since she has extremely large data.

    3.She should use Data Extracts to execute queries efficiently
     
    #9
  10. _20956

    _20956 Member

    Joined:
    Jan 21, 2018
    Messages:
    5
    Likes Received:
    0
    Hello
    Please find the Exercise assignment

    • Exercise 2.1: Getting started with Tableau

    Screen Shot 2018-05-14 at 9.35.13 PM.png

    Q1. Which segment has the highest sales across all years?

    A: Consumer Segment has the highest sales across all the years.

    Q2. For which Year and Category was the Home Office sales greater than Corporate sales?

    A: 2014 Technology has greater sales than Home office.


    • Exercise 3.1: Joins and Data Extracts
    Screen Shot 2018-05-14 at 9.36.00 PM.png

    Q1. Which is the least profitable state?

    A: Texas is the least profitable state with loss of 4K

    Q2. Customers from which state have returned the highest number of products?

    A: California is the state from which the customers have returned highest number of products
     

    Attached Files:

    #10
  11. Shafi Hadimani(1651)

    Alumni

    Joined:
    Oct 9, 2014
    Messages:
    6
    Likes Received:
    0
    Hello Team, unable to access the tableau video, getting error..Error attached. Please look into it.
     

    Attached Files:

    #11
  12. Shafi Hadimani(1651)

    Alumni

    Joined:
    Oct 9, 2014
    Messages:
    6
    Likes Received:
    0
    Exercise 2.1..
    Which segment has the highest sales across all years? Consumer
    For which Year and Category was the Home Office sales greater than the Corporate sales? 2014 Technology

    upload_2018-5-16_12-36-52.png
     
    #12
  13. Shafi Hadimani(1651)

    Alumni

    Joined:
    Oct 9, 2014
    Messages:
    6
    Likes Received:
    0
    Since line chart has to be selected (which I missed reading when I submitted exercise first)... The answer remains the same.

    Which segment has the highest sales across all years? Consumer
    For which Year and Category was the Home Office sales greater than the Corporate sales? 2014 Technology



    upload_2018-5-16_12-54-45.png
     
    #13
  14. Binoy Rajan

    Binoy Rajan New Member

    Joined:
    Dec 9, 2015
    Messages:
    1
    Likes Received:
    0
    #14
  15. Sushil Ghia

    Sushil Ghia Member
    Alumni

    Joined:
    May 2, 2017
    Messages:
    3
    Likes Received:
    0
     
    #15
  16. Sushil Ghia

    Sushil Ghia Member
    Alumni

    Joined:
    May 2, 2017
    Messages:
    3
    Likes Received:
    0
    Lesson 2 - Data Connections - Exercise - Problem Statement and answer.

    upload_2018-5-17_21-44-48.png
     
    #16
  17. _29151

    _29151 Member

    Joined:
    Apr 13, 2018
    Messages:
    2
    Likes Received:
    0
    Which tool should Genelia consider to prepare the data for analysis?
    She can use BI tools such as Tableau, Qlik for sales analysis or power query in excel

    Should she attempt to combine the data with a blend or a join?
    She should use blend functionality for combining the data

    What steps should she consider to ensure that queries are executed efficiently?
    Not sure.

    Komal Malik
     
    #17
    Last edited: May 20, 2018 at 9:06 AM
  18. _29151

    _29151 Member

    Joined:
    Apr 13, 2018
    Messages:
    2
    Likes Received:
    0
    Priyanka - Can you please share these files on my email ID as I am not able to access them.
     
    #18
  19. _31500

    _31500 New Member

    Joined:
    May 7, 2018
    Messages:
    1
    Likes Received:
    0
    Chapter 2 - Guided Exercise Answer:

    1. She should consider Excel Tool to prepare the data for analysis.

    2.She should use "Blend" to combine the data since she has extremely large data.

    3.She should use Data Extracts to execute queries efficiently
     
    #19
  20. _30032

    _30032 Member

    Joined:
    Apr 23, 2018
    Messages:
    3
    Likes Received:
    0
    Just for testing

    By Amit
     
    #20
  21. abhinavvedi

    abhinavvedi New Member
    Alumni

    Joined:
    Dec 6, 2017
    Messages:
    1
    Likes Received:
    0
    hi Tushar and riya,

    I got the combined set correct (screen-shot below), thanks a lot for your help!

    Regards
    Abhinav

    upload_2018-5-20_19-34-47.png
     
    #21
  22. _26935

    _26935 New Member

    Joined:
    Mar 22, 2018
    Messages:
    1
    Likes Received:
    0
    Name: Sylvia FrancisCourse: Tableau Desktop 10.5
    Instructor: Tushar
    Assignment Name: Quick Table Calculation with different compute using option.


    1. Quick Table Calculation - Difference - Option Compute using Table(across)
    It compares the value from left to right and give you the difference.
    Example: In first row (Central),
    2016value (10) comes from = 2015 value (476) - 2014 value (466)
    2016 value (127) comes from = 2016 value (603) - 2015 value (476)
    2017 value (175) comes from = 2017 value (778) - 2016 value (603)
    upload_2018-5-20_16-38-47.png

    2. Quick Table Calculation - Difference - Option Compute using Table(down)
    It compares the value from top to bottom in column and give you the difference.
    Example: In first column (2014),
    East value (51) comes from = East value (517) - Central value (466)
    South value (-168) comes from = South value (349) - East value (517)
    West value (312) comes from = West value (661) - South value (349)
    upload_2018-5-20_16-39-36.png

    3. Quick Table Calculation - Difference - Option Compute using Table(across then down)
    It compares the value from left to right and give you the difference for the first row
    Then for the first value of 2nd row is calculated from the first value in the 2nd row minus last value in the first row.
    Example: In first row (Central),
    2015 value (10) comes from = 2015 value (476) - 2014 value (466)
    2016 value (127) comes from = 2016 value (603) - 2015 value (476)
    2017 value (175) comes from = 2017 value (778) - 2016 value (603)
    Then for the first value of 2nd row (East) is calculated -> -261 = 2014 East value (517) - Central 2017 value (778)
    After that it goes across. Only the first value of each row is calculated from first row value minus last row last value.

    upload_2018-5-20_16-40-28.png

    4. Quick Table Calculation - Difference - Option Compute using Table(down then across)
    It compares the value from top to bottom in each column and give you the difference
    Then for the first value of 2nd column is calculated from the first value of 2nd column minus last value of first column
    Example: In first column (2014),
    East value (51) comes from = East value (517) - Central value(466)
    South value (-168) comes from = South value (349) - East value (517)
    West value (312) comes from = West value (661) - South value (349)
    Then the first value of 2nd column (-185) = first value of 2nd column (476) - last value of first column (661)

    upload_2018-5-20_16-41-15.png


    S
     
    #22
  23. _29933

    _29933 Member

    Joined:
    Apr 20, 2018
    Messages:
    2
    Likes Received:
    0
    Name : Riya Garg
    Course : Tableau Desktop 10.5
    Instructor : Tushar More

    First Class : 12 May 2018
    1. Problem Statement -1
    upload_2018-5-21_12-9-51.png

    Solution

    Product Category that has highest sales in the East region - Technology(264974)
    upload_2018-5-21_12-27-21.png

    upload_2018-5-21_12-29-8.png

    upload_2018-5-21_12-29-44.png

    Region that recorded the lowest sales of office supplies - South(125651)

    upload_2018-5-21_12-32-8.png

    upload_2018-5-21_12-32-44.png

    upload_2018-5-21_12-33-49.png

    upload_2018-5-21_12-34-41.png

    Second Class : 13 May 2018
    1. Problem Statement -1
    upload_2018-5-21_12-53-44.png

    Solution :

    1. Since data is coming from different sources , she should consider UNION to prepare the data for analysis. Since the data is at different levels of detail she can use PIVOT functionality.
    2. She should attempt to combine the data with a BLEND.
    3. She can FILTER OUT the not necessary data and can use EXTRACT option rather than using LIVE.
     

    Attached Files:

    #23
  24. _29933

    _29933 Member

    Joined:
    Apr 20, 2018
    Messages:
    2
    Likes Received:
    0
    Hi Priyanka , whatever i am posting seems like it is not getting posted it is saying : 'This message is awaiting moderator approval, and is invisible to normal visitors' Who's moderator now?Could u please take out some valuable time of yours and help me in this and please i believe u should also help in creating profile with name , it seems so ridiculous to each time post name also. Hope you will help?
    Thanks,
    Riya Garg
     
    #24
  25. _30032

    _30032 Member

    Joined:
    Apr 23, 2018
    Messages:
    3
    Likes Received:
    0
    Hi,

    I have selected range of values for an measure object from 400-500 but i am getting a customer with sales of more than 1000. Attaching a snapshot as well.

    Br,
    Amit
     

    Attached Files:

    #25
  26. _22178

    _22178 New Member

    Joined:
    Feb 3, 2018
    Messages:
    1
    Likes Received:
    0
    Hi Team,

    Could someone please help me on the below issue.

    when i was creating join function for the below both data-sets("sheet1" and "New Microsoft excel worksheet"). In canvas pane the sheet1 is on the left hand-side but in data view the both data-sets were appearing vice-versa. so I was unable to getting accurate join function data view.


    upload_2018-5-22_10-38-56.png

    Thanks for your help!

    Cheers,
    Siva.
     

    Attached Files:

    #26
  27. _25249

    _25249 Member
    Alumni

    Joined:
    Mar 7, 2018
    Messages:
    2
    Likes Received:
    0
    Hi ,
    After installing tableau always i am getting this error.
    Can Anybody help me.
    2018-05-23_175943.png
     
    #27
  28. _29215

    _29215 Member

    Joined:
    Apr 13, 2018
    Messages:
    3
    Likes Received:
    0
    #28
  29. _29215

    _29215 Member

    Joined:
    Apr 13, 2018
    Messages:
    3
    Likes Received:
    0
    Question for Tushar:
    We are MicroStrategy shop since 19 years with Oracle Data Warehouse.
    We have one of the team in corporate which uses Tableau. They are Microstrategy users since long time too.
    But they want to transition or develop new dashboards in Tableau (at least for those which they think MicroStrategy Visual Insight cannot accomplish). For MicroStrategy we have laid out Attributes and Facts schema objects mapped to Data Warehouse tables columns.
    Can we use these schema objects to develop Tableau dashboards?
    If not, what does it take to develop dashboards based on integrated Data Warehouse database tables / views?
     
    #29
  30. Sushil Ghia

    Sushil Ghia Member
    Alumni

    Joined:
    May 2, 2017
    Messages:
    3
    Likes Received:
    0
    Quick Table Calculation options
     

    Attached Files:

    #30
  31. _20956

    _20956 Member

    Joined:
    Jan 21, 2018
    Messages:
    5
    Likes Received:
    0
    Assignment By The Instructor

    Quick Table Calculation: Percent of Total
    Compute Using: Sub- Category

    This Quick Table Calculation is used to calculate the percentage of the totals. In this Example I have Visualized a Text Table which calculates the Percent of Total along the Sub Category.

    Screen Shot 2018-05-23 at 7.37.51 PM.png


    Quick Table Calculation: Rank
    Compute Using: Table Down and Sub Category

    This Quick Table Calculation is used to Assign Ranks. In this Example I have visualized a text table which allocates Rank to the Subcategories With respect to the Profit and Sales
    Screen Shot 2018-05-23 at 7.38.04 PM.png

    Quick Table Calculation: Running Total
    Compute Using: Table Across

    This Quick Table Calculation is used to calculate the running total of the values. In this example I have visualized a text table to show the running total of Sales across the years.
    Screen Shot 2018-05-23 at 7.38.16 PM.png

    Quick Table Calculation: Difference
    Compute using: Central(Region)

    This Quick table calculation is used to calculate the Difference between the values in the table. In this example I have visualized a text table to show the Difference between the Sum of Sales across all the regions with respect to the Central Region.
    Screen Shot 2018-05-23 at 7.38.27 PM.png
    Quick Table Calculation: Percentile
    Compute Using: State

    This quick table calculation gives us the percentile of the required values. In this example I have Visualized a map to display the percentile along the states .
    Screen Shot 2018-05-23 at 7.38.40 PM.png
     
    #31
  32. _20956

    _20956 Member

    Joined:
    Jan 21, 2018
    Messages:
    5
    Likes Received:
    0
    Exercise 4.1 Filtering the Data
    Screen Shot 2018-05-25 at 7.26.27 PM.png

    • Which region has the highest number of products returned by the customers?
    West
    • How many customers do you have on your list?
    10
     
    #32
  33. _20956

    _20956 Member

    Joined:
    Jan 21, 2018
    Messages:
    5
    Likes Received:
    0
    Exercise 4.2: Grouping, Aliases and Sets
    Screen Shot 2018-05-25 at 7.26.44 PM.png

    • Which are the bottom 2 products?
    Art and Fastener
    • What is the profit ratio for supplies?
    -3%
     
    #33
  34. Shafi Hadimani(1651)

    Alumni

    Joined:
    Oct 9, 2014
    Messages:
    6
    Likes Received:
    0
    Exercise 3.1-Joins and Data Extract

    upload_2018-5-26_1-37-10.png


    Which is the least profitable state? Texas
    Customers from which state have returned the highest number of products?- California
     
    #34
  35. Shafi Hadimani(1651)

    Alumni

    Joined:
    Oct 9, 2014
    Messages:
    6
    Likes Received:
    0
    Exercise 3.2: Data Blending

    upload_2018-5-26_1-39-54.png

    Which categories have vendor item prices above $500? - Cameras, Cell phone, and Accessories, Laptops.
    Between Laptops and Tablets, which category has a lower vendor item price?- Tablets
     
    #35
  36. Shafi Hadimani(1651)

    Alumni

    Joined:
    Oct 9, 2014
    Messages:
    6
    Likes Received:
    0
    #36

Share This Page