Data Analyst and Technical Consultant

Tag: data

AJAX and JSON starter kit

AJAX and JSON starter kit

AJAX allows web pages to be updated without refreshing the whole page using XMLHttpRequest and JSON, a lightweight data-interchange format, which is easy to read and write.

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

Google Analytics IQ

Google Analytics IQ

This is a quick guide to the fundamentals of Googles Analytics reporting and the principals in the certification exam.

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