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 […]

DATA INSIGHTS

GET IN THE KNOW

You don’t have time to wait around for the info you need to make data-driven decisions. SlamData integrates with what you already use to get you up and running quickly. Let's get started.

LET'S GO

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 […]

JSON to Insights: Tabulating non-tabular data without REFORM

When using Snowflake without REFORM, the data must first be downloaded from the source. This immediately makes stale data more likely and introduces risks associated with incorrect or outdated results. Dealing with pagination Like many web data sources, FDA.gov provides data in a paginated manner. This means that the dataset is not available as a […]

JSON to Insights: Tabulating non-tabular data with REFORM

Tabulating non-tabular data with REFORM With REFORM, we connect directly to the source of the data. In this case the source is the FDA.gov Web API. This ensures that we are always working with the latest data including new records and corrections. There is no need to download, stage or import the data. Self service […]