Real-World track
Real-World Scenarios
50 real job problems across the disciplines — each starts with a workplace issue and becomes its own publishable portfolio project.
Start at step 1. Each idea prepares you for the next one.
- 1Read the company's problem like a real job brief
- 2Look at the ready-made solution and understand each line
- 3Run the solution and check the deliverable
- 4Publish each solved case as its own portfolio project
- 5Complete all projects in a discipline to show that skill area
Continue where you left off
Data Analytics case 1: Root-cause analysis for Finance
50 questions remaining in this sector
Data Analytics · Problem Solving & Root Cause Analysis
15 exercises — finish them all to earn a certificate
15 questions left to earn this certificate
- Data Analytics case 1: Root-cause analysis for Finance
- Data Analytics case 2: KPI reporting for Environment
- Data Analytics case 3: Data cleaning for Conservation
- Data Analytics case 4: Share analysis for Healthcare
- Data Analytics case 5: Seaborn for Retail
- Data Analytics case 6: Target tracking for Construction
- Data Analytics case 7: Ranking for Manufacturing
- Data Analytics case 8: Trend analysis for Engineering
- Data Analytics case 9: Dashboards for Transport
- Data Analytics case 10: Recommendations for Energy
- Data Analytics case 11: Pivot summaries for Finance
- Data Analytics case 12: Top performers for Environment
- Data Analytics case 13: Averages for Conservation
- Data Analytics case 14: Filtering for Healthcare
- Data Analytics case 15: Bar charts for Retail
Data Analytics case 1: Root-cause analysis for Finance
+20 XPYou are a data professional. An insurance company has an issue: amount has jumped and managers do not know which region is causing it. As a Data Analyst, you are tasked to solve it.
Data Analytics case 2: KPI reporting for Environment
+20 XPYou are a data professional. A river protection agency has an issue: the board wants one page of KPIs for water_tests every month. As a BI Analyst, you are tasked to solve it.
Data Analytics case 3: Data cleaning for Conservation
+20 XPYou are a data professional. A national game reserve has an issue: the animal_counts export has blank and duplicated rows, so reports disagree. As a Reporting Analyst, you are tasked to solve it.
Data Analytics case 4: Share analysis for Healthcare
+20 XPYou are a data professional. A public clinic group has an issue: leaders want to know what percentage each ward contributes. As a Data Analyst, you are tasked to solve it.
Data Analytics case 5: Seaborn for Retail
+20 XPYou are a data professional. A clothing retailer has an issue: a manager says the items values are "all over the place". As a Insights Analyst, you are tasked to solve it.
Data Analytics case 6: Target tracking for Construction
+20 XPYou are a data professional. A building contractor has an issue: each record should stay under a target of 6 workers. As a Data Analyst, you are tasked to solve it.
Data Analytics case 7: Ranking for Manufacturing
+20 XPYou are a data professional. A packaging factory has an issue: the team wants a league table of every line. As a Commercial Analyst, you are tasked to solve it.
Data Analytics case 8: Trend analysis for Engineering
+20 XPYou are a data professional. A water pumping utility has an issue: management asks whether vibration is rising or falling. As a Data Analyst, you are tasked to solve it.
Data Analytics case 9: Dashboards for Transport
+20 XPYou are a data professional. A city bus operator has an issue: staff need a two-chart dashboard image for an email. As a Reporting Analyst, you are tasked to solve it.
Data Analytics case 10: Recommendations for Energy
+20 XPYou are a data professional. A renewable power producer has an issue: the director wants one clear recommendation from the power_readings data. As a Data Analyst, you are tasked to solve it.
Data Analytics case 11: Pivot summaries for Finance
+20 XPYou are a data professional. A community bank has an issue: managers want amount per region in one small table. As a Data Analyst, you are tasked to solve it.
Data Analytics case 12: Top performers for Environment
+20 XPYou are a data professional. A coastal clean-up charity has an issue: leaders only have time to read about the top 2 records. As a Data Analyst, you are tasked to solve it.
Data Analytics case 13: Averages for Conservation
+20 XPYou are a data professional. A marine turtle project has an issue: staff argue about what a "normal" seen is. As a BI Analyst, you are tasked to solve it.
Data Analytics case 14: Filtering for Healthcare
+20 XPYou are a data professional. A children's hospital has an issue: the Kids manager only wants their own numbers. As a Data Analyst, you are tasked to solve it.
Data Analytics case 15: Bar charts for Retail
+20 XPYou are a data professional. An online grocery shop has an issue: a poster needs one simple picture of items by store. As a Reporting Analyst, you are tasked to solve it.
Data Analytics · Problem Solving & Counting
15 exercises — finish them all to earn a certificate
15 questions left to earn this certificate
- Data Analytics case 16: Counting for Construction
- Data Analytics case 17: Banding for Manufacturing
- Data Analytics case 18: Summary statistics for Engineering
- Data Analytics case 19: Exporting for Transport
- Data Analytics case 20: Pie charts for Energy
- Data Analytics case 21: SQL totals for Finance
- Data Analytics case 22: SQL grouping for Environment
- Data Analytics case 23: SQL filtering for Conservation
- Data Analytics case 24: SQL averages for Healthcare
- Data Analytics case 25: SQL sorting for Retail
- Data Analytics case 26: SQL top records for Construction
- Data Analytics case 27: SQL counting for Manufacturing
- Data Analytics case 28: SQL thresholds for Engineering
- Data Analytics case 29: SQL min & max for Transport
- Data Analytics case 30: SQL search for Energy
Data Analytics case 16: Counting for Construction
+20 XPYou are a data professional. A road building company has an issue: nobody knows how many records each site has. As a Data Analyst, you are tasked to solve it.
Data Analytics case 17: Banding for Manufacturing
+20 XPYou are a data professional. A bakery production plant has an issue: staff want each units labelled Low, Medium or High. As a Data Analyst, you are tasked to solve it.
Data Analytics case 18: Summary statistics for Engineering
+20 XPYou are a data professional. A bridge inspection firm has an issue: a new manager wants a quick feel for the pump_checks numbers. As a Insights Analyst, you are tasked to solve it.
Data Analytics case 19: Exporting for Transport
+20 XPYou are a data professional. A delivery van fleet has an issue: the finance team wants the bus_trips data as a file. As a Data Analyst, you are tasked to solve it.
Data Analytics case 20: Pie charts for Energy
+20 XPYou are a data professional. A solar farm operator has an issue: leaders want to see each plant's slice of the whole. As a Data Analyst, you are tasked to solve it.
Data Analytics case 21: SQL totals for Finance
+20 XPYou are a data professional. A community bank has an issue: the board asks for the total amount across all regions. As a Data Analyst, you are tasked to solve it.
Data Analytics case 22: SQL grouping for Environment
+20 XPYou are a data professional. A coastal clean-up charity has an issue: managers want to compare every river side by side. As a Data Analyst, you are tasked to solve it.
Data Analytics case 23: SQL filtering for Conservation
+20 XPYou are a data professional. A marine turtle project has an issue: the Rhino team only wants its own records. As a BI Analyst, you are tasked to solve it.
Data Analytics case 24: SQL averages for Healthcare
+20 XPYou are a data professional. A children's hospital has an issue: staff argue about what a normal wait_minutes looks like. As a Reporting Analyst, you are tasked to solve it.
Data Analytics case 25: SQL sorting for Retail
+20 XPYou are a data professional. An online grocery shop has an issue: leaders want the biggest items records first. As a Data Analyst, you are tasked to solve it.
Data Analytics case 26: SQL top records for Construction
+20 XPYou are a data professional. A road building company has an issue: the director has time for only the top 2 records. As a Data Analyst, you are tasked to solve it.
Data Analytics case 27: SQL counting for Manufacturing
+20 XPYou are a data professional. A bakery production plant has an issue: nobody knows how many records each line holds. As a Reporting Analyst, you are tasked to solve it.
Data Analytics case 28: SQL thresholds for Engineering
+20 XPYou are a data professional. A bridge inspection firm has an issue: any vibration above 5 needs urgent review. As a Data Analyst, you are tasked to solve it.
Data Analytics case 29: SQL min & max for Transport
+20 XPYou are a data professional. A delivery van fleet has an issue: the report needs the best and worst delay_minutes in one line. As a BI Analyst, you are tasked to solve it.
Data Analytics case 30: SQL search for Energy
+20 XPYou are a data professional. A solar farm operator has an issue: staff cannot remember the exact spelling of a plant. As a Data Analyst, you are tasked to solve it.
Data Science · Problem Solving & Regression
15 exercises — finish them all to earn a certificate
15 questions left to earn this certificate
- Data Science case 1: Regression for Finance
- Data Science case 2: Anomaly detection for Environment
- Data Science case 3: Classification for Conservation
- Data Science case 4: Clustering for Healthcare
- Data Science case 5: Correlation for Retail
- Data Science case 6: Model evaluation for Construction
- Data Science case 7: Feature engineering for Manufacturing
- Data Science case 8: Probability for Engineering
- Data Science case 9: Random forest for Transport
- Data Science case 10: Communication for Energy
- Data Science case 11: Train/test split for Finance
- Data Science case 12: Scaling for Environment
- Data Science case 13: Logistic regression for Conservation
- Data Science case 14: Confusion matrix for Healthcare
- Data Science case 15: Missing values for Retail
Data Science case 1: Regression for Finance
+20 XPYou are a data professional. An insurance company has an issue: planners need to forecast next period's amount. As a Data Scientist, you are tasked to solve it.
Data Science case 2: Anomaly detection for Environment
+20 XPYou are a data professional. A river protection agency has an issue: some water_tests records look suspicious. As a Data Scientist, you are tasked to solve it.
Data Science case 3: Classification for Conservation
+20 XPYou are a data professional. A national game reserve has an issue: staff want to know early which records will be "high". As a Data Scientist, you are tasked to solve it.
Data Science case 4: Clustering for Healthcare
+20 XPYou are a data professional. A public clinic group has an issue: the team wants to group similar wards for different treatment. As a Data Scientist, you are tasked to solve it.
Data Science case 5: Correlation for Retail
+20 XPYou are a data professional. A clothing retailer has an issue: someone claims items grows over time. As a Data Scientist, you are tasked to solve it.
Data Science case 6: Model evaluation for Construction
+20 XPYou are a data professional. A building contractor has an issue: a vendor model claims 90% accuracy on site_jobs. As a Data Scientist, you are tasked to solve it.
Data Science case 7: Feature engineering for Manufacturing
+20 XPYou are a data professional. A packaging factory has an issue: the model cannot read the line words. As a Data Scientist, you are tasked to solve it.
Data Science case 8: Probability for Engineering
+20 XPYou are a data professional. A water pumping utility has an issue: a manager asks the chance a random record is from PumpA. As a Data Scientist, you are tasked to solve it.
Data Science case 9: Random forest for Transport
+20 XPYou are a data professional. A city bus operator has an issue: a single tree gave unstable answers for bus_trips. As a Data Scientist, you are tasked to solve it.
Data Science case 10: Communication for Energy
+20 XPYou are a data professional. A renewable power producer has an issue: executives need predictions explained in plain words. As a Data Scientist, you are tasked to solve it.
Data Science case 11: Train/test split for Finance
+20 XPYou are a data professional. A community bank has an issue: the payments model was tested on the data it learned from. As a Data Scientist, you are tasked to solve it.
Data Science case 12: Scaling for Environment
+20 XPYou are a data professional. A coastal clean-up charity has an issue: ph values are too big for the model to compare fairly. As a Data Scientist, you are tasked to solve it.
Data Science case 13: Logistic regression for Conservation
+20 XPYou are a data professional. A marine turtle project has an issue: staff need a yes/no prediction for each animal_counts record. As a Data Scientist, you are tasked to solve it.
Data Science case 14: Confusion matrix for Healthcare
+20 XPYou are a data professional. A children's hospital has an issue: the Healthcare team wants to see exactly where the model is wrong. As a Data Scientist, you are tasked to solve it.
Data Science case 15: Missing values for Retail
+20 XPYou are a data professional. An online grocery shop has an issue: some items values are blank and break the model. As a Data Scientist, you are tasked to solve it.
Data Science · Problem Solving & K Nearest Neighbours
5 exercises — finish them all to earn a certificate
5 questions left to earn this certificate
Data Science case 16: K-nearest neighbours for Construction
+20 XPYou are a data professional. A road building company has an issue: staff want to label a new site_jobs record by its closest neighbours. As a Data Scientist, you are tasked to solve it.
Data Science case 17: Hypothesis testing for Manufacturing
+20 XPYou are a data professional. A bakery production plant has an issue: a manager says two halves of machine_runs are different. As a Data Scientist, you are tasked to solve it.
Data Science case 18: Feature importance for Engineering
+20 XPYou are a data professional. A bridge inspection firm has an issue: leaders ask which input matters most for vibration. As a Data Scientist, you are tasked to solve it.
Data Science case 19: Histograms for Transport
+20 XPYou are a data professional. A delivery van fleet has an issue: nobody knows how delay_minutes values are spread out. As a Data Scientist, you are tasked to solve it.
Data Science case 20: Scatter plots for Energy
+20 XPYou are a data professional. A solar farm operator has an issue: someone thinks later power_readings records have bigger megawatts. As a Data Scientist, you are tasked to solve it.