Lesson 3 - Analyzing data in a table

So far we've imported our music albums file, and converted the "Genre" column into a relationship. Before we move on to graph functionality, let's learn how to do basic analysis of a flat file.

2 min read - Start now

Step 1

Open your music albums project from previous lesson. On the left side, notice the "Analyze" section. Next to "Filters", click on the "Add" button.

Step 2

We'll want to filter by artist, so for "Column" select "Artist". For "value", type in "The Beatles"". Click the "Apply" button.

Step 3

You should now see a table of all albums by The Beatles. Now let's try grouping and aggregations. Remove the filter and this time add a Group. For column, pick "Artist" and click the Confirm button.

Step 4

Add an aggregation too. Let's figure out how many albums we have for each artist. Add a new aggregation, for column select "Artist" again and leave type set to "Count". Click the confirm button.

Step 5

Your table now shows all artists and the number of albums for each. Let's sort the results by number of albums. Next to the "count Artist" column, click on the ellipsis icon and select "Sort descending".

Step 6

You will now see a list of artists with most albums. You just learned how to do simple filtering, aggregation and sorting of the results with KgBase.