Data Analyst and Technical Consultant

Data

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

Transpose data in Excel

Transpose data in Excel

If you have a worksheet with data in columns that you want to rotate so it’s rearranged in rows, you can use the Transpose feature. It lets you quickly switch data from columns to rows or vice versa

Visualisation: Dashboard Design

Visualisation: Dashboard Design

Presenting data and focusing on design when creating a dashboard seems easy enough but there are some simple things you can do to make the message clearer and quicker for the user to understand.

More Logical Excel Functions

More Logical Excel Functions

Here are five logical functions to use in Excel that will help you answer questions based on one or more conditions

SQL Dates, Time and Strings

SQL Dates, Time and Strings

Here are some code snippets to help you get your head around how dates and times work in SQL.

Pivot Tables

Pivot Tables

Pivot tables allow you to organise and summarise your data without changing the source data itself.