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

# How Dashport Works

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

SQL Database

SuperSheets

Google Sheets

Dashport Chat

No-Code

Ask in plain English — AI builds the chart for Superdashboard

Works with:SQL DBSuperSheetsGoogle Sheets

Custom SQL

Power Users

SELECT region, SUM(revenue) AS total

FROM orders

GROUP BY region

ORDER BY 2 DESC

Works with:SQL DBSuperSheetsGoogle Sheets

Report-ready → skip to Superdashboard

Total Revenue

$0K

+12.5%

Active Users

0

+18.2%

Revenue Trend

Via Dashport Chat

+23%

Sales by Quarter

Custom SQL

Q1

Q2

Q3

Q4

Top Regions

N. America

42%

Europe

28%

Asia Pacific

19%

Other

11%

Dashport Chat

No-Code

Revenue

$0K

+12.5%

Active Users

0

+18.2%

Revenue Trend

+23%

Top Regions

By Revenue

N. America

42%

Europe

28%

Asia Pacific

19%

Other

11%

CSV / Excel

JSON / XML

PostgreSQL

MySQL

SaaS / API

![Dashport](/favicon-white.svg)

CSV / Excel

JSON / XML

PostgreSQL

MySQL

SaaS / API

![Dashport](/favicon-white.svg)

1

### 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 QuerySuperdashboard— no Chat needed

SuperSheets

Month

Revenue

Growth

Jan

$42,000

+12%

Feb

$48,500

+15%

Mar

$55,200

+13%

Waiting for input...

2

### SuperSheets — Enter Data Directly

No database? No problem. SuperSheets is Dashport's built-in spreadsheet platform. Type in your data, apply formulas, and watch your dashboards update in real time — zero setup required.

*   Spreadsheet-style data entry inside Dashport
*   Formulas, calculated columns & data validation
*   Live sync: every edit instantly updates your dashboards
*   Import from Excel / Google Sheets in one click

RBAC Policy

Role

Dashboard

Data

Reports

Settings

Export

Admin

Editor

Viewer

Guest

Access granted

No access

3

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

AICode

Ask anything · AI generates charts instantly

4

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

+18% trend detected

JanAprJulOctJanApr

5

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

Team Sharing

0 viewing now

app.dashport.ai/share/q4-revenue-d7f2

Copy

Shared with

SK

JM

PR

TW

+3

Recent activity

6

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