Tuesday, July 11, 2023

How to Add new Story in Tableau?

 To add a new story in Tableau, you can follow these steps:

  1. Open your Tableau workbook.
  2. In the bottom left corner of the Tableau window, click on the "New Story" button. It looks like a blank sheet of paper with a star icon.
  3. A new blank story will be created, and you will be taken to the story editing interface.
  4. To add a sheet or visualization to the story, go to the "Sheets" pane on the left side of the Tableau window.
  5. Drag and drop a sheet or visualization from the "Sheets" pane onto the story canvas in the center of the Tableau window. This adds the selected sheet as a slide in your story.
  6. To rearrange the order of slides in the story, click and drag a slide to the desired position.
  7. To add captions or annotations to a slide, click on the slide to select it, and then click on the "Add Caption" button at the top of the story canvas. Enter the desired text in the caption box.
  8. Customize the appearance of the story:

    1. To change the layout of a slide, select the slide and click on the "Layout" button at the top of the story canvas. Choose from various layout options available.
    2. To apply formatting to the entire story, use the options in the "Story" dropdown menu in the top menu. You can modify fonts, colors, backgrounds, and other visual elements.
  9. Continue adding slides, captions, and formatting as needed to build your story.
  10. To preview the story, click on the "Play" button at the top of the story canvas. This allows you to view the story as a slideshow and navigate through the slides.
  11. Save your workbook to preserve the new story you have created.

Stories in Tableau are a way to present a series of visualizations or insights in a narrative format, guiding viewers through a sequence of slides. By leveraging the story feature, you can create compelling data-driven narratives that effectively communicate your findings and analysis.

How to Add Phone Layout in New Dashboard in Tableau?

To create a new dashboard with a phone layout in Tableau, you can follow these steps:

  1. Open your Tableau workbook.
  2. In the top menu, go to "Dashboard" and select "New Dashboard." A blank dashboard canvas will appear.
  3. In the new dashboard, go to the top menu and click on the "Device Preview" button. This button resembles a computer and a phone icon.
  4. The device preview window will appear, showing a preview of your dashboard on different devices. By default, it will display the desktop layout.
  5. Click on the phone icon in the device preview window to switch to the phone layout.
  6. In the phone layout view, you will see the blank dashboard displayed in a vertical orientation, resembling a phone screen.
  7. Start adding components to the phone layout:

    1. To add a worksheet: Drag and drop a worksheet from the "Sheets" pane onto the phone layout canvas.
    2. To add titles or text boxes: Go to the "Dashboard" dropdown in the top menu and select "Insert" to add titles or text boxes.
    3. To add other components: You can add images, filters, legends, and other dashboard components using the options available in the top menu.
  8. Adjust the phone layout as needed:

    1. Rearrange the components: Click and drag the components (worksheets, titles, text boxes, etc.) to reposition them within the phone layout. You can resize the components by dragging their edges to fit the phone screen.
    2. Modify formatting: Customize the fonts, colors, and other formatting options for the phone layout by selecting and formatting individual components.
  9. Use the device preview toolbar to switch between phone layouts for different screen sizes (such as iPhone, Android, or custom sizes), and preview how your dashboard will appear on various devices.
  10. Once you have added and formatted the components in the phone layout, click on the "Device Preview" button again to exit the device preview mode.
  11. Save your workbook to preserve the new dashboard with the phone layout.

By creating a new dashboard with a phone layout, you can design and optimize your dashboard specifically for mobile devices, providing a seamless and user-friendly experience for viewers accessing your dashboard on their phones or tablets. 

How to Add Phone layout in existing Dashboard in Tableau?

 To add a phone layout to an existing dashboard in Tableau, you can follow these steps:


  1. Open your Tableau workbook and navigate to the dashboard where you want to add the phone layout.
  2. In the top menu, click on the "Device Preview" button. This button resembles a computer and a phone icon.
  3. The device preview window will appear, showing a preview of your dashboard on different devices. By default, it will display the desktop layout.
  4. Click on the phone icon in the device preview window to switch to the phone layout.
  5. In the phone layout view, you will see the dashboard displayed in a vertical orientation, resembling a phone screen. The components of your dashboard might be rearranged or resized to fit the phone layout.
  6. Adjust the phone layout as needed:

    • Rearrange the components: Click and drag the components (worksheets, titles, text boxes, etc.) to reposition them within the phone layout. You can resize the components by dragging their edges to fit the phone screen.
    • Hide or show components: Right-click on a component and select "Hide" or "Show" to control the visibility of specific elements in the phone layout.
    • Modify formatting: Customize the fonts, colors, and other formatting options for the phone layout by selecting and formatting individual components.
  7. Use the device preview toolbar to switch between phone layouts for different screen sizes (such as iPhone, Android, or custom sizes), and preview how your dashboard will appear on various devices.
  8. Once you have made the necessary adjustments to the phone layout, click on the "Device Preview" button again to exit the device preview mode.
  9. Save your workbook to preserve the changes you made to the phone layout.

