info@lasmart.biz

7 Open Source and 2 low-code solutions for BI-analytics visualization

february 10, 2024 7 Open Source and 2 low-code solutions for BI-analytics visualization In this article, we decided to share our knowledge about building analytical dashboards using 9 different no-code solutions: we will give a brief description, tell you about the advantages and disadvantages of each solution.  The first part will cover such open-source solutions […]

Code versioning and releases for MSSQL

january 30, 2024 Code versioning and releases for MSSQL Git version control systems are essential for large-scale development projects — they provide a toolkit for tracking and managing changes to program code created by multiple developers in parallel. One such tool is Bitbucket, a code versioning tool from Atlassian. To organize SQL code versioning, Microsoft […]

Comparison of data visualization tools

january 15, 2024 Comparison of data visualization tools Nowadays, the choice of visualization tools is very relevant. A visualization tool is a technology that interprets data from a source into visual content (tables, graphs, dashboards), helping to create analytical and informative summaries of events or projects. Every analytical or monitoring system cannot do without a […]

Table plugin development and moving it project to project in ApacheSuperset.

december 26, 2023 Table plugin development and moving it project to project in ApacheSuperset In continuation of the plugin development for ApacheSuperset topic, I had an idea to create a chart oriented to solve a narrow task for testing the work of custom visualizations and checking the implemented features. This article will describe the process […]

Multiplying two numbers by developing a custom Jinja function in Apache SuperSet

december 15, 2023 Multiplying two numbers by developing a custom Jinja function in Apache SuperSet Knowing how to use Jinja templates in Apache Superset will extend the functionality of your dashboards, and in some cases optimize your dataset. We have written about such features in several articles: «Provisional filtering of the data in the subquery by […]

Cleaning up the data that exports to CSV from HTML formatting code in Apache Superset.

november 30, 2023 Cleaning up the data that exports to CSV from HTML formatting code in Apache Superset By using HTML for formatting, you can achieve colourful visualisations in Apache Superset. This topic was explained in detail earlier in our blog in the article «Interactive visualisation using HTML in Apache Superset». But, the effect of such […]

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 […]