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

This module is the second part to the introduction to the SQLite database and the SQL database query language. We will discover how we can start analysing a real dataset using SQL.

Module Objectives

Understand how you can use SQL to do analysis
Learn intermediate-level SQL queries

Prerequisites

SQLite – a simple, self-contained, serverless relational database. Comes preinstalled on Mac OSX, for Windows Download it here
The enhetsreistered SQLite database – the Norwegian company register.

Exporting and Importing Data

Introduction into Exploring Data

Curriculum

Introduction

Module Objectives

Prerequisites

Modal title