The company collects and recycles solid waste across major cities in the country of Brazil. the company would like to create a data warehouse so that it can create reports like
total waste collected per trucktype per station
total waste collected per station per city
total average waste collected per station per city