Data Wrangling Project

(Oct 2019)

Aim to create a database to support analysis of the relationship between culture, tourism and culture/arts development. The project focus on the data wrangling instead of data analytics.

• Gather real raw data from 11 sources across platforms and cleaned the dirty data within Excel (used advanced formulas, Pivot Table, and Power query) and RegEx

• Model and built a database to record combined data using SQL Server by SQL

• Improve data-based problem-solving skills, refined data wrangling skills and be patient

The documentation is enclosed here:

project documentation.pdf

Download PDF • 2.94MB