Paddy Alton – Medium

Paddy Alton

Paddy Alton

Elections, Opinion Polling, and Bayesian Statistics

A brief introduction to psephology — and a practical case study of how Bayesian statistics can be used in the wild!

Jul 1

Elections, Opinion Polling, and Bayesian Statistics

Jul 1

Paddy Alton

C.V. writing for Data Analysts

A guide to writing a good C.V. for people applying for Data jobs.

Mar 6

A mock-up of a C.V. in the style described in the article.

Mar 6

Paddy Alton
in
ITNEXT

An introduction to Bayesian statistics

At the heart of Bayesian statistics lies a simple insight: that there’s no such thing as a free lunch.

Jun 6, 2023

A white square containing two overlapping circles in the middle. The red circle is labelled ‘A’, the blue circle is labelled ‘B’, and the purple overlapping area is labelled ‘AB’.

Jun 6, 2023

Paddy Alton

How to use DBT with BigQuery to wrangle your Google Analytics data

The advent of Google Analytics 4 (GA4) brought with it a killer feature: the ability to directly export your data to BigQuery.

Jun 1, 2023

Data flow from your website, to Google Analytics, to the date-sharded events tables, to the date-partitioned tables managed by DBT. The dbt_marts dataset contains two tables: one for events, one for sessions.

Jun 1, 2023

Paddy Alton
in
Apolitical Engineering

How we use DBT and BigQuery External Connections to easily and reliably warehouse Cloud SQL data

A creative approach to reduce complexity and costs

May 22, 2023

How we use DBT and BigQuery External Connections to easily and reliably warehouse Cloud SQL data

May 22, 2023

Paddy Alton
in
Apolitical Engineering

Data Modelling for Startups (Part III)

This is the final article in a three-part series.

May 15, 2023

A blue square labelled ‘Sales’ is surrounded by three red squares labelled customers, products, and dates. Arrows point from these to the central blue square.

May 15, 2023

Paddy Alton
in
Apolitical Engineering

Data Modelling for Startups (Part II)

This is the second article in a three-part series.

May 15, 2023

A diagram showing data flowing from source, via pipelines, to a warehouse; then being transformed into data models in the warehouse by a data transformation tool; then being read out of the warehouse into a business intelligence tool.

May 15, 2023

Paddy Alton
in
Apolitical Engineering

Data Modelling for Startups (Part I)

This is the first article in a three-part series.

May 15, 2023

Four red squares represent dimensions as follows: dates, products, customers, and subscriptions. Three blue squares represent facts as follows: sales, reviews, and subscription creations. Sales and reviews facts both link to dates, products, and customers dimensions. Subscription creations facts link to dates, subscriptions, and customers.

May 15, 2023

Paddy Alton

Python, learnt backwards

A tutorial for near-beginners

Dec 21, 2022

Dec 21, 2022

Paddy Alton
in
Apolitical Engineering

Code reviews at Apolitical

At Apolitical we recently spent some time trying to codify ‘the way we do things’. Out of those discussions have come various sets of…

Dec 9, 2022

Code reviews at Apolitical

Dec 9, 2022

Paddy Alton

Paddy Alton

Expect articles on data science, engineering, and analysis.

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams