Every feature, in plain words.
184 capabilities across the whole path from data to decision — connect, prepare, model, calculate, visualise, share, automate, ask, secure and deploy. All of it is one product, in our cloud or on your own servers.
Connect to your data
Databases, warehouses, ERPs, accounting systems, business apps and spreadsheets — live or imported, chosen table by table. All connectors.
50+ data sources
Databases, data warehouses, ERPs, accounting systems, business apps, spreadsheets and any system with a web API.
Live or import, per table
Query a table live so nothing is copied, or import it for extra speed. Both sit on the same dashboard, even in the same chart.
Combine sources in one chart
A live table and an imported one, or two different databases, feed a single chart without a data-warehouse project.
Reporting on top of your ERP
SAP Business One, Odoo, Dynamics 365 Business Central, NetSuite, Tally, Zoho Books, Sage and more — Klayara reads from them and never writes back.
Google Sheets kept in sync
Targets and budgets from a sheet sit next to actuals from the database, refreshed on a schedule.
Excel and CSV upload
Drag in a file, check how its columns map onto a new or existing table, and chart it in minutes. Re-upload replaces exactly that file's rows.
Any system with a web API
Internal tools, niche industry systems and public data feeds become tables on a schedule, with nested answers flattened into plain columns.
Share a connection, not a password
Give colleagues view, edit or admin access to a data connection without ever handing out its credentials.
Credentials stored encrypted
Database passwords and keys are encrypted and never shown again once saved.
Searchable connector catalog
Browse sources by category — databases, warehouses, files and APIs, AI providers, messaging — and see what your workspace already uses.
New connectors on request
Ask for a source and it goes to the top of the build list; once built it appears everywhere in the product automatically.
Prepare and refresh
Shape the data on the way in, preview every step on real rows, and keep it current without anyone babysitting a refresh.
Choose the columns
Keep only the columns you need; the rest never arrive.
Filter the rows
Drop rows you don't want before they land, with and/or conditions.
Replace values
Swap one value for another across a whole column — "N/A" to blank, old codes to new ones.
Clean up text
Trim stray spaces and fix upper, lower or title case in one step.
Fill down
Carry the last value down into blank cells, the way spreadsheet exports leave them.
Add a calculated column
Create a new column from a formula while the data comes in.
Split and merge columns
Split one text column into several on a separator, or join several into one.
Group into totals
Summarise detailed rows into totals as they are loaded.
Unpivot wide sheets
Turn a spreadsheet with one column per month into a tidy list that charts can use.
Preview on real rows
Every preparation step shows its effect on real data, with a quality bar, before you commit.
Type-in reference tables
Type or paste targets, budgets and mappings straight into a small table and edit it in place.
No-code summary tables
Drag columns and measures to create a new summarised table without writing code.
Combine tables with a query
Analysts can write their own query to combine tables and preview the result before saving it.
Change an import later
Edit what an imported table pulls in and see exactly which columns will change before you save.
Table housekeeping
Change a column's type, bring back a removed column, remove one bad file's rows, duplicate a table, or pick up new source columns — without re-importing.
Impact check before you change
Before renaming or deleting a column, see every chart, formula, rule and filter that uses it.
Scheduled refresh
Hourly, nightly or on demand; every dashboard shows when its data was last updated.
Incremental refresh
Only new or changed rows are fetched, so refreshes stay quick on large tables.
Replace, append or update in place
Pick how each refresh lands; a full mirror also removes rows deleted at the source.
Never half-written
Readers never see a half-loaded table: a refresh swaps in whole or not at all.
Refresh on a signal
Another system can start a refresh — for example right after the nightly close.
Refresh health alerts
One alert when a refresh fails, one when it recovers; after three failures in a row the schedule pauses itself.
Sync status and run history
See when each table last refreshed and any errors, right next to the data.
Model and describe
Relate tables once, describe what the columns mean, and every chart, formula and AI answer reuses it.
Relationships, set once
Relate customers to orders to invoices once; every chart and formula can then use fields from both sides.
Lookup columns
Pull a value such as a customer's segment or an item's category from a related table without building a join.
Related rows
Open a record and see its related records from other tables beside it.
Friendly names
Show "Acme Ltd" instead of the customer number stored in the table.
Column meanings and formats
Tell Klayara a column is a country, phone number or postcode, how to format it, how to total it by default, and that months sort January to December.
Times and durations that add up
Clock times and durations can be totalled and averaged like numbers.
Multi-value columns
A cell holding "red, blue, green" can be filtered by any or all of its values, and split so each value gets its own bar.
Certified tables, owners and synonyms
Mark trusted tables, name a business owner, and add synonyms so "turnover" finds revenue.
AI-drafted descriptions
One click drafts plain-English descriptions of a table and its columns for a person to review and approve.
Column profiling
One click shows gaps, blanks, top values and spread for every column; click any part to filter.
Version history for tables
Table settings keep a version history you can restore from, just like dashboards.
Projects and search
Group tables and dashboards into projects, search across everything, and pick up recent work from the home page.
Formulas and calculations
138 functions written the way a spreadsheet reads — defined once, reused on every dashboard, and checked as you type. Formulas in depth.
138 formula functions
Maths, text, dates, logic, statistics, lookups, ranking and time intelligence, in twelve families.
Checked as you type
Errors are explained in plain words, with the column or function underlined, before you save.
One metric catalog
Define margin, churn or DSO once for the whole workspace and reuse it everywhere, so every chart agrees.
Year to date, quarter to date and more
Year, quarter, month and week to date, month-on-month, quarter-on-quarter, period shifts and rolling windows.
Your own financial year
Year-to-date and quarter-to-date follow your financial year, such as April to March.
Running totals, ranks and previous row
Running figures, ranks within a group, percentiles and the value from the previous row.
Share of total
Show each item's share of its group or of the grand total — including the total before the reader's filters.
Different level of detail
Work a figure out at a different level from the chart, such as average customer value shown by region.
Lookup from another table
Fetch a value from a related table inside a formula, returning blank when the match is ambiguous rather than guessing.
What-if parameters
Readers pick a target, rate or scenario on the dashboard and every formula that uses it updates.
Named steps inside a formula
Break a long calculation into named steps so it stays readable to the next person.
21 ways to total a measure
Sum, average, median, percentiles, distinct count, fill rate, first and last value and more, from a dropdown.
Formulas respect permissions
Authors cannot use a column they are not allowed to see — and get no hint that it exists.
Charts and visuals
100+ chart types and the analytical layers that make them useful, built by drag and drop. Dashboards & charts.
100+ chart types
Bars, lines, areas, pies, maps, funnels, waterfalls, treemaps, scatter, heatmaps, Sankey, gauges and many more.
Project and flow charts
Gantt and timelines, sunburst hierarchies, box and violin plots, chord and network diagrams, bump charts and Marimekko.
Six KPI card styles
A plain number, with trend, against target, with an icon, with several values, or with a sparkline.
Pivot tables
A spreadsheet-style pivot with correct subtotals and grand totals — even for averages.
Tables with totals
Totals under every column, colour scales, bars inside cells and a small trend line per row.
Per-column styling
Set alignment, font, case, width and number format column by column.
Text, image and web widgets
Add headings, notes, logos and embedded web pages beside the charts.
Decomposition tree
Break a total down level by level, clicking to open the next driver.
Small multiples
Split one chart into a grid of small charts, one per category.
Trend lines
Draw a trend through the data, with a confidence band and a measure of how well it fits.
Forecasting
Project the next periods, including seasonal patterns, with a likely range.
Reference lines and bands
Mark the average, median, a goal line or a normal range on any chart.
Outlier marking
Unusual points are flagged automatically, with adjustable sensitivity.
Automatic grouping
Klayara finds natural groups in a scatter chart and colours them.
Error bars
Show the spread or uncertainty around each value.
Log scale and fixed axes
Use a log scale or fix the axis range for data that spans large ranges.
Conditional formatting
Excel-style rules — including text rules — with icons, colour and whole-row highlighting.
Seasonality groupings
Fold every Monday or every 2 pm together to see weekly and daily patterns.
Numeric bands
Group values into bands of any width — order sizes, ages, deal values — for histograms.
Top N with "Others"
Show the top ten and roll the rest into one bar, so the chart stays readable.
Filters on totals
Keep only the categories whose total passes a threshold.
Per-chart time zone
A global dashboard can read each chart in its own local business day.
Dynamic titles
Chart titles show the reader's current filter choices.
Chart suggestions
Pick your columns and the builder suggests the charts that fit.
Undo, search and copy formatting
Undo and redo in the builder, find any setting by search, and copy one chart's styling to another.
Honest limits
When a chart hits its row limit it says so on the chart itself, instead of quietly dropping data.
Build on a phone
A compact builder made for editing dashboards on a mobile screen.
Dashboards and interactivity
Pages, sections, filters and links that let every reader find their answer without asking for another report. Dashboards & charts.
Cross-filtering
Click a bar and the whole page follows. The author chooses whether a click filters or highlights, and which charts react.
Drill-down
From the year to the month to the single transaction, in clicks.
The rows behind any number
Open the records behind any figure, with the filters explained in plain words, and export them.
Pages and sections
Organise a dashboard into pages and sections; each can be styled, sized from presets and collapsed.
Compared view
Two sections of one page show different slices side by side — this region against that one, this year against last.
Relative date filters
One-click "last 30 days", "this quarter" or "year to date".
Shared filters
Define a filter once and reuse it across dashboards; its choices narrow as other filters are picked.
Promote a chart filter
Turn a one-off chart filter into a reusable shared filter without rebuilding it.
Personal filter bookmarks
Each reader saves their own filter sets and a default, without changing anyone else's view.
Filters for a single chart
Filters that apply to one chart only, alongside the page-wide ones, and a filter well readers can use themselves.
Every view is a link
The page, filters and drill level live in the link, so a colleague opens exactly what you saw.
KPI from another dashboard
Show a metric defined on another dashboard, so one number has one definition everywhere.
Duplicate and move
Copy a dashboard, section or chart, or move a chart to another page.
Comments and mentions
Discuss a dashboard in place, @mention a colleague to email them, then resolve or reopen the thread.
Version history
Every change is kept; restore a whole dashboard or a single chart to an earlier version.
Usage analytics
See views, unique viewers, public-link views and a 30-day trend for each dashboard.
Wall-screen mode
Full-screen display that refreshes itself and cycles through pages automatically.
Works on every screen
Layouts adapt from the boardroom screen to a phone, with controls made for touch.
Dark mode and personal settings
Dark mode everywhere, plus personal density, font size, accent colour and date and number formats.
Explore the data
A spreadsheet-style viewer for every table, under each person's own permissions.
Spreadsheet-style viewer
Browse any table like a spreadsheet — grouped, with subtotals, or as a matrix.
Filters in plain language
Type "orders last quarter over 500" and it becomes a real filter.
Column control
Show, hide, reorder, group and colour columns; the layout is remembered for each table.
Saved views
Save a filtered, arranged view of a table, star it, make it your default, share it or schedule it.
Edit hand-entered tables
Edit reference tables directly, including pasting rows from a spreadsheet.
Export exactly what you see
Download the view on screen, filters included, to Excel, CSV or JSON.
Automations and alerts
Reports that send themselves and alerts that fire the moment something is true. Reports to WhatsApp, Slack & Telegram.
Three ways to fire
On a schedule, when a number crosses a line, or when a new matching record appears.
Alert from any chart
Turn any chart into an alert in one click.
Cooldown and snooze
An alert fires once when a line is crossed, waits before repeating, and can be snoozed.
Digest or one message per record
New-record alerts arrive as one summary or as one message per record.
Message templates
Messages can include the value seen, the threshold, the count and the record's own details.
Three-step builder
Trigger, action, review — with a plain summary of exactly what will happen.
Send a test first
Send a test message before trusting a new alert or channel.
Run log
Every check is logged: the value seen, whether it fired, and whether each channel delivered.
Ready-made automations
Start from a daily dashboard email, a threshold alert, a new-record alert or a weekly Slack report.
Personal notification settings
An optional weekly summary email, and per-person control of email and mention alerts.
Klayara AI
Ask in plain language, get a real chart built from your data — never an invented number, and never beyond the asker's permissions. Klayara AI.
Ask, get a real chart
A question becomes a live chart from your data that you can pin to a dashboard.
Within the asker's permissions
The AI sees only what the person asking may see — the same row and column rules as everywhere else.
Shows its steps
The assistant shows what it is doing as it works, instead of a spinner.
Suggested questions
Starter questions and follow-ups drawn from your own data, so nobody faces a blank box.
Chat history and feedback
Past chats are kept; answers can be regenerated, refined and rated.
Reads the dashboard you're on
Ask about the dashboard in front of you and the assistant uses it as context.
Uses your definitions
Reuses your saved metrics, synonyms and certified tables, so its answers match the dashboards.
Ask inside the builder
Type a question in the chart builder and get a chart back, ready to edit.
Admins choose the scope
Pick which tables the AI may use and give it company-wide instructions.
Bring your own AI
OpenAI, Anthropic, Google, Moonshot or any compatible provider — or a private model on your own servers.
A premium model and a fast one
Use a premium model for hard questions and a cheaper, faster one for quick tasks.
Prepaid AI credits
AI runs on prepaid credits, with balance, top-up and day-by-day spend visible in the product.
Switch it off entirely
Turn the AI module off and the product makes no outside connection at all.
Security and governance
Decide once who sees which rows and columns; the rule holds in every dashboard, download, report, embed and AI answer. Security & permissions.
Row-level security
Each person or team sees only their region, branch, customer or entity — set once, applied everywhere.
Rules from each person's profile
Row rules can follow each person's own region or branch, or a mapping table you maintain.
Security dimensions
Name axes such as branch or region, grant each person "all" or a list, and start everyone on "nothing until granted".
Column-level security and masking
Hide a column, blank it, replace it, or keep only the last four digits — with named exceptions where needed.
Coverage view
See which tables each rule governs and which members still lack grants, so gaps are visible.
Check access
See a table exactly as a chosen member would: their rows, their hidden columns, their masked values.
Access console
Browse access by person, role or resource, with a plain explanation of why someone can reach something.
Batch access changes
Review and apply up to 200 grants, removals and role changes at once.
Custom roles
Build unlimited roles from 17 granular permissions.
Several roles per person
One person can hold several roles at once, such as Sales and Finance reader.
Safety rails
The last owner can't be removed, and removing someone clears all their individual access.
Protection survives plan changes
A billing lapse or plan change never switches a security rule off.
Two-factor sign-in
Authenticator-app codes with recovery codes, plus passwords, one-time codes and Sign in with Google.
Re-confirm for sensitive changes
Changing a password, two-factor settings or email requires signing in again.
Personal API keys
Each user can issue and revoke their own keys for scripts and notebooks.
Activity log
Changes, shares and sign-ins recorded with before-and-after detail.
Separate usage limits
Normal use, sign-ins, AI and each embed have their own limits, so one can't starve another.
Deploy it your way — or run it as your own platform
Our cloud, your cloud, your data centre or a closed network — and, for service providers, a full back office to run many customers. Self-hosted.
Cloud, private cloud or on-premises
Run Klayara in our cloud, in the cloud region you choose, in your data centre, or fully offline.
No call-home
No licence server, no usage tracking, no hidden connections. The self-hosted product is the full product.
Scales out
Add capacity as you grow; heavy data loading can run separately from dashboards.
Ready for IT operations
Health checks, monitoring and logs your IT team expects.
Everything through the API
Anything the screens do can be automated through a documented interface that stays in step with the product.
White-labelled deployment
Run the whole platform under your own brand.
Operator console
A back office, separate from the customer app, to run every customer, plan and invoice.
One-form customer setup
Create a customer with its owner and storage in one form; suspend or reactivate in a click.
Dedicated servers per customer
Give a large customer their own database servers with a setting, not a project.
Supervised support access
Support can open a customer's workspace for 15 minutes, with a visible banner and a record of it.
Plans, modules and private pricing
Build plans with seats, trials and limits, switch features on per plan or per customer, and offer a private plan to one customer.
Billing controls
Grace days, a clear lock screen when payment lapses, and invoices visible in the product.
AI pricing and controls per customer
Set AI rates and your markup, see usage by customer, and grant credit or a default model per customer.
Operator roles
Eight operator permissions control what each member of staff can do and see.
Arabic and English
Full right-to-left Arabic interface, switchable per user, alongside English.
Speed, included
No capacity to buy and no premium engine tier — fast is part of every plan. Why Klayara.
100M+ rows, still instant
Dashboard tiles answer in well under a tenth of a second on a table with more than 100 million rows.
Fast on live sources too
Data you keep in your own database can be made dashboard-fast by summaries Klayara keeps, without copying the detail.
Never a wrong answer from a shortcut
Out-of-date summaries are skipped automatically — a speed-up can only be slower, never wrong.
Crowd-proof dashboards
When many people open the same dashboard at once, the database answers once; runaway queries are stopped cleanly.
Benchmark it yourself
Rerun our speed tests on your own hardware and data.
Templates built into the product.
Pick a dashboard or an automation template when you create one, then make it your own. More ready-made layouts by team and industry are in the template gallery.
Dashboard templates
- Executive overview
- Sales performance
- Financial summary
- Marketing funnel
- Operations monitor (a wallboard that refreshes every minute)
- Inventory and supply
- Customer insights
- Product usage
- Analytics deep dive
- Blank starter
Automation templates
- Daily dashboard email at 09:00
- Threshold alert with the value and the line crossed
- New-record alert the moment a matching row appears
- Weekly Slack report every Monday at 09:00
What features does Klayara include?
More than 180 features across connecting and preparing data, modelling, formulas, 100+ chart types, interactive dashboards, a spreadsheet-style data viewer, sharing and embedding, scheduled delivery to email, WhatsApp, Slack and Telegram, automations, an AI assistant, row- and column-level security, self-hosting and a full operator console.
Are all features included in every plan?
Every feature is part of the product; plans switch modules such as AI, embedding and automations on or off. Speed, row-level security and column masking are never sold as extras. See the plans.
Is the self-hosted edition missing any features?
No. The self-hosted edition is the same product as the hosted cloud, AI included, and it runs without any outside connection.
Can Klayara build the dashboards for us?
Yes. Our BI developers connect your systems, build the dashboards, reports and alerts, and hand them over. Talk to sales.
See every feature on your own data.
Tell us which systems you run and what you need to see — we'll show you the features that matter to you, live.
Prefer to see plans first? See pricing