Back to class · Class 14 · Class14-Queries and Reports with the Data Service Module in BIZUIT

Lesson 1 of 7

How to get the most out of the class?

Para obtener el máximo beneficio de esta clase:

To get the most benefit from this class:

Ideal Audience

This class is aimed at professionals who wish to create advanced queries and generate graphical reports in BIZUIT, and who need to integrate data from external sources. It is recommended to have basic knowledge in:

  1. Databases and SQL Queries

  2. Data Visualization

Class Objectives

Design queries that extract, organize, and filter data according to specific needs.

Topics to be Covered

Introduction to the Data Service Module
  • General functionalities of the module.

  • Submodules and global parameters.

SQL Query Creation
  • Use of the query editor to design queries.

  • Validation and adjustment of queries.

Parameter Configuration
  • User control settings to interact with parameters.

Graph Design
  • Creation of interactive charts.

  • Customization of axes, series, and colors.

Drilldown Configuration
  • Connection between submodules through interactive clicks.