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.
✔️ No coding or SQL skills required
With our Dash query builder, admins don’t need any coding or SQL knowledge and can still create effective queries.
✔️ Structured data access
Despite the vast amount of data available within Moodle, much of it remains unstructured and inaccessible. Dash provides structured access to this data, making it easier for administrators, teachers, and managers to retrieve and utilize relevant information.
✔️ Flexible configuration
Each data source encompasses fields, conditions, and filters, offering users flexibility in defining the content and scope of their queries. This allows for precise customization of Dash content based on specific database queries and user requirements.
✔️ Dynamic content
Dash supports a wide range of fields, from simple database-derived entries to more complex elements like dynamic buttons that adjust based on user privileges and course status. This enables the creation of dynamic and context-sensitive content within Dash.