Visualizing Access Data with Data Explore

Visualizing Access Data with Data Explore

This document describes how to track and visualize data about your governance environment over time with Data Explore, part of SailPoint's Access Insights service. 

See the following sections for information:

 

About Data Explore

Making data-informed decisions is crucial to running an effective and innovative identity governance program. Data Explore puts all of your organization's identity data at your fingertips, making it easy to:

  • Monitor new governance-focused metrics across your organization

  • Generate and share interesting insights and knowledge with leadership

  • Present historical data for post-event analysis and reporting

To access Data Explore, click Admin > Dashboard > Data Explore in the SailPoint interface. Use Data Explore's top navigation to access the following:

  • Sources - A list of tables representing the columns of data being tracked, and parameters available for querying

  • Charts - A space to create queries and generate visualizations based on the query results

  • Dashboards - A set of visualizations, including prebuilt and custom combinations of charts

Best Practice:  To follow the principal of least privilege in your IdentityNow system,  grant report admin user level permissions to employees that you want to have view access to the Access History and Data Explore interfaces. For more information, see Report Admin User Level.

 

Exploring Data in Tables

The tables available in Data Explore represent your SailPoint Predictive Identity data source. Tables are defined and maintained by SailPoint.

To explore your tables and see how they affect what can be displayed in visualizations:

  1. In Data Explore, click Sources > Tables to see the list of tables available for your data source.

  2. Click the magnifying glass DataExplore_ShowRecord.png next to a table name, to view additional information on the Show Table page.

    DataExplore_Tables.png

  3. Use the tabs on the Show Table page to determine how your data is exposed and define the fields available in the Charts interface.
  • Detail - Provides detailed information about the table.

  • Columns - Lists table columns and provides selectable parameters that define the fields you see in the Charts page. 

    For example, if the Filterable and Is temporal parameters are both checked for a column, it will be available for filtering when choosing a query time period in the Charts interface. See Creating Charts for more information.

    DataExplore_TableColumns.png

  • Metrics - Displays the metrics available to you when querying the table. Metrics define the value axis for a visualization, so you can see what type of data to expect in a visualization.

    For example, the following images show the COUNT(*) metric and how it is expressed in the Top 10 Departments chart. Because COUNT(*) is the only metric available, you can only view departments by number count.  If multiple metrics exist for a table, you can sort by multiple metrics in your chart. You cannot add or remove metrics.

    DataExplore_metrics.png

    DataExplore_MetricCount_chart.png

 

Creating Charts

Charts are generated from the results of a query, so you'll need to start by creating a query based on the subset or "slice" of data you're interested in.

Your query becomes a chart only after you build a visualization and save it. A chart is a saved query paired with a visualization.

To create a query and generate a visualization for it:

1.  Click Sources > Tables to see the tables available for querying.  See Exploring Data in Tables for more information.

2.  Navigate to the query page. You can start a query in a couple ways:

  • Go to Sources > Tables, and click on a table entry in the list.

  • Go to Charts, and click DataExplore_AddRecord.png to add a new chart. Select a Datasource (table) and Visualization Type, and click Create new chart.

Both ways bring you to the same query / visualization page you use to create charts.

DataExplore_query_visualization.png

  1. On the Data tab, adjust the Visualization Type and Query options. The available query options depend on the type of visualization you choose.

  2. On the Visual Properties tab, adjust visualization properties like color and timestamp format. 

  3. To better understand the data that will be returned for your selections, click theDataExplore_view_icon.png menu in the top right and select to view the query, results, and samples.

  4. Click Run Query to refresh the visualization after you change the type and query options.

3.  When you have finished creating the visualization, click Save to enter a chart name and optionally add the chart to a dashboard.

DataExplore_saveChart.png


If you don't add the chart to a dashboard at this time, it will be available on the Charts page (along with any other charts you have saved), for ad hoc analysis or to be included in a dashboard later. See Displaying Charts in Dashboards for more information.

Working with Charts

Click Charts to access the Charts page which displays a list of all the charts you have saved.

Here, you can work with charts as follows:

  • Filter the chart list
  • Click on a chart name to go to the query / visualization page
  • Inspect and edit chart details
  • Delete charts

Displaying Charts in Dashboards

