Introduction into Exploring Data

Curriculum

4 Sections
16 Lessons
Lifetime

Expand all sectionsCollapse all sections

A gentle introduction to exploring and understanding your data
What if we told you, there is a quick way, your computer can help you to summarize and understand data? Wouldn’t this be great? Check this course to learn how to use pivot tables to do this!
5
Advanced Spreadsheet Formulas
It's time to go beyond the basics and learn advanced formula tricks. This module will introduce you, among other things, to Vlookup: one of the most powerful spreadsheet formula.
5
An introduction to SQL Databases for analysing data - Part 1
Spreadsheets are really useful, but sometimes they're too limited for what you want to do. Like analysing a very big dataset quickly or gaining complex insights on your data. Here comes the SQL query.
3
An introduction to SQL Databases for analysing data - Part 2
Now that we know the basics of SQL language, we can explore how to use them to analyse a real dataset.
4

Introduction

Spreadsheets are great for data analysis but when it comes to larger amounts of data or more complex data structures – databases really outperform them. The most common type of databases used are so-called “SQL” databases. SQL is short for “Structured Query Language” – a special language to send requests to the database and get some results out of it (or data into it). While there is some standard for SQL – every SQL-database uses a slightly different dialect. Don’t be afraid – the basics are the same.

This module provides a basic introduction to the SQLite database and the SQL database query language. This first part introduces SQLite and illustrates how to start working with it.

Module Objectives

Understand basic SQL
Understand importing and exporting of Data

Prerequisites

SQLite – a simple, self-contained, serverless relational database. Comes preinstalled on Mac OSX, for Windows Download it here

Extension Activity – Querying a Data Set

Introduction into Exploring Data

Curriculum

Introduction

Module Objectives

Prerequisites

Modal title