Create an analysis

You can create an analysis for each dataset and customize how you want to present the engagement data in the visualization.

To create an analysis:

  1. From the Cloud menu (), select Sherlock Builder.

    An interactive frame powered by Amazon QuickSight displays.

  2. Select the Analyses tab.

    A list of existing analyses displays.

  3. Select New analysis.

    The Sherlock BI Builder interface with the New analyses button highlighted.

  4. Select the applicable dataset for the analysis. Available datasets include:

    • accountsummary
    • cv (CaseView)
    • cvcontrol
    • cvmlp (management letter points)
    • cvrisk
    • groupings
    • hi (history)
    • mappings
    • metadata (engagement properties)
    • sh (document)
    • trialbalance
    • ts (issues)
    • user
    • usergroup

    For more information on these datasets and their uses for data visualizations, see Datasets for Sherlock visualizations.


    • Dataset names are appended with the firm's short name (e.g. trialbalance-testfirm-001).
    • The entityrls dataset contains entity level security information and should not be used as the dataset for an analysis or shared with others.
  5. Select Create analysis.

    The dataset confirmation dialog with the Create analysis button highlighted.

  6. Customize the analysis.

    To learn more, see Working with Analyses and the related subtopics.

    The interface for designing an analysis.

  7. If you want to collaborate on the analysis with other Sherlock Builder users in your firm, select Share () | Share analysis.

    The Share analysis dialog displays.

  8. Enter each user's email and select Share.

    The Share analysis dialog with the Share field and Share button highlighted.