01 Dataliteracy
Spotify Dataset
Kaggle link: Top Hits Spotify from 2000-2019
SQL Link: Dataset as SQL script
Coffee Dataset
Delivery
Individual or in pairs
Max 5 pages in .pdf using the hand-in link
Report content
Brief introduction & description of ONE of the dataset
How is the data structured? (E.g. Highligts of: Examples of data scales, dataset description, examples of data types)
For each question below:
Write a query solving the question
Describe - how does the query work?
A single example application/usage of the data set within:
Your personal domain
A professional domain (You decide whom the "user" is)
Research topic
Formulate a specific question and answer that question with a query
Questions (Top Hits Spotify dataset)
How many songs have explicit content?
Display all songs made between 2000-2010
What is the name of the most danceable track from 2001?
Display only the artist name and song title of tracks with a key between 1-5
Display all data pf songs starting with 'B' that has a key between 1-5
Questions (Coffee dataset)
Display all data from customers who do not have a phone number entered into the customer table
Display all products and their country of origin in a single table
Display all orders, customer firstname & lastname, and the country of origin of the product they ordered
Handin Date
17/9 - 2023 23:59
Handlin Link
https://kea-fronter.itslearning.com/LearningToolElement/ViewLearningToolElement.aspx?LearningToolElementId=1155448
Last updated