Skip to main content

AI Data Analysis v0.1

Dalgo's AI Data Analysis allows you to leverage AI and ask Dalgo questions about data that's stored in your warehouse. Explore a range of possibilities; generate quick insights on your data, learn more about the data quality of your dataset, or even summarise qualitative data!

Prerequisite: You have to have your warehouse setup on Dalgo and the warehouse must contain some data.

Video

Steps to use the feature​

  1. Navigate to AI Data Analysis in the left pane
  2. Enter an SQL query to select the table that you want to analyse
  3. Select the 'Summarise' prompt and build on it or enter a custom prompt.
Screenshot 2024-11-13 at 2 51 08 PM
  1. Press submit and wait for the response to be generated.
Screenshot 2024-11-13 at 2 56 49 PM
  1. Iterate on your prompt or query to improve the output of your prompt.
Screenshot 2024-11-13 at 2 56 02 PM
  1. When you are satisfied with the output you can click on 'save as' to save the session so that you can access it again for future analyses.
  2. Click on saved sessions to access previously saved sessions
Screenshot 2024-11-13 at 3 01 52 PM
  1. You could also press the copy symbol to copy the response and paste it into a deck
Screenshot 2024-11-13 at 2 58 57 PM
  1. You may choose to download your SQL query, prompt, and response as a csv by clicking on the download button.
  2. If the response is unsatisfactory press the 'thumbs down' icon at the bottom right of the window and share your feedback with us.
Screenshot 2024-11-13 at 2 58 00 PM

Troubleshooting and FAQs​

  1. If the response is not to your satisfaction then iterate on your prompt.
  2. If the page is taking too long to generate a response then reload it and try a different prompt.
  3. The output will not be representative of your entire dataset if your dataset is over 500 rows. This feature is currently limited to 500 rows of analysis.

Tips and Best Practices​

  1. Give context on the data to the extent that you can
  2. If your column names are not representative of the data in the column then you should mention the column name in your prompt. For example: If my column is named 'xyz' and the data in this column is the number of covid deaths per country. Then In my prompt I should mention to calculate total covid deaths from column 'xyz'
  3. Mention if you want the data to be numbered, in bullets, or in a table and how many points or words you want the data in. This will help format and limit your response.