Category: SQL
-
Gold layer
Now we finally are in the final stage of our ELT process, in this layer we will see the fables that our dashboards will consume, this layer have tables group fields, dimension tables fact tables. We consume the data from the silver layer that is clean, we have one dashboard and one tab for each…
-
Silver model part II
We was analyzing our tables in bronze layer to clean in silver layer, we saw that we have some problem with the tables staff and staff_schedule because we have different id_staff from staff schedule and staff table, also we have people that exits in staff_schedule and didn’t exist in staff table, in other hand the…
-
Silver model part I
We will continue our example, we will analyze the data of the files , clean and transform the data from bronze schema. we will analyze the tables staff, staff_schedule and services_weekly. staff we will select the role unique values from staff table : we will select the service unique values from staff table : staff_schedule…