Skip to main content

Varicent ELT Help Center

Random number generator

Abstract

Generate random numbers to analyze potential scenarios with the Random number generator tool.

Important

The Random number generator tool is not widely available yet. If you want this feature, contact Varicent Support.

Generate random numbers to analyze potential scenarios with the Random number generator tool. The tool helps you understand the distribution of historical data, modify that distribution and explore scenarios and impact of changes.

When to use this tool

Use the Random number generator tool when you want to run simulations, so you will be able to make better business decisions and understand the range and probabilities of outcomes of each scenario.

Input

The Random number generator tool requires one data input.

Configuration

Use the following configuration options to help randomize your data.

Configuring the Random number generator tool
  1. In the pipe builder, add your data source.

  2. Click symon_add_icon.png +Add Tool.

  3. Click See all tools.

  4. In the search bar, search for Random number generator. Click Add tool.

    Tip

    You can also find the Random number generator tool in the Learn section.

  5. Connect the tool to your data set.

  6. In the configuration pane, enter the following information:

    Table 58. Random number generator tool configuration

    Field

    Description

    Exclude duplicate rows (Optional)

    Select a column containing unique IDs to to remove duplicate rows from simulation.

    Note

    This field could be filled out when the Random number generator tool is added to the pipe after the Repeat tool.

    Randomization1

    Enter a name for your randomization, or leave the default, Randomize1, Randomize2, and so on.

    Randomization method

    Select the randomization method, either Learned or Defined.

    • Learned method: The tool automatically selects the distribution type and learns the data.

      Find this distribution in the Tool tab after you build.

    • Defined method: You manually select the distribution type and learn the data from your configurations.

    Learned distribution column

    Select a numerical column to use when using the Learned method.

    Distribution type (Defined)

    Select the distribution type from the drop-down menu to specify the mathematical model defining how input variables uncertainties are represented:

    • Normal

    • Triangular

    • Uniform

    • Weibull

    • Poisson

    • Binomial

    Enter the constraints for your selected distribution type.

    Advanced section

    Min

    Enter the constraints for the minimum value of the random number generated.

    Max

    Enter the constraints for the maximum value of the random number generated.

    Group by

    (Optional) Select Group by to group your data by selected columns.

    Note

    You cannot select the column that you selected in Exclude duplicate rows or Learned distribution column.



  7. Build your pipe, then review the simulation results in the Row viewer Tool tab.

Usage example

Use the Random number generator tool to make data-driven decisions based on scenario planning. For example, if you are a sales organization with hundreds sales people, you would like to get an idea of what the company will be potentially spending during the compensation process. All of the sales people have different attainment levels. Using the Random number generator tool, you can see what the potential outcome will be for individual employees. This would indicate how much you could potentially spend during the compensation cycle.