Key Task: Analyze Multiple Data Sources

Use Analyze Multiple Data Sources to build dashboard that includes widgets from multiple data sources in order to provide a holistic view that correlates between data of different types.

For example, understand the impact of OS version on applications performance, or analyze number of crashes and resource utilization in a single view.

Procedure

  1. Step 1 Open a browser and sign in to Aternity.
  2. Step 2 SelectMain Menu > Analyze > Multiple Data Sources.
    Select what kind of data you want to analyze
  3. Step 3 Select a data source for the first widget and click Go.
    Field Description
    Applications

    This data source provides data you need to investigate your own theories on any application's performance (including discovered applications with no activities defined).

    Learn how to customize an advanced dashboard to analyze Applications.
    Business Activities

    This data source provides data you need to investigate your own theories on any managed application's activity performance.

    Learn how to customize an advanced dashboard to analyze Business Activities.
    Device Health

    This data source provides data you need to track errors and crashes throughout your organization by viewing the latest individual health events with all of their details. Use this data source to analyze for patterns with specific types of health events to find correlations with attributes like the device model, RAM, location, and disk type.

    Learn how to customize an advanced dashboard to analyze Device Health.
    Host Resources

    This data source provides data you need to investigate correlations between attributes that relate to host resources, using the customization features of the advanced dashboard.

    Learn how to customize an advanced dashboard to analyze Host Resources.
    Installed Software

    This data source provides data you need to analyze the current status of software deployment across your entire organization.

    Learn how to customize an advanced dashboard to analyze Installed Software.
    Installed Software Changes

    This data source provides data you need to check and analyze the installed software related changes on each Windows physical monitored device, along with its version and deployment date.
    Process Resources

    This data source provides data to investigate your own theories on any managed application's resource usage (PRC), which would slow down devices.

    Learn how to customize an advanced dashboard to analyze Process Resources.
    Remediation

    This data source provides information about the executed remediation actions and their results/states.
  4. Step 4 Customize the dashboard by dragging measures and dimensions to the Columns and Rows bar, so that you can compare specific attributes.
    Drag measures and dimensions to the Columns and Rows fields in the top bar
  5. Step 5 To display a filter of this value in the right pane of the dashboard, hover over the attribute, open its drop-down menu, and select Show Filter.
    Alternatively, drag this attribute to the Filters section.
    Add filter for further correlation of data

    For more information on the full editing capabilities of this dashboard, see http://www.tableau.com/learn/training. View the following training sections:

    • Visual Analytics

    • Calculations

    • Tableau Server

    • How To

  6. Step 6 Click Create new sheet in the bottom of the screen and then select a data source for the second widget, either a different one or the same one.

    Each widget is associated with one data source. You can create multiple widgets and associate them to data sources as you need.

    You can rename each widget and dashboard.

    Create a second worksheet with a different data source
    Tip

    If you receive a communication error 504, ensure that your dashboard does not list too many rows (like all your device names or usernames). You can narrow the scope of the data displayed by selecting Show Filter for that attribute and selecting the values to display. To further improve dashboard performance, select Aggregation Type > Hourly or Daily, and do not include Tableau's level of detail expressions.

  7. Step 7 Click Create a new dashboard in the bottom of the screen and then drag the Sheets to the middle of the screen.

    Arrange the sheets in the most convenient way to view data, either in rows or in columns.

    Create a new dashboard using multiple widgets
  8. Step 8 Use Filter to allow filtering between widgets.
    Note

    Note that filtering works even between widgets that use different data sources.

    Note that filtering requires that in both widgets from different data sources will be at least one identical column name, otherwise filter does not work.

  9. Step 9 Save dashboard.