Exploring Your Data

Overview
Exploration Interface
Visualisations
- Chart Types
- Example: Temperature Trend
AI-Assisted Analysis
Export Options
Next Steps

Overview

The Data Exploration interface provides an intuitive, Trendz-inspired environment for interactive data analysis. Query, visualise, and discover insights without writing SQL.

Exploration Interface

Metric Explorer

Select Data:

Choose table: iot_catalog.telemetry
Select metrics: temperature, humidity, pressure
Choose dimensions: device_name, timestamp
Apply filters: last 7 days

Visual Query Builder:

FROM: iot_catalog.telemetry
SELECT:
  - AVG(temperature) as avg_temp
  - AVG(humidity) as avg_humidity
GROUP BY: device_name
WHERE: timestamp > NOW() - 7 days
ORDER BY: avg_temp DESC

Quick Filters

Time Range:

Last hour
Last 24 hours
Last 7 days
Last 30 days
Custom range

Device Filter:

All devices
By type
By location
Custom selection

Aggregation Options

Functions:

AVG - Average value
SUM - Total
COUNT - Record count
MIN/MAX - Range
STDDEV - Variability

Time Buckets:

1 minute
5 minutes
1 hour
1 day

Visualisations

Chart Types

Time Series:

Line chart
Area chart
Stacked area

Comparisons:

Bar chart
Column chart
Pie chart

Analysis:

Scatter plot
Heatmap
Box plot

Example: Temperature Trend

SELECT 
  DATE_TRUNC('hour', timestamp) as hour,
  device_name,
  AVG(temperature) as avg_temp
FROM iot_catalog.telemetry
WHERE timestamp > current_timestamp() - INTERVAL 7 DAYS
GROUP BY hour, device_name
ORDER BY hour;

Visualisation:

Type: Line chart
X-axis: hour
Y-axis: avg_temp
Series: device_name

AI-Assisted Analysis

Natural Language Queries:

User: "Show average temperature by device for last week"

Generated SQL:
SELECT 
  device_name,
  AVG(temperature) as avg_temp
FROM iot_catalog.telemetry
WHERE timestamp > current_timestamp() - INTERVAL 7 DAYS
GROUP BY device_name;