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 […]
How a grocery chain increased its dairy category assortment by 37% with the help of Lasmart
march 17, 2023 How a grocery chain increased its dairy category assortment by 37% This retail operates in a chain of more than 100 shops in the surrounding region. As is often the case, the shops vary in size and assortment. In early 2022, GreenShelf was introduced to bring the process of merchandise display management […]
Changes in the dashboard UI template in Apache Superset design
march 16, 2023 Changes in the dashboard UI template in Apache Superset design Virtually every corporation has its own corporate identity (brand book) and requires it to be followed when developing an analytics systems portal. The Apache Superset user interface looks quite concise, but lacks customisation to select the colour scheme of the main rendering […]
What is a business intelligence strategy?
march 10, 2023 What is a business intelligence strategy? Understanding Business Intelligence Strategy Business Intelligence (BI) refers to the tools and techniques used to collect, integrate, analyze, and present business data to support decision-making. A BI strategy is a roadmap that enables organizations to measure their performance and gain competitive advantages by utilizing data mining […]