AI and BI: differences and combined use
november 14, 2025 AI and BI: differences and combined use Business intelligence (BI) and artificial intelligence (AI) are powerful tools that help companies transform raw data into valuable insights and actions. In today’s world, where data volumes are growing exponentially, the ability to efficiently process, analyse, and use this information is critical for competitiveness. Goals […]
Advantages of using Apache Superset
october 30, 2025 Advantages of using Apache Superset In today’s business environment, data plays a key role. It forms the foundation for defining a company’s development direction, enhances competitiveness in the market, and provides valuable insights for optimising business processes. However, in order to correctly interpret and utilise data, reliable tools for analysis and visualisation […]
DWH ETL process optimisation: improving performance tenfold
october 14, 2025 DWH ETL process optimisation: improving performance tenfold During the development of a data warehouse (DWH) for business analytics, one of the key aspects is the efficient extraction of data from various sources such as other databases, CSV, HTML, and JSON files. Given the large volumes of data received daily, it is critically […]
Incremental population of fact tables in a dbt model
september 29, 2025 Incremental population of fact tables in a dbt model Data Build Tool (dbt) enables the consistency and freshness of analytical data in the warehouse. However, as projects scale, a key challenge emerges — implementing incremental updates for fact tables containing large volumes of event-based data spanning extended time periods. This article explores how […]
Using dbt (data build tool) in traditional data warehouse development
september 21, 2025 Using dbt (data build tool) in traditional data warehouse development Data Build Tool (dbt) – has become an essential tool for analysts and data engineers, streamlining data transformation and management processes in modern data warehouses. By defining acyclic dependencies and automating model builds, dbt helps ensure the consistency and freshness of analytical […]
Data-driven approach: case studies from small businesses to international corporations
august 26, 2025 Data-driven approach: case studies from small businesses to international corporations Introduction: data-driven decision-making A data-driven approach means making decisions based on objective data analysis rather than relying solely on intuition. Research shows that companies that actively leverage data are three times more likely to improve the quality of their decision-making compared to […]
ODS and Data Marts in BI
august 11, 2025 ODS and Data Marts in BI What is an ODS (Operational Data Store) An Operational Data Store (ODS) is a centralised database that consolidates up-to-date data from various operational systems within a company. Data is loaded into an ODS almost in real time and is stored either without historical changes or with […]
6 common misconceptions when choosing a BI system
july 28, 2025 6 common misconceptions when choosing a BI system Selecting and implementing a BI system is not just a technical task — it’s a strategic one. Many companies approach it superficially, ultimately wasting money and ending up with a platform that no one actually uses. Here are some common misconceptions businesses rely on […]
Why a business needs a DWH and how to justify the project
july 23, 2025 Why a business needs a DWH and how to justify the project Can you measure the ROI of a data warehouse? In most companies, data is stored in a fragmented manner across different systems. Access to these systems is typically restricted by department and role. For example, financial and tax data may […]
Prompt engineering: experience in optimising LLM behaviour
june 26, 2025 Prompt engineering: experience in optimising LLM behaviour During the development of a tool for automatic database documentation generation, we encountered several challenges when working with LLMs: Excessive, irrelevant information. Presence of technical details not relevant to the user. Inconsistency with the desired structure and style. These issues negatively impacted the usefulness of […]