Helps you reach "I get it" and then "it's live and beautiful" for any data requirement — faster than any other platform.
DataPallas is a full-stack BI platform — interactive dashboards and pivot tables (like Tableau or Power BI) alongside pixel-perfect report generation (like Crystal Reports), all in one tool. The video above covers building dashboards for an algorithmic trading platform, but DataPallas can be easily used across ERP, CRM, Finance, Accounting, or any other domain.
For a deep-dive into the algo trading dashboards shown above, read this blog post.
To explore the full range of what DataPallas can do — from PDF bursting to SQL-driven reports to live BI dashboards — read on.
| What you need | What you're using today | DataPallas |
|---|---|---|
| 1. Data Exploration | Chat2DB AI — ask in natural language, get SQL, results, and charts | |
| 2. Dashboards & Analytics | Embeddable data-tables, charts, pivot tables, and analytics | |
| 3. Report Generation | Pixel-perfect PDFs, Excel, HTML, Word from any data source |
Also includes: 4. report bursting | 5. self-service document portals | 6. AI crew
- Download datapallas-server-docker.zip
- Extract the zip and navigate to the
DataPallasdirectory - Run
docker compose up -d - Open
http://localhost:9090
1. AI-Powered Data Exploration
- Connect to any database — PostgreSQL, MySQL, SQL Server, Oracle, SQLite, DuckDB, ClickHouse, and more
- Build interactive views on the explore data canvas — drag tables or cubes, configure widgets visually, apply shared filters
- Built-in Chat2DB web app — ask questions in natural language, get SQL, results, and visualizations instantly
2. Dashboards, Analytics & Semantic Layer
- Define metrics, dimensions, and joins once in a semantic layer (cubes) — every chart, pivot, and dashboard reads from the same source of truth
- Build interactive dashboards for sales, finance, and real-time business monitoring
- Embed datatables, charts, and pivot tables as web components directly in your own apps
- Build a data warehouse with OLTP-to-OLAP sync via CDC — powered by DuckDB, ClickHouse, and dbt
- Your council of AI domain experts: Athena (data & reports), Hephaestus (automation & ETL), Hermes (portals), Apollo (modern web)
- Agents learn your projects, preferences, and workflows — improving with every interaction
- Chat through the built-in Chat2DB web app or classic desktop and mobile chat apps
4. Report Bursting & Automation
- Split, personalize, and auto-deliver reports to the right people — via email, FTP, or cloud storage, at scale, on schedule
- Built-in quality assurance guarantees every delivery
- Automate payslips, invoicing, and payment processing workflows
- Design pixel-perfect PDFs, Excel, HTML, and Word documents from any data source
- Multi-format input: SQL, Excel, XML, CSV
- Large-scale generation — seed millions of records and benchmark on your hardware
6. Self-Service Document Portals
- Build secure portals for employees, customers, and partners — HR, billing, payments, education
- Choose between Grails or modern Next.js 15/React/Tailwind stacks
See all samples — report bursting, report generation, interactive dashboards, pivot tables, and more.
Full documentation is available at datapallas.com/docs.
Everything above is the doing side — install DataPallas and build the real dashboards, reports, customer portals and automations your business needs. But here's what sets DataPallas apart: it's also one of the best places to learn and master data itself — SQL, data modeling, ETL/ELT — on real, production-like data, with AI to guide you and your data never leaving your machine. So it isn't "powerful BI or learning platform" — it's both at once: ship production work today, and become a sharper data professional while you do it.
How to use DataPallas to learn everything data — SQL, data modeling, ETL/ELT, warehousing, BI and more, told as a Greek-myth dialogue.
We welcome contributions! Bug reports, feature requests, documentation, or code — every bit helps.
- Bug reports & feature requests: Open an issue
Start using it today with no artificial restrictions — all features included. No community vs. enterprise editions.
Watch this repository to be notified of future updates:
