Skip to content

Helen Anderson

Business Intelligence Specialist
  • Data Analysis
  • Data Leadership
  • Data Technology
  • AWS Study Guide
  • About
  • Search

Helen Anderson

  • Search
  • Data Analysis
  • Data Leadership
  • Data Technology
  • AWS Study Guide
  • About
women technology pioneers

Women who inspire and influence

10 Women Who Changed the Tech World

powerbi data governance

Carefully consider who has access to what and why

Planning and Developing a Power BI Data Governance Strategy

dataengbytes 2021

Back for 2021 with more talks than ever

Conference wrap-up: DataEngBytes

risk powerbi analytics adoption

Create a risk management strategy

Mitigating Risk When Implementing New Analytics Platforms

transformation powerbi

Transformation tools for easier analysis

Ten Ways To Transform Data With Power BI

blogging vanity metrics marketing

Big numbers can be misleading

What’s Wrong With Vanity Metrics

data dashboards scoping

Deliver what they need, not what they think they need

Are You Really Going To Use a Dashboard?

aws redshift analytics

New and exciting Redshift features

Amazon Redshift: 7 New Features for Data Analysts

aws community day

A special week-long community event

A Recap of AWS AU/NZ Community Week

data democracy

Don't slide into anarchy

Is It Anarchy in the Data World?

team culture

Create a positive team environment

Creating a Culture of Collaboration

imposter syndrome tech

Strategies to feel better

How To Manage Imposter Syndrome

excel tips and tricks

Excel for quick analysis and cleansing

The 25 Best Ways To Excel in Excel

advice for new developers analysts

Learning, communicating, being kind to yourself

Developing Your Skills as a Data Analyst

tech-blog-posts

blog posts are an art and a science

Tips for Writing Your Next Blog Post

work from home

You're doing great

How To Be Kind When You’re Under Lockdown

database migration

This isn’t just about the next shiny thing

The Importance of Modernising Databases

onboard teammates

Make it a formal repeatable process

A Guide to Onboarding New Teammates

hiring data analysts

Identifying and hiring data analysts

How To Hire the Right Data Analyst

designing data team

The tough questions before you engage a recruiter

Getting a Data Team Up and Running

aws reinvent

Exciting, busy and I learned a whole lot

My re:Invent: From A to Z

vpc london underground

Networking can be tricky

A VPC Is Like the London Underground

data projects

How to gather requirements

Six Tips for Scoping Data Requests

amazon kinesis streams

Gone are the days of batch processing

Gently Down the Stream With Kinesis

sql window functions

Window Functions are incredibly powerful

SQL Window Functions: NTILE, LAG, and LEAD

window-functions-sql

Window functions are incredibly powerful

SQL Window Functions: RANK and Running Totals

sql aggregates

Aggregates bring your data to life

SQL Aggregate Functions and Mariah Carey

data team interviews

Technical, cultural fit, communication

Get To Know What Your Interviewer Wants To Know

sql system diagrams

Not just a spaghetti mess

Entity-Relationship Diagrams With Sonic the Hedgehog

sql server search system tables

Your database doesn’t just contain your data

A Guide to Searching With System Tables

tech talk preparation

You have something to offer, give it a try

Your First Tech Talk: What You Need To Know

aws ec2 instance types

EC2 'families' of instance types

Which AWS EC2 Service Is Right for You?

aurora migration

The retrospective of 'Project Aurora'

The Great Migration: from SQL Server to AWS Aurora

career switchers

My journey so far

What Career Switchers Should Know

database dance class

Ballerinas and database concepts.

Databases Are Like Dance Classes

sql concepts database

SQL concepts that pop up during training

SQL Concepts From A to Z

certified aws cloud practitioner

AWS's service list grows each month

AWS Concepts From A to Z

sql indexes

Have you checked your indexes?

Improve SQL Query Performance by Using Indexes

sql server join

Joining tables is a big learning curve.

Relational Joins Without Venn Diagrams

customise sql server ssms

10 ways to make it work best for you.

10 Ways To Customise SQL Server Management Studio (SSMS)

© 2022 Helen Anderson – All rights reserved

Powered by WP – Designed with the Customizr Theme