Industry trends, news, and updates

JSON to Insights: Analysing the tabulated data with SQL

Analysing the tabulated data with SQL Sometimes we would prefer to use normal SQL instead of software like Power BI. Now that the data has been tabulated, we can analyse it using straightforward SQL. Using REFORM we can push the tabulated data into SQL databases and warehouses such as Snowflake and Postgres. The FDA states […]

JSON to Insights: More details about REFORM

More details about REFORM Self-service and pre-preparation Traditionally data is pre-prepared into a normalised schema in a warehouse for analysts. REFORM speeds up both the compute and labour of this process as well as ensuring accuracy. There is an alternative approach. Providing analysts with direct access to REFORM enables them to fulfil their own data […]

JSON to Insights: Joining datasets with REFORM

Joining datasets with REFORM REFORM 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. The meanings of these numbers are described in this table: https://reform-fda.s3.amazonaws.com/drug_characterizations.csv We can combine this […]

JSON to Insights: Analysing the tabulated data with Power BI

Analysing the tabulated data with Power BI Now that the data has been tabulated, we can analyse it using software such as Microsoft Power BI. PowerBI can either connect directly to REFORM, or to a database or warehouse such as Snowflake or Postgres where REFORM has pushed the data. To connect Power BI directly to […]

REFORM User Guides

REFORM with SQL Server

How to get transformed JSON data from REFORM into SQL Server.

REFORM with Amazon Redshift

How to get transformed JSON data from REFORM into Amazon Redshift.