Sometimes, you need to connect Looker to your database but you are not a data engineer, so it is handy to have a guided step by step. the sources are the Looker SSH tunnel doc and some google cloud SQL doc In your console, on in compute engine and pr...

Parsing json and array of json is usually a pain, so I just wanted to share what I use to do this. In the following example, I used the dataflow mongoDB template, which is a no code way of piping your data from mongoDB to Bigquery. In this case, the ...

Hi, I struggled to find an easy explanation on how I can easily display my own shapes on a map and then match data with it and display them on a looker viz. So to remember how I did it, I amgoing to document it here. This is detailing the 2 posts fro...

Very often, I work on subscription data, with a typical contract table with a start date, an end date, an amount and a contract length. How can you use this to understand your monthly recurring revenue, churn rate, and all these typical metrics typic...

When I am working on cRM data, I always use the crm block form keboola with a bit of the salesforce block. I was working on hubspot data but there is no snapshot data with the fivetran connector, only this deal_stage table which basically records the...