Technologies: SQL (IBM Db2), BI (IBM Cognos Analytics w/ Watson)
Normalized waste management dataset and loaded into IBM DB2 database. Created a data module in IBM Cognos Analytics to connect to data warehouse and built simple dashboard highlighting key data and metrics.
Project Files:
- initial-waste-management-data.csv - Sample of starting data set.
- DimDate.csv - date dimension CSV data.
- DimStation.csv - station dimension CSV data.
- DimTruck.csv - truck dimension CSV data.
- FactTrips.csv - fact CSV data surrounding waste collected in tons and related primary/foreign key IDs.
- dim-and-facts-table-create.sql - SQL to create the dimension & fact tables.
- max_waste_stats-mqt.sql - SQL to create MQT in Db2 for max waste stats by city, stationid, and truck type.
- debug-db2-reason-code-1.sql - SQL statements used to diagnose issue with error "reason code 1" from trying to query certain tables.
Sample of initial data:
Loading the CSVs into IBM DB2:
Creating connection between DB2 data warehouse and Cognos Analytics:
Dashboarding:
