Helen Anderson

work

Business Intelligence Consultant

location

Wellington, New Zealand

joined

Jun 19, 2017

Pinned

Helen Anderson

Apr 25

Big Data concepts from A to Z

#database #datascience #hadoop #machinelearning

100 1

9 min read

Helen Anderson

Feb 6 '19

SQL concepts from A to Z

#data #database #sql #beginners

625 14

14 min read

Helen Anderson

Dec 10 '18

AWS concepts from A to Z

#beginners #aws #architect

675 28

11 min read

Helen Anderson

May 26

Why you need SQL window functions (part 2)

#data #database #sql

29 3

3 min read

Why you need SQL window functions (part 1)

#data #database #sql

30 2

4 min read

Helen Anderson

May 17

Have you VACUUMed your tables lately?

#data #database #sql

26 1

3 min read

Helen Anderson

May 14

#discussWhich game are you playing right now?

#discuss

29 102

1 min read

Helen Anderson

May 11

How to customise SQL Server Management Studio (SSMS)

#data #database #sql

41 6

4 min read

Helen Anderson

May 10

#watercoolerWhat's your wifi's name?

#discuss #watercooler

63 135

1 min read

Helen Anderson

May 8

You should write that blog post

#beginners #writing #blogging

89 5

2 min read

Helen Anderson

May 5

AWS Database: The Journey to Certification

#data #database #aws

53 4

5 min read

Helen Anderson

May 3

Why I use SQL CTEs

#data #database #sql

53 8

3 min read

Helen Anderson

May 3

SQL aggregate functions and Mariah Carey

#data #database #sql

29 3

4 min read

Helen Anderson

May 1

The importance of database modernisation

#aws #database #migration #modernisation

6 min read

Helen Anderson

Apr 29

SQL Joins without the Venn diagrams

#sql #beginners #data #database

90 4

3 min read

Helen Anderson

Apr 27

My Tech Journey: Advice for Career Switchers

#beginners #career #shecoded #motivation

48 5

4 min read

Helen Anderson

Apr 25

6 Ways to Level Up Your Career

#career #culture #leadership #productivity

103 3

3 min read

Helen Anderson

Apr 15

Things to consider when writing your next blog post

#writing #blogging #tutorial #tips

145 12

5 min read

Helen Anderson

Apr 10

Being kind while working in lockdown

#career #leadership #motivation #productivity

63 1

4 min read

Helen Anderson

Mar 15

SaaS metrics: what do the acronyms mean?

#marketing #startup #performance #businessintelligence

84 4

5 min read

Helen Anderson

Mar 4

Nevertheless, Helen Anderson Coded

#shecoded

85 15

1 min read

Helen Anderson

Mar 1

How to use the VLOOKUP Excel function

#excel #analysis #beginners

48 8

3 min read

Helen Anderson

Feb 10

Onboarding: How to give new hires a soft landing

#leadership #career #hiring #analytics

100 4

5 min read

Helen Anderson

Jan 27

How to hire a data analyst

#leadership #career #hiring #analytics

57 4

6 min read

Helen Anderson

Jan 20

Designing the data team

#leadership #career #database #analytics

85 6

7 min read

Helen Anderson

Dec 16 '19

#techtalks10 Takeaways from 2019 AWS re:Invent

#aws #techtalks

8 min read

Helen Anderson

Dec 12 '19

My 2019 re:Invent: from A to Z

#aws

83 3

8 min read

Helen Anderson

Nov 25 '19

I Sat the AWS Cloud Practitioner Exam Online: Here's What Happened

#aws #cloud #certification

166 19

4 min read

Helen Anderson

Nov 18 '19

AWS Series: All About Cost Optimisation

#aws #cloud #costoptimisation

79 5

3 min read

Helen Anderson

Nov 13 '19

AWS Series: All About Security

#aws #cloud #security

121 1

4 min read

Helen Anderson

Oct 17 '19

AWS Series: Free AWS Services

#aws #cloud

191 2

5 min read

Helen Anderson

Oct 11 '19

AWS Series: CloudWatch or CloudTrail?

#aws #monitoring #cloudwatch #cloudtrail

75 1

3 min read

Helen Anderson

Aug 13 '19

AWS Series: Why a VPC is like the London Underground

#aws #vpc #networking

115 3

5 min read

Helen Anderson

Aug 5 '19

6 Tips for Successful Projects

#career #productivity #communication

210 1

4 min read

Helen Anderson

Jun 24 '19

AWS Series: Gently Down the Stream with Kinesis

#aws #beginners #kinesis #database

73 8

4 min read

Helen Anderson

Jun 23 '19

#discussWhat Advice Would You Give Your 20-year-old Self?

#discuss

95 137

1 min read

Helen Anderson

Jun 4 '19

What your interviewer really wants to know

#career #interview #beginners #database

357 9

8 min read

Helen Anderson

May 20 '19

Entity Relationship Diagrams explained by Sonic the Hedgehog

#database #sql #beginners #datamodel

219 11

3 min read

Helen Anderson

May 13 '19

AWS Series: SNS, SQS or both?

#beginners #aws #architect

63 2

3 min read

Helen Anderson

May 7 '19

Pearl Jam, Nirvana and Beautiful Data Visualisations

#d3 #javascript #music #datavisualisation

121 8

4 min read

Helen Anderson

Apr 29 '19

6 ways to search with System Tables

#sql #data #database #productivity

101 1

4 min read

Helen Anderson

Apr 23 '19

How to rock your first tech talk

#beginners #culture #speaking #career

319 27

6 min read

Helen Anderson

Apr 16 '19

AWS Series: Which EC2 is right for you?

#beginners #aws #architect

128 4

4 min read

Helen Anderson

Mar 26 '19

AWS Series: What's in the Bucket?

#beginners #aws #architect

99 2

4 min read

Helen Anderson

Mar 16 '19

AWS Series: Don't you know who IAM?

#beginners #aws #architect

125 6

4 min read

Helen Anderson

Mar 8 '19

Nevertheless, Helen Anderson Coded

#shecoded #career #womenintech

127 12

2 min read

Helen Anderson

Jan 21 '19

Resources for beginner data analysts

#learntocode #sql #beginners #learning

226 7

2 min read

Helen Anderson

Dec 9 '18

Moving data around with the Database Migration Service

#sql #database #aws #data

3 min read

Helen Anderson

Nov 27 '18

Speed up your queries with indexes

#sql #data #database #beginners

258 36

4 min read

Helen Anderson

Oct 31 '18

Database migration with the Schema Conversion Tool

#sql #database #aws #data

47 2

2 min read

Helen Anderson

Aug 28 '18

AWS Series: The Journey to Certification

#aws #architect #career

464 29

1 min read

Helen Anderson

Pinned

Join our DEV Community :)