loading...
ronsoak  profile picture

ronsoak

Data Analysis Team Lead at Xero in Wellington NZ. Dev tag moderator and passionate about space! All views expressed here are my own.

Location Wellington NZ Joined Joined on  Twitter logo GitHub logo LinkedIn logo Medium logo External link icon
Education

BA in Psychology and Linguistics

Work

Data Analysis Team Lead at Xero

Data abstinence in the name of being an ethical data company is not a sound operating model

Data abstinence in the name of being an ethical data company is not a sound operating model

Reactions 5
5 min read
Google plays the victim in an open letter to Australians. A wolf in sheep’s clothing.

Google plays the victim in an open letter to Australians. A wolf in sheep’s clothing.

Reactions 8 Comments 1
7 min read
Doing the Impossible, using ASSISTANT to make a SQL Linter (and how you can make it lint whatever you want)

Doing the Impossible, using ASSISTANT to make a SQL Linter (and how you can make it lint whatever you want)

Reactions 45 Comments 1
7 min read
What they don’t tell you about being an analyst

What they don’t tell you about being an analyst

Reactions 28 Comments 2
13 min read
I built my own SQL tester in Python, then rebuilt it again from scratch,here's what I learned.

I built my own SQL tester in Python, then rebuilt it again from scratch,here's what I learned.

Reactions 18 Comments 2
11 min read
Whelp, they got all our data, now what? - A guide, well a lecture first, then a guide.

Whelp, they got all our data, now what? - A guide, well a lecture first, then a guide.

Reactions 49
18 min read
Data Analyst? TIME TO LEARN PYTHON!!!🐍🐼

Data Analyst? TIME TO LEARN PYTHON!!!🐍🐼

Reactions 47 Comments 10
5 min read
The Good, The Bad, The Ugly: Microsoft's three significant impacts on the world of Data.

The Good, The Bad, The Ugly: Microsoft's three significant impacts on the world of Data.

Reactions 40 Comments 1
3 min read
The R.A.G (Redshift Analyst Guide): Troubleshooting process

The R.A.G (Redshift Analyst Guide): Troubleshooting process

Reactions 17 Comments 4
3 min read
The R.A.G (Redshift Analyst Guide): Things to avoid / Best Practice

The R.A.G (Redshift Analyst Guide): Things to avoid / Best Practice

Reactions 15
7 min read
The R.A.G (Redshift Analyst Guide): Understanding the Query Plan (Explain)

The R.A.G (Redshift Analyst Guide): Understanding the Query Plan (Explain)

Reactions 19 Comments 2
7 min read
The R.A.G (Redshift Analyst Guide): Data Types and Compression

The R.A.G (Redshift Analyst Guide): Data Types and Compression

Reactions 13
7 min read
The R.A.G (Redshift Analyst Guide): Sorting & Zone Maps

The R.A.G (Redshift Analyst Guide): Sorting & Zone Maps

Reactions 11 Comments 1
7 min read
The R.A.G (Redshift Analyst Guide): Distribution

The R.A.G (Redshift Analyst Guide): Distribution

Reactions 14 Comments 1
7 min read
The R.A.G (Redshift Analyst Guide): How does it work?

The R.A.G (Redshift Analyst Guide): How does it work?

Reactions 12
6 min read
The R.A.G (Redshift Analyst Guide): What is Redshift?

The R.A.G (Redshift Analyst Guide): What is Redshift?

Reactions 30 Comments 2
7 min read
Let's have a look at how AWS names their products...*eye twitch*

Let's have a look at how AWS names their products...*eye twitch*

Reactions 19 Comments 6
5 min read
When it comes to Data, the customer is always wrong - The Four Horsemen of the Assumption Apocalypse

When it comes to Data, the customer is always wrong - The Four Horsemen of the Assumption Apocalypse

Reactions 24 Comments 3
2 min read
0-50,000: How my team wrote 50k words of Documentation in under 5months

0-50,000: How my team wrote 50k words of Documentation in under 5months

Reactions 61 Comments 1
7 min read
I have HTML templates my team uses, can I build a WYSIWYG over the top? How do I inject content into the body of a HTML template

I have HTML templates my team uses, can I build a WYSIWYG over the top? How do I inject content into the body of a HTML template

Reactions 4 Comments 3
1 min read
Some advice on advice

Some advice on advice

Reactions 51 Comments 5
4 min read
I'm changing my job title to Data Librarian.

I'm changing my job title to Data Librarian.

Reactions 50 Comments 5
2 min read
What specifically should I learn for a career in DevOps (more explanation below)

What specifically should I learn for a career in DevOps (more explanation below)

Reactions 16 Comments 7
1 min read
Famous Company <> Career Happiness

Famous Company <> Career Happiness

Reactions 50 Comments 5
3 min read
An observation about UX (from a noob) - Twitter likes vs the rest

An observation about UX (from a noob) - Twitter likes vs the rest

Reactions 9 Comments 2
2 min read
How to create an induction process from the ground up.

How to create an induction process from the ground up.

Reactions 17
7 min read
Does this form of testing already exist?

Does this form of testing already exist?

Reactions 2 Comments 3
1 min read
Get serious about Data Governance now, or it will cost ALL of us in the future.

Get serious about Data Governance now, or it will cost ALL of us in the future.

Reactions 13
5 min read
Who are your career heroes & why? (Signal Boost!)

Who are your career heroes & why? (Signal Boost!)

Reactions 15 Comments 7
2 min read
I have written a lot about Burnout and Crunch Culture, Ask Me Anything!

I have written a lot about Burnout and Crunch Culture, Ask Me Anything!

Reactions 5 Comments 3
1 min read
Master information management by understanding this core principle.

Master information management by understanding this core principle.

Reactions 7
4 min read
SQL Workflow: Visual Studio Code + Snippets

SQL Workflow: Visual Studio Code + Snippets

Reactions 8
6 min read
You are probably a victim of Crunch Culture

You are probably a victim of Crunch Culture

Reactions 68 Comments 2
7 min read
Determining the worth of one-off Reporting.

Determining the worth of one-off Reporting.

Reactions 13 Comments 3
4 min read
That’s not very Data Warehouse - an argument against elegant SQL code

That’s not very Data Warehouse - an argument against elegant SQL code

Reactions 25 Comments 5
4 min read
loading...