Waste Company that 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 yeat 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 collectted per trucktype per city
- Total waste collected per trucktype per station per city.
- Design the dimension table MyDimDate
- Design the dimension table MyDimWaste
- Design the dimension table MyDimZone
- Design the fact table MyFactsTrips
- Load data into the dimension table DimDate
- Load data into the dimension table DimTruck
- Load data into the dimension table DimStation
- Write aggrgation queries
- Create MQTs
- Create a Dashboard
- Create a piechart in the dashboard
- Create a bar chart in the dashboard
- Create a line chart in the dashboard
