My name is Johan van de Werken. I am a freelance analytics engineer and have a decade of hands-on experience in web, marketing & data analytics. I thrive best at the sweet spot between data, business & tech.

expertise & services

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

  • Data warehousing solutions: leveraging platforms like BigQuery for robust, scalable storage.

  • Analytics engineering excellence: utilizing dbt or Dataform to transform and optimize your SQL data workflow.

  • Advanced data visualization: crafting compelling narratives with tools like Looker Studio, Tableau, and Power BI.

  • Web analytics insight: harnessing the power of web analytics tools like Google Analytics 4 (GA4) and Piwik PRO for comprehensive web insights.

  • Marketing analytics expertise: deciphering market trends with tools like Google Ads, Microsoft Ads, Facebook, LinkedIn and Search Console.

  • In-depth data analysis: turning raw data into actionable insights.

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

GA4BigQuery.com

GA4BigQuery is a digital platform on how to query Google Analytics 4 (GA4) data in BigQuery.My goal is to provide valuable content to data analysts, online marketeers and engineers, who seek guidance on how to query the GA4 BigQuery export data set. The platform offers a free newsletter for all subscribers and premium content for paid subscribers.

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.