Skip to main content

Using Archie to automatically generate research questions for your collections

Archie can generate research questions and analytical hypotheses based on the database tables in a collection. This feature helps data analysts, data scientists, and other users explore the types of questions that the data might answer. By leveraging metadata, Archie suggests relevant questions that can guide further analysis. Generated questions can be saved as queries within a project, making them accessible for future users who may have similar inquiries. This is especially useful for non-technical users who do not work with SQL regularly. Saved queries can be searched and reused, streamlining the data exploration process.

To generate a list of useful questions for a collection:

  1. Browse to a collection that has tables in it.

  2. Go to the Contains tab and from the Tables section, click the Three dot menu and select Generate questions.

    archie_bot_questions.png
  3. The system processes the tables that are in the collection and then suggests a list of questions that the collection may be able to answer. Select any or all of the questions and save them to a project or dataset where you can generate relevant queries. Click the Add questions button.

    Note

    The dataset or project where you are saving these queries must have the actual database tables stored in them. Only then you will be able to convert these questions into queries and get meaningful insights on the data in the tables.

    archie_bot_questions02.png
  4. You are taken to the Project or Dataset where you saved the questions. Launch the Workspace and you will see each question saved as a template for the query.

    archie_bot_questions03.png