πŸ”—Connect your data

Overview

The "Connect Data" page in AnalytiTalk allows users to link their data sources for analysis. Users have three main options:

  1. Open data : Select from pre-existing datasets.

  2. Select your database : Connect to databases such as Snowflake, BigQuery, RedShift, or PostgreSQL by providing connection details.

  3. Upload a file : Upload data files in formats like CSV, XLS, and XLSX either by dragging and dropping them or browsing files on your computer.

This simplifies the process of connecting and preparing your data for analysis.

Open Data

  • Choose "Open Data" as your data source.

  • Select from available datasets, such as "Music Store," "INSEE Population France," or "INSEE Election France."

By following these steps, you can easily explore and analyze sample datasets using AnalytiTalk.

How to connect Open Data.

Select your database

To connect AnalytiTalk to your own databases, follow these steps:

  • Choose "Select Your Database" as your data source option.

  • From the dropdown menu, select your database type. Available options include:

    • Snowflake

    • BigQuery

    • Redshift

    • Postgres

How to connect your databases.
  • Enter the required connection details, such as host, port, database name, username, and password.

  • Ensure that your database is accessible from AnalytiTalk and that you have the necessary permissions.

How to provide the credentials.

Once connected, you can start querying your data using natural language, create visualizations, and leverage AnalytiTalk's powerful analysis tools.

Upload a file

To upload your files to AnalytiTalk for data analysis, follow these steps:

  • Choose "Upload a File" as your data source option.

  • Drag your file into the designated area on the screen.

  • Alternatively, click the "Browse files" button to select the file from your computer.

  • Supported file formats

    • CSV

    • XLS

    • XLSX

  • Ensure your file size does not exceed 50MB and formatted for example the column names always be in the first row.

By following these steps, you can easily upload your data files and start analyzing them using AnalytiTalk

How to upload a file.

Last updated