Public chart with a map of Moscow from a CSV file

You can use DataLens to 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 source of data on Moscow population and area for 2018. Source: List of districts and settlements in Moscow.

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

1. Create a connection.
2. Create a dataset.
3. Create a chart with a map of Moscow districts.
4. 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.

Step 1. Create a connection and datasetStep 1. Create a connection and dataset

Create a dataset based on the Files connection type.

1. Go to the DataLens interface.

2. In the left-hand panel, select Connections and click Create connection.

3. Select the Files connection type.

   

4. Click Upload files and select the file to be uploaded. For this example, use Moscow Population 2018.csv (download link). It may take up to several minutes to load it, depending on the speed of your internet connection.

   

   Once loading is compete, you will see a preview of the file data. To view it, use the scroll bars on the right and at the bottom.

   

5. In the top-right corner, click Create connection.

6. Enter Moscow Population 2018 as the 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.

1. Click Create dataset.

   

Step 2. Create a datasetStep 2. Create a dataset

1. If the workspace is empty, drag the Moscow Population 2018.csv spreadsheet from the selection panel to the workspace.

   

2. Go to the Fields tab.

   

3. For the Area, Population, and Housing stock fields, specify Sum as the aggregation type.

   

   The fields with the defined aggregate functions become measures and change their color to blue.

   

4. For the District coordinates field, change the data type to Geopolygon.

   

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

   

6. In the window that opens, enter Moscow population as the dataset name and click Create.

7. When the dataset is saved, click Create chart.

   

Step 3. Create a chart with a map of various Moscow districtsStep 3. Create a chart with a map of various Moscow districts

1. Select the Map visualization type.

   

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

   

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

   

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

   

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

   

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

Step 4. Publish the chartStep 4. Publish the chart

1. Click and select Public access in the list that opens.

   

2. In the Public access settings window that opens, enable Access via link.

   

3. Confirm publication of the chart and its linked data.

4. Copy the unique URL of the chart. Click Apply.

   

5. 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.
• Creating a dashboard with a map, bar chart, and selectors.
• Publishing a dashboard.