Cleaning and transformations are the unsung heroes in driving any analysis forward.

Goal: Data Readiness. Preparing the nashville housing dataset for analysis.

• An intial query shows a semi-structured dataset based off missing values and the records returned.

• Cleaned and standardized records to eliminate gaps and inconsistencies.

• Address splits allow for readability and subsequent filtering.

• Best practices need to be adhered. A View was created to delete duplicates rather than deleting from the raw data.

• Properties may have multiple owners. Important to keep in mind for analysis surrounding individuals.

Question: How has the impact of Covid progressed over the years?

• Datasets recorded values by day, giving values for death counts and death totals.

• Cases, Deaths and resulting Mortality rates for reported cases as we progressed along the years.

• Aggregations summarized by places of interest helped visualize respective impacts.

• View Visualization