Simple dashboard from a CSV file

This guide demonstrates how to use DataLens to analyze dependencies, for example:

• Superhero's weight depending on gender.
• Superhero's weight depending on whether they are good or bad.

For source data, we are going to use the SuperHeroes.csv file with data about the superheroes: name, gender, race, comics publisher, etc. Download it before going through the guide.

To visualize and explore data, set up DataLens and follow the steps below:

1. Create a workbook.
2. Create a connection.
3. Create a dataset.
4. Create the first chart.
5. Create the second chart.
6. Create a dashboard and add charts to it.
7. Add selectors to the dashboard.
8. Start analyzing superhero dependencies and data.

Getting startedGetting started

To get started with DataLens:

If you have any technical questions about the service, contact Yandex Cloud support. To ask for advice, discuss the solution to your problem or best practices of the service, write to the DataLens chat in Telegram.

Create a workbookCreate a workbook

1. Go to the DataLens home page.
2. In the left-hand panel, select Collections and workbooks.
3. In the top-right corner, click Create → Create workbook.
4. Enter a name for the workbook: Tutorials.
5. Click Create.

Create a connectionCreate a connection

Create a connection to the source data file.

1. In the top-right corner of the workbook, click Create → Connection.

2. Under Files and services, select the Files connection.

3. Click Upload files.

4. Select the SuperHeroes.csv file. Wait until the table content appears on the screen.

5. Click Create connection.

   

6. Enter SuperHeroes for the connection name and click Create.

Create a datasetCreate a dataset

Create a dataset based on the SuperHeroes connection:

1. In the top-right corner of the connection page, click Create dataset.

2. Go to the Fields tab.

3. Create a field for the superheros's average weight:

   1. Duplicate the Weight field: on the right side of the row with the field, click and select Duplicate.

   2. Rename the Weight (1) duplicate field as Weight avg: click the field name, delete the current name, and enter the new one.

   3. In the Aggregation column, select Average. The aggregation field will change its color to blue: it is now a measure.

      

4. Save the dataset:

   1. In the top-right corner, click Save.
   2. Enter SuperHeroes dataset for the dataset name and click Create.

Create the first chartCreate the first chart

To visualize data by gender, create a bar chart.

1. Click Create chart in the top-right corner of the dataset page.

2. Add superhero names to the chart. To do this, drag the Name field from Dimensions to the X section.

3. Add superhero weights to the chart. To do this, drag the Weight avg field from Measures to the Y section.

4. Sort columns by descending weight. To do this, drag the Weight avg field from Measures to the Sorting section.

   

5. Color code superheros in the chart based on gender. To do this, drag the Gender field from Dimensions to the Colors section.

6. Redefine the colors for the Gender dimension:

   1. Click in the Colors section (the icon is displayed when you hover over the section).

   2. Select colors: Pink for Female; blue for Male; orange for unknown.

   3. Click Apply.

      

7. Leave on the chart only those superheroes whose weight is known (greater than zero):

   1. Drag the Weight avg field from Measures to the Filters section.
   2. In the window that opens, specify the Greater than operator and the 0value.
   3. Click Apply filter.

   

8. Save the chart:

   1. In the top-right corner, click Save.
   2. In the window that opens, enter SuperHeroes — gender for chart name and click Save.

   

Create the second chartCreate the second chart

To visualize superheros as good or bad, create the second chart – a bar chart.

1. Copy the chart you created in the previous step:

   1. In the top-right corner, click → Save as copy.

      

   2. In the window that opens, enter the SuperHeroes — alignment name for the new chart and click Save.

2. Replace the gender color code with the good-bad color code. To do this, drag the Alignment field from Dimensions to the Colors section and hold it over the Gender field until the latter turns red.

3. Redefine the colors for the Alignment dimension:

   1. Click in the Colors section (the icon is displayed when you hover over the section).
   2. Select the colors: green for good; blue for neutral; red for bad; orange for unknown.

4. Save your chart: click Save in the top-right corner.

   

Create a dashboard and add charts to itCreate a dashboard and add charts to it

Create a dashboard to add charts and other widgets to:

1. In the left-hand panel, select Collections and workbooks and go to the Tutorials workbook.

2. In the top-right corner, click Create → Dashboard.

3. In the panel at the bottom of the page, select Chart.

   

4. In the window that opens, click Select.

5. Choose the SuperHeroes — gender chart.

6. Click Add.

   

7. Repeat steps 3-6 to add the SuperHeroes — alignment chart.

8. Adjust the size of the charts with your mouse and place them on the dashboard as you prefer.

   

Add selectors to the dashboardAdd selectors to the dashboard

Add selectors to filter superheroes by race (Race field) and publisher (Publisher field).

1. In the panel at the bottom of the page, choose Selector.

   

2. Add a selector for race:

   1. Select SuperHeroes dataset.
   2. Select the Race field.
   3. Enable Multiple choice.
   4. Click Save.

   

3. Add a selector for publisher:

   1. Make sure you selected the SuperHeroes dataset dataset.
   2. Select the Publisher field.
   3. Enable Multiple choice.
   4. Click Save.

4. Position the selectors on the dashboard however you like.

5. Save the dashboard:

   1. In the top-right corner of the dashboard, click Save.
   2. Enter SuperHeroes dashboard for the dashboard name and click Create.

6. Your dashboard is ready.

   

Analyze data about superheroesAnalyze data about superheroes

1. Apply various filters and analyze the weight dependencies on a superhero's gender and good or bad alignment.

   

   The dataset analyzed shows the following dependencies:

   • Men are generally heavier than women.
   • Bad superheroes are mostly heavier than good ones.

2. You can create new measures in the dataset, e.g., average height (Height field average) and number of superheroes (number of unique entries from the Name field), and answer the following questions:

   • Which race is the most numerous?
   • Is there a dependency between a superhero's height and their being good or bad?
   • Which studio created the most superheroes?