Simple dashboard from a CSV file

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

• Superhero’s eye and hair color on their gender.
• Superhero’s eye and hair color on their good or evil alignment.

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 a bar chart.
5. Create a donut 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 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. Navigate to the Fields tab.

3. Create a measure field with the number of superheroes:

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

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

   3. In the Aggregation column, select Number of unique. 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 a column chartCreate a column chart

To visualize superheroes split into good and evil, create a chart, e.g., a column chart:

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

2. Add the good or evil property to your chart. To do this, drag the Alignment field from Dimensions to the X section.

3. Add the number of superheroes to your chart. To do this, drag the Heroes count field from Measures to the Y section.

4. Sort the columns by number of superheroes. To do this, drag the Heroes count field from Measures to the Sorting section.

   

5. Color code superheroes in the chart based on whether they are good or evil. To do this, drag the Alignment field from Dimensions to the Colors section.

6. 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 evil; orange for unknown.

   3. Click Apply.

      

7. Add labels to your chart with the number of superheroes. To do this, drag the Heroes count field from Measures to Labels.

   

8. Save the chart:

   1. In the top-right corner, click Save.
   2. In the window that opens, enter a name for the chart: SuperHeroes: Alignment, then click Save.

   

Create a donut chartCreate a donut chart

To display the number of heroes of each gender, create a donut 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 a name for the new chart: SuperHeroes: Gender, then click Save.

2. Select the Donut chart visualization type.

   

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

4. 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.

5. Set the chart to display the number of superheroes by gender as a percentage:

   1. Click the icon before the field name in the Labels section.
   2. In the Label value field, select Percentage, then click Apply.

   

6. 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, hold down Chart and drag it to the required area.

   

4. In the window that opens, click Select.

5. Select 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 Eye color and Hair color:

1. In the panel at the bottom of the page, hold down Selector and drag it to the required area.

   

2. Add a selector for eye color:

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

   

3. Add a selector for hair color:

   1. Make sure you selected the SuperHeroes dataset dataset.
   2. Select the Hair color 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 eye and hair color dependencies on a superhero's gender and good or bad alignment.

   

   The dataset analyzed shows the following dependencies:

   • There are more men with black eyes and more women with green eyes.
   • There are more good ones with blue eyes and evil ones with red eyes.
   • There are more women with red hair and more men with black hair.
   • There are more evil ones with gray hair and more good ones with brown hair.

2. Next, you can:

   • Create new measures in the dataset, e.g., average height (Height field average) and average weight (Weight field average) of superheroes.
   • Add new charts to the dashboard, e.g., an indicator with the number of superheroes or a bar chart with the number of superheroes by publisher.
   • Add new selectors to the dashboard, e.g., to select a publisher or superhero race.
   • Explore more patterns.