Analytics Query Builder (Dataviews)
SQL-based data composition tool letting users join multiple data sources to build unified analytics datasets.
Overview
Designed Dataviews — a SQL-based data composition tool that lets users join multiple data sources via a visual query editor to build unified analytics datasets. Supports joins, unions, aggregates, and a drag-and-drop schema browser.
Approach
Partnered with analytics-power users to understand data consolidation pain points. Combined a familiar SQL editor with a visual schema browser for discoverability — SQL-literate users get full power, others can explore tables before writing queries. Added beautification, preview, and CSV/JSON export for a complete workflow.
Outcome
Eliminated manual data consolidation workflows and reduced IT dependency for report building. Supports complex analytical scenarios without leaving Kissflow, feeding directly into the reporting layer.