Data queries

Using the "Queries" tab of the Data Card Editor, you can create the queries that the selected card can use to configure its visual representation without technical knowledge.

The steps to be taken are the following:

  • Select a Data Model. Data models must be previously configured in Biuwer. The list of available data fields will be displayed, organized in a block of Dimensions and another block of Metrics, according to the type of field, and also the name of the Dataset to which each field belongs.

  • Identify data fields. You can use the interactive search that filters the data fields by name. Remember that different Datasets may have fields with the same name. To identify each field to which Dataset is associated, simply place the cursor over the field.

  • Drag and drop data fields into the "Columns" block on the right. You can sort the fields by dragging them up and down.

  • Click on the "Preview" button to display results of the query.

Once you have previewed the results of a query, you can make the changes you need in terms of fields, adding others, removing others or customizing each one. When Biuwer detects any change in the query, it will show you a message so that you can update the data according to the changes made.

Each field uses by default the settings of the corresponding dataset, in terms of field type (Dimension or Metric) and in the case of metrics, the default aggregation function. However, at the time of setting up the card queries, you can change this behavior by clicking on the pencil icon for each field:

  • Dimension fields. You can indicate that they behave like metrics, with the aggregation function available depending on the type of data of the field. This is useful when you want, for example, to count different elements in a dataset.

  • Metric fields. You can modify the default aggregation function assigned, since in different contexts of analysis you may need to add, count, obtain averages, maximums, minimums, etc.

Other aspects that you should take into account when configuring your data queries in Biuwer:

  • Data sorting. Data will be obtained performing a physical data query in a database, either managed by you or by Biuwer. If you do not specify any sorting, data will be obtained as it is returned from the database. You can configure the "Default sorting" block to retrieve data already sorted by one or more fields, in ascending or descending order, and this can be useful for setting up data rankings, for example.

  • Limit of records. By default all queries in Biuwer will apply a limit to the number of records obtained. However, depending on your plan you can set this limit and even not apply any limit at all. A common use case for setting up rankings is to apply a record limit and the associated sorting. For example, to obtain the 10 customers that have bought the most, you would apply a limit of 10 records, while ordering by the amount of sales field from the highest to the lowest amount (descending).

If you specify for your queries the option "No limit" you must be aware of the volume of data that can be obtained and this may affect the performance, both of the database query itself, the time required to transfer the data and subsequently its representation on the card.

When you have configured your queries with the expected fields and results, it is time to configure in the "Visualization" tab the graphic aspect that the data card will have. This depends on each type of card and you can see a preview of the card as you make settings.

Last updated