3. Importing Data

Simlytiks allows for visualizations to be organized per imported data source, so we can keep certain visualized information separate from other visualized information.

Initial View After Importing Data

To learn how to access the Simlytiks Application, please review this section.

The landing page allows us to upload new datasets, sift through and open saved dashboards, and drag-and-drop files quickly into the application.

Figure 1: Simlytiks Landing Page

1. New Dataset: Click this button to upload a dataset in Simlytiks and start creating a dashboard.
2. Filters: Click on a basic filter to search through saved Simlytiks dashboards in the data table.
3. Drop Box: Drag-and-drop or click-to-upload files to open as a dataset in Simlytiks.
4. Saved Simlytiks Dashboards: Click on a dashboard name to reopen it in Simlytiks.

We can add data to explore in four main ways. Start by clicking on + New Dataset in the top left corner of the page to open the modal window for uploading data. Each tab in the modal contains each way for uploading data. Read on to learn about these.

3.1. Import From File

Upload data from our local machine by dragging-and-dropping files or clicking to open the local files window.

Figure 2: Import From File

The file will appear in the drop-zone. Finish importing the data into Simlytiks by clicking View at the bottom right corner of the modal. For excel files, we will be prompted to select data in the next window as shown in the following video:

3.2. Connect to Database

Source data from a database by running a query to pull the data.

Figure 3: Connect to Database

3.3. Simulations or Experiments

Open a simulation or physical test in Simlytiks. We can sift through all our simulation and physical test records and choose to view one or compare multiple.

Figure 4: Simulations or Experiments

Mid-Run Extraction

NEW as of June 7, 2022: You can re-extract simulation responses to update your simulation comparison in Simlytiks. Use this option when choosing responses in the Simulation Compare window for viewing the data in Simlytiks.

Figure 5: Mid-Run Extraction

Here is an example:

Figure 6: Mid-Run Extraction Example

3.4. Sample Datasets

Select one of the listed sample datasets to explore, and then click View to open it in Simlytiks. This is a great option if looking to just get familiar with Simlytiks.

Figure 7: Sample Datasets

3.5. Data Sheets

Upon creating or opening new dataset, you’ll have a dataset navigation bar at the bottom of the page where you con import more data to create multiple dataset explorations under the same Simlytiks window.

Figure 8: DataSet Navigation

Duplicating Sheets

Duplicate your data sheet under File > Duplicate. This is helpful if you want to separate explorations for the same dataset.

Figure 9: Duplicate a Sheet

3.6. Importing Additional Data

Importing Assets

You can import images/alias/colors from other datasets into your current dataset. This is useful if you need consistency in your data customizations through out all your explorations.

Figure 10: Importing Assets

Importing Updated Data

You can update your dataset by importing additional data and choosing to replace, join or append new with original data.

Here’s how it’s done:

This option can support merge when duplicate primary-keys are found as shown in the following video: