Posts

Showing posts with the label #artandanalytics

Tableau:Create and customize measure filters | Fundamentals

Please download the dataset: click for dataset Your manager is particularly concerned about sales in the Central region, and wants to know which products are generating negative profits. You decide it will help to create an additional filter on Profit . Create a filter for the sum of Profit to filter data on negative profit and title it "Adjust View by Profits".  When you are done, your view should look like the image below. Create a filter for Profit to show products that did not generate any profit. Open the starter file Product View Starter.twbx from your saved location. Drag Profit to the Filters shelf. In the Filter Field dialog box, select Sum , and then click Next . Select At Most as the filter type. Type 0 (number) in the text box and then click OK . Show the Profit filter in the view. Right-click the Profit filter in the Filters shelf. Select Show Filter .   Change the title of the Profit filter to Adjust View by Profits . Click the drop-down arrow on the Profi...

Tableau: Create a Hierarchy | Fundamentals

  Please download the dataset: Click for dataset We’ve explored how to create a hierarchy with Tableau. Here’s your opportunity to apply your knowledge by creating a hierarchy using Superstore data. You are working in a sales workbook, and you want to see how sales are ranked within each region by sales person.  To support this analysis,  create a hierarchy that includes Region and Sales Person , and drill down into the hierarchy to compare rankings for each. Good luck! Create a hierarchy called Sales Person by Region using the fields Region and Sales Person . In the Data pane, drag the Sales Person field onto the Region field. This opens a dialog box. Name the hierarchy Sales Person by Region. In the Create Hierarchy dialog box, next to  Name, change Region, Sales Person to Sales Person by Region.  Click OK . Drag the new hierarchy to Rows and expand it. Drag Sales Person by Region to Rows. Click the [+] to drill down. (This can be performed on the sh...

Tableau: Create Groups in View | Fundamentals

   Please download the dataset: Click for dataset You want to quickly compare the income of two separate country groups to determine if tourism is similar based on the size in a treemap. You will create a group from Spain , France , and Germany to compare tourism in the United States within the view. Good luck! Open the starter file in Tableau. Create a group in the treemap that contains Spain , France , and Germany . Group on All Dimensions . In the Income by Region and Country treemap, drag to select Spain , France , and Germany . In the dialog that opens, click the paper clip, then select All Dimensions . Create a second group from a single mark: United States . Click United States to select it.  In the dialog that opens, click the paper clip. Compare the size of each group. If selected, click the United States group again to de-select it. Great work! You’ve created two new groups in your data to compare the size of each in a treemap.

Tableau: Customize data source| Fundamentals

Please download the dataset: click for dataset Now, You have a data source file with hurricane data. You want to customize and save the data source so you can reuse the customized version to build additional workbooks in Tableau. Open the starter file in Tableau. Rename the Lat (deg) and Long (deg) fields to Latitude and Longitude , respectively.  In the Data pane, right-click the Lat (deg) field and select Rename . Type Latitude and press Enter. In the Data pane, right-click the Long (deg) field and select Rename . Type Longitude and press Enter. Convert the Category field to a dimension and change the default sort order to Descending . Drag the Category field from the Measures area to the Dimensions area. Right-click Category , point to Default Properties , and then select Sort . In the Sort dialog box, select Descending . Close the dialog box. Set the geographic role for the Longitude field to Longitude . In the Data pane, right click Longitude . Point to Geographic Role ...