lab In this lab you will use real-world examples to demonstrate the skills you have practiced in other hands-on labs. You will design, create, populate and query a Data Warehouse. Skills Network Labs (SN Labs) is a virtual lab environment used in this course. Upon clicking the "Open Tool" button below, your Username and Email will be passed to SN Labs and will be used in strict accordance with IBM Skills Network Privacy policy, such as for communicating important information to enhance your learning experience. Your grade will be based on the following tasks: Task 1: Design the dimension table MyDimDate (2 pts) Task 2: Design the dimension table MyDimWaste (1 pt) Task 3: Design the dimension table MyDimZone (1 pt) Task 4: Design the fact table MyFactTrips (2 pts) Task 5: Create the dimension table MyDimDate (2 pts) Task 6: Create the dimension table MyDimWaste (1 pt) Task 7: Create the dimension table MyDimZone (1 pt) Task 8: Create the fact table MyFactTrips (2 pts) Task 9: Load data into the dimension table DimDate (1 pt) Task 10: Load data into the dimension table DimTruck (1 pt) Task 11: Load data into the dimension table DimStation (1 pt) Task 12: Load data into the fact table FactTrips (1 pt) Task 13: Create a grouping sets query (2 pts) Task 14: Create a rollup query (2 pts) Task 15: Create a cube query using the columns year, city, station, average waste collected (2 pts) Task 16: Create an MQT named max_waste_per_station using the columns city, station, trucktype, max waste collected (2 pts) Task 17: Create a pie chart in the dashboard (1 pt) Task 18: Create a bar chart in the dashboard (1 pt) Task 19: Create a line chart in the dashboard 19-line.jpg (1 pt) Task 20: Create a pie chart in the dashboard (1 pt)