Category: Data Analysis
-
How to Create Metabase Dashboards Using dbt Gold-Layer Tables and the dbt analyses Folder
This is the final step of our dbt project: displaying our data in a dashboard so that managers and directors can use it to make informed decisions. This dashboard contains four reports, and we will show how to create each one in Metabase: First, we need to connect Metabase to the database used in our…
-
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…