59 docs tagged with "analyst"

Chat with our AI agent to generate pipelines

Group and pivot your data

Expand or contracts the boundaries of a polygon or line

Returns one integer that represents the count of records in the input dataset

Create geographic points with longitude and latitude coordinates

Standardize data formats

Encode and decode data using different techniques

Obfuscate data in one or more columns

Remove duplicates from your data

Calculate the distance between two points

Run SQL queries that update dynamically at runtime

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

Send your output tables from your pipeline to others via email

Fix gems errors with one click

Find data sources using Prophecy's AI agent

Filter the data

Return rows that match a certain count

Identify the shortest distance between spatial objects

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

Generate spatial heatmaps from geo point data using hexagons

Join two or more datasets

Parse JSON inside a table

Limit the number of columns processed

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

Convert your table from long to wide format

Create a polygon or polyline from a set of coordinates

Send your pipeline output directly to PowerBI

Explore the SQL Project Editor interface

Use Prophecy and SQL to run pipelines

Assign each row a unique ID

Use expressions to reformat column names and values

Pattern matching and text extraction using regular expressions

Call APIs from your pipeline

View detailed information about each operation performed during a pipeline run

Leverage a Python script in your pipeline

Decrease the number of nodes that make up a polygon or polyline

Find relationships between geographic features

Use a custom SQL statement

Create and call stored procedures to use in pipelines

Send data to automatically update your Tableau dashboards

Convert text into a column in your table

Create a placeholder gem in your pipeline

Transform data sources using Prophecy's AI agent

Convert your table from wide to long format

Convert your table from wide to long format

How Prophecy uses AI to help with pipeline development

Create moving aggregations and transformation

Parse XML inside a table