Headless BI-Tool in SQL & BigQuery
Justin Plagis
Providing Data Clarity cross internal & external Team
Essentially building an ETL protocol using Stitch data, BigQuery as DWH to pull our data from our backend (Mongo, Firebase) and unify metrics cross the organization. From here, we segmented & scrubed the data based on a strict transformation system in SQL to ensure we had metric consistency cross all departs, segmented this into seperate data-sets and built two inlooks into our data. One for Operational Teams, one for Finance Team & Investors.
Key parts of the project:
Unifying data using ETL cross Mongo & Firebase
Building multiple transformation layers in BigQuery to compute relevant metrics
Push data to relevant visualization/export tools (Looker / Metabase/CSV export)
Built dashboards to visualize data in each respective tool
Company: Packaly.com | Sustainable logistics provider
Skills used
BigQuery, Data Architecture, Data Management, Data Pipelines, Data Visualization, ETL, Looker, Mobile Analytics, MongoDB, Analytics, Google Cloud / GCP, SQL
Like this project
Posted Jan 28, 2025
Providing Data Clarity cross internal & external Team
Likes
0
Views
5
Clients
Packaly
