Skip to main content

Learn More: Data Foundations Lab

Learn more about WQU's free, self-paced Data Foundations Lab that builds practical data skills.

Written by Kate Porter

Your Starting Point for Applied Technical Learning

Every data science and AI project starts with data, but real-world data is rarely clean. Files arrive in the wrong format, values are missing, and sensors report the impossible. Before anyone can build a reliable model or draw meaningful conclusions, that data needs to be prepared and validated. In the Data Foundations Lab, you’ll build on your foundational Python and statistics knowledge to turn messy, real-world data into reliable, analysis-ready datasets.

You'll gain practical experience in:

  • Preparing messy, real-world data for analysis

  • Making and defending data quality decisions

  • Building reproducible, tested data workflows

  • Applying your skills to unfamiliar datasets across different industries

Self-Paced (Est. 10-16 weeks)

6-8 Hours Per Week

Prerequisites:

  • Foundational Python skills

  • Comfort working in Jupyter Notebooks

  • Basic statistics

  • Ability to read tables and simple charts

Application Requirements

  • Above Suggested Prerequisites

  • Passing score on Admissions Assessment (70% or higher)

    • Before you can start the Lab, you need to take a short Admissions Assessment. We want to make sure you have a solid foundation on which you can build the skills we teach in our program.
      ​
      We ask that you not use supplementary materials, so close your textbooks and any other browser windows. We recommend that you have a pencil and paper ready in case you want to write out a problem.
      ​
      ​To prepare for the Assessment, we recommend the following resources:

    • If you fail the Admissions Assessment

      • you have a second (and final) attempt after a 7-day waiting period.

      • Applicants who do not pass the test on their 2nd attempt are able to reapply to the Lab following a waiting period of 6 months from the date of their 2nd attempt.

      • Important Warning: Each student may create and maintain only one account on the WQU learning platform, regardless of the number of programs they are enrolled in. Creating, operating, or controlling more than one account is prohibited unless expressly permitted by the Academic Dean or other authorized personnel. Creating duplicate accounts to bypass restrictions currently in place is strictly prohibited. This includes creating multiple accounts to gain additional attempts at an Admission Test or to apply to multiple graduate programs, and creating a new account after an existing account has been suspended, terminated, or withdrawn.

Next Steps After Passing the Admissions Assessment

  1. Complete your Student Profile;

  2. Sign the User Agreement;

  3. Begin Project 1

Once you have completed your profile and signed the User Agreement, you will be automatically enrolled in Unit 1, which can be accessed via My Courses in the top navigation of the WQU Learning Platform.

After Unit 1, you are responsible for registering for Unit 2 by navigating to My Courses and "Register".


The Data Foundations Lab is designed in two progressive units:

  • Unit 1: Four projects that cover loading, cleaning, combining and visualizing real-world data. Completing Unit 1 earns you a shareable digital badge.

  • Unit 2: Four advanced projects that build data quality judgment and reproducible, tested workflows, leading to a full Lab certificate.

Credentials Earned Upon Successful Completion

  • Shareable digital badge upon successful completion of Unit 1

  • Verified Digital Badge and Certificate upon successful completion of Units 1 & 2
    ​
    ​By the end of this Lab, you'll know how to:
    ​

    • Prepare real-world data for analysis across multiple formats and sources

    • Evaluate data quality and make informed preparation decisions

    • Build reproducible, tested and documented data workflows

    • Apply your skills to unfamiliar datasets and new contexts

Project Descriptions

The Data Foundations Lab comprises two units, each with four end-to-end projects. Each successful project completion unlocks the registration for the next.

Project 1: The NYC Property Sales Engagement

self-paced

As a hypothetical junior analyst for a property consultancy, learners answer a simple client question: what did New York property really sell for last year? The sales data comes from public NYC records in CSV, Excel and JSON files, each with its own problems, from encoding errors to multi-sheet workbooks. Learners load every file, manage memory on a large extract and turn prices stored as text into numbers they can trust. The project closes by running the same workflow on property sales from the United Kingdom.

