Sapioverse

Intelligence
Log in

Master Sapioverse

This guide details every interface and tool in the platform so you can turn your databases into a real competitive advantage.

Sapioverse Overview
1

Analysis Chat

The Chat is your main tool to ask your data directly and get immediate answers in natural language. No technical knowledge required; just ask whatever you need to know:

Database Selector

In the left panel, you can choose the data source you want to query. Once selected, the system will confirm it's ready. If you want to change topics or clear the screen, click "New Conversation".

Switching Sources Switching Databases
Clear Chat New Conversation
Side Panel

Writing Queries

The bottom area lets you type business questions. The intelligence understands the context of your previous questions to follow up on the analysis.

Query Input

Analysis Results

Each answer includes an Executive Summary, an Interactive Chart, a detailed Data Table and the generated Technical Query. You can pin any analysis to a dashboard.

System Response
Data Button

View the raw data behind the analysis.

Technical Button

Check the system's technical logic.

Pin Button

Pin the chart to a dashboard.

2

Bulk Export Mode

When you need to extract large volumes of data for external analysis or audits, you can activate Export Mode directly from the chat bar.

Export Mode ON
EXPORT MODE: ON

No Automatic Limits

By activating this mode, the AI ignores display restrictions (LIMIT/TOP) to extract all data that matches your description, allowing downloads of up to 20,000 records.

Professional Excel Format

Once the response is obtained, you can download the full dataset in a .xlsx file ready to be processed in spreadsheet tools.

Tip: Use this mode when your question involves a detailed list (e.g., "Give me all invoices from the last quarter with client details").
3

Control Panels

Dashboards are spaces where you monitor your key indicators in real time. Group your most important metrics in a single view to make informed decisions.

Dashboard View

Custom Organization

Create specific panels for each area (e.g., Sales, Operations) to group your most relevant analyses and share them with your team.

Add from Chat Add chart to dashboard

Use the "ADD TO DASHBOARD" button in any Chat response to send it to a dashboard.

Automatic Reports

Receive your panels directly in your email with the frequency you choose (Daily, Weekly, or Monthly).

Email Subscriptions

Detailed Exploration

Interact with your data dynamically. Scroll down to discover the management and export tools.

Chart Management

01. CUSTOMIZATION

Editable Titles

Adapt each chart to your business context by changing its title directly from the dashboard interface.

02. REAL TIME

Data Refresh

Charts update automatically upon entry. You can also force a manual update to see the latest changes.

03. AUDIT

View Data and SQL

Inspect the original data table or the SQL code that generated the chart for maximum transparency.

04. MAINTENANCE

Delete Charts

Keep your panels clean by removing visualizations that are no longer necessary with a single click.

01. REPORTING

PDF and PPT Export

Download the full dashboard for your presentations or official reports in PDF or PowerPoint.

02. AUTOMATION

Email Subscriptions

Automate the sending of your panels to relevant stakeholders on a recurring basis.

03. FREQUENCY

Flexible Scheduling

Choose specific days and times for automatic delivery. Sapioverse guarantees punctuality.

04. NAVIGATION

Panel Management

Go back to the general list or delete full panels to organize your workspace efficiently.

Global Tools

4

Data Source Management

Define and explain to the system what information it should use to answer your questions. Connect your databases and give them the necessary business context.

Sources Interface

New Connections

Add your SQL databases (PostgreSQL, MySQL, SQL Server) in seconds by configuring access parameters.

Add Connection

Table Selection

You don't need to import your entire database. Select only the tables that contain relevant information for your analyses.

Add Table

Business Context

It is essential to explain what your data means so the IA can provide accurate answers.

Connection Detail

Data Tools

01. AUTOMATIC ANALYSIS

EDA Statistics

Generate an automatic statistical report to understand the distribution and quality of your data instantly.

02. UPDATE

Refresh Metadata

If your data changes or new records are added, use this option so the IA updates its statistical view.

03. MAINTENANCE

Structure and Deletion

Refresh the table structure to detect new columns or remove the table from the system if you no longer need it.

5

Visual Data Map

Visualize the architecture of your information through an interactive Entity-Relationship diagram.

ER Diagrams

Access a graphical representation of your tables and their connections by clicking the ER Diagram button on any connection.

ER Diagram Button
Visual Map
🖱️
Interactivity

Organize tables by dragging them and use zoom to navigate.

📑
Details

Use 'View Fields' to inspect the columns of each table.

🎯
Focus

'Reset' button to automatically center the view.

6

Table Relationships

To perform advanced analyses that cross-reference information (e.g., Sales by Salesperson), you must define how tables connect.

Manage Relationships

Define 'Many-to-One' relationships so the Chat understands how data from different departments relate.

Relationships Button
Relationships Interface

Components of a Relationship

  • 1

    Fact Table (Sales)

    The main table containing the numerical values you want to analyze.

  • 2

    Dimension Table (Customers)

    The table that provides categories or names to filter data (e.g., the customer's name).

  • 3

    Join Fields (FK / PK)

    The unique identifier shared by both tables (e.g., CUSTOMER_ID).

Let's get started!

Set up your data sources and discover the hidden value in your information with Sapioverse.

Get started now