Data Import

How to bring your own data

Planning your data import

There are 4 steps for importing data into Exabel:

  1. Prepare Data Mappings: Determine the identifiers to be used to map your data to the pre-loaded Factset company & security symbology.

  2. Define a Data Model: Identify what entities and relationships exist in your data. Determine how to link entities to time series, and how to group these time series into signals.

  3. Prepare Data: Transform your data into time series, at the right level of aggregation, in the right format, and mapped to the selected mapping identifiers.

  4. Import Data: Import your data into Exabel with the available methods.

πŸ‘

Simple data sets - skip ahead to importing data (step 4)

If you have company-level time series, and have already mapped each time series to a company identifier (eg Bloomberg ticker), you may skip directly to importing data.

Import methods

There are 3 primary methods of importing your data into Exabel:

  1. File Uploader: upload Excel files directly into the Exabel web app

πŸ“˜

File Uploader: for quick, one-off evaluations of simple data

The File Uploader allows for imports of simple time series data that has to be at company-level, or at global-level (not linked to any entity).

Imports are processed in seconds, and appear directly in your Library, available for analysis immediately.

  1. Exabel SDK: import data with Exabel's SDK (software development kit)

  2. Import jobs (beta): import data with Exabel's direct database integration, currently available for Snowflake.

πŸ“˜

Exabel SDK and Import Jobs: for data pipelines and complex data models

Both the Exabel SDK and Import jobs (beta) allow you to import your own custom entities and relationships. You can then import time series data for any entity.

You can use the graph_signal() DSL function to access this data, and save such a signal to your Library.


What’s Next

Learn more about mapping your data to companies & securities, then defining data models, preparing and mapping data, and methods for importing data