Cloud Data Element Analysis

This browser-based tool enables you to run data element analysis reports from database tables existing in the Cloud on the major Cloud Data Platforms (or any other database that you can access via the Internet). Simply provide the connection string from your data source's database, table name, and column name(s). The Analyze Column Name is the column for which element analysis will occur, identifying the frequency of occurrence of individual data elements. This is an easy step to take in improving the usability and value of your important data assets.

For instructions on how to include elementizing of a dataset as part of workflow, including scheduled runs, ongoing processing, or part of a data pipeline, see the Element Analysis Workflow Guide.

Run Here - Report Setup:

*Interzoid API License Key: Login or register to obtain

*Database Connection Type (Select from drop-down):

*Database Connection String (use full URL if CSV, such as "https://dl.interzoid.com/csv/companies.csv"): Sample connection strings

*Table Name ("CSV" if CSV):

*Analyze Column Name (Column # if CSV, first column = 1):

Select Report Type:

Data Element Analysis Report (most users)

* Note: Use connection type = "CSV File", connection string = "https://dl.interzoid.com/csv/companies.csv", table name = "CSV", and column name = "1" for a demo that does not use credits from your account.

Additional Information:

Login to www.interzoid.com to obtain your API Key. It is how we track usage. If you do not yet have one, register for a free trial at www.interzoid.com/register-api-account.

Sample SQL Scripts in case you need sample/test data for a test drive.

How to use CSV files for data processing within Interzoid Cloud Data Connect.

            
        Element Analysis Report (Full Name Field) Sample:

        Mr,3431
        Ms.,2383
        Ms,1922
        Dr,1432
        MRS,922
        Mr.,891
        Jr,510
        JR,477
        Doctor,432
        Jr.,144
        Mister,220
        Miss,140
        Sr.,77

Run scheduled or as part of a batch script? Embed in workflow or within a data pipeline? Execute programmatically? You can run this entire process with a single API call. Example:

            
        https://connect.interzoid.com/run?function=elementize&apikey=use-your-own-api-key-here&source=CSV&connection=https://dl.interzoid.com/csv/companies.csv&table=CSV&column=1&html=true

Full Dataset Processing API Documentation

Return to Platform Home