Skip to content

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-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 totalFROM ordersGROUP BY regionORDER BY 2 DESC

Works with:SQL DBSuperSheetsGoogle Sheets

Report-ready → skip to Superdashboard

03Superdashboard

Superdashboard

live

Total 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

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
  • 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
    MonthRevenueGrowth
    2Jan$42,000+12%
    3Feb$48,500+15%
    4Mar$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.

    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
    RoleDashboardDataReportsSettingsExport
    Admin✓✓✓✓✓
    Editor✓✓✓–✓
    › Viewer✓–✓––
    Guest✓––––

    Access granted No access

    What this role sees · Viewer

    Revenue by region

    Europe49,810••••••
    Asia Pacific43,010••••••
    North America42,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

    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

    Jan42
    Feb55
    Mar48
    Apr67
    May72

    + 7

    ✓ 12 rows · complete▶ Run Query
    answercode
    ⇆

    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σ anomaly

    actual forecast

    Latest insights

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