Sales and billing
Revenue by period, product, rep and region straight from system tables.
Databases
Dashboards from SQL Server, with AI
Many ERPs and management systems store their data in SQL Server. Connect the database to Hubviz, pick tables or a query and let AI build the dashboard with your operational numbers.
7 days free · Cancel before the trial ends and pay nothing
How to connect: SQL Server
-
Create the connection profile
Enter your SQL Server access details in Hubviz Studio. The profile is saved for reuse in other projects.
-
Pick tables or write the query
Browse schemas, tables and views, or write the SQL. If you prefer, describe it in plain language and AI generates the query.
-
Ask for the dashboard
With the cube created, ask AI for the dashboard or build it in the visual editor and publish to Hubviz Web.
What you can do
- Explorer with schemas, tables, views, primary and foreign keys
- Custom query or direct table selection
- AI SQL generator based on the database structure
- Scheduled refresh with cron expressions
Finance
Payables, receivables, overdue accounts and cash flow.
Inventory and operations
Turnover, coverage and movement by unit.
Executive view
KPI cards compared with the previous period for leadership.
Frequently asked questions
Does Hubviz change data in SQL Server?
No. Hubviz reads data for analysis. We recommend a database user with read-only permission.
Do I need to know SQL?
No. You can pick tables or describe the query in plain language for AI to generate the SQL.
Does it work with SQL Server on the company network?
Yes. Hubviz Studio runs on your computer and connects to any database that computer can reach, including on the internal network.
See also
See all your company numbers in one place this week
You get 7 free days to connect your sources and build your first dashboards.