How To
Apr 5, 2023

Big Data Visualization Made Easy With Gigasheet

Everybody loves a chart or graph! Data visualization tells a story about complex data in a simple format that can be instantly understood. But behind every chart, there is data that has been collected, curated, and prepared for visualization. Most of the time, this is probably done using a spreadsheet such as Microsoft Excel or Google Sheets.

But, what if you have a REALLY big data set? Data visualization becomes a much harder problem if you can't easily open the source data. Microsoft Excel is limited to one million rows, and Google sheets is limited to 10 million cells, which is basically the equivalent limit (imagine a 10 column file, limited to 1 million rows). Therefore, you will need to locate other big data visualization tools. And let's face it, not everyone knows how to set up a database and use SQL to summarize data.

Enter Gigasheet, the big data spreadsheet that can handle up to a billion rows of data without installing any software. Additionally, Gigasheet is a full-fledged data science workbench with all tools you will ever need for data analysis and visualization. Simply upload your file and start analyzing.

In this blog, we will explore how easy it is to explore huge files and perform big data visualization with Gigasheet. So, read on.

Big Data Visualization with Gigasheet

For our analysis and visualization, we are using a dataset with information regarding the artist and the songs on the Spotify global weekly chart. The dataset includes columns for artist name, song title, position in the chart, number of streams, and much more.

As mentioned, we will use Gigasheet to convert data to charts from our Spotify weekly chart dataset. We will explore different visualization options, including pie charts, line graphs, bar graphs, and more. We will also use features like groups, filters, etc., for data analysis. Let’s get started.

Before we can convert data to charts, we need to upload our data set to Gigasheet. So, first, we will head to gigasheet.com and sign in. (You can sign up for Gigasheet here for free!)

Once we are in, we have the Gigasheet Library on our screens which stores all our files. Now, we will click on New and choose our Spotify global weekly chart dataset.

Snapshot of processed CSV files in Gigasheet's library.

Our dataset is a CSV file, but you can upload large datasets in many popular formats, including XLSX, JSON, LOG, ZIP, and more. Now we will click on our dataset, and Gigasheet will open it in tabular form.

CSV dataset of Spotify dataset processed in spreadsheet format in Gigasheet.

Big Data Visualization Examples

Below we will explore several different charts that can be created from the data set.

Top 20 Songs and Their Total Streams

Our Spotify dataset has details of the top 200 songs, so let us see which songs had more streams in the week. We will click on Filter in the menu bar and filter rows with Pos (position) less than or equal to 20, as shown below.

Gigasheet allows users to create filters with conditions to filter data as per their need.

Now for data visualization, we will select all the cells in the Title and Streams columns. From here, there are 2 ways to create a chart:

1. Hit the Chart Data button

Once highlighted, create a visualization with the click of a button.

big data visualization examples
Bar chart of Top 20 Songs and Their Total Streams

If you want to change the chart type, mouse over the chart are and select the triangle to choose a different chart type. Here, I convert it to a pie chart.

Pie Chart of Top 20 Songs and Their Total Streams

2. Or Right-click Data, and Directly Choose the Chart Type

Here I choose, Chart Range > Column > Grouped.

Creating bar graph using Chart Range feature in Gigasheet.

And there we have the top 20 songs and the number they did in the week.

Snapshot of a bar graph created in Gigasheet.

Top 10 Artists with the Most Songs on the Chart

Now, let us see, out of all the artists on the Spotify weekly chart, which ones have the most songs featured on the list? First, we will click on Group in the menu bar and group rows by Artist column.

Users can group rows by columns and even create group within groups.

Then, we will sort the Title column in descending order by clicking on the header row, as shown below.

Gigasheet does not require coding to sort data. Users can sort values in a column using Sort option.

Since many artists have multiple songs on the list, we need to calculate the sum of their weekly streams. Therefore, we will bring up the drop menu and select Sum.

Gigasheet automatically performs calculations depending on the data in a column. Users just have to select arithmetic function.

We will use a pie chart to visualize data for the top 10 artists with the most songs. And select cells in Title column for the top 10 artists, and select Chart Range > Pie.

Snapshot of pie chart created in Gigasheet.

Weekly Streams and Total Streams for the Top Artist

Bad Bunny is the top artist with the most songs on the Spotify weekly chart and the most combined streams in the week. So let us deep dive into the performance of the artist’s songs and convert data to charts. First, we will filter data for Bad Bunny using the filter as shown in the snapshot.

Gigasheet allows users to create filters with conditions to filter data as per their need.

Not all songs saw boosted streams; some songs had static numbers, and some even had fewer streams from the previous week. We will select Title, Streams, and Stream+ columns to visualize this trend and right-click > Chart Range > Line.

Snapshot of line chart created in Gigasheet.

Customizing Charts and Graphs

We also get plenty of options to customize charts to create data visualizations tailored to their specific needs.

1. Change Chart Type

As you saw above, Gigasheet has many graphs and charts, but you can switch from one type to another with one click. If the bar graph does not work best with your dataset? Just expand the chart settings and select the chart type you prefer.

Charts and graphs are customizable in Gigasheet.

2. Add Labels

In Gigasheet, you can add titles to graph and labels to axis, legends, and data in Format section of graph settings.

3. Stylize Your Graphs

Working with a color scheme on your data analysis report? Gigasheet allows you to customize the look of graphs as well.

Charts and graphs are customizable in Gigasheet.

4. Export Your Graphs

You can download the charts you prepare, download them to your device to add charts in Excel or any tool you work on.

Wrapping Up Big Data Visualization

Anyone can easily visualize data and extract meaningful insights, thanks to Gigasheet. You can quickly create charts and graphs from their data without coding or specialized software. Additionally, it provides users with a massive selection of editable templates and options to customize their data visualization to suit their particular requirements. And Gigasheet is completely free-to-use, so sign up today!

Similar posts

The ease of a spreadsheet with the power of a database, at cloud scale.

No Code
No Database
No Training
Sign Up, Free Forever

By using this website, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.