Data querying

The Redivis platform includes tools to query data inline and build new tables in a project using a code or graphical interface.

Initial queries

You can learn a lot about a dataset right on the dataset page — documentation, metadata, summary statistics are available; and once you have data access you can perform a direct query on the data itself. Go to the Tables tab on any dataset page to try this out by opening up any table to investigate it further.

Starting a project

Once you're ready to perform more complicated queries or join additional tables, you can either download the dataset directly to your computer or add it to a project. Click the Add to project button on the dataset page, or create a new project from your workspace and click the + Dataset button.

This will bring the dataset — for example, Medicare Inpatient Charges — into the Redivis project interface. To manipulate the data, click the Transform button to create a new transform node.

You can then build a transform to select the variables and rows in your output table. You can click back on the original dataset node in the left map to reference any statistic information while while building up each step.

When you're ready to generate an output table, click the "Run" button at top right. This transform shown below selects all providers in California whose medicare payments are higher than the average, for a particular diagnosis group. This project shown here is public for you to explore and create your own copy.

After your run job is complete, you can click on the output table to explore your results and make sure the output is valid, and update your transform accordingly.

On the output table you can:

  • View variables

  • View summary statistics

  • View cells

  • Run queries

  • Save or export the table and its metadata

Next steps

Master the project tool

You can learn more about how to use the project tool to join tables, utilize value lists, create variables, and more in further documentation.

Share and collaborate

Work on projects together with collaborators in real time.

Download tables

When you have final tables you want to analyze further you can download them to your computer.

Upload your own datasets

You can upload your own data to share with collaborators or use in projects