

(Optionally) filter and aggregate your data.Typically, the process consists in three steps: How can you create a report with DaDaBIK? It supports four different relational RDBMSs (MySQL, PostgreSQL, MS SQL Server and SQLite) and other data sources (see Data Source Definition later) If you know some SQL, this can help you for creating more complex reports, but it is not needed to create PHP graphs or PHP pivot tables.ĭaDaBIK can certainly uses MySQL as a data source, but it is not limited to it. you don't need to know any programming language to create a report with DaDaBIK. The reason we use the word PHP here is just because DaDaBIK is written primarily in PHP (+ Javascript) but this is probably not very important for some of you: you give DaDaBIK some data to work on, you set some parameters and you get your report the programming language we used to develop DaDaBIK might be completely irrelevant to you, in fact you can surely create no-code reports, i.e. Among the various aspects covered by DaDaBIK, is the creation of reports.

DaDaBIK is much more, its' a complete low-code no-code platform that you can use to build complex Web applications, starting from your data, with little or no code. Let's say you have hundreds (or thousands, or millions) of records, related to the last five years extract useful information just by looking into these data may be difficult.Ī simple report that consists of aggregating orders by year and plotting the data in a line chart can already give you valuable information: you can immediately see how the sales are going, year by year.ĭaDaBIK is also a reports generator. A tabular report or a graph can summarize your data (possibly after having filtered and aggregated them), and communicates precise information, enriching the knowledge of the reader.įor example, you may have a MySQL table (or an Excel/CSV) file containing the orders your shop received, one row for each order. We produce reports, starting from our data, because we want to extract knowledge from our data and communicate information to some specific people or to the general public. If you are here, you (or your customers) need to produce reports.
