Getting started with DataLens

In this tutorial, you'll create your first dataset, build several charts to visualize data, and place them on a dashboard.

To get started with DataLens:

If you have a technical question about the service, please contact support. To ask for advice or discuss the solution to your problem or best service practices, write to the DataLens chat in Telegram.

Create a connection

1. Go to the connections page.

2. Click Create connection.

3. Select the ClickHouse connection.

   1. In the window that opens, specify the connection parameters:

      • Connection type — Specify manually.
      • Host name — rc1a-ckg8nrosr2lim5iz.mdb.yandexcloud.net.
      • HTTP interface port — 8443 (default).
      • Username — samples_ro.
      • Password — MsgfcjEhJk.

   2. Enable the HTTPS option and Allow subqueries in datasets and queries from charts.

   3. Check the connection and click Create connection.

   4. Enter Sample ClickHouse as your connection name.

   5. Click Create.

   

Wait for the connection to be saved.

Create a dataset

1. In the upper-right corner, click Create dataset.

2. Drag the MS_SalesMiniTable table to the workspace.

   

3. Go to the Fields tab.

4. In the Aggregation column, select Sum for the Sales field.

5. Create a measure for the number of orders.

   1. Rename the OrderID field to OrderCount.
   2. Change the aggregation type to Number of unique.

6. For the ShopAddressCoord field, change the data type to Geopoint.

7. Click Save in the upper-right corner to save the dataset.

8. Enter the dataset name and click Create.

   

Create a column chart

1. In the upper-right corner, click Create chart.

2. For the visualization type, choose Column chart.

3. Add the product subcategory to the chart. To do this, drag the ProductSubcategory field from the Dimensions section to the X section.

4. Add a sales measure to the chart. To do this, drag the Sales field from the Measures section to the Y section.

5. Sort the chart in descending order of sales measure. Drag the Sales field from the Measures section to the Sorting section.

6. Save the chart.

   1. In the upper-right corner, click Save.
   2. In the window that opens, enter the Sales by subcategory name for the chart and click Save.

   

Create an area chart

1. In the created chart, select Area chart as the visualization type.

2. Replace the product subcategories with the order date on the X-axis. From the Dimensions section, drag the OrderDate field to the X section and hold it over the ProductSubcategory field until it turns red.

3. Add the product category to the chart. To do this, drag the ProductCategory field from the Dimensions section to the Colors section.

4. Display the chart by week.

   1. Click the calendar icon next to the OrderDate field in the X section.
   2. In the drop-down list of grouping options, select Week under Grouping.
   3. Click Apply.

5. Save the chart.

   1. Click the down arrow next to the Save button in the upper-right corner.

   2. Choose Save as.

   3. In the window that opens, enter the Sales by week name for the new chart and click Save.

      

Create a map

1. In the created chart, select Map as the visualization type.

2. Add the coordinates of the points of sale to the map. To do this, drag the ShopAddressCoord field from the Dimensions section to the Points (Geopoints) section.

3. Change the point size based on the number of orders. To do this, drag the OrderCount field from the Measures section to the Points size section.

4. Change the point color based on the sales measure. To do this, drag the Sales field from the Measures section to the Colors section.

5. Add the following fields to the Tooltips section:

   • ShopAddress
   • ShopName
   • Sales
   • OrderCount

6. Save the chart.

   1. Click the down arrow next to the Save button in the upper-right corner.

   2. Choose Save as.

   3. In the window that opens, enter the Sales map name for the new chart and click Save.

      

Create a dashboard

1. Go to the DataLens homepage.
2. Click Create dashboard.
3. Enter a name for the dashboard and click Create.

Add charts to the dashboard

1. In the upper-right corner, click Add and choose Chart.

2. In the window that opens, click Select.

3. Select the Sales map chart. This will automatically fill in the Title field.

4. Click Add.

5. Repeat the steps to add the Sales by subcategory and the Sales by week charts.

6. Position the charts on the dashboard however you like.

   

Add a selector to the dashboard

1. Click Add and choose Selector.

2. Add the calendar selector for the order date.

   1. Select the created dataset.
   2. Select the OrderDate field.
   3. This will automatically fill in the Title field. Click the Show checkbox next to the selector title.
   4. Select the Calendar type.
   5. Enable Range.
   6. Click Add.

3. Position the selector on the dashboard wherever you like.

4. Save the dashboard. To do this, click Save in the upper-right corner.

   

What's next

• Review the tutorials for examples of using the service.
• Read about service concepts.
• See step-by-step instructions.
• Look at an example ready-made dashboard.