Learning areas/Real-World Scenarios

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.

Learn in this order

Start at step 1. Each idea prepares you for the next one.

0/5
  1. 1Read the company's problem like a real job brief
  2. 2Look at the ready-made solution and understand each line
  3. 3Run the solution and check the deliverable
  4. 4Publish each solved case as its own portfolio project
  5. 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

Resume →

Data Analytics · Problem Solving & Root Cause Analysis

15 exercises — finish them all to earn a certificate

0/15 done
15 questions left to earn this certificate
  1. Data Analytics case 1: Root-cause analysis for Finance
  2. Data Analytics case 2: KPI reporting for Environment
  3. Data Analytics case 3: Data cleaning for Conservation
  4. Data Analytics case 4: Share analysis for Healthcare
  5. Data Analytics case 5: Seaborn for Retail
  6. Data Analytics case 6: Target tracking for Construction
  7. Data Analytics case 7: Ranking for Manufacturing
  8. Data Analytics case 8: Trend analysis for Engineering
  9. Data Analytics case 9: Dashboards for Transport
  10. Data Analytics case 10: Recommendations for Energy
  11. Data Analytics case 11: Pivot summaries for Finance
  12. Data Analytics case 12: Top performers for Environment
  13. Data Analytics case 13: Averages for Conservation
  14. Data Analytics case 14: Filtering for Healthcare
  15. Data Analytics case 15: Bar charts for Retail

Data Analytics case 1: Root-cause analysis for Finance

+20 XP

You 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.

PYTHONRoot-cause analysisData Analytics

Data Analytics case 2: KPI reporting for Environment

+20 XP

You 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.

PYTHONKPI reportingData Analytics

Data Analytics case 3: Data cleaning for Conservation

+20 XP

You 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.

PYTHONData cleaningData Analytics

Data Analytics case 4: Share analysis for Healthcare

+20 XP

You 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.

PYTHONShare analysisData Analytics

Data Analytics case 5: Seaborn for Retail

+20 XP

You 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.

PYTHONSeabornData Analytics

Data Analytics case 6: Target tracking for Construction

+20 XP

You 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.

PYTHONTarget trackingData Analytics

Data Analytics case 7: Ranking for Manufacturing

+20 XP

You 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.

PYTHONRankingData Analytics

Data Analytics case 8: Trend analysis for Engineering

+20 XP

You 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.

PYTHONTrend analysisData Analytics

Data Analytics case 9: Dashboards for Transport

+20 XP

You 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.

PYTHONDashboardsData Analytics

Data Analytics case 10: Recommendations for Energy

+20 XP

You 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.

PYTHONRecommendationsData Analytics

Data Analytics case 11: Pivot summaries for Finance

+20 XP

You 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.

PYTHONPivot summariesData Analytics

Data Analytics case 12: Top performers for Environment

+20 XP

You 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.

PYTHONTop performersData Analytics

Data Analytics case 13: Averages for Conservation

+20 XP

You 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.

PYTHONAveragesData Analytics

Data Analytics case 14: Filtering for Healthcare

+20 XP

You 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.

PYTHONFilteringData Analytics

Data Analytics case 15: Bar charts for Retail

+20 XP

You 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.

PYTHONBar chartsData Analytics

Data Analytics · Problem Solving & Counting

15 exercises — finish them all to earn a certificate

0/15 done
15 questions left to earn this certificate
  1. Data Analytics case 16: Counting for Construction
  2. Data Analytics case 17: Banding for Manufacturing
  3. Data Analytics case 18: Summary statistics for Engineering
  4. Data Analytics case 19: Exporting for Transport
  5. Data Analytics case 20: Pie charts for Energy
  6. Data Analytics case 21: SQL totals for Finance
  7. Data Analytics case 22: SQL grouping for Environment
  8. Data Analytics case 23: SQL filtering for Conservation
  9. Data Analytics case 24: SQL averages for Healthcare
  10. Data Analytics case 25: SQL sorting for Retail
  11. Data Analytics case 26: SQL top records for Construction
  12. Data Analytics case 27: SQL counting for Manufacturing
  13. Data Analytics case 28: SQL thresholds for Engineering
  14. Data Analytics case 29: SQL min & max for Transport
  15. Data Analytics case 30: SQL search for Energy

Data Analytics case 16: Counting for Construction

+20 XP

You 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.

PYTHONCountingData Analytics

Data Analytics case 17: Banding for Manufacturing

+20 XP

You 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.

PYTHONBandingData Analytics

Data Analytics case 18: Summary statistics for Engineering

