Dash contains a powerful query builder for which admins do not need any SQL knowledge. The information displayed can be tailored by selecting from various data sources. These sources amalgamate data from diverse areas, such as student details, enrollments, and completion statuses. Despite the abundance of data within Moodle, much of it remains inaccessible to administrators, teachers, and managers in a structured format.

Each data source encompasses:

• fields (the actual information)
• conditions (which restrict which data is included in the outcome, e.g. the table)
• and filters (to let the end-user filter within the available data)

Fields range from simple database-derived entries like user first names to more intricate elements like ‘smart course buttons,’ which dynamically adjust based on user privileges and course status.

Predefined filters accompany every data source, empowering users to fine-tune Dash content according to specific database queries. Selecting appropriate filters allows users to focus on relevant data subsets.

Restricting the data contained in a table or grid is often essential for tasks such as displaying courses from specific categories or showing enrolled courses. Therefore, administrators can impose conditions to restrict included data, ensuring that end-users cannot modify essential parameters. These pre-defined conditions cater to common use cases and are periodically updated to accommodate evolving requirements.

With these comprehensive options, administrators can analyze diverse scenarios, ranging from targeted information dissemination to monitoring compliance-related metrics and gauging overall course acceptance and user engagement. Informed decisions and optimization strategies can then be formulated based on these insights.

For advanced customization, administrators can leverage Dash Developer to create or upload custom data sources.