Project 2: The City Air Quality Engagement

self-paced

A city wants to publish a daily air quality figure, but first someone has to confirm the sensor feed can be trusted. Using a year of hourly readings from a roadside sensor in an Italian city, learners find and map gaps in the data, test simple ways to fill them and learn when each method gives a misleading picture. They also protect the feed with duplicate checks, filters and range checks. The final lesson applies the same checks to air quality data from multiple stations in Beijing.

Project 3: The Rising Rates Engagement

self-paced

When US interest rates rose quickly in 2022 and 2023, which parts of the economy held up best? Learners answer this question using US industry returns from the Kenneth French Data Library and interest rate data from FRED. No finance background is needed, as every market concept is explained in plain language. Learners build reusable functions, create new measures such as the growth of one dollar invested, and combine data series that follow different calendars. The project closes by asking the same question of European markets.

Project 4: The Online Retail Engagement

Project 4 • self-paced

A manager wants to understand two years of online sales and needs to trust what the charts show. Learners work with the transaction history of a UK online gift shop, where cancelled orders, missing customer IDs and repeated entries are part of the data. They build clear charts a non-technical reader can follow and record every cleaning decision in a short data quality report. The project ends by answering the same questions with purchase data from a different online shop.

Project 5: The Iowa Home Appraisal Engagement

self-paced

A home valuation firm prices houses from county records, but many fields are empty. Some values are truly unknown, while others simply mean a house has no pool, garage or basement. Learners fill gaps using neighborhood context and rules that follow the meaning of the data, then measure how much each choice changes the result. They package their cleaning steps as reusable, tested code. The project closes by running the same pipeline on property records from Washington, DC.

Project 6: The Faulty Sensor Engagement

self-paced

A research lab placed 54 wireless sensors on one floor to track temperature, humidity and light, and the building team wants to use them to run the heating. When batteries run low, sensors start reporting impossible values. Learners design a multi-level filter, handle edge cases and test how much the result shifts when thresholds change. They then move their filter into reusable modules with automated tests. The final lesson runs the same module on weather stations along Chicago's beaches.

Project 7: The Report Card Engagement

self-paced

A personal finance newsletter wants a simple health check of every US-listed company: how much it sells, how much it keeps as profit and how much it owes. Using annual reports filed with the SEC, learners build meaningful measures such as profit margins and test how choices like trimming extreme values change the picture. No finance background is needed. Along the way, they learn to recognize why data goes missing and choose the right strategy for each case. The project closes by rebuilding the table from the SEC's raw quarterly files.

Project 8: The Bike Share Data Audit Engagement

self-paced

A city transport office wants to plan new bike docks using trip records from London's public bike scheme, but first it needs a dataset it can trust and a quality score it can quote. The records include rides lasting seconds or weeks, mismatched timestamps and station codes missing their leading zeros. Learners build a framework of validation rules that scores the data's reliability and produce an analysis-ready file with every transformation documented. In the final lesson, the same pipeline and rules run on bike trips from Helsinki.

Learning Outcomes

  • Prepare Real-World Data for Analysis Identify and resolve common data quality challenges across multiple file formats, sources and domains, including encoding errors, inconsistent formats and missing values.

  • Make Informed Technical Decisions Evaluate different data preparation approaches and use sensitivity analysis to measure how each choice affects downstream results.

  • Build Reliable, Reproducible Workflows Develop, test and document data preparation processes as reusable code that others can rerun, validate and modify.

  • Apply Skills in New Contexts Adapt workflows to unfamiliar datasets, document what changes and build a foundation for more advanced data science learning.

  • Assess Data Quality Systematically Design validation rules and data quality frameworks that quantify how reliable a dataset is, and recognize why data goes missing.

  • Communicate Findings Clearly Build charts a non-technical reader can follow and produce data quality reports that explain every cleaning decision.

Did this answer your question?