Patricio Villanueva

Starbucks Rewards Program Analysis

Analysis of Starbucks customer data to uncover insights that can help the company boost sales, improve customer loyalty, and optimize marketing costs by sending the right offers to customers. By leveraging customer demographics, the analysis aids in tailoring targeted promotional strategies.

Sparkify Churn Analysis

Analysis of user behavior to predict customer churn for Sparkify, a music streaming service. By identifying key features like user engagement and demographics, the analysis helps Sparkify boost retention by targeting likely churners with special offers, optimizing marketing efforts and reducing cost.

A CI implementation for your data warehouse with DBT

At Landbot, we use dbt to develop and manage our Data Warehouse (DWH), focusing on maintaining data accuracy as we introduce or update models. To achieve this, we've adopted a Continuous Integration (CI) and Continuous Delivery (CD) workflow, where every Pull Request triggers a suite of tests and, upon merging, automatically initiates a production build. This blog post outlines our simple method for implementing CI with DBT Cloud and Gitlab/Github, which has allowed us to accelerate development, ensure data quality, and reduce costs.