Data Analyst and Technical Consultant

Tag: analytics

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.

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

Statistics with SAS

Statistics with SAS

SAS gives you the ability to transform your data and perform statistical analysis.  This starter kit shows you how to produce descriptive statistics for your projects