User Guide Overview
Complete tour of GoPie's interface and core features
Welcome to the GoPie User Guide! This comprehensive guide will help you master all of GoPie's features, from uploading your first dataset to creating advanced visualizations and APIs.
Understanding the GoPie Interface
GoPie's interface is designed to be intuitive and powerful, organizing your data exploration workflow into distinct areas.
Main Navigation
The main navigation is located in the sidebar and includes:
Projects
Organize your datasets and analyses into logical groups
Datasets
Upload, manage, and configure your data sources
Chat
Natural language interface for querying your data
SQL Playground
Direct SQL editor for advanced queries
APIs
Auto-generated REST APIs for your datasets
Settings
Configure your account, teams, and preferences
Dashboard Overview
When you first log in, you'll see your dashboard with:
- Recent Activity - Your latest queries, uploads, and analyses
- Quick Actions - Common tasks like uploading data or starting a chat
- Project Overview - Summary of your active projects
- Usage Statistics - Track your API calls and data usage
Key Concepts
Before diving into specific features, let's understand some core concepts:
Projects
Projects are containers that group related datasets and analyses. Think of them as workspaces where you can:
- Organize multiple datasets around a common theme
- Share access with specific team members
- Maintain separate chat contexts
- Track project-specific usage
Datasets
Datasets are your data sources in GoPie. They can be:
- Uploaded Files - CSV, Excel, Parquet, or JSON files
- Connected Sources - Live connections to databases or cloud storage
- API Endpoints - Data fetched from external APIs
Chats
Chats are conversational sessions where you interact with your data using natural language. Each chat:
- Maintains context throughout the conversation
- Can reference multiple projects or datasets
- Generates SQL queries automatically
- Creates visualizations from results
SQL Playground
The SQL Playground provides a traditional query interface with:
- Syntax highlighting and auto-completion
- Natural Language to SQL conversion
- Query execution with real-time results
- Fix & Execute results with AI on failed queries
Workflow Overview
Here's a typical workflow in GoPie:
Create a Project
Start by creating a project to organize your work. Give it a meaningful name and description.
Upload or Connect Data
Add datasets to your project by uploading files or connecting to external data sources.
Expose data via APIs
Access your data programmatically through auto-generated REST APIs.
Explore with Chat
Use natural language to ask questions about your data. GoPie will generate SQL and visualizations automatically.
Refine with SQL
For complex queries, switch to the SQL Playground for full control over your analysis.
Create Visualizations
Transform query results into interactive charts and dashboards.
What's Next?
Now that you understand the interface, explore these key areas:
Data Management
Learn how to upload and manage your datasets
Querying Data
Master natural language and SQL queries
Visualizations
Create compelling data visualizations
API Access
Integrate GoPie with your applications
Best Practices
To get the most out of GoPie:
- Organize with Projects - Create separate projects for different use cases
- Describe Your Data - Add descriptions to datasets and columns for better AI understanding
- Start with Natural Language - Let GoPie generate initial queries, then refine as needed
Ready to dive deeper? Continue to the next section to learn about uploading and managing your data.