My name is Johan van de Werken. I am a freelance analytics engineer and I help companies trust their numbers: clean data collection, solid pipelines, and reporting people actually use. I'm at my best at the intersection of data, business and tech.

expertise & services

  • No nonsense data strategy & advice: straightforward, effective strategy tailored to your business.

  • Data warehousing: robust, scalable storage on platforms like BigQuery.

  • Analytics engineering: clean, maintainable SQL workflows with dbt or Dataform.

  • Data visualization: dashboards that tell a story in Data Studio, Tableau, or Power BI.

  • Web analytics: reliable measurement and insight with Google Analytics 4.

  • Marketing analytics: connecting the dots across Google Ads, Microsoft Ads, Meta, LinkedIn and Search Console.

  • Data analysis: turning raw data into decisions you can act on.

clients

testimonials

Johan has been a great asset over the past few months, helping us advance our use of Google Analytics data in BigQuery through dbt. He brings a wealth of experience and knowledge, quickly understanding our needs and delivering valuable results. Easygoing and collaborative yet sharp on the points where it matters. Highly recommended!
Kevin Laan (Head of Data & Analytics, de Bijenkorf)

Johan was a pleasure to work with on a recent project to visualise our GA4 data. He designed and built the framework in BigQuery we needed to model our data in an extremely cost efficient manner. As a result of his work, we are now able to make data-driven decisions in real-time using our web analytics data.
Brendan Jackson (Senior Director Digital Marketing, Aptean)

Johan has helped our organization well in identifying our data needs. His working method is customer-oriented, clear and has delivered great results that will be of great use to us as an organization.
Anne-Margreet Jonkman (Manager Marketing & Communication, Radboud University)

Johan has been instrumental in setting up a data warehouse for us in BigQuery, by tying in the dozens of various historic and live sources of information we had floating around. Now, with the warehouse as our source of truth the whole company is on the same page when looking into finance, audiences, and trends - it's as if we started this project on day one.
Paul Matthijs Lombert (CEO, Hedge)

side projects

Simmer video course

Together with Simo Ahava (Simmer) I have created a popular video course, focusing on learning SQL in the context of Google BigQuery and Google Analytics 4.The course is self-paced, and you can take it at your own leisure. The individual topics always contain text content to help flesh out the concepts. There are illustrations, links, and tips to help you understand more about the topic.

GA4Dataform.com

GA4Dataform is your one-click solution to harness the full power of GA4 data in BigQuery, without the hassle.Transform your raw GA4 event data into actionable insights with industry-leading, enterprise-level efficiency and precision.Our pre-built SQL models are designed by industry leaders, ensuring you're working with the best-in-class analytical frameworks from the get-go. You don’t need to be a GA4 / BigQuery / Dataform expert to perform like one.Designed for digital analysts, technical marketers, data teams, and developers.

contact

Select Star B.V.
KVK 95993304
VAT ID NL867418369B01
Let me know what's on your mind. I'll get back to you asap.