You can create dashboards that include multiple charts to provide a more complete and personalized view of your data. The information in each chart automatically refreshes every time you access a dashboard that includes that chart.

To see a list of existing dashboards, click Dashboards in Data Explore.

NOTE:  A dashboard can only be edited by its creator, but you can save a copy of any dashboard with a different name and then make changes to the new dashboard.

Exploring Prebuilt Dashboards

Data Explore comes with prebuilt dashboards to provide you with a clear and comprehensive view of key governance data across your organization. 

To explore these prebuilt dashboards, click Dashboards, then click on either Employee Dashboard, Request Statistics, or Certification Statistics.

You can click  DataExplore_moreIcon.png  on any chart in a dashboard to dive deeper into the individual chart's query and adjust the chart settings. See Creating Charts for more information.

NOTE: Your organization's configuration determines the data available for display and the available filters, so you might not see data in all of the charts in a prebuilt dashboard. 

 

Employee Dashboard

The Employee dashboard provides a snapshot of your core identity data and allows you to dynamically filter by identity attributes. 

For example, filter by Finance for department and San Francisco for location to see how many new identities have been added in the last quarter to the San Francisco office's Finance department or see the top roles held by identities in that department and location.  

This dashboard includes the following charts: 

  • Number of identities

  • New identities by quarter

  • Accounts by source

  • Employees by department by location

  • Employees by location by title

  • Employees by state
  • Top job titles

  • Top roles

  • Launchpad apps

  • Top access profiles

  • Top entitlements

 

Request Statistics Dashboard

The Request Statistics dashboard provides a number of views into your request activity, such as application, entitlement, and role requests by popularity, location, and department.

For example, you can see your organization's most-requested applications to inform IT investment decisions or help determine which apps new hires will likely need to access.

This dashboard includes the following charts:

  • Number of requests by department - 1 yr

  • Number of requests by location - 1 yr 

  • Average request time by location

  • Most requested entitlements
  • Most requested roles

  • Most requested applications

  • Approved vs rejected by app

 

Certification Statistics Dashboard

The Certification Statistics dashboard uncovers data about your certifiers and certification activity, helping you improve and ensure adherence to governance policies. You can filter by certifier location, department, and job title to further focus your exploration.

For example, filter by the Accounting department to see your top certifiers' activity in that department, possible issues with certification timelines, and Accounting-wide certification activity.

The Certification Statistics dashboard includes the following charts:

  • Most revoked entitlements

  • The number of decisions by department

  • Top certifiers with analytics around their approval activity

  • Late certifiers and their number of days late


Creating a New Dashboard

You can create your own dashboards to supplement the prebuilt dashboards that SailPoint provides.

NOTE:  You need at least one chart to create a dashboard. If you have not created any charts, do that first, or use existing charts from the list on the Charts page.

There are two ways to create a new dashboard: on the Dashboards page or when saving a new chart.

On the Dashboard page:

  1. Click Dashboards, and then click DataExplore_AddRecord.png to add a new dashboard.

  2. Provide the following information for your dashboard: a title, the charts to include, the owner, and any JSON and CSS to use to customize the dashboard.

  3. Click Save to create the dashboard.

When saving a new chart:

  1. When saving a new chart, select Add to new dashboard and enter a name for the dashboard.

  2. Click Save & go to dashboard. Your new chart appears in your new dashboard.

Your new chart and dashboard also appear in the lists on the Charts page and Dashboards page, respectively.

 

Sharing and Exporting Data, Visualizations, and Dashboards

You can easily export and share your data, visualizations, or dashboards with others.

Exporting Data 

Table and chart data on the query / visualization page can be exported as a CSV or JSON file.

  • Click  DataExplore_json_button.png  to export the .json file and save or copy the data.

  • Click  DataExplore_csv_button.png  to save data as a .csv file.

Sharing Visualizations

On the query / visualization page, click  DataExplore_llink_button.png  to copy the URL associated with the visualization, and share it with other authenticated users.

Sharing Dashboards

On a Dashboard page, click Edit dashboard > Share dashboard to copy the URL associated with the dashboard and share it with other authenticated users.

 

Labels (1)
Version history
Revision #:
9 of 9
Last update:
‎Oct 06, 2020 05:06 PM
Updated by:
 
Contributors