About the Data

T$-$Shirts.com Fabric Water Impact Analysis

Within the Excel workbook, the Production$\_$Data worksheet contains the source data to work with for

this assignment. The source data is formatted as a Table with the Table Name: Batch$\_$Table

Each row describes one batch of T$-$shirts that was produced by T$-$shirts.com.

Each column in the Table represents particular Attributes, which we also refer to as Dimensions.

In this scenario, our Attributes describe the t$-$shirt Batches, and they include:

$$ the Date a batch is produced,

$$ a Batch Number $($for identification, indicates the order the batches are produced$),$

$$ the Product that is produced $($these are all fabric types$),$

$$ the Category type that the fabric material belongs to$,$

$$ the Machine that produced the batch, and

$$ the Employee that operated the machine.

The batch metrics $($measures$)$ include:

$$ the Quantity of shirts produced in the batch, and

$$ Gallons of Water per shirt, and

$$ Gallons of Water per batch.

The water is used to make the fabric that is used for that batch.

How many gallons of water are required to create enough fabric for one $(1)$ t$-$shirt?