+20 XP

You 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.

PYTHONSummary statisticsData Analytics

Data Analytics case 19: Exporting for Transport

+20 XP

You 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.

PYTHONExportingData Analytics

Data Analytics case 20: Pie charts for Energy

+20 XP

You 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.

PYTHONPie chartsData Analytics

Data Analytics case 21: SQL totals for Finance

+20 XP

You 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.

SQLSQL totalsData Analytics

Data Analytics case 22: SQL grouping for Environment

+20 XP

You 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.

SQLSQL groupingData Analytics

Data Analytics case 23: SQL filtering for Conservation

+20 XP

You 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.

SQLSQL filteringData Analytics

Data Analytics case 24: SQL averages for Healthcare

+20 XP

You 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.

SQLSQL averagesData Analytics

Data Analytics case 25: SQL sorting for Retail

+20 XP

You 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.

SQLSQL sortingData Analytics

Data Analytics case 26: SQL top records for Construction

+20 XP

You 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.

SQLSQL top recordsData Analytics

Data Analytics case 27: SQL counting for Manufacturing

+20 XP

You 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.

SQLSQL countingData Analytics

Data Analytics case 28: SQL thresholds for Engineering

+20 XP

You 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.

SQLSQL thresholdsData Analytics

Data Analytics case 29: SQL min & max for Transport

+20 XP

You 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.

SQLSQL min & maxData Analytics

Data Analytics case 30: SQL search for Energy

+20 XP

You 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.

SQLSQL searchData Analytics

Data Science · Problem Solving & Regression

15 exercises — finish them all to earn a certificate

0/15 done
15 questions left to earn this certificate
  1. Data Science case 1: Regression for Finance
  2. Data Science case 2: Anomaly detection for Environment
  3. Data Science case 3: Classification for Conservation
  4. Data Science case 4: Clustering for Healthcare
  5. Data Science case 5: Correlation for Retail
  6. Data Science case 6: Model evaluation for Construction
  7. Data Science case 7: Feature engineering for Manufacturing
  8. Data Science case 8: Probability for Engineering
  9. Data Science case 9: Random forest for Transport
  10. Data Science case 10: Communication for Energy
  11. Data Science case 11: Train/test split for Finance
  12. Data Science case 12: Scaling for Environment
  13. Data Science case 13: Logistic regression for Conservation
  14. Data Science case 14: Confusion matrix for Healthcare
  15. Data Science case 15: Missing values for Retail

Data Science case 1: Regression for Finance

+20 XP

You 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.

PYTHONRegressionData Science

Data Science case 2: Anomaly detection for Environment

+20 XP

You 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.

PYTHONAnomaly detectionData Science

Data Science case 3: Classification for Conservation

+20 XP

You 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.

PYTHONClassificationData Science

Data Science case 4: Clustering for Healthcare

+20 XP

You 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.

PYTHONClusteringData Science

Data Science case 5: Correlation for Retail

+20 XP

You 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.

PYTHONCorrelationData Science

Data Science case 6: Model evaluation for Construction

+20 XP

You 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.

PYTHONModel evaluationData Science

Data Science case 7: Feature engineering for Manufacturing

+20 XP

You 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.

PYTHONFeature engineeringData Science

Data Science case 8: Probability for Engineering

+20 XP

You 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.

PYTHONProbabilityData Science

Data Science case 9: Random forest for Transport

+20 XP

You 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.

PYTHONRandom forestData Science

Data Science case 10: Communication for Energy

+20 XP

You 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.

PYTHONCommunicationData Science

Data Science case 11: Train/test split for Finance

+20 XP

You 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.

PYTHONTrain/test splitData Science

Data Science case 12: Scaling for Environment

+20 XP

You 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.

PYTHONScalingData Science

Data Science case 13: Logistic regression for Conservation

+20 XP

You 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.

PYTHONLogistic regressionData Science

Data Science case 14: Confusion matrix for Healthcare

+20 XP

You 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.

PYTHONConfusion matrixData Science

Data Science case 15: Missing values for Retail

+20 XP

You 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.

PYTHONMissing valuesData Science

Data Science · Problem Solving & K Nearest Neighbours

5 exercises — finish them all to earn a certificate

0/5 done
5 questions left to earn this certificate
  1. Data Science case 16: K-nearest neighbours for Construction
  2. Data Science case 17: Hypothesis testing for Manufacturing
  3. Data Science case 18: Feature importance for Engineering
  4. Data Science case 19: Histograms for Transport
  5. Data Science case 20: Scatter plots for Energy