#analyticalengineering — Public Fediverse posts

Just finished Analytics Engineering with dbt in @DataTalksClub's free course – a deep dive into building data pipelines for analytics. 🚀

Key learnings:
✅️ Built transformation models with dbt from raw CSV/Parquet files in Google Cloud Storage
✅️ Designed dimensional data warehouse schema (staging, intermediate tables) implemented in BigQuery
✅️ Implemented comprehensive data quality checks using dbt tests to ensure reliable analytics
✅️ Mapped dependencies & lineage with dbt visualization tools for optimized performance
✅️ Analyzed NYC taxi revenue patterns across zones using SQL window functions

Really enjoying transforming raw data into actionable insights! Check out my project:
https://github.com/ammartin8/data_engineering_zoom_camp/blob/main/modules/module_4/project_04/README.md

#dataengineering #dbt #analyticalengineering #analytics #datanalytics #datawarehousing #fedihire #ai #tech #linux #data #dev #sql #code #mastodon #learning