Uploading your data

Learn about the upload process, data analysis and data types

The uploading process

Atmolytics Cloud removes the heavy lifting of migrating your data. Your dataset will go through a few steps to work with Atmolytics Cloud.

Step 1 - Formatting Atmolytics Cloud will format your data with its in-built upload tool.

Step 2 - Analysis Atmolytics Cloud will analyse your data.

Step 3 - Importing And finally, Atmolytics Cloud will import your dataset.

Choosing a data source

Uploading your data: choosing a data source The beta version of Atmolytics Cloud currently supports the following data sources:

  • CSV (.csv)
  • Excel Spreadsheet (.xlsx)

In the future, you’ll be able to connect Atmolytics Cloud to PostgreSQL, MySQL and SQL Server.

Uploading your data: choosing a data file Once you have chosen where your data is coming from, click ‘Continue’ to choose your data.

Excel files

Uploading your data: choosing a data source

Atmolytics Cloud supports Excel files containing multiple worksheets. If you have multiple worksheets, the next screen will prompt you to choose from the following:

  • The worksheet: the worksheet containing your dataset
  • The header row: Atmolytics Cloud will try to detect this, though this can be overridden
  • The first row of data: Atmolytics Cloud will try to detect this, though this can be overridden
  • The column range: Which columns to include in the analysis
Tip

Atmolytics Cloud supports Excel files containing multiple worksheets. If you have a single file with multiple worksheets, you won't need to change anything.

CSV files

Atmolytics Cloud will read through each row and column contained in the CSV file.

Analysis results

Uploading your data: analysis results After Atmolytics Cloud has formatted your data, you’ll see the results screen. This screen provides a list of fields contained within your dataset.

Data types

Uploading your data: data types We use an algorithm to determine the data type in your dataset. The data types vary from text, numeric, multiple choice and dates. In some cases, you can change the data type.

Field names/alias

Uploading your data: renaming fields Sometimes header rows are written in shorthand or are missing. On the results screen, you’ll be able to:

  • Change the data type; and
  • Rename fields; and
  • Hide fields

This can be useful if you have a large dataset. You’ll be able to break down your dataset into multiple smaller datasets. This can be useful when you start to analyse your data in Atmolytics Cloud.

When you’re happy with your edits, click ‘Continue’ to move onto specifying some key data fields.

Key data fields

Uploading your data: key data fields Key data fields enable specific functionality in Atmolytics Cloud. During analysis, Atmolytics Cloud tries to pre-select fields that match our algorithm. You can override these fields, but you might lose some features.

When you’re happy with your key data fields, click ‘Continue’ to start importing your data.

Naming the dataset

Uploading your data: naming the dataset The final step in importing your data is to give your dataset a name. Naming your dataset helps to identify it when using Atmolytics Cloud.

After you’ve named your dataset, click ‘Import’. This will save the dataset into Atmolytics Cloud.

Further reading