business intelligence

Comidor Business Intelligence (BI) Tools

1891 830 Comidor BPM Platform

Business Intelligence (BI) Tools

 

Comidor also provides Business Intelligence tools such as Data Visualization and Reporting Tools. Reporting tools per unit are accessible through Reports link or/and Actions button . While, Data Visualization Tools are available as different views e.g. List view, Chart view, 2D Analysis, 3D Analysis. Moreover, through report builder tool of 2D Analysis and 3D Analysis you can create customized reports.

The available Views in each Unit vary.

Chart

Entering most of the Units, you will find that except the list of records can also be displayed in Chart View.business intelligence

  1. Change Folder Categorization, apply Filters and Tags, periods and states or search for specific name and criteria records.business intelligence
  2. Select between Time-based (with options) and Data-based Analysis.
  3. Focus, Print and Export Pie Charts, Stack Charts for Data Analysis and Column and Line Charts for Time Analysis.

 

Reports

Comidor Business Intelligence tools offer plenty predefined reports as well as a report builder tool for creating customized reports. Comidor Reports doesn’t come as a separate Comidor package; to the contrary, the Reports are embedded in each of the modules (Enterprise Collaboration, BPM, Project Management, CRM, Business Administration).

2D and 3D Analysis with Query Builder

With 2D and 3D (time-based) analysis each user can literally find, filter, format and classify any kind of information from a single or multiple interconnected Units. Almost all Comidor Units come with this powerful Business Intelligence mechanism which allows users to create any kind of View on demand. Views are SQL queries and can be simple or as complex as the case orders. Views in Comidor are simple to create through the Analytics option on the top of the page. The user can create a new view simply by selecting the desired Unit’s table fields and drag n’ drop these to the Views Build window. Doing so, the SQL query is automatically built for the user.

Users can execute, save, modify or delete views at will. The true power of Views lies in the Analytics mechanism which is capable of linking information from different Units and thus creating complex SQL queries which upon execution offer results of unprecedented value and clarity. For example, user can create a view that combines information from the Tasks, Projects, Opportunities, Accounts and Contacts units just by selecting the associated units and their fields!

For 2D Analysis:

business intelligence

  1. You will find 2D Analysis, when entering a Unit and clicking on the 2D Analysis button next to List View and Chart View buttons.
  2. Utilize Data Management options, using Tags, Filters and Search and View drop-down lists to find the data you want to act upon.
  3. Sort and Group data by specific criteria you wish. See results updated below. You can see even the Sums only.
  4. Click on Print View or Export View buttons to print and export these data.
  5. You can edit this Query builder’s report and adjust SQL queries upon your criteria.
    • Click on Edit Query and a pop-up window opens. Click on Reset to erase all SQL queries or Drag-n-drop queries from the Query builder list on the right.
    • Execute to see the updated results.
  6. On top of that, you can click on Custom View, to create a new View and have it saved in order to re-use it.
    • Click on Custom Views. Select New View from the list.

      business intelligence

    • Click on + sign to expand the tree-list, drag-n-drop SQL queries from the list on the left to the text box on the right. Click on Execute the Query.
    • Save the Query.
      • A new pop-up window appears. Give a name on the new view. Click OK to save it.
    • You can now next time load this View from the Custom Views drop-down list.business intelligence

Regarding 3D Analysis:

This is only available in some units of Comidor as it requires numerical values to work in proper.business intelligence

  1. Click on 3D Analysis View button on a Comidor Unit.
  2. Utilize Data Management options, using Tags, Filters and Search and View drop-down lists to find the data you want to act upon.business intelligence
  3. Group data by specific criteria you wish. See results updated below. You can see even the Sums only. Change Date and Values list upon your requirements.
  4. Click on Print View or Export View buttons to print and export these data.
  5. You can always create a New view through Custom Views drop-down list, as decribed above.