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 …
Course: Excel for Data Analysis
Optional Project Task: Visualising relationships
In this topic you’ve seen how visualisations can be used to spot patterns and trends in data. Now it’s your turn to apply this to your optional project with the …
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 …
Excel Functions: How to Wrangle Data with Spreadsheets
There’s a variety of tools and techniques for importing and processing data. Traditionally, and for relatively small, simple data sets, we do this manually with text editors or spreadsheets. For …
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 …