|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/analytics-engineering-bootcamp/
课程评论：没有评论
**课程名称：** 分析工程师训练营 (Analytics Engineering Bootcamp) **课程概述：** 本课程是成为一名优秀的分析工程师的必备指南。通过生动有趣的讲座，您将学习成为分析工程师所需的一切知识，并深入了解各种工具、技术和建模概念。您将学习如何使用 dbt (Data build tool) 和 BigQuery 设计和实现数据仓库解决方案。课程包含基于场景的测验题，以巩固关键学习目标。 **课程结束时，您将掌握：** * 数据库与数据仓库的区别 * OLTP 与 OLAP 系统的概念 * 范式化与反范式化方法 * 数据建模方法论（Inmon, Kimball, Data Vault & OBT） * ETL 与 ELT 的区别 * 数据建模技术（尤其是在 dbt 中的应用） * 构建维度数据仓库的实践经验 **近期更新：** * 2023年3月：更新了术语表并增加了内容 * 2024年3月：新增 dbt 高级用户加速开发讲座（包括 Data Pilot、生成式 AI 驱动的工作流程助手的使用） **课程适合人群：** * 希望成为分析工程师或提升现有技能的数据分析师、BI分析师或数据仓库开发人员。 * 希望复习 OLTP 和 OLAP 系统相关概念和术语的数据专业人士。 * 希望获得分析工程师职位的学生或近期毕业生。 * 对分析工程师职业道路感兴趣的任何人。
Welcome to the Analytics Engineering Bootcamp course. the only course you need to become an amazing Analytics Engineer.This complete Analytics Engineering Bootcamp will take you step-by-step through engaging and fun lectures and teach you everything you need to know on how to succeed as an Analytics Engineer. Throughout this course you'll get an in depth insight into all the various tools, technologies and modelling concepts.Students will learn how to design and implement a Data Warehouse solution using DBT (Data build tool) & BigQuery.Each section contains scenario based quiz questions that help solidify key learning objectives for each concept & theory..By the end of the course, you'll learn and get really good understanding of:Differences between database and a data warehouseConcepts between OLTP & OLAP systemsNormalisation & De-Normalisation methodsData Modelling methodologies such as (Inmon, Kimball, Data Vault & OBT)Difference between ETL & ELTData modelling techniques especially using dbtHands-on experience building dimensional data warehouseRECENT UPDATES:Mar2023 - Updated Glossary and added more contentsMar2024 - New: dbt Power User accelerated development lectures (Including usage of Data Pilot, Generative AI driven workflow assistant)Who this course is for:Data Analyst, BI Analysts or Data Warehouse developers who are looking to become Analytics Engineers or looking to improve existing skillsFor data professionals who wants to get a refresher on all the concepts and terms surrounding OLTP & OLAP systemsStudents or recent graduates who are looking to get a job as an Analytics EngineerAnyone who is interested in Analytics Engineer Career Path
