22 docs tagged with "analyst"

Group and pivot your data

Change the data type of multiple columns at once

Rename multiple columns in your dataset in a systematic way

Standardize data formats

Remove duplicates from your data

Dynamically filter columns of your dataset based on a set of conditions

Filter the data

Flatten nested columns

Build functions with SQL macros to be used in gem expressions

Power your pipelines with gems

Join two or more datasets

Limit the number of columns processed

Use dbt macros in your pipelines

Sort the data

Introduction to pipeline development for analysts

Add variables to your pipelines

Use pipelines in SQL projects

Use Prophecy and SQL to run pipelines

Use expressions to reformat column names and values

Call APIs from your pipeline.

Use a custom SQL statement

Create moving aggregations and transformation