AI Analytics Tool hero

Project Summary

An AI-powered conversational analytics tool that enables stakeholders to explore console usage data and generate insight summaries using natural language. The tool eliminates the need for SQL queries or technical expertise.

Core SkillAI Agent Architecture & Interface Design
RoleProduct Designer & Developer

Discovery

What I learned about users, their challenges, and the opportunity space.

Discovery visualization

Data insights were locked behind technical barriers and knowledge gaps

Non-technical stakeholders needed console usage data to inform decisions, but couldn't formulate the right questions because they didn't know what data existed or how to ask for it.

Design Approach

How I translated insights into a solution through design and development.

Before and after comparison showing complex SQL statements transformed into conversational discovery

Conversational AI that helps users discover what to ask, not just answer what they already know

Rather than optimizing single-shot queries, I designed a multi-turn dialogue system that lets users progressively refine questions and uncover insights they wouldn't have known to ask for initially.

What I Delivered

Key deliverables spanning interface design, user flows, and system architecture.

Guided Interface

Conversational Interface with Guided Discovery

The conversational experience with guided prompts enables users to start broad and progressively refine their questions. Context is maintained across turns, allowing natural exploration without repeating information.
Key Workflow

Intelligent Data Storytelling

Rather than raw tables, the system transforms query results into narrative summaries that identify patterns, trends, and actionable insights—highlighting what matters most and suggesting related explorations.
System Architecture

Semantic Data Model Architecture

The breakthrough innovation: A proprietary semantic data model that maps how users think about data (business terms) to how data is stored (technical database structures).
AI Data Tool screenshot 1
AI Data Tool screenshot 2
AI Data Tool screenshot 3

Key Decisions

These are the decisions I made that shaped the products experience.

Conversational experience over one-shot queries

Users couldn't formulate specific questions—they didn't know what data existed or how to ask for it. I designed a multi-turn dialogue letting users start broad and refine through follow-ups.

Semantic data model as translation layer

An AI-powered conversational analytics tool that enables stakeholders to explore console usage.

Data storytelling over raw results

Users wanted answers, not spreadsheets. I shifted focus to narrative summaries that identify patterns, explain significance, and suggest next steps.

Interested in working together?

Let's talk about how I can help solve complex product challenges for your business.