Process Data with Xplenty and Visualize it with Chart.io

Process Data with Xplenty and Visualize it with Chart.io

We concentrate on making data processing as fast and easy as possible. To complete the dataflow, Xplenty integrates with a plethora of services that can store, analyze, or visualize data. One of these services is Chart.io, a popular service for data visualization. You can use Xplenty to process the data and then visualize the results in Chart.io. Here’s how.

Processing Data with Xplenty

In the example below, we used Xplenty to process public GitHub data and find the total commit sizes per day in June 2014.

Dataflow

Xplenty dataflow

  1. github_source — loads the relevant GitHub data from our public S3 directory

    cloud storage source

  2. filter_commits — filters only PushEvents (commits)

    filter

  3. select_fields — selects the commit size field while typecasting it to an integer and changes the date to a string format via the ToString(created_at,'yyyy-MM-dd') function

    select

  4. sum_commit_size — calculates the total commit size per day

    aggregate

  5. output_redshift — saves the results to Redshift so they can be loaded in Chart.io (here’s how to connect Xplenty to Redshift). Xplenty can also save the results as CSV files or to relational databases, which can all be integrated with Chart.io.

    amazon redshift destination

Visualizing Results with Chart.io

Once the above job is executed on a cluster, the results will be stored in Redshift. To load this data in Chart.io:

  1. Log in to your Chart.io account

  2. Go to “Settings” and “Data Sources” to connect a new data source and select “Amazon Redshift.”

    Chart.io connect a new data source

  3. Enter all the relevant Redshift connection details and click “Connect.”

    Chart.io connect a Redshift data source

  4. Start visualizing your data.
    Chart.io connect a Redshift data source

Summary

Data can be easily processed with Xplenty and then visualized in Chart.io. We showed an example of how GitHub data can be aggregated and visualized, but we’re really curious to see what you would be able to do with your data.


Integrate Your Data Today!

Get a 7-day free trial. No credit card necessary.