Combine and tidy two datasets of store sales from different years to prepare for analysis in Tableau. This task will involve restructuring the datasets to adhere to the principles of tidy data, which is a common requirement for real$-$world data analysis.

Description

Download the datasets for the respective years from the provided links:

Sales Data for Year $1$ Download Sales Data for Year $1$

Sales Data for Year $2$ Download Sales Data for Year $2$

Load both datasets into Tableau Prep, combine them, and tidy the data.

Export the cleaned dataset to a suitable format.

Submission

The clean dataset.

Your Tableau Prep flow file showing your process.

A report documenting the steps taken, with a screenshot of your Tableau Prep flow to illustrate your approach.

Note: Receiving datasets in various structures is typical in data analysis. Frequently, they need to be prepped before any meaningful analysis can occur. Your ability to clean and combine such data is a valuable skill.