By adding a phone layout to your existing dashboard, you can ensure that your dashboard is responsive and optimized for mobile devices, providing a better user experience for viewers accessing your dashboard on their phones or tablets.

How to use Action Filter in Tableau?

 Action filters in Tableau allow you to create interactivity between different components of your dashboard. They enable users to select data points in one visualization, which then dynamically filters or highlights related data in other visualizations within the same dashboard.

Here's a step-by-step guide on how to use action filters in a Tableau dashboard:

  1. Open your Tableau workbook and navigate to the dashboard where you want to use action filters.
  2. Create the visualizations that you want to interact with each other. These visualizations can be worksheets or charts that are part of your dashboard.
  3. Select the source visualization: Determine the visualization from which you want to trigger the action. This will be the visualization that users interact with to apply filters.
  4. Right-click on the source visualization and select "Create > Action." A dialog box will appear.
  5. In the Action dialog box, choose "Filter" as the action type. This means that the action will apply a filter to the target visualization(s) based on user selections in the source visualization.
  6. Specify the target visualization(s): Select the visualization(s) that you want to be filtered or highlighted based on the user's interaction in the source visualization. You can choose multiple target visualizations.
  7. Configure the action settings:

    By default, the action will be triggered when the user selects a data point in the source visualization. You can customize this behavior by choosing different trigger options like hover or menu selection.
  8. Choose the fields that will be used to filter the target visualization(s). You can select one or more fields, depending on your requirements.
  9. Specify how the filter should be applied in the target visualization(s), such as adding the selection as a new filter or replacing existing filters.
  10. Customize the action's appearance (optional): You can add a tooltip or highlight effect to provide visual feedback to users when they interact with the source visualization. These options are available in the Action dialog box under the "Run action on" section.
  11. Click "OK" to save the action.
  12. Preview and test the dashboard: Interact with the source visualization to see how the action filter affects the target visualization(s). Verify that the filter is applied correctly and that the desired data is displayed based on user selections.

By using action filters, you can create dynamic and interactive dashboards that allow users to explore and analyze data in a more engaging and intuitive way.

How to Clear the Dashboard in Tableau?

 To clear a dashboard in Tableau and remove all the components and formatting, you can follow these steps:

  1. Open your Tableau workbook and navigate to the dashboard you want to clear.
  2. In the top menu, go to the "Dashboard" dropdown.
  3. From the dropdown menu, select "Clear" or "Clear Layout" option. The exact wording may vary depending on the version of Tableau you are using.
  4. A confirmation dialog box will appear asking if you want to clear the dashboard. Click "OK" or "Yes" to proceed.

After confirming, all the components, such as worksheets, titles, captions, text boxes, and formatting within the dashboard, will be removed. The dashboard will be left blank with a clean canvas.

Please note that this action cannot be undone, so make sure to save your workbook before clearing the dashboard. If you accidentally clear the dashboard and want to retrieve the previous layout, you can use the Undo option (Ctrl + Z or Command + Z) immediately after clearing the dashboard.

How to Format Dashboard in Tableau?

