top of page

Data Cleaning Project

I completed this project in an undergraduate course, Data Journalism (Spring 2023), where the objectives were similar to those of the Pivot Tables Project. I was provided with a dataset containing property information for different properties in the United Kingdom. I cleaned and transformed the dataset before going into further data analysis to ensure accurate results and visualizations. The next task I performed was creating pivot tables and pivot charts to provide valuable insights (i.e., patterns, trends), such as the popularity of property type by location, or the average asking price for the top three property types. The end goal was to create a dashboard to summarize and display the key findings, as well as include interactive elements that correlate to the pivot charts.

Excel Sheet:

bottom of page