38 docs tagged with "analyst"

Group and pivot your data

Let Copilot help you build and understand data pipelines

Create geographic points with longitude and latitude coordinates

Standardize data formats

Remove duplicates from your data

Calculate the distance between two points

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

Send your pipeline output tables to others via email

Fix gems errors with one click

Filter the data

Flatten nested columns

Build functions with SQL macros to be used in gem expressions

Match records that are not exactly identical

Generate documentation throughout your pipeline to improve transparency

Power your pipelines with gems

Automatically generate expressions with natural language

Automatically generate gems with natural language

Join two or more datasets

Parse JSON inside a table

Limit the number of columns processed

Find more information about the success of failure of different operations

Use dbt macros in your pipelines

Change the data type of multiple columns at once

Rename multiple columns in your dataset in a systematic way

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.

Leverage a Python script in your pipeline

Use a custom SQL statement

Send data to automatically update your Tableau dashboards

Convert text into a column in your table

Convert your table from wide to long format

Create moving aggregations and transformation

Parse XML inside a table