Work

Teaching Case Cleaning House: A Case Teaching Data Cleaning Using Real-World Zillow Real Estate Data

Year: 2024

Type: article

Abstract: When we imagine the work of a data analyst, we often picture meaningful data analysis and beautiful data visualizations.Although that is an exciting part of the job, data analysts actually spend the majority of their time acquiring, cleaning, and preparing data for analysis.This teaching case guides students through some of the most common data cleaning challenges, including handling missing data, reshaping datasets, splitting columns, and profiling data to anticipate data quality concerns.Students will practice these skills in Microsoft Power BI, a current market leader in data analytics, using real-world, publicly available data from the popular United States real-estate platform Zillow.This case would be a good addition to data analytics, data management, or data visualization classes, or in general information systems courses looking to introduce students to the vital activity of data cleaning.

Source: Journal of Information Systems Education

DOI: 10.62273/oqxc8468

Author: Cassandra Collier

Institution: Southern Illinois University Edwardsville

Language: English

Topic: Information Systems Education and Curriculum Development

Subfield: Information Systems

Field: Computer Science

Domain: Physical Sciences

SDG: Quality education

Open Access status: hybrid

OpenAlex ID: W4404231545