Internship Tasks

📊 Intermediate

Temperature vs Ice Cream Sales

Read the chart and answer every question (70% correct to pass).

Data Analysis

⏱ 5min ⭐ 150 XP

📊 Intermediate

Order Value Distribution

Read the chart and answer every question (70% correct to pass).

Data Analysis

⏱ 5min ⭐ 150 XP

📊 Intermediate

Query Runtime by Table Size

Read the chart and answer every question (70% correct to pass).

Data Analysis

⏱ 5min ⭐ 150 XP

📊 Intermediate

Model Accuracy by Model

Read the chart and answer every question (70% correct to pass).

Data Analysis

⏱ 5min ⭐ 150 XP

📊 Intermediate

Churn by Tenure

Read the chart and answer every question (70% correct to pass).

Data Analysis

⏱ 5min ⭐ 150 XP

📊 Intermediate

Support Response Time by Team

Read the chart and answer every question (70% correct to pass).

Data Analysis

⏱ 5min ⭐ 150 XP

📊 Intermediate

Monthly Refund Amounts

Read the chart and answer every question (70% correct to pass).

Data Analysis

⏱ 5min ⭐ 150 XP

📊 Intermediate

Email Open Rate by Subject Style

Read the chart and answer every question (70% correct to pass).

Data Analysis

⏱ 5min ⭐ 150 XP

📊 Intermediate

Market Share by Brand

Read the chart and answer every question (70% correct to pass).

Data Analysis

⏱ 5min ⭐ 150 XP

🔍 Intermediate

Integer Division Percentage

Find the buggy line.

Data Analysis

⏱ 5min ⭐ 150 XP

🔍 Intermediate

Mutating Original Data

Find the buggy line.

Data Analysis

⏱ 5min ⭐ 150 XP

🔍 Intermediate

Dates Converted to Text Before Sorting

Find the buggy line.

Data Analysis

⏱ 5min ⭐ 150 XP

📊 Intermediate

Website Visits Trend

Read the chart and answer every question (70% correct to pass).

Data Analysis

⏱ 5min ⭐ 150 XP

📊 Intermediate

Full Year Sales Seasonality

Read the chart and answer every question (70% correct to pass).

Data Analysis

⏱ 5min ⭐ 150 XP

📊 Intermediate

Profit by Store

Read the chart and answer every question (70% correct to pass).

Data Analysis

⏱ 5min ⭐ 150 XP

📊 Intermediate

Customer Acquisition Cost by Channel

Read the chart and answer every question (70% correct to pass).

Data Analysis

⏱ 5min ⭐ 150 XP

📊 Intermediate

Payment Method Share

Read the chart and answer every question (70% correct to pass).

Data Analysis

⏱ 5min ⭐ 150 XP

📊 Intermediate

Support Tickets by Type

Read the chart and answer every question (70% correct to pass).

Data Analysis

⏱ 5min ⭐ 150 XP

📊 Intermediate

Survey Satisfaction Split

Read the chart and answer every question (70% correct to pass).

Data Analysis

⏱ 5min ⭐ 150 XP

📊 Intermediate

Ad Spend vs Sales

Read the chart and answer every question (70% correct to pass).

Data Analysis

⏱ 5min ⭐ 150 XP

📊 Intermediate

Price vs Units Sold

Read the chart and answer every question (70% correct to pass).

Data Analysis

⏱ 5min ⭐ 150 XP

🧮 Intermediate

Rank a Score

Rank descending.

Data Analysis

⏱ 5min ⭐ 150 XP

🧮 Intermediate

Standard Deviation

Measure spread.

Data Analysis

⏱ 5min ⭐ 150 XP

🔍 Intermediate

SQL Where Placed Before From

Find the buggy line.

Data Analysis

⏱ 5min ⭐ 150 XP

🔍 Intermediate

SQL Alias Used in WHERE

Find the buggy line.

Data Analysis

⏱ 5min ⭐ 150 XP

🔍 Intermediate

SQL Join Wrong Key

Find the buggy line.

Data Analysis

⏱ 5min ⭐ 150 XP

🔍 Intermediate

SQL Null Comparison

Find the buggy line.

Data Analysis

⏱ 5min ⭐ 150 XP

🔍 Intermediate

SQL Having vs Where

Find the buggy line.

Data Analysis

⏱ 5min ⭐ 150 XP

🔍 Intermediate

Off By One Loop

Find the buggy line.

Data Analysis

⏱ 5min ⭐ 150 XP

🌳 Intermediate

Handling Outliers

Decide what to do.

Data Analysis

⏱ 5min ⭐ 150 XP

🌳 Intermediate

Inner vs Left Join

Choose the right join.

Data Analysis

⏱ 5min ⭐ 150 XP

🌳 Intermediate

Interpreting a p-value

Read a test result.

Data Analysis

⏱ 5min ⭐ 150 XP

🌳 Intermediate

Small Sample Warning

Judge reliability.

Data Analysis

⏱ 5min ⭐ 150 XP

🌳 Intermediate

Normalisation for Comparison

Compare fairly.

Data Analysis

⏱ 5min ⭐ 150 XP

🌳 Intermediate

Choosing a Sampling Method

Pick a method.

Data Analysis

⏱ 5min ⭐ 150 XP

🌳 Intermediate

Handling Data From Two Time Zones

Prevent an error.

Data Analysis

⏱ 5min ⭐ 150 XP

🌳 Intermediate

Simpson's Paradox Warning

Read aggregates carefully.

Data Analysis

