Author: Helen Anderson
-
How To Hire the Right Data Analyst
Data Analysts are in demand. Find everything you need to know about identifying and hiring Data Analysts in this one handy guide
-
Getting a Data Team Up and Running
Whatever your reasoning for a data team there is some planning and some tough questions to ask yourself before you engage a recruiter
-
-
A VPC Is Like the London Underground
Networking and AWS VPC can be tricky. But it doesn’t have to be. Just like learning to use the The Tube, you’ll be a natural in no time
-
Six Tips for Scoping Data Requests
How to run successful projects, manage expectations and gather stakeholder requirements without burning out or ending up doing nothing well
-
Gently Down the Stream With Kinesis
Gone are the days of batch processing, AWS Kinesis allows you to run analytics on the fly and shard streams for scalability
-
SQL Window Functions: NTILE, LAG, and LEAD
SQL Server Window Functions are incredibly powerful and allow us to access a total from another row and bucket data to show top performers
-
SQL Window Functions: RANK and Running Totals
SQL window functions allow us to see the rows in a table with a new column showing a running total, rank or moving average
-
SQL Aggregate Functions and Mariah Carey
SQL aggregate functions bring your data to life. They allow you to take a standard table and use a function or two to build metrics and answer questions about the data
-
Get To Know What Your Interviewer Wants To Know
When it comes to tech interviews, the interviewer is looking for not only technical knowledge but cultural fit, and how you communicate
