Skip main navigation

£199.99 £139.99 for one year of Unlimited learning. Offer ends on 28 February 2023 at 23:59 (UTC). T&Cs apply

Find out more

Database Fundamentals: A Video Introduction

Here, we’ll focus on relational databases. As an analyst you’ll often work with these, especially when you have to analyse business data or transactions. Read also: What is a database …

Why Create Exploratory Visualisations in Excel?

Visualising data is often the most effective way to describe, explore, and summarise a set of numbers, especially for very large data sets. Generally speaking, there are two categories of …

How to Create Pivot Tables in Excel

This video on the basics of creating pivot tables will include: Creating and selecting the correct cells Using pivot tables in an existing or new worksheet How to add fields …

How to Sort and Filter Data in Excel

Sorting data in Excel There are many options for sorting data. You can sort data on common attributes, such as: text (A to Z, or Z to A) numbers (low …

Wrangling data in Excel

In this activity you’ll practice wrangling data. Download the spreadsheet. 3.1.6-songs.csv (CSV file) The worksheet has information about songs that have reached number one in the US charts. Unfortunately, the …

How to Create a Database Using SQLite

This database we’re creating will be a blank canvas to create table structures, which we’ll fill with information. Using DB Browser to create a database One can go about using …

What Is Structured Query Language (SQL)?

Structured Query Language (SQL) is the most widely implemented database query language and is supported by many popular relational database systems, including: MS SQL Server, IBM DB2, MySQL, and Microsoft …