Posts

Showing posts from August, 2023

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: Create Groups in Data | Fundamentals

  Please download the dataset: Click for dataset We have learned how groups can support your data analysis needs.  Now let's apply what you've learned about how to create a group within the Data pane in the following activities. The guided activity below will prompt you to take specific actions and provide feedback and guidance along the way. You want to find out average life expectancy for three countries within the Oceania region, and then compare that with other regions.  You will create a group named Oceania for the  three countries, Australia , New Zealand , and Papua New Guinea , and compare the group with the rest of the countries. Step 1: Opening the Starter File Start by launching Tableau and opening the relevant starter file that contains the data you want to work with.   Step 2: Creating the Oceania Group Navigate to the Dimensions pane within Tableau. Locate the arrow icon and click on it to reveal a dropdown menu. From the options presented, choose...

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 ...

Tableau: Create and Modify Data Extracts | Fundamentals

Please download the dataset: Click here for Dataset Now you have a dataset with sales data from around the world, but you want to create a view that displays only the data for each state in the United States. To do this, you need to create a filtered extract specifically for the U.S., including the State field. You can use the "Number of Records" worksheet to verify that your filtering is working correctly. Good luck! Open the starter file in Tableau. Review the grand total on the Number of Records Worksheet and open the Extract Data dialog box.  Click the Number of Records tab to navigate to that worksheet. Note how many records are listed in the grand total on the Number of Records worksheet. Open the Data menu and select the Orders (Superstore Sales Training) data source. Click Extract Data. Configure the extract to show aggregated U.S. Country / Region data for visible fields per year and hide unused fields.  Under Filters, click Add, and in the Add Filterdialog box, sele...

Tableau: Connect to Data Source | Fundamentals

  Please download the dataset: Click for Dataset Step-by-Step Guide: Enhancing Your Tableau Experience with Excel Data Tableau, a powerful data visualization tool, allows you to seamlessly connect to Excel files and transform your data into insightful visualizations, organize your data, and customize field names and data types for a more meaningful analysis. Step 1: Connecting to the Excel File 1. Launch Tableau Desktop. 2. On the Start page, spot and click on "Microsoft Excel". 3. In the Open dialog box, navigate to the location where you've stored your Excel file. 4. Select the Excel file and hit the "Open" button. Step 2: Renaming the Data Source 1. Next to the data source icon, you'll find a name, likely something like "data_connection_practice". 2. Click on the existing name and replace it with a more descriptive title, such as "Orders Data". Step 3: Loading the Orders Sheet 1. Under the "Sheets" section, locate the "O...