{ "version": "https:\/\/jsonfeed.org\/version\/1", "title": "LEFT JOIN: blog on analytics, visualisation & data science, posts tagged: business intelligence", "home_page_url": "https:\/\/en.leftjoin.ru\/tags\/business-intelligence\/", "feed_url": "https:\/\/en.leftjoin.ru\/tags\/business-intelligence\/json\/", "icon": "https:\/\/en.leftjoin.ru\/user\/userpic@2x.jpg", "author": { "name": "Nikolay Valiotti", "url": "https:\/\/en.leftjoin.ru\/", "avatar": "https:\/\/en.leftjoin.ru\/user\/userpic@2x.jpg" }, "items": [ { "id": "8", "url": "https:\/\/en.leftjoin.ru\/all\/yandex-datalens-review\/", "title": "Overview of Yandex DataLens", "content_html": "

Let’s take our minds off of the project on receipt data collection for a while. We will speak about the project’s following steps a bit later.<\/p>\n

Today we’ll be discussing a new service from Yandex – DataLens<\/a> (the access to demo was kindly provided to me by my great friend Vasiliy Ozerov <\/a> and the team Fevlake <\/a> \/ Rebrain<\/a>). Currently, the service is in Preview<\/i> mode and is, in essence, a cloud BI. The main shtick of the service is that it can easily and handy work with clickhouse (Yandex Clickhouse<\/a>).<\/p>\n

Connection of data sources<\/h2>\n

Let’s review the major things: connection of a data source and dataset setting.
\nThe selection of DBMS is not vast, nevertheless some main things are present. For the purpose of our testing, let’s take MySQL.<\/p>\n

\n\"\"\n
Selection of data sources DataLens<\/div>\n<\/div>\n

On the basis of the connection created, it is suggested to create a dataset:<\/p>\n

\n\"\"\n
Interface of dataset settings, definition of measurements and metrics<\/div>\n<\/div>\n

On this stage it’s defined which table’s attributes are becoming measurements, and which are turning into metrics. You can choose data aggregation type for the metrics.
\nUnfortunately, I didn’t manage to discover how it’s possible to state several interconnected tables (for example, attach a handbook for measurements) instead of a single table. Perhaps, on this stage developers suggest us to solve this issue by creating of required view.<\/p>\n

Data visualization<\/h2>\n

Regarding the interface itself – everything is pretty easy and handy. It reminds of a cloud version of Tableau. If comparing to Redash, which is most frequently used in conjunction with Clickhouse, the opportunities of visualization are simply staggering.
\nEven pivot tables, in which one can use Measure Names as columns’ names are worth something:<\/p>\n

\n\"\"\n
Setting of pivot tables in DataLens<\/div>\n<\/div>\n

Obviously, there is an opportunity to make also basic charts in DataLens from Yandex:<\/p>\n

\n\"\"\n
Construction of a linear chart in DataLens<\/div>\n<\/div>\n

There are also area charts:<\/p>\n

\n\"\"\n
Construction of an area chart in DataLens<\/div>\n<\/div>\n

However, I didn’t manage to find out how data classification by months \/ quarters \/ weeks is carried out. According to an example of data, available in the demo version, developers are still solving this issue by creating additional attributes (DayMonth, DayWeek, etc).<\/p>\n

Dashboards<\/h2>\n

For now, interface of dashboard blocks’ creation looks bulky, and interface windows are not always comprehensive. Here is, for instance, a window, allowing to state a parameter:<\/p>\n

\n\"\"\n
Not really apparent setting window for dashboard parameters<\/div>\n<\/div>\n

However, in the gallery of examples we can see highly functional and convenient dashboards with selectors, tabs and parameters:<\/p>\n

\n\"\"\n
An example of a working dashboard with parameters and tabs in DataLens<\/div>\n<\/div>\n

Looking forward to fixing of interface shortcomings, improving of Datalens and preparing to use it together with Clickhouse!<\/p>\n", "date_published": "2019-04-08T11:42:38+03:00", "date_modified": "2020-05-13T14:22:57+03:00", "image": "https:\/\/en.leftjoin.ru\/pictures\/2019-04-08_11-11-17@2x.png", "_date_published_rfc2822": "Mon, 08 Apr 2019 11:42:38 +0300", "_rss_guid_is_permalink": "false", "_rss_guid": "8", "_e2_data": { "is_favourite": false, "links_required": [], "og_images": [ "https:\/\/en.leftjoin.ru\/pictures\/2019-04-08_11-11-17@2x.png", "https:\/\/en.leftjoin.ru\/pictures\/2019-04-08_11-13-52@2x.png", "https:\/\/en.leftjoin.ru\/pictures\/2019-04-08_11-17-35@2x.png", "https:\/\/en.leftjoin.ru\/pictures\/2019-04-08_11-18-15@2x.png", "https:\/\/en.leftjoin.ru\/pictures\/2019-04-08_11-20-27@2x.png", "https:\/\/en.leftjoin.ru\/pictures\/2019-04-08_11-22-46@2x.png", "https:\/\/en.leftjoin.ru\/pictures\/2019-04-08_11-25-19@2x.png" ] } } ], "_e2_version": 3386, "_e2_ua_string": "E2 (v3386; Aegea)" }