Analytics Workshop Sofia2. Visualization. (Part 4/4)

The goal of this workshop is to create a recommendation system based on user ratings. The workshop is based on one of the exercises proposed at the Spark Summit.

 

We’ll use one of the Movielens datasets that already reside on the platform. We’ll do it in four steps:

 

  • Creating a simple display.

 

In the final step we’re going to create a dashboard on the created ontology.

 

 

 

Gadget Creation

 

First we’ll create the gadgets that will be displayed in the dashboard. Go to ‘My Gadgets’ menu. Click on ‘New Gadget’. The first gadget we’ll create is one of ‘table’ type. Choose that option in the catalog. You will have to fill in the necessary data for it creation:

 

  • Name: E.g. adviser_table_yourname
  • KP: The ThinKP you created in previous steps
  • Get data from query
    • Database: BDH
    • Maximum values to plot: 100
    • Get data each (seconds): 0
  • Query
    • Ontology: Choose the ontology you have created for this workshop.
    • Query: select User, Movie, Genre from name_ontology

 

It should look something like this:

 

image358

 

Click on the add button next to the query. You’ll see more options you have to fill in with the name of the field to display along with its transformation (It is not mandatory), and the alias that will appear in the Gagdet. Add the User, Movie and Genre fields.

 

image359

 

If everything is correct, below this block should appear a preview of the table. To finish, click on “Create”.

 

Let’s go for the second Gagdet. Go to Gadget creation menu and choose in the catalog one of ‘Pie’ type. Again we have to fill in a number of attributes:

 

  • Name: adviser_pie_yourname
  • KP: The same ThinKP as for the table
  • Get data from query
    • Database: BDH
    • Maximum values to plot: 100
    • Get data each (seconds): 0
  • Query
    • Ontology: Choose the ontology you have created for this workshop.
    • Query: select Genre, count(distinct Movie) as num from name_ontology group by Genre

 

image360

 

As in the table, we have to fill in the measurements:

 

  • Category: Genre
  • Value: num

 

Once you have added the measurements, a preview of the chart will appear:

 

image361

 

Just need to create the dashboard. To do this, go to ‘My Dashboards’ menu, click on ‘New Dashboard’. Fill in the name, choose the theme you prefer and click on ‘New page’. A window like this will open:

 

image362

 

Click on + button to choose a created Gadget and choose ‘Table Gadget’ type. Once done, click on the Gadget configuration button, choose the one you created in the previous steps, put a name and click on the “Close” button.

 

image363

 

You should show the table you created with the Gagdet.

 

Similarly, add the ‘Pie’ Gagdet you created in the previous steps. Once this is done, you can move the gadgets by using the move button on each of them. Finally, the dashboard might look something like this:

 

image364

 

So far the Analytics Workshop Sofia 2, we hope you have enjoyed.

 

We’ll wait for you in the next posts!

 

 

Analytics Workshop Sofia2. Visualization. (Part 4/4)

Responder

Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de WordPress.com

Estás comentando usando tu cuenta de WordPress.com. Cerrar sesión / Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión / Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión / Cambiar )

Google+ photo

Estás comentando usando tu cuenta de Google+. Cerrar sesión / Cambiar )

Conectando a %s