Data Analyst and Technical Consultant

Tag: analytics

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

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.