Introduction

DoordaOnline is a data exploration platform that provides tools to help you understand, share and download data. Organisations typically use DoordaOnline to offer their teams an easy way to query and download or explore the data independently to decide what they want to integrate and automate within their applications.

Core Features of DoordaOnline:

• Querying Data: Utilise either a graphical query builder or a native query editor to interact with your databases.

• Data Visualisation: View query results as tables or charts, with customisation options available.

• Questions: Save queries as 'Questions' that can be added to dashboards and organised within collections.

• Dashboards: Combine multiple questions into dashboards, applying filters that update all questions simultaneously.

• Collections: Organise questions and dashboards into collections, similar to folders, to manage and control permissions effectively.

• Models: Create models to curate datasets, simplifying the process for users to query commonly filtered or joined data.

• Metrics: Define standardised calculations for important figures within your team.

Key Concepts in DoordaOnline:

• Questions: Saved queries with visualisations that can be added to dashboards or collections. They are the charts you can organise on dashboards.

• Dashboards: Group related questions (charts and other cards) that can be filtered and refreshed together.

• Collections: Similar to folders, they help organise and manage permissions for your questions, dashboards, and other items.

• Models: Curated datasets from your database, making it easier for users to query commonly filtered or joined data.

• Metrics: Standardised calculations for important figures within your team.

Creating Questions in DoordaOnline:

There are two primary methods to create questions:

1. Query Builder: A graphical interface that allows you to create questions without needing to know SQL. You can select data, apply filters, summarise, group, sort, join, and add custom columns.

2. Native Query Editor: For those familiar with SQL, this editor enables the creation of complex queries with reusable code snippets and parameters.

Dashboards in DoordaOnline:

Dashboards enable you to:

• Arrange multiple questions in a coherent layout.

• Add filters that affect multiple questions simultaneously.

• Include text cards for context and explanations.

• Set up automatic refresh intervals.

• Make cards interactive.

• Set up subscriptions to automatically send dashboards via email, Slack, or webhooks.

By understanding these core concepts and features, you can effectively utilise DoordaOnline to analyse and share your data insights.