Skip to content

Analytics Mayhem

Data finds a way

  • GitHub
  • LinkedIn
  • Mail
Konstantinos
Papadopoulos

Digital Analytics &
Data Specialist

Recent Posts

  • Propensity Score Matching in Python January 3, 2021
  • Adobe Analytics – Reports API using OAuth & Python September 27, 2020
  • Adobe Analytics data – Reports API v2.0 & Python June 14, 2020
  • Apache Airflow and DBT on Docker Compose May 11, 2020
  • Schedule dbt models with Apache Airflow April 6, 2020
  • Incremental dbt models using Adobe Analytics Clickstream February 16, 2020

Interesting read

Machine Learning based F1 race prediction engine

Tags

  • adobeAnalytics
  • airflow
  • analysis
  • bigQuery
  • clustering
  • cookies
  • crossDevice
  • dataFeeds
  • dbt
  • googleCloudPlatform
  • javascript
  • localStorage
  • measurement
  • postgresql
  • python
  • segments
  • sql
  • tealium

Tag: dbt

Apache Airflow and DBT on Docker Compose

Apache Airflow and DBT on Docker Compose

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

Posted on May 11, 2020August 29, 2020Categories dbtTags airflow, dbt, postgresql
Schedule dbt models with Apache Airflow

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

Posted on April 6, 2020August 29, 2020Categories dbt, Google BigQueryTags airflow, bigQuery, dbt
Incremental dbt models using Adobe Analytics Clickstream

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

Posted on February 16, 2020August 29, 2020Categories dbtTags bigQuery, dataFeeds, dbt
Adobe Analytics Clickstream data with dbt & SQL – Guide

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

Posted on January 12, 2020August 29, 2020Categories ClickstreamTags adobeAnalytics, bigQuery, dataFeeds, dbt, sql
Model Adobe Analytics Data in BigQuery with dbt – Into

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

Posted on October 27, 2019August 29, 2020Categories Adobe Analytics, Google BigQueryTags adobeAnalytics, bigQuery, dataFeeds, dbt
Proudly powered by WordPress
Before you go!

 

 

 

 

 

 

Subscribe to the newsletter

and do not miss any future post!

Enter your email address

Thanks, I’m not interested