JSON to Insights: Joining Datasets with Precog
By Jeff Carr
December 9, 2019

Joining datasets with Precog

Precog shows us that in the adverse events dataset, drug characterizations are denoted as numbers. These numbers represent whether or not the drug was suspected as causing the adverse reaction or interacting with a suspected drug.

Precog showing drug characterization being denoted as numbers

The meanings of these numbers are described in this table:


We can combine this with the adverse events dataset by using Precog to load both as tables into our analysis software, database or warehouse then joining the two tables together. This will give us the drug characterizations in english, rather than as numbers.

To do this add the dataset as a source, pick the columns then access the results.

Screenshot of Precog showing adding the drug characterizations table as a datasource

When using SQL, Tableau, Looker or ThoughtSpot to analyse the data, we use the “Join” features. When using Power BI we use the “Merge queries” feature.

This straightforward process can be applied to any dataset, allowing us to join data from both tabular and non-tabular datasets as we please. This can be applied to datasources such as relational databases, CSV files, web APIs, NoSQL databases and others.

Previous page: Analysing the tabulated data with Power BI

Next page: Analysing the tabulated data with SQL

NEWS & BLOG

Introduction to Precog Express

Introduction to Precog Express

Welcome to Precog Express. Precog Express is a universal data connector. It lets you pull data from any source and send it just about anywhere ⎼ streamlining the entire data integration process. Let’s take a look around.

read more
New sources: Oracle Hospitality Opera, Infor SunSystems, Serverstack, Hologram, Verizon Thingspace, and many more

New sources: Oracle Hospitality Opera, Infor SunSystems, Serverstack, Hologram, Verizon Thingspace, and many more

Precog continually adds new sources. This week’s roundup includes: Ardunio, Ardunio PubSubClient, FronteggGUS, GermanyHCSS, HiveMQ, Hologram, Infobip, Infor SunSystems, Microsoft Service Bus, Mosquitto, Oracle Hospitality Opera, Paho, Paho Android Service, Paho Eclipse, Qualtrics XM, Serverstack, ServiceTitan, Shop Aware, SkysoftConnections, Swift, Trimble Viewpoint, Verizon Thingspace, Wolf MQTT / Wolf SSL, Wolf SSL.

read more

Ready to Start?

FROM OUR CUSTOMERS

Cured

Precog is an important partner for Cured and a critical member of our data stack. The Precog platform has delivered data connectors to necessary data sources other vendors could not or would not, and in a very short timeframe. The product is intuitive, efficient, cost-effective, and doesn&... Read More

Ashmer Aslam - CEO Cured
Walnut St. Labs

Precog lets us prototype analytics projects quickly — building marketing dashboards based on data from a variety of sources — without needing a data engineer or developer — we create new data sources in a few hours to sources like Brightlocal, a popular local SEO SaaS solution, and h... Read More

Chris Dima - CEO
Alteryx

We welcome Precog to the Alteryx technology partner ecosystem as a partner extending the capabilities of our platform, further simplifying analytics for our customers.

Hakan Soderbom - Director of Technology Alliances
SouthEnd

We recognized a need in our customer base to perform advanced analytics on SAP data sets — we performed an extensive evaluation of Precog and chose it as a strategic solution for our go to market needs based on its performance and given their strong strategic relationship with SAP.

Alfredo Poncio - CEO
SouthEnd
SendaRide

Precog is the vital tool in our ability to pull data from a variety of business sources quickly and cleanly. Our internal MongoDB backend, as well as other cloud services like Hubspot, were a constant challenge to the business teams desire for reporting data prior to using Precog. With the... Read More

Josh Wilsie - VP