Executing DBT models through Apache Airflow can be both challenging and fun the same time! The previous post “Schedule dbt models with Apache Airflow” was a first a iteration on the topic. This time, the focus is on running Apache … Read the rest
Schedule dbt models with Apache Airflow
Working with dbt certainly makes the life of an analyst much better. It brings a certain structure that without a framework is difficult to achieve. One aspect however that I find lacking in dbt is monitoring the ongoing execution and … Read the rest
Incremental dbt models using Adobe Analytics Clickstream
In the previous article (Adobe Analytics Clickstream data with dbt & SQL) I discussed how to start with dbt and build basic models using Adobe Analytics Clickstream data. This time will dive into a more useful feature. Creating incremental dbt … Read the rest
What is Adobe Analytics
In today’s digital world, all companies rely on a digital presence to promote their brand, sell products and engage with their customers. What is Adobe Analytics and how it can help in achieving your business goals?
Let’s get into it! … Read the rest
Adobe Analytics Clickstream data with dbt & SQL – Guide
Have previously elaborated on both the usefulness of working with raw clickstream data and how powerful I consider dbt (data build tool) in managing SQL models. This time I will take a more practical approach to go through the basic … Read the rest
Marketing Channels in JavaScript
All Web Analytics vendors provide out-of-the-box configurations to setup Marketing Channels and attribution reporting. However there will always be a case that you need to implement custom marketing channel detection logic in JavaScript through the tag management system. Even though … Read the rest
Model Adobe Analytics Data in BigQuery with dbt – Into
Working with the raw Adobe Analytics data is always both interesting and challenging. One of the reasons is that Adobe (and all analytics vendors) have trained us to have easy access to multiple reports and metrics. However those rely on … Read the rest
Adobe Analytics and time between funnel steps
Recently I had to deal with the question “How much time it takes for a customer to go through funnel steps?” Simple question on the face of it. But the more I was thinking about it, the more complicated it … Read the rest
Data Feeds & Clustering BigQuery tables
Clustering in BigQuery
BigQuery is well-known for being lighting fast in terms of processing enormous volumes of data. There is no doubt about this. We, as product users, have a few options in our disposal to achieve so. First and … Read the rest
Tealium GitHub Integration
The first time I heard about the Tealium Github integration was almost a year ago, around the time when Digital Velocity ’18 was in London. It sounded like an exciting feature to enhance your data collection process. And it finally … Read the rest