Public chart with a map of Moscow from a CSV file

In DataLens, you can grant public access to your charts and dashboards.

In this tutorial, we will use DataLens to visualize and publish Moscow population metrics on the map of Moscow districts.

We will use the Moscow Population 2018.csv file as the data source on Moscow population and area in 2018. Download it before you proceed with this guide. Source: List of Moscow districts and settlements.

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 chart with a map of Moscow districts.
5. Publish the chart.

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 Moscow Population 2018.csv.

   Wait until the table content appears on the screen. It may take up to several minutes to load it, depending on the speed of your internet connection.

5. Click Create connection.

   

6. Enter Moscow Population 2018 for connection name and click Create.

This will create the file connection. The data will be shown in the same form as in the file. To use it, you need to create a dataset.

Create a datasetCreate a dataset

Create a dataset based on the Moscow Population 2018 connection:

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

2. In the dataset, go to the Fields tab.

3. For the Area, Population, and Housing stock fields, specify Sum as the aggregation type. The fields with defined aggregation functions become measures and change their color to blue.

4. For the District coordinates field, change the data type to Geopolygon: select Geopolygon in the Type column.

   

5. Save the dataset:

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

Create a chart with a map of Moscow districtsCreate a chart with a map of Moscow districts

Create a heat map chart to visualize the distribution of population across Moscow districts:

1. On the dataset page, click Create chart in the top-right corner.

2. Select the Map visualization type.

   

3. Select Polygons (Geopolygons) as the layer type.

   

4. Add polygons of districts to the map. To do this, drag the Coordinates field from Dimensions to Polygons (Geoplygons).

5. Change the district colors based on the population. Drag the Population** field from **Measures to the Colors section.

   

6. Save the chart:

   1. In the top-right corner, click Save.

   2. In the window that opens, enter Moscow population map by district as the chart name and click Save.

      

Publish the chartPublish the chart

1. At the top of the screen, click → Public access.

2. In the window that opens, enable the link sharing option next to the chart name.

3. Click Continue to confirm the publication of the chart and its linked data.

4. Click Copy link to copy the chart's unique URL.

   

5. Click Apply.

6. Open a new tab in the browser and go to the copied link.

   

You can share this link with your colleagues, partners, and friends. When opening the chart link, authorization and authentication are not required.

Also try:

• Building a column chart by district and population.

  Moscow population by district

  

• Creating a dashboard with a map, bar chart, and selectors.

• Publishing a dashboard.