What are visualizations?

SQL editor enables you to visualize your query outputs using a range of ready-made charts and dashboards.

These can help you to explore the format of the data, create statistical summaries and look for trends and behaviours.

What are the benefits of using SQL Explorer and visualizations?

  • Minimal coding experience required
  • Quick to get started and exploring your data
  • Lots of visualization options


Contents


Accessing visualizations through SQL Explorer

  1. Go to Dock > SQL Explorer.
    The SQL Queries screen appears.
  2. Launch SQL Editor or edit a saved query.
  3. Run a query to load data into your environment.
  4. Once your query has successfully run, click VISUALIZE to load the visualization explorer.



Exploring your data

After clicking VISUALIZE, the visualisation explorer opens in a new browser tab.

From here, you can see which columns are included and a sample of the observations.


The visualization tool has a range of functions that enable you to manipulate the data according to your requirements:

  • Data types
    Get to know the format of each variable.
    For example, character, numeric, timestamp.
  • Group by
    Group rows with the same value to create a summary row.
  • Metrics
    Find your average, count, distinct count, maximum, minimum and sum.
  • Sort by
    Sort your data by ascending or descending for one variable.
  • Filter
    Filter your data by logical operators.
    For example, less than, more than, equal to, is null.


Visualization examples

There are currently 50 different visualization outputs to choose from. 

These include line charts, bar charts and heatmaps.