Installing Apache SuperSet with Docker on Widows OS
november 15, 2023 Installing Apache SuperSet with Docker on Widows OS Apache SuperSet is a fairly well-known open source solution in bi-analytics community. The easiest way to install it locally is to use Docker on Linux or Mac OSX. However, most dashboard users use Windows, which, unfortunately, is not supported by SuperSet officially. You can […]
Integrating Superset into an application
october 13, 2023 Integrating Superset into an application Corporate reporting in large companies is not limited to standard BI tools. It is often necessary to develop solutions that allow using several products together, which imposes additional requirements to UI design, such as using a single authorization form for the entire application. Faced with this task, […]
Automation tools for SQL code styling
october 13, 2023 Automation tools for SQL code styling This post is going to list free SQL code formatting tools. The priority of the quest was to find add-ons to SQL Server Management Studio (SSMS) or sites that could provide it. The T-SQL procedures were used for testing. The purpose of this work is to […]
Configuring a simple TG bot and connecting it to MS SQL Server database
september 29, 2023 Configuring a simple TG bot and connecting it to MS SQL Server database The development of modern social networks and messengers provides many opportunities to create interactive applications for monitoring or processing database data that are convenient for developers and business users. In this post we will tell you how to connect […]
Running a dev environment and developing a simple plugin in Apache Superset.
august 23, 2023 Running a dev environment and developing a simple plugin in Apache Superset. Formatting Apache Superset visualizations using CSS and HTML is applicable in most cases, but for some charts it is not applicable, and it can significantly complicate the query to the data source. The logical solution to this problem and the […]
Display different fields of the dataset in one column of the table depending on the filter value
july 27, 2023 Output different dataset fields in one table column depending on the filter value in Apache Superset It is not uncommon for analysts in their work to use flat tables to output metrics grouped by different attributes. Output of flat tables with a set of metrics is not problematic in Apache Superset. However, […]
Using MS SQL functionality as a data source to increase the speed of SuperSet operation
july 14, 2023 Using MS SQL functionality as a data source to increase the speed of SuperSet operation When working with big data, it is necessary to pay special attention to query optimization. In this respect, the combination of MS SQL and Apache Superset solutions is very flexible in terms of distributing computation workloads. In […]
Apache Kylin distributed analytics data store
july 09, 2023 Apache Kylin distributed analytics data store Analysts have to group and merge data frequently. These operations in relational databases are resource-intensive. Operational analytical processing (OLAP) is a technology that organizes large commercial databases and supports complex analysis. It can be used to perform complex analytic queries without negatively impacting transactional systems. OLAP […]
Loading data from external file sources with gpfdist
june 30, 2023 Loading data from external file sources with gpfdist Greenplum provides extensive functionality for working with data in external sources, and the source, volume and purpose of use must be taken into account when choosing how to access the data. To download large amounts of data from files located on remote hosts, the […]
Apache Sqoop — installation and configuration
june 23, 2023 Apache Sqoop — installation and configuration Analysts often have to group and merge data. These operations in relational databases are resource-intensive. Operational analytical processing (OLAP) is a technology that organizes large commercial databases and supports complex analysis. It can be used to perform complex analytical queries without negatively impacting transaction systems. OLAP […]