[Read on Dashport](https://v2.dashport.ai/how-it-works)

How it works · six steps

# How Dashport Works

From raw data to actionable insights in six simple steps. Secure, flexible, and collaborative.

[Start free trial→](https://v2customer.dashport.ai/signup)[Book a demo→](https://calendly.com/dashport-sales/30min)

01·Data Sources

*   SQL Database
*   SuperSheets
*   Google Sheets

↓

02·Build

D

Dashport Chat

No-Code

Ask in plain English — AI builds the chart for Superdashboard

▍

Works with:SQL DBSuperSheetsGoogle Sheets

OR

</>

Custom SQL

Power Users

SELECT region, SUM(revenue) AS totalFROM ordersGROUP BY regionORDER BY 2 DESC

Works with:SQL DBSuperSheetsGoogle Sheets

Report-ready → skip to Superdashboard

↓

03·Superdashboard

Superdashboard

live◎ Show the work

Total Revenue

$0$386K

▲ +12.5%

Active Users

08,334

▲ +18.2%

Revenue Trend

0%+23%

Via Dashport Chat

JanFebMarAprMayJunJulAug

Revenue

Sales by Quarter

Q1–Q4

Custom SQL

Q1

Q2

Q3

Q4

Top Regions

0%42%

N. America · By Revenue

*   N. America42%
*   Europe28%
*   Asia Pacific19%
*   Other11%

Sample data · Hover a number to see its work

Steps

1.  [01Connect Your Data](#step-1)
2.  [02SuperSheets — Enter Data Directly](#step-2)
3.  [03Manage Your Data Role](#step-3)
4.  [04Build with AI or Code](#step-4)
5.  [05Automated AI Analysis](#step-5)
6.  [06Share with Your Team](#step-6)

01/ 06connect

## 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

Pro Tip

### 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.

</> Custom SQL Query

Dashport Chat · skipped

▦ Superdashboard

— no Chat needed

sources → dashport

0/5 connected↻ Replay

*   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.

02/ 06enter

## 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

A5fx

Month

Revenue

Growth

2

Jan

$42,000

+12%

3

Feb

$48,500

+15%

4

Mar

$55,200

+13%

5

Board · Revenue by month

JanFebMarApr

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.

03/ 06govern

## 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

AdminEditorViewerGuest

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.

04/ 06build

## 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

✱ AI</> Code

Monthly Revenue

+23% YoY

› ▍

JanFebMarAprMayJunJulAugSepOctNovDec

✱ 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

✓ 12 rows · complete▶ Run Query

answercode

⇆

Show me monthly revenue trendWhich product has the highest sales?Compare Q3 vs Q4 performance

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.

05/ 06analyse

## 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 detected

⚠ +2.3σ anomaly1234

actual forecast

Latest insights

1.  1anomalyAnomaly Detected — OctRevenue spiked to 2.3σ above baseline. Review recommended.
2.  2trendGrowth Trend AcceleratingQ3 growth is +18% vs Q2. Strongest momentum in the last 4 quarters.
3.  3forecastForecast: Q1 Looking StrongIf current trend holds, Q1 is projected at +23% YoY. Confidence: 84%.
4.  4summaryWeekly AI Summary ReadyYour performance report for the week has been generated and sent to stakeholders.

Agent

Labels each insight as a trend, anomaly, suggestion or opportunity, with a confidence score.

You

Decide what to act on.

06/ 06share

## 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

⌁app.dashport.ai/share/q4-revenue-d7f2Copy

*   ✓Password
*   ✓Expiry date
*   ✓Embed
*   ✓Scheduled email

Shared with

*   SKSarah K.
*   JMJames M.
*   PRPriya R.
*   TWTom 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.

[Start free trial→](https://v2customer.dashport.ai/signup)[Book a demo→](https://calendly.com/dashport-sales/30min)

14-day free trial · Cancel anytime · Secured by Stripe

*   [The three products→](/features)
*   [Agents & MCP→](/agents)
*   [Trust & rules→](/trust)
