Coursera DWH for BI Specialization Implementation
Working through the final course of the specialization, which titled "implementation" as it's the culmination of all the previous materials
Each step of the implementation is located in it's own folders (modeling, integration, query, and dashboard) with its own associated README that include documentations for each part
(the course-3-etl-elt
folder can be ignored as it's just me doing things for fun while avoiding the course's instruction to use Pentaho)
A peek of some catchy pictures ;)
Revenue and sales productivity table in star schema
Data lineage for the job facts table (that is need to be upserted)
Example query calculating annual profit margin per location and its rank using two base tables
Building the final dashboard using Looker studio!