How it works · six steps
How Dashport Works
From raw data to actionable insights in six simple steps. Secure, flexible, and collaborative.
01Data Sources
- SQL Database
- SuperSheets
- Google Sheets
02Build
Dashport Chat
No-CodeAsk in plain English — AI builds the chart for Superdashboard
Works with:SQL DBSuperSheetsGoogle Sheets
Custom SQL
Power UsersSELECT region, SUM(revenue) AS totalFROM ordersGROUP BY regionORDER BY 2 DESC
Works with:SQL DBSuperSheetsGoogle Sheets
Report-ready → skip to Superdashboard
03Superdashboard
Superdashboard
liveTotal Revenue
$386K
▲ +12.5%
Active Users
8,334
▲ +18.2%
Revenue Trend
+23%
Via Dashport Chat
Sales by Quarter
Q1–Q4
Custom SQL
Top Regions
42%
N. America · By Revenue
Sample data · Hover a number to see its work
Connect Your Data
Seamlessly integrate with your existing data stack. We support a wide range of data sources so you can get started immediately.
- Upload CSV or Excel files directly
- Connect to SQL databases (PostgreSQL, MySQL, MS SQL, Snowflake)
- Select a table or write a custom SQL query
- Use REST APIs for custom data connections
SQL Power User Shortcut
Write a custom SQL query when connecting your database and your report data is already shaped and ready. In the BI world, a custom query is the report — you can skip Dashport Chat entirely and go straight to Superdashboard to build your charts.
— no Chat needed
sources → dashport
0/5 connected- CSV / Excel
- JSON / XML
- PostgreSQL
- MySQL
- SaaS / API
dashport · intake
Agent
Reads the schema and suggests joins, each with a confidence score.
You
Pick a table, or paste your own SQL.
SuperSheets — Enter Data Directly
SuperSheets is Dashport's built-in spreadsheet platform. Enter data and formulas, then use Sync on the connected source before querying the latest sheet revision.
- Spreadsheet-style data entry inside Dashport
- Formulas, calculated columns & data validation
- After edits: Sync the sheet source, then rerun to update saved results
- Import from Excel / Google Sheets in one click
Revenue 2026
SuperSheets| Month | Revenue | Growth | |
|---|---|---|---|
| 2 | Jan | $42,000 | +12% |
| 3 | Feb | $48,500 | +15% |
| 4 | Mar | $55,200 | +13% |
| 5 |
Board · Revenue by month
Waiting for input…
Agent
Can draft the sheet's columns from one sentence. You review before it applies.
You
Type rows. Every board that uses them updates.
Manage Your Data Role
Keep your sensitive information secure with enterprise-grade governance controls. Define exactly who sees what.
- Role-based access control (RBAC) for teams
- Column-level data masking for sensitive PII
- Row-level security policies
- Audit logs for all data access and changes
RBAC Policy
| Role | Dashboard | Data | Reports | Settings | Export |
|---|---|---|---|---|---|
| Admin | ✓ | ✓ | ✓ | ✓ | ✓ |
| Editor | ✓ | ✓ | ✓ | – | ✓ |
| › Viewer | ✓ | – | ✓ | – | – |
| Guest | ✓ | – | – | – | – |
Access granted No access
What this role sees · Viewer
Revenue by region
| Europe | 49,810 | •••••• |
| Asia Pacific | 43,010 | •••••• |
| North America | 42,730 | •••••• |
- email · masked
- – no export
Agent
Scans connected sources and suggests which columns are sensitive.
You
Approve it. Roles and masks enforce it from then on.
Build with AI or Code
Create the perfect dashboard your way. Use our advanced AI for instant generation, or switch to code for precision control.
- Ask questions in plain English to generate charts
- Use the drag-and-drop builder for quick layouts
- Switch to Code Mode to edit raw SQL or React components
- Custom CSS styling for pixel-perfect branding
Monthly Revenue
+23% YoY›
✱ AI generated · 12 data points
query.sql
-- Monthly revenue trend (last 12 months)SELECT DATE_TRUNC('month', created_at) AS month, SUM(amount) AS revenueFROM transactionsWHERE created_at >= NOW() - INTERVAL '12 months'GROUP BY 1ORDER BY 1 ASC;
Adds up every transaction, month by month · 12 of 12 months · nothing missing ✓
rows · 12
| Jan | 42 |
| Feb | 55 |
| Mar | 48 |
| Apr | 67 |
| May | 72 |
+ 7
Ask anything · AI generates charts instantly
Agent
Writes the SQL, checks the result is complete and picks the chart.
You
Approve it, pin it, or open the code.
Automated AI Analysis
Your personal AI analyst analyzes trends, tracks changes, and prepares detailed reports and insights directly on your dashboard.
- Automatic trend detection and anomaly alerting
- Daily or weekly AI-generated performance summaries
- Predictive analytics for future forecasting
- Natural language explanations of complex data changes
AI Analyst
+18% trend detectedactual forecast
Latest insights
Agent
Labels each insight as a trend, anomaly, suggestion or opportunity, with a confidence score.
You
Decide what to act on.
Share with Your Team
Turn insights into action by sharing your dashboards with stakeholders. Collaborate in real-time and drive decisions.
- Share public links or secure password-protected views
- Embed dashboards directly into your product
- Schedule automated email reports
- Comment and annotate directly on charts
Team Sharing
0 viewing now- Password
- Expiry date
- Embed
- Scheduled email
Shared with
- Sarah K.
- James M.
- Priya R.
- Tom W.
Recent activity
Agent
Sends scheduled reports and logs every job.
You
Choose who sees what, and for how long.
Connect once. Then ask, check and share.
Connect a source and ask your first question today. The work stays visible at every step.
14-day free trial · Cancel anytime · Secured by Stripe