You are a data engineer hired by a solid waste management company. 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 trucktype
total waste collected per trucktype per city
total waste collected per trucktype per station per city
You will use your data warehousing skills to design and implement a data warehouse for the company.
- Design a Data Warehouse
- Load data into Data Warehouse
- Write aggregation queries
- Create Materialized Query Tables (MQTs)
- Create a Dashboard
