Dataform

Extract customer data from various sources (CRM, marketing automation, etc.) into BigQuery.

Use Dataform to transform and clean the data, creating features for the churn prediction model.

Train a machine learning model in Vertex AI using the transformed data.

Deploy the model and use Dataform to score customers daily, identifying those at risk of churning.

Trigger alerts and actions for high-risk customers.

Extract sales data from CRM and other sources into BigQuery.

Use Dataform to transform and aggregate the data, creating key sales metrics.

Build a dashboard in Looker Studio that visualizes the sales metrics.

Schedule Dataform to update the data in BigQuery hourly.

Enable real-time monitoring of sales performance.

Define data quality rules and assertions in Dataform using SQLX.

Schedule Dataform to run data quality checks daily.

Generate data quality reports and dashboards.

Alert data owners of any data quality issues.

Track and resolve data quality issues over time.

Extract marketing campaign data from various platforms (Google Ads, Facebook Ads, etc.) into BigQuery.

Use Dataform to transform and aggregate the data, creating key marketing metrics.

Build a report in Looker Studio that visualizes the campaign performance.

Schedule Dataform to update the report daily.

Distribute the report to marketing stakeholders automatically.

Extract customer data from various sources into BigQuery.

Use Dataform to transform and clean the data, creating features for the segmentation model.

Train a clustering model in Vertex AI using the transformed data.

Use Dataform to assign customers to segments based on the model's output.

Use the segments to personalize marketing campaigns and improve customer engagement.