Read draft, twbx files attached and review the worksheets and data sources.
Make at least three substantial comments/suggestions (at least 100 words each).
Requirements for your three comments:
- (2 * 10pts = 20 pts) For two of your comments, review two of the six charts in their draft. For each chart:
- Review the worksheet and data source in Tableau. Do their numbers make sense? Are appropriate aggregations performed? Is the data source appropriate (data formatted correctly)? To receive full credit, please demonstrate that you opened their Tableau files and reviewed the data source and worksheets.
- Name or list any problems and suggest solutions. If you cannot find any problems, describe how the chart demonstrates concepts or principles that we have covered. Similar to your discussion posts, remember to tell your reader where in the readings and materials you found the concepts.
- (10pts) One of your comments should address other elements of their draft. Some examples: Did they ask good questions and use the right charts to address those questions? Did they make appropriate conclusions?
Other recommended exercises in your review:
- Each comment should help improve this project.
- Each comment should give enough context to help all readers learn.
- Each comment should quote or reference at least one of our class materials and apply a concept that we have covered.
- Please make sure the readers can easily follow your comments and find the sections/graphs that you refer to.
Part 3.twb
0 [Orders] Count true 0 "A1:U9995:no:A1:U9995:0" true 6 Row ID 20 [Row ID] [Orders] Row ID 0 integer Sum true "I8" [Orders_54361BFB766C46558B791A04A1CE3C9B] Order ID 130 [Order ID] [Orders] Order ID 1 string Count true "WSTR" [Orders_54361BFB766C46558B791A04A1CE3C9B] Order Date 7 [Order Date] [Orders] Order Date 2 date Year true "DATE" [Orders_54361BFB766C46558B791A04A1CE3C9B] Ship Date 7 [Ship Date] [Orders] Ship Date 3 date Year true "DATE" [Orders_54361BFB766C46558B791A04A1CE3C9B] Ship Mode 130 [Ship Mode] [Orders] Ship Mode 4 string Count true "WSTR" [Orders_54361BFB766C46558B791A04A1CE3C9B] Customer ID 130 [Customer ID] [Orders] Customer ID 5 string Count true "WSTR" [Orders_54361BFB766C46558B791A04A1CE3C9B] Customer Name 130 [Customer Name] [Orders] Customer Name 6 string Count true "WSTR" [Orders_54361BFB766C46558B791A04A1CE3C9B] Segment 130 [Segment] [Orders] Segment 7 string Count true "WSTR" [Orders_54361BFB766C46558B791A04A1CE3C9B] Country 130 [Country] [Orders] Country 8 string Count true "WSTR" [Orders_54361BFB766C46558B791A04A1CE3C9B] City 130 [City] [Orders] City 9 string Count true "WSTR" [Orders_54361BFB766C46558B791A04A1CE3C9B] State 130 [State] [Orders] State 10 string Count true "WSTR" [Orders_54361BFB766C46558B791A04A1CE3C9B] Postal Code 20 [Postal Code] [Orders] Postal Code 11 integer Sum true "I8" [Orders_54361BFB766C46558B791A04A1CE3C9B] Region 130 [Region] [Orders] Region 12 string Count true "WSTR" [Orders_54361BFB766C46558B791A04A1CE3C9B] Product ID 130 [Product ID] [Orders] Product ID 13 string Count true "WSTR" [Orders_54361BFB766C46558B791A04A1CE3C9B] Category 130 [Category] [Orders] Category 14 string Count true "WSTR" [Orders_54361BFB766C46558B791A04A1CE3C9B] Sub-Category 130 [Sub-Category] [Orders] Sub-Category 15 string Count true "WSTR" [Orders_54361BFB766C46558B791A04A1CE3C9B] Product Name 130 [Product Name] [Orders] Product Name 16 string Count true "WSTR" [Orders_54361BFB766C46558B791A04A1CE3C9B] Sales 5 [Sales] [Orders] Sales 17 real Sum 15 true "R8" [Orders_54361BFB766C46558B791A04A1CE3C9B] Quantity 20 [Quantity] [Orders] Quantity 18 integer Sum true "I8" [Orders_54361BFB766C46558B791A04A1CE3C9B] Discount 5 [Discount] [Orders] Discount 19 real Sum 15 true "R8" [Orders_54361BFB766C46558B791A04A1CE3C9B] Profit 5 [Profit] [Orders] Profit 20 real Sum 15 true "R8" [Orders_54361BFB766C46558B791A04A1CE3C9B] "[federated.0l5scg70xff1111459k6t0ja5pty].[avg:Calculation_26177180016398336:qk]" "[federated.0l5scg70xff1111459k6t0ja5pty].[sum:Calculation_26177180016398336:qk]" "[federated.0l5scg70xff1111459k6t0ja5pty].[avg:Profit:qk]" "Central" "West" "South" "East" "Furniture" "Technology" "Office Supplies" Average Profit by Year Region [federated.0l5scg70xff1111459k6t0ja5pty].[avg:Profit:qk] [federated.0l5scg70xff1111459k6t0ja5pty].[yr:Ship Date:ok] Average Profit by Year Region [federated.0l5scg70xff1111459k6t0ja5pty].[avg:Profit:qk] [federated.0l5scg70xff1111459k6t0ja5pty].[yr:Ship Date:ok] Profit by Region and Category [federated.0l5scg70xff1111459k6t0ja5pty].[none:Region:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:State:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Category:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Sub-Category:nk] ([federated.0l5scg70xff1111459k6t0ja5pty].[none:Region:nk] / [federated.0l5scg70xff1111459k6t0ja5pty].[none:Category:nk]) [federated.0l5scg70xff1111459k6t0ja5pty].[avg:Profit:qk] Profit by Region and Category [federated.0l5scg70xff1111459k6t0ja5pty].[none:Region:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:State:nk] ([federated.0l5scg70xff1111459k6t0ja5pty].[none:Region:nk] / ([federated.0l5scg70xff1111459k6t0ja5pty].[none:Category:nk] / [federated.0l5scg70xff1111459k6t0ja5pty].[none:Sub-Category:nk])) [federated.0l5scg70xff1111459k6t0ja5pty].[sum:Profit:qk] Profit Map [federated.0l5scg70xff1111459k6t0ja5pty].[Latitude (generated)] [federated.0l5scg70xff1111459k6t0ja5pty].[Longitude (generated)] Average Profit by Region and State [federated.0l5scg70xff1111459k6t0ja5pty].[none:Region:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:State:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Sub-Category:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Category:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[:Measure Names] ([federated.0l5scg70xff1111459k6t0ja5pty].[none:Region:nk] / ([federated.0l5scg70xff1111459k6t0ja5pty].[none:State:nk] / [federated.0l5scg70xff1111459k6t0ja5pty].[none:Category:nk])) ([federated.0l5scg70xff1111459k6t0ja5pty].[:Measure Names] * [federated.0l5scg70xff1111459k6t0ja5pty].[avg:Profit:qk]) Return on Sales % [federated.0l5scg70xff1111459k6t0ja5pty].[none:Sub-Category:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[yr:Ship Date:ok] Return on Sales % 2014 2018 [federated.0l5scg70xff1111459k6t0ja5pty].[yr:Ship Date:qk] [federated.0l5scg70xff1111459k6t0ja5pty].[avg:Calculation_26177180016398336:qk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Sub-Category:nk] Return on Sales % [federated.0l5scg70xff1111459k6t0ja5pty].[none:Category:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Sub-Category:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Region:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:State:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[yr:Ship Date:ok] [federated.0l5scg70xff1111459k6t0ja5pty].[avg:Calculation_26177180016398336:qk] [federated.0l5scg70xff1111459k6t0ja5pty].[avg:Calculation_26177180016398336:qk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Sub-Category:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[sum:Profit:qk] ([federated.0l5scg70xff1111459k6t0ja5pty].[none:Category:nk] / [federated.0l5scg70xff1111459k6t0ja5pty].[none:Sub-Category:nk]) ^^^^^^^^ Use the filters along the right hand side to adjust your view ^^^^^^^^ Use the filters along the right hand side to adjust your view [federated.0l5scg70xff1111459k6t0ja5pty].[none:Sub-Category:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[yr:Ship Date:ok] [federated.0l5scg70xff1111459k6t0ja5pty].[:Measure Names] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Category:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Region:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:State:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Sub-Category:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[yr:Ship Date:ok] [federated.0l5scg70xff1111459k6t0ja5pty].[yr:Ship Date:qk] [federated.0l5scg70xff1111459k6t0ja5pty].[:Measure Names] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Category:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Region:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Sub-Category:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[yr:Ship Date:ok] [federated.0l5scg70xff1111459k6t0ja5pty].[yr:Ship Date:qk] [federated.0l5scg70xff1111459k6t0ja5pty].[:Measure Names] [federated.0l5scg70xff1111459k6t0ja5pty].[__tableau_internal_object_id__].[cnt:Orders_54361BFB766C46558B791A04A1CE3C9B:qk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Category:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Region:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:State:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Sub-Category:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Category:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Region:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Sub-Category:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[:Measure Names] [federated.0l5scg70xff1111459k6t0ja5pty].[__tableau_internal_object_id__].[cnt:Orders_54361BFB766C46558B791A04A1CE3C9B:qk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Category:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Region:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:State:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Sub-Category:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Category:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Region:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[yr:Ship Date:ok] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Category:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[none:Region:nk] [federated.0l5scg70xff1111459k6t0ja5pty].[yr:Ship Date:ok]