pregismond / introduction-to-data-warehousing

Final Assignment Submission: Introduction to Data Warehousing

Introduction to Data Warehousing

Disclaimer

This repository contains my submission for the Final Assignment: Introduction to Data Warehousing. The original files were provided by the IBM Skills Network as part of the Data Warehouse Fundamentals course on Coursera. I have made modifications to fulfill the project requirements.

Usage

• You are welcome to use this repository as a reference or starting point for your own project.

• If you choose to fork this repository, please ensure that you comply with the terms of the Apache License and give proper credit to the original authors.

Project Scenario

As a data engineer working for a solid waste management company in Brazil, I have been tasked with designing and implementing a data warehouse, as well as creating visualizations using various charts in Cognos Analytics. Our company collects and recycles solid waste across major cities in Brazil, operating hundreds of trucks of different types for waste collection and transportation.

Objectives

• Design a Data Warehouse
• Load data into Data Warehouse
• Write aggregation queries
• Create MQTs
• Create a Dashboard

Directions

1. Design the dimension table MyDimDate
2. Design the dimension table MyDimWaste
3. Design the dimension table MyDimZone
4. Design the fact table MyFactTrips
5. Create the dimension table MyDimDate
6. Create the dimension table MyDimWaste
7. Create the dimension table MyDimZone
8. Create the fact table MyFactTrips
9. Load data into the dimension table DimDate
10. Load data into the dimension table DimTruck
11. Load data into the dimension table DimStation
12. Load data into the fact table FactTrips
13. Create a grouping sets query using the columns stationid, trucktype, and total waste collected
14. Create a rollup query using the columns year, city, stationid, and total waste collected
15. Create a cube query using the columns year, city, stationid, and average waste collected
16. Create a materialized view named max_waste_per_station using the columns city, stationid, trucktype, and max waste collected
17. Create a pie chart in the dashboard that shows the waste collected by truck type
18. Create a bar chart in the dashboard that shows the waste collected station wise
19. Create a line chart in the dashboard that shows the waste collected by month wise
20. Create a pie chart in the dashboard that shows the waste collected by city

Setup

Begin the Final Assignment: Introduction to Data Warehousing.

Learner

Pravin Regismond

Acknowledgments

• IBM Skills Network © IBM Corporation 2021. All rights reserved.