Using Concert Data Apps, you can connect to data sources and design dashboards using drag-and-drop components. The solution gives you full control over how data is displayed, filtered, and used for tracking, reporting, and decision-making purposes.
Concert Data Apps supports:
Connecting to SQL databases, REST APIs, Graph endpoints, AI models, or custom data sources.
Building dashboards with tables, charts, forms, filters, KPIs, and other components.
Interacting with data by using search, date pickers, components, and drop-downs.
Updating data automatically using polling or reloading it based on user interactions, and using built-in tools or JavaScript to format or clean your data.
Defining actions such as selection between pages, transforming data, or triggering logic.
Import and export dashboards between Concert Data Apps instances.
Workflow
Refer to the following figure and table for more details on workflow for using Concert Data Apps from connecting data, creating pages, and exporting your finished application.
Figure 1. Concert Data apps product workflow
Create Data App - A project is a workspace that can contain multiple pages with main dashboard, secondary pages, side windows, or drill-downs.
Add data sources - Easily integrate multiple data sources like SQL, REST, GraphQL, or AI services into your project. Each widget can independently use a different data source.
Choose components (widgets) - Widgets are building blocks that are used to show data or capture user input.
Tabular Data – Show structured rows
Visualizations – Display trends or summaries
KPI – Highlight key numbers like totals or averages
Data Entry – Add interactivity (selects, toggles, date pickers, forms)
Other – Display static content (text, images, icons)
Add pages for flows like drill-downs, pop-outs, or side window.
Run queries - If you have connected your data source, the built-in query editor can be used to retrieve the required data. Query results are updated in real time and can be directly linked to individual widgets for dynamic data visualization.
Apply data transformations - Clean, reshape, or enhance your query results by using these tools.
Path – Extract values from nested fields (for example, data.items[0].price).
Distribute – Flatten arrays or object lists into rows.
Convert Date – Format raw timestamps into readable formats.
Custom Function – Use JavaScript for filtering, sorting, or complex logic.
Map data to widgets - Each widget uses and renders data based on its structure. Configure each widget’s display using mapped fields and expressions.
Bind data fields to the needed value of the component content. Use {{result.variable}} for a variable of a single list, and {{item.variable}} for a variable of a list of items.
Use parameters such as {{ self.value }} for dynamic content.
Use formats such as moment() for date formatting and number() for numbers (example, currency, and decimals).
Add pages - Add more pages to expand your app user experience. Each page has its own widgets, layout, and logic and connect to others by actions.
Side window – For quick detail views or actions.
Drill-downs – Select to deeper layers of data.
Multi-step flows – Guide users through a process.
Setup Actions & Logic - You can make your app interactive by setting up what happens when users interacts with widgets. Common Triggers are On Click, On Row Selection, On Load, On Submit. Available Actions are as follows :
