Data Analyst and Technical Consultant

Data

How is Amazon Redshift so fast?

How is Amazon Redshift so fast?

Redshift is a solution for big data from Amazon.  Once you’ve created a data warehouse, called a cluster, you can use SQL tools to perform analysis fast.  Really fast.

Big Data Platforms:  Spark v Hadoop

Big Data Platforms: Spark v Hadoop

Big Data is everywhere and it comes with a lot of jargon.  The term is being used to refer to everything from ‘lots of data’ to so much data it can’t be processed on a single server.

5 Tips for better SQL

5 Tips for better SQL

Here are 5 quick tips to improve your query performance and simplify your schemas.

Database Fundamentals: SQL Views

Database Fundamentals: SQL Views

Database views are searchable objects in a relational database defined by a query. The view doesn’t store data but you can query a view like you can a table.

VBA Starter Kit

VBA Starter Kit

VBA is a programming language used in Excel to record routine tasks and procedures.  By creating a short script you can automate adding new data to a sheet, performing calculations and create custom functions.

Five handy addons for Google Sheets

Five handy addons for Google Sheets

If you’re new to Google Sheets there are some quick addons you can use to add functionality and make it feel more like Excel