Overview

This guide teaches how to perform Assisted Discovery through Yellowfin's Report Builder.

Procedure

1. Create a new report using the Report Builder in the normal way. Drag in the values that you want included in the report.
   
   

   Automated insights only works with standards reports, it doesn’t support cross-tab reports. When building a report for Automated Insights, only add values to the columns section.

2. Click on the Smart Analysis button.
   
   
   
   
3. An Insight Wizard will appear. Use it to make selections so that it generates the most appropriate insights.
   
   
   
   
4. Select the type of analysis that you want to do. For example understanding the drivers for a single metric, or comparing metrics or dimensions to understand differences. Depending on the option selected, additional information needs to be provided.
5. Here’s an overview of these options:
   • Explain Metric: Choose this option to allow Yellowfin to better explain a single metric. Yellowfin will identify related data that most influences the chosen metric. The specific metric of interest needs to be selected from the next drop down.  For example, you may want to understand Actual Revenue (metric). 
     
     
     
     
   • Compare Metrics: This option compares the values and drivers of two chosen metrics.  For example, you may want to compare Actual Revenue (metric) to Planned Revenue (metric).
     
     
     
     
   • Compare Dates: Use this option to compare a single metric across two time periods. You will need to select the specific date field that represents the time period, the metric you want to compare, and the two time periods that you want to compare. For example, you may want to compare Actual Revenue (metric) for Sales Date (date field) from this year to last year (time periods). 
     
     
     
     
   • Compare Dimensions: Use this option to compare a metric across two dimensions. You will need to select the dimension that you want to compare, the metric that you are comparing, and then the specific values of the dimension. For example, you may want to compare Invoiced Amount (metric) between Regions (dimension) Asia and Europe (dimension values). 
     
     
     
     
6. You can expand the Advanced Settings option to apply a few additional preferences to your automated chart creation. 
   
   
   
   
   • Let the wizard know whether higher data values are good or bad for the result you have in mind. For example, higher values of Sales are good.
   • You can also select and deselect specific fields to be included in the analysis. For example, remove any fields that are not likely to be relevant, for example Date of Birth. Removing fields can make your analysis run faster.
     • Click on the de-select all button to remove all the fields from selection.
       
       
       
       
     • Or click on the select all button to choose them all.
7. Click on the Continue button after providing the details.

8. A new Auto Analysis panel will appear in the report builder, displaying the results of the analysis process. These insight results will be generated based on the options that you selected in the previous step; and will be displayed in order of statistical relevance.

    

   The chart type selected by Yellowfin depends on the type of data. For example, if the values are both metrics, then a scatter plot graph will be generated.

   
   
   
   

9. A narrative explanation is also provided with each of the charts, allowing you to better interpret the results of the analysis.
10. Double-click on a chart or click on its add icon to select it. This will copy the selected chart to the chart builder page. You can include multiple charts in your report this way. 
    
    
    
    
11. Once you have selected the charts you want to keep, click on the charts toolbar option to open the Chart Builder.
    
    
    
    
12. Your chosen charts will already be there.
13. You can still view the other automated charts, that you did not select, by clicking on the insights icon on the right side of the Data screen.
    
    
    
    

14. These charts can now be used to build and publish reports in the normal way. You have now rapidly created relevant report content with a fraction of the effort it would normally take to analyse data and build reports.
    
    
    

    If you perform these assisted discovery steps again, the charts from the previous analysis will be removed from the Auto Analysis panel; however the ones you had selected will remain on the Chart builder page.