The company collects and recycles solid waste across major cities in the country of Brazil. The company operates hundreds of trucks of different types to collect and transport solid waste. The company would like to create a data warehouse so that it can create reports like:
total waste collected per year per city
total waste collected per month per city
total waste collected per quarter per city
total waste collected per year per truck type
total waste collected per truck type per city
total waste collected per truck type per station per city
You will use your data warehousing skills to design and implement a data warehouse for the company.