Explore

Query, join, and discover insights in an Airbook.

To create Projects, Airbooks, and queries, you need the Analyst role or higher.

Creating a Project and Airbook

On the left sidebar, below the list of different pages, you will see a Projects section. Click Add Project below this to create a new project. In an empty project, we'll create a new Airbook by default.

You can think of a project as a folder containing related Airbooks. For example, you might choose to have a project containing all your Airbooks analyzing Sales data. You can click the + icon by the project name to add another Airbook within.

Writing a query

Airbooks are made up of blocks. To query, you can create a no-code or SQL block. Press / to bring up the list of blocks and pick one of these options. Here's a walk you through the process below, or read on if you prefer.

SQL Blocks

You can only query one datasource at a time. To join across datasources, see the section below.

If you know how to use SQL, this is the most flexible way to get your data. First, select your datasource from the dropdown. The input field will autofill with a basic SELECT * query. This is a great way to get a quick overview of the contents of your table. You can modify this query as you wish or run it as-is.

Press Shift + Enter or click the Run button on the right to run your query. After a few seconds, you'll see a table containing your rows and columns below the input field. We call this a Dataframe.

The Dataframe you've created has a name, indicated in the green label above your block. You can change this if you wish by clicking on the label and typing into the field. Your query will run again when this is done.

Your Dataframe is now available for further querying, joining across datasources, charting and more.

No-Code Blocks (Query Builder)

Querying and joining Dataframes

To query a Dataframe, set your datasource in the dropdown to Local Dataframes. Simply use the name of the Dataframes you want to select from as the table name. You can see some example queries below.

/* Selecting a subset of users from table0 */
SELECT * FROM table0 WHERE table0.age > 25

/* Joining on a common id field shared between two tables */
SELECT *
FROM table1
JOIN table2 ON table1.id = table2.id;

You can also join and query Dataframes in a Query Builder block. Priyansh needs to write this too.

Creating Charts

There a range of options for charts that you can customize to fit your data. Watch the video below for a quck walkthrough from Hoshang.

Press / and choose chart block to start visualizing your data. You will see options on the right and a preview of your chart on the right. Choose your Dataframe and select the chart type that best represents your data's story.

Configure axes by choosing the dimensions you wish to represent. Airbook charts are highly customizable. You can open the dropdown for each dimension to see color and other styling options, as well as data manipulations such as aggregates and stacking options.

Creating a Statistic

You might want to highlight a specific value from one of your dataframes as a Key Performance Indicator (KPI) or a category leader. You can use a Statistic for this.

Press / and choose statistic from the options. Click the gear in the top right and configure your statistic. If you choose Static, you can type in a value. Otherwise, you can use a Dynamic statistic to choose a Dataframe and a row or aggregate of a particular column as your key value.

Statistics are also highly customizable. You can add a prefix, title, and even a target. You can use these to add additional context such as a unit or a KPI title.

You can re-run the Statistic using the play button in the top right to update the data when the Dataframe updates.

Looking for a more presentable format? Check out Present to learn how to create great Dashboards.

Collaboration

Airbook is best as a collaborative experience. Here's Hoshang again with a quick explainer:

Click the Share button in the top right of your screen to bring up the collaboration options. Here, you can add team members or other stakeholders as analysts who can write SQL queries, editors who can add context or feedback, and viewers who can simply review the analyses without making changes.

You can mention teammates in specific blocks of the notebook to draw their attention or ask for their input. They receive notifications and can jump right into the notebook to collaborate on the data analysis actively. Just type in @ in a text block to browse a list of team members and hit Enter to select one.

See Roles and Permissions to learn more about what these roles can do.

Once your analysis is done, move on to the next section to build some great Dashboards!