Importing Data into OmniSci

The goal for this project is to visualize Spotify’s data with OmniSci Immerse to analyze the trend of artist/track popularity from 2017–2018. I downloaded this Spotify dataset as a CSV from Kaggle, which contains the daily ranking of the 200 most streamed songs in 53 countries from 2017 and 2018 by Spotify users. It contains over 3 million rows, comprising 6629 artists, and 18598 songs for a total count of one hundred five billion streams.

Now that the data is on my local machine, it’s ready to be imported into OmniSci Immerse. Inside the OmniSci Cloud interface, select the ‘Data Manager’ tab from the navigation bar, then click on the blue ‘Import Data’ button on the upper-right corner:

We’re given two options for importing data: from a local file on your machine or from Amazon S3. Since my data is on my local machine, I’ve selected the ‘Import data from a local file’ option, and then selected the Spotify CSV file I downloaded from Kaggle.

After OmniSci has finished uploading the file, you’ll see a preview of the data, have the option to rename the table, and finally we can select the ‘Import Data’ button.

After the data has successfully imported, you can return to the Data Manager page and see that your new table is included. Now you’re ready to create your very first dashboard.