Lema Core Technologies
Dashboard Studio — Build Visual Dashboards, Powered by AI
Compose interactive dashboards from any Odoo model with a drag-and-drop grid, 15+ chart types, and a bring-your-own-key Gemini assistant that designs dashboards, explains charts, and answers natural-language questions about your data — no code required.
Odoo 18 OPL-1 15+ Chart Types BYOK Gemini AI
Lema Core Technologies is a provider of business software solutions specializing in custom Odoo development. We help businesses unlock the full potential of their Odoo instances through reliable, well-tested modules.
Demo Preview
See Dashboard Studio in Action
Use Cases
What You Can Build with Dashboard Studio
From a single KPI tile to a full executive suite spanning sales, inventory, and finance — compose it visually, or describe it in plain English and let the AI assistant build the first draft.
Prompt-to-Dashboard
AI Designer
Pick a model or type a keyword — Gemini proposes chart items with the right measures and group-by fields, ready to drop onto the grid.
Example: Keyword "Sales" → auto-picks sale.order and drafts revenue-by-month, top customers, and pipeline charts.
Explain with AI
Plain-English chart summaries
Click the sparkle icon on any chart — Gemini reads the underlying data and writes a factual analysis plus actionable insight, with optional text-to-speech playback.
Example: "Revenue is up 18% MoM, driven mainly by the EU region — consider reallocating APAC ad spend."
Chat with Your Data
Ask questions, get real answers
Type a question in the chat panel — Gemini drafts a read-only SQL query, it's validated SELECT-only, executed safely, and summarized back in plain language.
Example: "Which 5 customers grew the most this quarter?"
TV Mode
Office wall displays
Fullscreen carousel that rotates through every dashboard a user can access — built for TVs mounted in the sales floor or ops room.
Example: Rotate Sales Pulse → Operations Overview → Executive Summary every 15 seconds.
Scheduled Reporting
KPI mail on a cron schedule
Send rich HTML snapshots of a dashboard's KPIs to a distribution list automatically — daily, weekly, or on whatever schedule you configure.
Example: Monday-morning revenue recap emailed to the leadership team.
External Data
Beyond Odoo's own tables
Chart data from an external MySQL or PostgreSQL database, or import a CSV/Excel file — side by side with your live Odoo records.
Example: Blend a legacy warehouse database's stock levels with Odoo's sales figures on one board.
Screenshots
Visual Walkthrough
Home Overview
A greeting banner, live stat cards for dashboards/charts/maps/bookmarks/lists, and a preview card per dashboard — complete with a hand-rolled SVG sparkline of its first chart, no charting library involved.
A Distinct Visual Language
Rounded column corners, a muted grid, an indigo/sky palette, and a dark tooltip pill with a soft shadow — every chart shares one consistent, custom theme, not a generic default.
KPI Tiles & Multi-Chart Boards
KPI cards with a "vs Target" comparison, a radial progress ring for goal tracking, and a mix of polar, semi-circle, and line charts side by side on one board.
Example Board: Operations Overview
One of the built-in starter templates — a KPI ratio tile, horizontal bar, doughnut, area chart, and an un-grouped list view, all on a single board built entirely from Odoo's own data.
Example Board: Executive Summary
Two KPI tiles with a "vs Target" pill, a bar chart with data-labels on, a semi-circle pie, a polar area chart, and a line chart with values — a denser, executive-facing layout template.
Bookmarks & Quick Recall
Star any board from Home and it shows up here — a dedicated, uncluttered list for the dashboards each user actually comes back to every day.
Template Gallery
Start a new dashboard from Blank or from a curated starter (Sales Pulse, Operations Overview, Executive Summary) — managed under Tools, right next to the AI Designer and the import wizard.
AI Assistant
Bring Your Own Gemini Key.
Nothing Routes Through a Lema Server.
Paste your own Google Gemini API key in Settings and every AI request — dashboard generation, chart explanation, chat-with-data — calls Google's API directly. No proxy, no third-party data handling.
🔑
Your Key, Your Quota
Get a free key at aistudio.google.com/apikey — no Lema account or subscription required.
⚙️
Pick Your Model
Choose from Gemini 2.5 Flash Lite/Flash/Pro up to the latest 3.x preview models — trade cost for reasoning depth.
🛡️
SELECT-Only Guardrail
Chat-with-data queries are parsed and rejected outright if they're anything but a single read-only SELECT.
🎯
Field-Constrained Prompts
The AI is only ever offered your model's real, correctly-typed field names — no hallucinated fields silently dropped.
What the AI assistant can do
✅ Generate a full dashboard from a picked model or a keyword
✅ Explain any chart's data in plain language + spoken audio
✅ Answer natural-language questions about your data
Chart Library
15+ Chart Types, One Consistent Theme
Mix and match freely on the same drag-and-drop grid — every type shares the same rounded corners, tooltip style, and color palette.
Features
What You Get
Visual Building
🧩 Drag-and-Drop Grid
Gridstack-powered layout with live resize, free positioning, and per-tile theming — arrange a board the way you'd sketch it on paper.
🎨 Custom Theme Presets
Five pastel tile themes plus four chart palettes (Default/Dark/Material/Moonrise) — all driven from one design-token file.
📐 Template Gallery
Start from Blank, Sales Pulse, Operations Overview, or Executive Summary — each a distinct, purpose-built layout, not a reshuffled copy of the others.
Data & AI
🔌 External DB Connectors
Chart data straight from an external MySQL or PostgreSQL database, side by side with native Odoo records.
📥 CSV / Excel Import
Drop in a spreadsheet and chart it immediately — no staging model or import wizard detour needed.
🧮 Custom SQL with Multi-Company
Write raw SQL data sources with {#MYCOMPANY} / {##MYCOMPANY} placeholders that resolve per active company automatically.
Collaboration & Operations
🔖 Bookmarks & Saved Filters
Star your most-used dashboards for one-click access; save personal or group-shared filter presets per board.
📺 TV Mode
Fullscreen slide carousel across every accessible dashboard — built for office wall displays and ops rooms.
📧 Scheduled KPI Mail
Cron-driven HTML KPI reports emailed to a distribution list — no manual export-and-send routine.
Start Fast
Built-In Template Gallery
Every template is a distinct, hand-composed layout — not the same item pool reshuffled under a different name.
⬜
Blank
Start from zero and build item by item.
📈
Sales Pulse
3 KPI tiles + bar & line charts + a grouped list — 6 items.
🏭
Operations Overview
KPI ratio, horizontal bar, doughnut, area chart, ungrouped list — 5 items.
📊
Executive Summary
2 KPIs, a bar chart, polar area, semi-circle pie, and a line chart — 6 items.
How the AI Assistant Works
Request → Constrained Prompt → Validated Result
Every AI call is scoped to your model's real fields before it ever reaches Gemini — and every SQL answer is scoped to SELECT-only before it ever reaches Postgres.
Menu Structure
Configuration → Settings
Configuration → Boards
Configuration → Saved Filters
Configuration → Dashboard Layouts
Technical Specifications
Built on Odoo 18 Standards
📦 Dependencies
- base, web, base_setup, bus, base_geolocalize, mail
- Python: pandas, xlrd, openpyxl, gTTS, mysql-connector
🖥️ Deployment
- Odoo Community & Enterprise
- Odoo.sh (PaaS)
- On-Premise, single or multi-worker
🗂️ Model Namespace
- All models under the
lema.dashboard.*namespace - Design tokens in one SCSS file — recolor the whole app from one place
🔒 Security
- Dashboard User — read and use shared dashboards
- Dashboard Manager — create, edit, delete, and share dashboards
- Per-board group-based visibility restrictions
Version History
What's New
Frequently Asked Questions
Got Questions?
Do I need a Lema account or subscription to use the AI assistant?
Is it safe to let AI "chat with my data"? Can it modify records?
SELECT statement — INSERT, UPDATE, DELETE, DROP, ALTER, stacked statements, and other write/DDL keywords are refused before the query ever reaches the database cursor. The AI cannot create, modify, or delete any record through the chat feature.
Which Gemini models can I choose, and which should I pick?
What chart types are supported?
Can I connect to a database outside Odoo?
How does multi-company work with custom SQL data sources?
{#MYCOMPANY} (the current active company id) and {##MYCOMPANY} (all active company ids), which are resolved automatically per user — so one SQL-backed chart works correctly across every company without duplicating it.
What are the built-in templates, and can I customize them?
Is this available for Odoo Community and Enterprise?
Do purchases include future version upgrades?
Related Products
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Lines of code | 32368 |
| Technical Name |
lm_dashboard_studio |
| License | OPL-1 |
| Website | https://lemacore.com |
LEMA Dashboard Studio
A visual dashboard builder for Odoo 18 — build interactive, shareable dashboards with drag-and-drop, 15+ chart types, and an AI assistant that designs from natural language prompts.
What you can do
- Compose dashboards from any Odoo model — sales, inventory, HR, finance — without writing code.
- Add 15+ chart types: bar, line, area, pie, donut, polar area, radar, funnel, bullet, map, KPI, tile, list, to-do.
- Resize and reorder every tile with a drag-and-drop grid powered by gridstack.
- Theme each tile individually: background color, header color, font color, custom icon.
- Filter live with predefined or custom filter chips, and pin favorites for quick recall.
- Drill from a parent chart into child dashboards to keep stakeholder views uncluttered.
- Schedule KPI summaries by email with one click.
- Display a curated rotation of dashboards on a TV wall using full-screen carousel mode.
- Export any chart to PDF, PNG, Excel, or CSV.
Example dashboards
Two of the built-in starter templates, each combining several chart types on one board built entirely from live Odoo data:
AI assistant (bring your own Gemini key)
Open the AI Designer panel, paste a natural-language description ("Show me a bar chart of sales by month with a target line at $50K"), and the assistant turns it into a configured dashboard item. The AI engine handles model selection, field mapping, measure type, and group-by date precision automatically.
The assistant calls Google's Gemini API directly using an API key you provide yourself — no request ever passes through a Lema-hosted server. Chat-with-your-data only ever runs a single, validated read-only SELECT query; any other statement is rejected before it reaches the database.
External database charts
Connect to a MySQL or PostgreSQL database to chart non-Odoo data. Enter host, database, user, password, and port; the runtime issues parameterized queries and caches results per user session. Custom SQL supports the placeholders {#MYCOMPANY} (single active company id) and {##MYCOMPANY} (all active company ids).
TV mode
Pick a dashboard, switch on TV mode, and the screen rotates through every board the user has access to. Each board fades in with a 4-second pause; transitions are keyboard-controllable for live demos.
Quick start
- Install LEMA Dashboard Studio from the Apps screen.
- Navigate to Dashboard Studio → My Dashboards.
- Click Add New Dashboard and pick a starting template.
- Click Edit Layout, then Add Chart to insert tiles.
- For each tile, pick a data source (Odoo model, External DB, API, CSV), the chart type, and the axes / measure / group-by.
- Save the layout. Pin filters as needed.
Configuration
Administrators paste their own Gemini API key and pick a model under Dashboard Studio → Configuration → Settings. No AI feature works until a key is configured; get one at https://aistudio.google.com/apikey.
Security
Two roles ship with the module:
- Dashboard User (base.group_user) — read and use shared dashboards.
- Dashboard Manager (lm_dashboard_studio_group_manager) — create, edit, delete, and share dashboards.
Each dashboard supports group-based visibility — restrict a board to a specific res.groups audience.
Support
- Source: https://lemacore.com
- Email: support@lemacore.com
License
OPL-1. © LEMA Core Technologies. Maintained by PT Mazuta Bima Tek.
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module