Project Connections


Helping you find connections between distant datasets.


Overview

At its essence, Project Connections helps you find new information by linking together separate CSV files.

After ingesting personal CSV files, you can use our application to find table relationships. When starting in 'User Exploration' mode, you first find a starting table that contains a column name of your choice. After selecting that table, you can find up to sixteen related tables based on the number of matching columns. The more matching columns between two tables, the closer they will appear in the table connection graph. Here, you may choose any related table to join with your current table. When joining tables, you then select unique columns upon which you shall join. For example, emails are often unique to individuals, so that is often a good column joining choice.

Instead, if you'd like help beginning the process, you can use are 'Computer Guided' mode. All you need to do is select two columns, and our program will show you up to five connection 'paths'. For example, maybe these two columns exist within a single table, so we will present that table to you. Perhaps you select Column A and Column D, and you uploaded Table E with Column A, which has a matching Column B with Table F, which has a matching Column C with Table G, which contains Column D; we will show you that Table E to Table F to Table G connection. All you need to do is double-click on that connection of tables, and you can continue with this table as you would in 'User Exploration' mode.

After joining tables through either method, you have the option to query your new table for specific values, undo your previous join or action, save your table to your computer and our database, or continue and join your table with other ingested tables. If you choose to save your table, you can view it again by selecting it in our saved tables tab.

Ingest Files

Upload your own CSV files into the system. Once uploaded, you can ingest them for use in our program.

Explore

Use our 'User Exploration' mode to start with a single column name, find a starting table, and discovere tables with related column names.

Get Assistance

Use our 'Computer Guided' mode to start with two column names and find a string of tables that connect them.

Save Tables

After joining multiple tables, you can save your table to our database, download it to your computer, and load it later from our 'Saved Tables' tab.

After joining together multiple tables, try querying your resulting table and see what connections you can find. Say, for example, you are a vet looking to make new connections. Perhaps you have a adoption table that says John Smith has a pet named Rufus, and a census table says John Smith lives in Washington D.C. Now, you could join John Smith's pet info with his census info on name to have his address.

Then you could join that bigger table, on both pet name and owner name, with a pet store table to find out if there are any newly adopted pets that you could send their owners advertising about your veterinarian practice, especially as their rabies shot comes due. This information, which originally would have been difficult to find, is now right in your hands.

But that's just one story. What connections will you make?



Download

Project download is currently unavailable.