Drill-down is a powerful data exploration technique that allows you to move from a high-level summary to more detailed views. By clicking on a data point within a dashboard or report—such as a bar, metric, or chart segment—you can reveal deeper layers of information. This enables you to quickly investigate trends, spot anomalies, and understand performance breakdowns without leaving your current view.
The Visualizer is a crucial component for performing Business Intelligence (BI) Analytics. It's where you actively engage in data visualization to transform raw data into actionable insights, ultimately driving data-driven decision-making.
DataGOL offers a flexible way to visualize your data through configurable widgets.
Aggregate functions are calculations performed on a set of values to produce a single summary value. They are incredibly useful for gaining insights from large datasets by condensing information into meaningful metrics. In effect you are prompting the Visualizer to take a numerical column, perform a specific calculation (Sum, Max, Min, Average, Count, Unique Count etc.) on its values, and then display the results grouped by the categories in this other column.
Alerting is a core feature in DataGOL that allows you to create alerts and notifications in DataGOL for tracking key performance indicators (KPIs) effectively.
Configuring Area chart widget
Configuring Bar chart widget
What Are Formulas in DataGOL?
Configuring Box plot widget
In DataGOL, users can apply various aggregation types to columns to summarize and analyze data effectively. These aggregations help transform raw values into meaningful insights — such as totals, averages, trends, and patterns.
Conditional formatting allows you to visually highlight and analyze your data by applying specific rules. You can enhance data analysis with the conditional formatting feature for tables and pivot tables. This powerful tool allows you to define custom rules to dynamically color-code cells based on their values. It provides a strong reasoning for its use by enabling quick visual identification of key data points that meet specific thresholds or criteria, which is a far more efficient method of data comprehension than manual inspection.
1. Select a workbook to visualize data. You can choose one of the following types of workbooks:
Dashboards are interactive visual interfaces that consolidate and present key data points in a clear, accessible format. They enable users to monitor performance, uncover trends, and make informed decisions by visualizing complex datasets through charts, tables, and key performance indicators (KPIs).
Dashboards are interactive visual interfaces that consolidate and present key data points in a clear, accessible format. They enable users to monitor performance, uncover trends, and make informed decisions by visualizing complex datasets through charts, tables, and key performance indicators (KPIs).
Configuring Donut chart widget
What is Drill Down Journey?
Administrators can now predefine specific analytical journeys for end-users via drill down. Instead of navigating through complex and unstructured data, users can now follow curated pathways to gain deeper insights. To do this, you must create and save related widgets as drafts. These drafts, which can include any combination of visualizations and settings, represent the steps a user will take when exploring data. When a user clicks on a data point within a widget on the dashboard, they are guided through the predefined draft widgets.
What is Ad-Hoc Drill-Down?
Configuring Funnel chart widget
Configuring KPI widget
Configuring Line chart widget
Configuring Packed Bubble chart widget
In DataGOL,Parameters are dynamic input placeholders—such as a number, text, date, or boolean—that replace hardcoded values in formulas or BI Workbooks. They allow users to adjust values on the fly in dashboards or visualizations without editing the actual SQL or underlying dataset.
Configuring Pie chart widget
After you have created a visualization or widget, you can pin it to the dashboards.
Configuring Pivot table widget - configuration and setting
Drafting a visualization allows you to save your progress and continue working on it later without losing any changes. This is particularly useful when you are in the middle of creating a complex visualization and need to step away. Saving it as a draft ensures your work is securely stored, so you can pick up right where you left off.
Configuring Scatter chart widget
To begin visualizing data, you must first select a workbook as follows:
Configuring Table widget
Theming of embedded dashboards or third-party sharing dashboards involves customizing their appearance to match the host application's look and feel. This process ensures a consistent and seamless user experience, making the embedded dashboard feel like a natural part of the application rather than a separate tool. This is particularly useful for maintaining brand consistency.
Configuring Tree map chart widget
Once the workbook is selected, the next step is to identify and add the desired columns to be visualized.
This topic introduces the user interface (UI) for data visualization. It describes the individual components of the visualizer's interface and explains the function of each part. Each of the functions are referenced to the corresponding topics.
The Details panel provides in-depth information about the SQL query that powers your current widget. This panel is essential for users who want to understand exactly how their data is being fetched, filtered, and transformed.
In the Visualizer, you can add filters at the widget level to refine the data displayed in your visualizations.
Widgets provide a wide range of data visualization options within our business intelligence (BI) tool. By combining different data columns with a variety of widgets, business users can uncover valuable insights. Our system provides visualization suggestions based on your data, helping you understand which visualizations are best suited for your dimensions, metrics, and time-based information.