Explore Data

tell me more icon Tell me more

This cue card set uses the connection and project created in Getting Started with Data Miner.

  1. Follow these steps to create a new workflow named Transformations:

    1. In the Data Miner navigator, expand dmConnection.
    2. Right-click the project HighValue; select New Workflow.
    3. Name the new workflow Transformations.

  2. If the Component Palette is not open, open it using View > Component Palette. Make sure that Workflow Editor is selected.

  3. Create a data source node for the data to explore:

    1. In the Component Palette, click the Data section, and left-click Data Source.
    2. Move the mouse to the place in the workflow identify where you want to place the node. Click.
    3. The Define Data Source wizard is launched.
    4. In the Available Tables/Views list, select the view MINING_DATA_BUILD_V. The columns (attributes) of the view are displayed.
    5. Click Finish to select this view with all of the columns selected.
    6. The new node is created. The default name of the node is MINING_DATA_BUILD_V, the name of the table.

  4. Explore the data in MINING_DATA_BUILD_V before you transform it. Create and run an Explore Data node:

    1. Move an Explore Data node from the Data section of the Component Palette to the workflow.
    2. Name the new node ExploreMiningData by selecting the name and typing in the new name.
    3. Right-click MINING_DATA_BUILD_V, and select Connect. Use the mouse to draw the link to ExploreMiningData. Click to end the line.
      tell me more icon Tell me more about what I see in the GUI.
    4. Right click ExploreMiningData and select Run.

  5. After execution finishes, right-click ExploreMiningData and select View Data. The data viewer opens in a new tab ExploreMiningData.
    tell me more icon Tell me more about what I see in the GUI.

  6. Select an attribute such as CUST_INCOME_LEVEL. CUST_INCOME_LEVEL has data type VARCHAR2. The upper part of the display shows the histogram, the data type, percent NULLs, the number of distinct values, the percent distinct values, and the mode. A large version of the histogram is displayed in the bottom of the page.

  7. When you are done exploring attributes, close the tab.

You are now ready to define transformations.

tell me more icon Tell me more about what I see in the GUI

The cue cards icon Next step is identify important attributes.