Analyzing Data

How to write SQL queries or using the Autodaas Query builder to analyze data.

8 Articles

  • Editing a column name or logic You can edit a column in the View Builder - either renaming or editing business logic - with a few clicks. 1. On the Columns tab, click...
  • Writing SQL Queries   Before you can write a SQL Query, you'll need to add data sources the way you normally would. Once your data is added to the Build...
  • Aggregations To aggregate a column in Autodaas, add a column, then scroll down to the "Edit Columns" section and click the Aggregation dropdown on...
  • Adding filters to a query If you want to look at a subset of the data that you added to your View, you'll need to add a filter. i.e. If I have a list of users and...
  • Saving a Query as a View Once you've built a query, you can save it as a dataset. Once it's saved, you can search for the dataset, use it as a data source in...
  • Adding columns to a query Once you've selected the data sources that you want to use in a View, it's time to add columns. 1. Click the Add Column button on either...
  • Joining datasets If you need to combine data from multiple datasets, you'll need to join the datasets on a common column. For example, to use data from...
  • Adding a dataset to a query The first thing you need to do when you create a View is to add data sources. You can use any file, database table, or even another View...
Helpdocs by drift