Formatting a dashboard in Tableau involves various aspects such as adjusting the size and layout, adding titles and captions, customizing colors and fonts, and applying other visual elements. Here's a step-by-step guide on how to format a dashboard in Tableau:

  1. Open your Tableau workbook and navigate to the dashboard you want to format.


  2. 1.Adjust the size and layout:

    • To change the size of the dashboard, go to the "Size" dropdown in the top menu and select a preset size or specify a custom size.
    • To modify the layout, drag the edges of the individual worksheets within the dashboard to resize them or rearrange their position by dragging and dropping.

  3. 2.Add titles and captions:

    • To add a title to the dashboard, go to the "Dashboard" dropdown in the top menu and select "Show Title." Then, click on the newly displayed title area to enter the desired text.
    • To add captions or text boxes, go to the "Dashboard" dropdown and select "Insert Text." Click on the desired location within the dashboard to enter text and format it using the formatting toolbar.

  4. 3.Customize colors and fonts:

    • To modify the color scheme of the dashboard, go to the "Format" dropdown in the top menu and select "Workbook Theme" to choose from available themes or customize individual colors using the "Palette" option.
    • To change fonts, go to the "Format" dropdown and select "Workbook Theme." From there, click on "Edit Colors" and choose the desired font styles and sizes for various elements, such as titles, labels, and tooltips.

  5. 4.Apply visual elements:

    • To add a border to the entire dashboard, go to the "Format" dropdown, select "Borders," and choose the desired border style and width.
    • To apply a background color or image to the dashboard, go to the "Format" dropdown, select "Shading," and select the desired background options.

  6. 5.Fine-tune individual components:

    • Click on each worksheet within the dashboard to access its specific formatting options. You can adjust the size, fonts, colors, labels, tooltips, and other settings for each worksheet independently.

  7. 6.Test and refine:

    • Preview the dashboard by clicking the "Show Dashboard" button in the bottom left corner to see how it looks and make any necessary adjustments.
    • Save your changes and continue refining the formatting until you achieve the desired appearance.

Remember, formatting options may vary slightly depending on the version of Tableau you're using, but these general steps should provide a good starting point for formatting your dashboard. 

what is Show Grid in Dashboard in Tableau?

 In Tableau, the "Show Grid" feature in the dashboard refers to a setting that allows you to display a grid of horizontal and vertical lines on the dashboard canvas. This grid helps you align and position the various components of your dashboard, such as worksheets, text, images, and other objects.

Enabling the "Show Grid" option provides a visual guide that helps you create a clean and organized layout. The grid lines are evenly spaced and provide a reference for placing and aligning objects precisely. This feature is particularly useful when you want to ensure consistent spacing and alignment across multiple elements on your dashboard.


To toggle the "Show Grid" feature in Tableau, you can follow these steps:


  1. Open your Tableau workbook and navigate to the dashboard you want to work on.
  2. In the top menu, go to "Format."
  3. From the drop-down menu, select "Preferences."
  4. In the Preferences dialog box, you will find a section called "Dashboard Grid."
  5. Check the box next to "Show Grid" to enable it or uncheck it to disable it.
  6. Click the "OK" button to apply the changes.

Once you enable the grid, you will see the horizontal and vertical lines displayed on the dashboard canvas, making it easier for you to align and position your dashboard components precisely.

It's worth noting that the "Show Grid" feature is a visual aid and does not affect the actual functionality or behavior of your dashboard.

Tuesday, July 4, 2023

How to create device Layout of Dashboard in Tableau?

 To create a device layout in a Tableau dashboard, you can use the Device Preview feature, which allows you to design and optimize your dashboard for different device sizes. Follow these steps:

  1. Open Tableau: Launch Tableau Desktop and open the workbook that contains the dashboard you want to create a device layout for.
  2. Navigate to the Dashboard Tab: At the bottom of the Tableau window, locate the dashboard tab and click on it to access the Dashboard tab.
  3. Enable Device Preview: In the Dashboard tab, go to the "Layout" menu at the top and click on the "Device Preview" option. This will enable the device layout functionality.
  4. Select a Device: Tableau provides a list of common devices to choose from, such as desktop, tablet, and phone. Click on the device icon that represents the desired screen size and resolution you want to design for.
  5. Customize the Device Layout: Once you select a device, the dashboard canvas will adjust to the chosen screen size. Resize and rearrange the components on the dashboard canvas to optimize their placement for the specific device. You can drag and drop worksheets, objects, and containers to adjust their position and size.
  6. Switch Devices: To design for other devices, simply click on the device icon again and select a different device size. Tableau will adapt the canvas to the new device's dimensions, allowing you to make further adjustments to the layout.
  7. Preview and Test: As you design the device layout, you can preview how the dashboard will appear on different devices. Click on the "Preview" button in the Device Preview toolbar to see how the dashboard will look for the selected device. You can interact with the visualizations and test their responsiveness.
  8. Customize Layouts for Multiple Devices: Repeat steps 4 to 7 to create optimized layouts for various devices you want to support, such as desktop, tablet, and phone. Customize the components and rearrange them to ensure an optimal user experience on each device.
  9. Save the Workbook: Once you have designed and customized the device layouts, save your Tableau workbook to retain all the configurations. Go to "File" > "Save" to save the workbook in the desired location on your computer.