⏱ 5min ⭐ 150 XP

🌳 Intermediate

Dashboard for Executives

Choose the design approach.

Data Analysis

⏱ 5min ⭐ 150 XP

🌳 Intermediate

Choosing a Chart for Two Numeric Variables

Pick a chart.

Data Analysis

⏱ 5min ⭐ 150 XP

🌳 Intermediate

Aggregating Before Joining

Avoid duplication.

Data Analysis

⏱ 5min ⭐ 150 XP

🌳 Intermediate

Data Ethics: Personal Data

Respect privacy.

Data Analysis

⏱ 5min ⭐ 150 XP

🧮 Intermediate

Percent Growth

Compute growth.

Data Analysis

⏱ 5min ⭐ 150 XP

🧮 Intermediate

Average For One Category

Conditional average.

Data Analysis

⏱ 5min ⭐ 150 XP

🧮 Intermediate

Multiple Criteria Count

Count with two conditions.

Data Analysis

⏱ 5min ⭐ 150 XP

🧮 Intermediate

Multiple Criteria Sum

Sum with two conditions.

Data Analysis

⏱ 5min ⭐ 150 XP

🧮 Intermediate

Flag High Value Orders

Return High or Normal.

Data Analysis

⏱ 5min ⭐ 150 XP

🧮 Intermediate

Safe Division

Handle errors.

Data Analysis

⏱ 5min ⭐ 150 XP

🧮 Intermediate

Lookup a Price

Exact match VLOOKUP.

Data Analysis

⏱ 5min ⭐ 150 XP

🧮 Intermediate

Round to Two Decimals

Round a ratio.

Data Analysis

⏱ 5min ⭐ 150 XP

🧮 Intermediate

Remove Extra Spaces

Clean text.

Data Analysis

⏱ 5min ⭐ 150 XP

🧮 Intermediate

Make Names Upper Case

Standardise text.

Data Analysis

⏱ 5min ⭐ 150 XP

🧮 Intermediate

Combine First and Last Name

Join with a space.

Data Analysis

⏱ 5min ⭐ 150 XP

🧮 Intermediate

Extract Year From a Date

Get the year.

Data Analysis

⏱ 5min ⭐ 150 XP

🧮 Intermediate

Extract the First Three Characters

Slice text.

Data Analysis

⏱ 5min ⭐ 150 XP

🔢 Intermediate

Order SQL Logical Execution

Arrange the clauses in the order the database logically evaluates them.

Data Analysis

⏱ 5min ⭐ 150 XP

🔢 Intermediate

Order Steps of an A/B Test

Sequence the stages of a well-run A/B test.

Data Analysis

⏱ 5min ⭐ 150 XP

🔢 Intermediate

Order the CRISP-DM Phases

Arrange the CRISP-DM phases in order.

Data Analysis

⏱ 5min ⭐ 150 XP

🔢 Intermediate

Sequence Handling Missing Values

Order the steps for dealing with missing data.

Data Analysis

⏱ 5min ⭐ 150 XP

🔢 Intermediate

Order Steps to Build a Dashboard

Sequence the dashboard build.

Data Analysis

⏱ 5min ⭐ 150 XP

🔢 Intermediate

Order Steps in Exploratory Analysis

Sequence a first look at a new dataset.

Data Analysis

⏱ 5min ⭐ 150 XP

🔢 Intermediate

Order Steps to Join Two Tables Correctly

Sequence the safe join workflow.

Data Analysis

⏱ 5min ⭐ 150 XP

🔢 Intermediate

Rank Medians Smallest First

Order the sets by median from lowest to highest.

Data Analysis

⏱ 5min ⭐ 150 XP

🔢 Intermediate

Order Sample Sizes for Reliability

Order the samples from least to most reliable estimate, all else equal.

Data Analysis

⏱ 5min ⭐ 150 XP

🔢 Intermediate

Order the Levels of Measurement

Order measurement levels from least to most informative.

Data Analysis

⏱ 5min ⭐ 150 XP

🔢 Intermediate

Order the ETL Pipeline Stages

Order the stages of an ETL pipeline.

Data Analysis

⏱ 5min ⭐ 150 XP

🔢 Intermediate

Order Steps to Present Findings

Sequence the storytelling steps.

Data Analysis

⏱ 5min ⭐ 150 XP

🔢 Intermediate

Order Time Units Smallest to Largest

Order the time periods from shortest to longest.

Data Analysis

⏱ 5min ⭐ 150 XP

🔢 Intermediate

Order Steps to Merge Multiple Files

Sequence combining monthly CSV files.

Data Analysis

⏱ 5min ⭐ 150 XP

🔢 Intermediate

Order Steps to Document an Analysis

Sequence documentation steps.

Data Analysis

⏱ 5min ⭐ 150 XP

💻 Intermediate

Search for a City

Search sales.csv for lines containing Lagos.

Data Analysis

⏱ 5min ⭐ 150 XP

💻 Intermediate

Count Refund Lines

Count lines containing refund in orders.csv.

Data Analysis

⏱ 5min ⭐ 150 XP

💻 Intermediate

Extract the Second Column

Print column 2 of the comma-separated sales.csv.

Data Analysis

⏱ 5min ⭐ 150 XP

💻 Intermediate

Top Three Scores

Show the 3 highest numbers in scores.txt.

Data Analysis

⏱ 5min ⭐ 150 XP

💻 Intermediate

Unique Customer Names

Show each unique line of names.txt once.

Data Analysis

⏱ 5min ⭐ 150 XP