Solutions · 01

BI platform

Upload a spreadsheet or connect a database, Google Sheets or an API. The bi19 platform recognizes what the data is about, links the tables and proposes the measures; you review, apply and build the dashboards. Fixing by hand is the exception.

The problem

  1. The data exists, but nobody trusts the number.

  2. Every report is a spreadsheet rebuilt by hand.

  3. The meeting ends with an opinion, not a decision.

The platform

What it does for you.

  1. Any source

    Files (CSV, Excel, JSON, Parquet), PostgreSQL, MySQL and SQL Server, Google Sheets and APIs, with credentials stored encrypted.

  2. Automatic modeling

    It identifies what each table is about, the role of each column and the keys, and links the tables when names and values agree.

  3. Measures ready to use

    Counts, totals, average ticket and averages proposed from the data; once applied, they become certified measures the whole team shares.

  4. Dashboard builder

    Charts, tables and indicators on a canvas that saves as you work; each dashboard picks the bases that feed it.

  5. Your Power BI inside

    Connect your company's Power BI and show its reports in bi19: viewers don't need a Power BI license, and row-level security is respected.

  6. Workspaces and roles

    Each company in its own workspace, with owner, editor and viewer: viewers see the numbers, they don't change them.

  7. Sharing with external users

    Share a dashboard with people outside your company (clients, partners, the board) without opening the workspace. They see only what you shared, read-only, and only owners and editors can share.

    Authentication policy

    • Verified identity

      Every access asks for a 6-digit code sent by email, or a Google or Microsoft account. No open links.

    • Access list

      Only the emails or company domains you choose get in.

    • Expiry and revocation

      Set an end date, or cut access at any time.

    • Access log

      See who opened each dashboard, and when.

How it works

From the spreadsheet to the dashboard, in four steps.

Load the base

Upload a file or connect a database, a Google Sheets link or an API.

Review the proposal

The platform shows what it understood: subject, columns, links and measures. Adjust what you want.

Apply the model

The tables enter the BI and the measures become certified: one source of truth for every report.

Build the dashboards

Charts, tables and indicators in the builder, which saves as you work.

Custom projects

Need something specific? We build it.

Financial studies, geomarketing, case studies, Power BI dashboards and data science, made for the decision at hand by the same team that builds the platform.

Power BI

Power BI chart of net revenue by grade with the cumulative share line
Targeted financial studies presented in Power BI: revenue by product, average ticket, acquisition and retention.

Geomarketing

Map with customers and competitors plotted around a school, with a radius selector
Geomarketing and geographic intelligence: where customers and competitors are, within each location's radius.

Business Intelligence

Dashboard with a stacked bar chart and four indicators
Business Intelligence dashboards created with a proprietary tool built by BI19.
Start a project

Sources

Connects to what you already use.

  • CSV
  • Excel
  • JSON
  • Parquet
  • PostgreSQL
  • MySQL
  • SQL Server
  • Google Sheets
  • REST APIs
  • Power BI

Questions

Before you start.

Do I need to know data modeling?

No. The platform proposes the subject, the links and the measures; you review and adjust what you want before applying.

I already use Power BI. Do I lose my reports?

No. Connect your company's Power BI and the reports appear in bi19, next to the dashboards built here.

Can I use data from my ERP or CRM?

If it has an API or a database, yes: the platform reads APIs, page after page, and SQL databases directly. When it has neither, we find the way in as a custom project.

Can you build something specific for us?

Yes. Custom dashboards, studies and integrations are part of what we do. Tell us what you need.

Let's turn your data into decisions.

Sow ideas, reap solutions.