Using hyperlinks to pass filter values from one dashboard to another in Apache Superset
april 28, 2023 Using hyperlinks to pass filter values from one dashboard to another in Apache Superset. Creating interactive analytics solutions is in wide demand in the field of data research. The formation of dashboards with sequential deepening into data sections is a well-known and logical mechanic for building an analytical system. In order for […]
Features of Kylin object changes
april 21, 2023 Features of Kylin object changes Recently, open-source technologies have become increasingly popular and actively used. Our company is no exception and began to master the new Apache technology stack. After several successful projects we want to share our development experience and some features. It is a well-known fact that the development of […]
Connecting Apache SuperSet to Apache Kylin.
april 19, 2023 Connecting Apache SuperSet to Apache Kylin. The combination of open-source solutions opens up many possibilities for creating analytical systems. In this sense, using Apache Kylin cubes as a data source for Apache SuperSet dashboards is a very attractive idea. However, connecting them is not such a trivial task. Environment: — Apache SuperSet […]
Provisional filtering of the data in the subquery by filter values in Apache Superset
april 15, 2023 Provisional filtering of the data in the subquery by filter values in Apache Superset. The issue of query optimisation for Apache Superset virtual datasets is quite relevant, as it greatly affects the visualisation speed of the report data. From the dashboard user’s point of view, this is critical. In some cases it […]
Excel error when connecting to MDX for Kylin data model
april 12, 2023 Excel error when connecting to MDX for Kylin data model Not so long ago our company started to master the new Apache technology stack. After several successful projects we want to share our development experience and some features. Analytical systems are rapidly evolving, but the role of a tool like Excel remains […]
Formatting using CSS Template
april 07, 2023 Formatting using CSS Template. As a continuation of the previous article «Modifying the Dashboard UI Template in Apache Superset» I would like to talk about other features available when editing the CSS template. Thus visualisation in analytics is not limited to the colour scheme of the dashboard and can be used to […]
Interactive visualisation using HTML in Apache Superset
april 06, 2023 Interactive visualisation using HTML in Apache Superset Past articles have discussed formatting methods using CSS template editing. This is an effective method if static formatting options are required. However, it’s not appropriate if you want to tweak a number in a table based on a value (such functionality is not available in […]
Configuring number formats in Apache Superset
april 01, 2023 Configuring number formats in Apache Superset Not so long ago our company started to master the new Apache technology stack. And now, after several successful projects, we wanted to share. It is no secret that the role of dashboards in modern analytical systems is quite high. The user of any interactive product […]
Kylin component settings (Hadoop: YARN, HDFS)
march 30, 2023 Apache Kylin distributed database Not so long ago our company started to master the new Apache technology stack. After several successful projects we want to share our development experience and some features. After deploying the Apache Kylin docker image from the developers (apachekylin/apache-kylin-standalone:4.0.0), when working with analytics solutions, we faced the problem […]
Apache Kylin distributed database
march 23, 2023 Apache Kylin distributed database Analysts often have to group and merge data. These operations in relational databases are resource intensive. Operational analytical processing (OLAP) is a technology that organises large commercial databases and supports complex analysis. It can be used to perform complex analytical queries without adversely affecting transaction systems. OLAP data […]