Data Exploration & Profiling
Explore More. Understand Faster.
Every dataset tells a story. Falcon Data Studio gives you the tools to discover it.
Explore data in interactive grids, build visualisations and save the views you keep coming back to, without exporting your results to another application.
Move naturally between SQL, tabular exploration and charts.
Filter, sort and find, without writing a query
Column filters do the exploratory work: search a text column, tick values from a list, bound a number or a date, or type a SQL condition when nothing else fits. Filters run on the server, so a million-row table answers as fast as its indexes allow.
The Column Finder jumps to a column by name in a wide result, and range selection with Copy and Copy with Headers takes a slice straight into a spreadsheet or a message.
Text, wildcard, value list, number range, date range, boolean and custom SQL filters Sorting with server-side paging Row numbers, cell ranges, keyboard navigation
Charts where the data is
Open a chart over any grid: pick the chart type, the x field and the value fields, and watch the preview update. Plot it in a floating window that follows the grid, so a new filter, a sort or an edit redraws the chart.
Line, area, column, bar, pie and scatter charts; sum, average, count, min and max aggregations; a secondary axis and mixed series for combo charts; bubbles sized by a third field; a time axis for dates.
Zoom and pan with the wheel or by dragging Save the chart as an image Chart settings are remembered per set of columns
Save the view, not a copy of the data
A grid with its filters and sort can be saved as a query file in your local workspace. Open it tomorrow and it runs again against the live table.
Files you receive are just as welcome: Open File loads a CSV, TSV or JSON file into a tab, and Export writes any grid back out as CSV, TSV or JSON.
Saved grid queries open from the explorer like any other object Folders in the local workspace keep scripts, queries and files together Everything is addressed by URL, so a tab can be bookmarked
Go beyond query results
Filtering and sorting
Available Seven filter types and sorting, executed on the server.
Charts
Available Six chart types with aggregation, a secondary axis and combo series.
Exploratory analysis
Available Grids, saved queries, files and charts in one place.
Column profiling
Coming soon Distinct counts, null rates and value distributions per column.
Statistics
Coming soon Min, max, mean and percentiles for any result set.
Data quality
Coming soon Rules over columns and rows with counts of the violations.
What ships today and what is next
Profiling and statistics are the next step for the grid. Until they land, the filters, charts and a GROUP BY get you most of the way.
- Interactive grids
Available Filters, sorting, selection, copy and paste, editing.
- Charts
Available Line, area, column, bar, pie and scatter, with aggregation.
- Saved queries and export
Available Saved grid queries, Open File and Export to CSV, TSV or JSON.
- Column profiling
Coming soon A profile panel per column computed on the server.
- Statistics
Coming soon Summary statistics for a result set or a selection.
- Data quality checks
Coming soon Reusable rules with violation counts.
From Raw Data to Working Solutions.
One workspace to connect, query, explore, transform, automate and build.
Whether you are managing databases, engineering pipelines or creating applications, Falcon Data Studio helps you get more from your data.
Start with the modern Data IDE: the Windows desktop app, or open it in your browser.