Now that we have cleaned up our data, we still require some additional data and transformations to occur in order to prepare our data for analysis. Specifically, we need to add our additional month data around hours billed to customers, as well as some additional transformations.Â
Merging, copying, and appending queries
Merging queries
Note that in the January query, there is a column called TaskID. The values in this column match the values in the TaskID column from our Tasks query. This Tasks query has additional information about each of these tasks regarding whether or not the task is Billable, or some other category, such as PTO, Int Admin, Sales Support, and Training. It would be good to have this information included...