By utilizing the Device Preview feature in Tableau, you can create device-specific layouts to ensure your dashboards are responsive and optimized for different screen sizes. This allows viewers to have an optimal experience, whether they are accessing the dashboard from a desktop computer, tablet, or mobile phone.

How to Create a new Dashboard in Tableau?

 To create a new dashboard in Tableau, you can follow these steps:

  1. Open Tableau: Launch Tableau Desktop, which is the application where you create and manage your Tableau workbooks.
  2. Open a Workbook: Either open an existing workbook or create a new one by going to the "File" menu and selecting "New Workbook."
  3. Navigate to the Dashboard Tab: At the bottom of the Tableau window, locate the dashboard tab and click on it to access the Dashboard tab.
  4. Create a New Dashboard: Once in the Dashboard tab, click on the "New Dashboard" button, which is represented by a blank page icon. Alternatively, you can go to the "Dashboard" menu at the top and select "New Dashboard."
  5. Customize the Dashboard Layout: Tableau will open a blank canvas for your new dashboard. On the left side of the screen, you'll find the "Objects" pane with various components you can add to your dashboard, such as sheets, filters, legends, and more. Drag and drop the desired components onto the dashboard canvas to customize its layout.
  6. Add Sheets and Objects: To populate the dashboard with visualizations, drag worksheets or sheet tabs from the "Sheets" pane on the left side of the screen and drop them onto the desired position within the dashboard canvas. You can resize and rearrange the components as needed.
  7. Customize the Dashboard Appearance: Use the formatting options available in Tableau to adjust the appearance of the dashboard. You can modify the font style, color palette, background, borders, and other visual elements to align with your desired design.
  8. Interact with Dashboard Objects: Click on individual worksheets or objects within the dashboard to interact with them. You can apply filters, drill down into data, and perform other actions based on the configuration of your visualizations.
  9. Save the Workbook: Once you have created and customized your dashboard, remember to save your Tableau workbook to retain all the dashboard configurations and visualizations. Go to "File" > "Save" to save the workbook in the desired location on your computer.


That's it! You have successfully created a new dashboard in Tableau. You can continue refining and updating the dashboard by adding additional sheets, modifying the layout, or applying filters and interactions to enhance the user experience.

How to Relace Datasource in a workbook in Tableau?

 To replace a data source in Tableau with a different one while maintaining the existing workbook structure, you can follow these steps:

  • Open the Workbook: Launch Tableau Desktop and open the workbook that contains the data source you want to replace.
  • Navigate to the Data Source Tab: At the bottom of the Tableau window, locate the data source tab and click on it to access the Data Source tab.
  • Identify the Current Data Source: In the Data Source tab, find the current data source that you want to replace. Take note of its name and the fields it contains.
  • Connect to the New Data Source: Go to the "Data" menu at the top and select "New Data Source." Alternatively, you can click on the "Connect" pane on the left sidebar.
  • Choose the New Data Source: Select the appropriate data source type for your new data, such as a file, database, or other supported sources. Specify the connection details and locate the new data source.
  • Map Fields (if necessary): If the new data source has different field names or structures compared to the original data source, you may need to map the fields manually. Tableau will attempt to automatically match fields, but you can make adjustments as needed.
  • Replace the Data Source: Once the new data source is connected and the fields are mapped (if required), right-click on the original data source in the Data Source tab and select "Replace Data Source" from the context menu.
  • Select the New Data Source: In the Replace Data Source dialog box, choose the new data source you connected in step 5 from the available options.
  • Verify and Update Field Mappings: Tableau will attempt to map the fields from the old data source to the fields in the new data source. Review the field mappings and make any necessary adjustments to ensure the correct mapping of data.
  • Apply Changes: Click on the "OK" button to replace the data source. Tableau will update the workbook to use the new data source while maintaining the existing worksheets and visualizations.
  • Validate and Update Worksheets: Review the worksheets in your workbook to ensure that the new data source is functioning as expected. Check that the data is correctly displayed and any calculations or visualizations are updated accordingly.

By replacing the data source, you can seamlessly switch to a new data set without having to recreate or modify your existing Tableau workbook extensively.

How can you create an alias for a table in a SQL query?

In SQL, you can create an alias for a table in a query to give the table a temporary, alternative name that you can use in the query. Table ...