ideal interaction with Yandex DataLens

ideal interaction with Yandex DataLens

“On the whole earth there was one language and one dialect. And they said: Let us build ourselves a city and a tower as high as the heavens, and let us make a name for ourselves before we scatter over the face of the whole earth. And the Lord said: Here is one people, and they all have one language; and this is what they began to do, and they will not be deterred from what they set out to do; let us go down and mix their language there, so that one does not understand the other’s language. And the Lord scattered them from there throughout the land; and they stopped building the city. That is why the name was given to it: Babylon, because there the Lord mixed the language of the whole earth, and from there the Lord scattered them over the whole earth” (Genesis 11:1, 4, 6-9).

Tower of Babel

Distribution of languages ​​in the world of programming

According to biblical chronology, these events took place long, long ago, at the beginning of human history. But something similar has happened in our time. And many languages ​​appeared, including programming languages. This did not escape their various colleagues from the BI sphere either.

Each more or less large vendor in the BI field has developed its own language for working with data. They especially excelled at Microsoft by making languages M and DAX for Power BI, and before that MDX for MS Analysis Services. Qlik Sense and many others followed the same path.

More recently, in the 80s and 90s, the world of BI analytics was simple and uncomplicated because there was only one language: Transact-SQL. But apparently someone didn’t want people to build BI’s “Tower of Babel” and that’s why he split the languages. And BI-analysts from different camps were confused: Microsoft, Qlik, Tableue, etc.

Return to the origins of Yandex

But not all companies followed the path of creating their own language. Yandex, with its Russian business intelligence product Yandex Datalens, is taking us back to the roots; to the right of all analysts, the same gold standard from which it all began – T-SQL (Transact-SQL).

T-SQL has many variations (dialects), but everywhere its essence is the same:
List of fields From Table(s) Where…

Or as in Russian 1C:
SELECT Fields FROM Table WHERE…

What is all this for? If you know the basics of T-SQL, then you speak the language of the founders and developers of databases and BI, and you have a higher education in this field.

Features of Yandex DataLens

Yandex Datalens provides incredible flexibility in data access:

All these data sources can be combined and glued together in single dashboards. And if you add data from 1C here, Yandex Datalens will become completely universal. But here Yandex Datalens has a small flaw: there is no standard connector for 1C 8 of this product.

Denvik solution

Denvik specialists corrected this shortcoming by implementing ETL from 1C 8 in a specialized analytical database Clickhouse, with which Yandex Datalens perfectly interacts.

From 1C to Yandex Datalens

We took the best from each product:

  • with 1C – its language of requests and subscriptions to events;

  • with Clickhouse – its ability to digest huge masses of information;

  • with Datalens – simple and adaptive visualization of data from the Clickhouse database.

What functions are available with 1C Data Extractor in BI?

  1. Downloading arbitrary data from 1C:

    1. documents;

    2. registers;

    3. directories;

    4. billing and holding plans;

    5. other accounting objects in 1C;

    6. and their arbitrary combination using the 1C query language.

  2. Automatic creation and modification of the table structure in the receiving base.

  3. Multithreaded download from 1C to the database (parallelization of 1C data during mass download).

  4. Tracking changes in 1C and downloading data in real time (with certain settings).

And what about Yandex Datalens? Let’s evaluate its capabilities.

  1. An ideal solution when you need to quickly collect data in analytical panels (dashboards);

  2. Adaptive design (which means that dashboards are displayed equally beautifully on a computer, tablet, and phone);

  3. A large number of connectors to various DBMS and not only;

  4. A large number of visualizations;

  5. A lot of educational materials, videos, a large community in Telegram;

  6. Simple function description language;

  7. It is based on the query language for SQL databases;

  8. Simple, convenient, beautiful.

An example of a dashboard in Yandex Datalens.

An example of a dashboard

This dashboard is built on the basis of the 1C Trade Management 11 demo base.
Test its capabilities yourself.

User: Accountant (A.G. Belkina),
Password not required

  • Try to create documents or change existing ones.

  • After about 1-2 minutes, your changes in 1C will appear in Yandex Datalens.

All this is the result of our software product, Data Extractor 1C in BI. Documentation The data extractor can be found on the website.

Related posts