Documentation
FreeUncover trends and patterns in your data using natural language.
FreeFree tier
About Documentation
Powerdrill's Advanced Analytics feature enables users to analyze raw data using natural language, generating visualizations such as charts and maps. It supports uploading CSV, TSV, and Excel files (up to 10 per session) and integrates with SQL databases (MySQL and PostgreSQL) via a secure read-only connection. Users can ask questions in natural language to uncover trends and patterns without needing to write SQL queries.
Key Features
Natural language data analysis
Generate charts, maps, and visualizations
Upload CSV, TSV, Excel files (up to 10 per session)
Connect MySQL and PostgreSQL databases
Read-only user setup for security
Test connection before finalizing SQL integration
Demo available for testing
Pros & Cons
Pros
- Simple natural language interface reduces learning curve
- Supports multiple data sources (files and databases)
- Generates visualizations automatically
- Emphasizes data security (keys and passwords not stored)
- Demo available for quick trial
Cons
- Limited to CSV, TSV, and Excel file formats
- SQL connection requires manual setup and read-only user configuration
- Only supports MySQL and PostgreSQL databases
- May have limitations on data size or query complexity (not specified)
Best For
Data exploration and pattern discoveryBusiness intelligence reportingDatabase querying without SQL knowledgeAd-hoc analysis of uploaded datasetsVisualizing trends from SQL databases
FAQ
What file formats does Advanced Analytics support?
Advanced Analytics supports CSV, TSV, and Excel files. Up to 10 files can be uploaded at a time.
Which SQL databases are supported?
Powerdrill supports MySQL and PostgreSQL databases for SQL Advanced Analytics.
How does Powerdrill handle data security for SQL connections?
Powerdrill prioritizes data security. Keys and passwords are never accessed or stored by the system. Users are prompted to create a read-only user for database connection.