This course provides a foundational understanding of analytics engineering, focusing on building end-to-end data solutions. It teaches essential skills for designing, implementing, and optimizing analytics systems, from data ingestion to visualization. The course will enhance your ability to apply best practices in data modeling, cloud analytics, and collaborative workflows, all while building scalable and reliable data platforms. With the guidance of industry experts, learners will gain the knowledge to transition from data analysis to analytics engineering.
Fundamentals of Analytics Engineering
您将学到什么
Design and implement data pipelines from ingestion to serving data
Apply best practices for data modeling and schema design
Scale data processing using cloud-based analytics platforms
要了解的详细信息
可分享的证书
添加到您的领英档案
最近已更新！
March 2026
作业
14 项作业
授课语言：英语（English）
了解顶级公司的员工如何掌握热门技能
该课程共有14个模块
In this section, we explore the role of analytics engineers in modern data strategies, comparing ETL and ELT workflows and clarifying their distinct responsibilities from data analysts and engineers.
涵盖的内容
2个视频1篇阅读材料1个作业
2个视频• 总计2分钟
- Courser Overview• 1分钟
- What Is Analytics Engineering - Overview Video• 1分钟
1篇阅读材料• 总计20分钟
- Introduction• 20分钟
1个作业• 总计10分钟
- Introduction to Analytics Engineering• 10分钟
In this section, we explore the Modern Data Stack (MDS), its key differentiators from legacy systems, and its advantages and limitations for data management.
涵盖的内容
1个视频2篇阅读材料1个作业
1个视频• 总计1分钟
- The Modern Data Stack - Overview Video• 1分钟
2篇阅读材料• 总计30分钟
- Introduction• 10分钟
- Explaining Three Key Differentiators Versus Legacy Stacks• 20分钟
1个作业• 总计10分钟
- Exploring the Modern Data Stack• 10分钟
In this section, we will learn about data ingestion pipelines, including eight essential steps and scalable solutions.
涵盖的内容
1个视频7篇阅读材料1个作业
1个视频• 总计1分钟
- Data Ingestion - Overview Video• 1分钟
7篇阅读材料• 总计55分钟
- Introduction• 10分钟
- Understanding the Eight Essential Steps of a Data Ingestion Pipeline• 10分钟
- Trigger• 10分钟
- State Management• 5分钟
- Transformations• 10分钟
- Loading• 5分钟
- Working with Data Ingestion An Example Pipeline• 5分钟
1个作业• 总计10分钟
- Data Ingestion Fundamentals• 10分钟
In this section, we examine the evolution of data warehousing, cloud migration, and key components of cloud data warehouses, focusing on practical applications and market leaders.
涵盖的内容
1个视频10篇阅读材料1个作业
1个视频• 总计1分钟
- Data Warehousing - Overview Video• 1分钟
10篇阅读材料• 总计100分钟
- Introduction• 10分钟
- The 1980s Relational and Object-Oriented Databases• 10分钟
- Moving to the Cloud• 10分钟
- Data Scientists• 10分钟
- Building Blocks of a Cloud Data Warehouse• 10分钟
- The UI• 10分钟
- Pricing• 10分钟
- Knowing the Market Leaders in Cloud Data Warehousing• 10分钟
- Databricks• 10分钟
- GlobalTech Catering to Complexity and Scalability• 10分钟
1个作业• 总计10分钟
- Data Warehouse Fundamentals and Evolution• 10分钟
In this section, we examine data modeling techniques, focusing on normalization, dimensional modeling, and data vault approaches to ensure data integrity, scalability, and efficient system design.
涵盖的内容
1个视频10篇阅读材料1个作业
1个视频• 总计1分钟
- Data Modeling - Overview Video• 1分钟
10篇阅读材料• 总计100分钟
- Introduction• 10分钟
- Stability and Flexibility• 10分钟
- Designing Your Data Model• 10分钟
- Data Modeling Techniques• 10分钟
- First Normal Form and Repeating Groups• 10分钟
- Verifying Table Normalization and Identifying Redundancies• 10分钟
- Finding the Grain• 10分钟
- The Star Schema• 10分钟
- Hubs• 10分钟
- Comparison of the Different Data Models• 10分钟
1个作业• 总计10分钟
- Data Modeling Fundamentals• 10分钟
In this section, we explore data transformation techniques, scalable data modeling, and best practices to enhance data usability and support analytics.
涵盖的内容
1个视频6篇阅读材料1个作业
1个视频• 总计1分钟
- Transforming Data - Overview Video• 1分钟
6篇阅读材料• 总计70分钟
- Introduction• 10分钟
- Design Choices• 10分钟
- Integrate• 10分钟
- Data Transformation Best Practices• 10分钟
- Within the Same Query• 20分钟
- Tools That Facilitate Data Transformations• 10分钟
1个作业• 总计10分钟
- Data Transformation Fundamentals• 10分钟
In this section, we explore how data becomes useful through dashboarding, BI tools, and data products, emphasizing accessibility, trust, and actionable insights for effective decision-making.
涵盖的内容
1个视频5篇阅读材料1个作业
1个视频• 总计1分钟
- Serving Data - Overview Video• 1分钟
5篇阅读材料• 总计60分钟
- Introduction• 20分钟
- Programming Environments• 10分钟
- Serving Data Four Key Topics• 10分钟
- Interactive and Static Reports• 10分钟
- A Real-World Example of Actionable Metrics• 10分钟
1个作业• 总计10分钟
- Data Product and Data Serving Fundamentals• 10分钟
In this section, we explore practical analytics engineering by implementing ELT workflows with Airbyte Cloud, modeling data using dbt Cloud, and visualizing insights with Tableau to solve real-world business problems.
涵盖的内容
1个视频9篇阅读材料1个作业
1个视频• 总计1分钟
- Hands-On Analytics Engineering - Overview Video• 1分钟
9篇阅读材料• 总计140分钟
- Introduction• 10分钟
- Looking at the Data• 20分钟
- What About BI Tools• 10分钟
- Preparing Google Cloud• 10分钟
- Modeling Data Using dbt Cloud• 10分钟
- Dbt Project Structure• 20分钟
- Materializing Models• 20分钟
- Naming Convention• 10分钟
- Visualizing Data with Tableau• 30分钟
1个作业• 总计10分钟
- Data Platform Fundamentals• 10分钟
In this section, we explore data quality challenges in source systems, pipelines, and governance, and introduce observability, data catalogs, and semantic layers as solutions to ensure reliable and consistent data.
涵盖的内容
1个视频8篇阅读材料1个作业
1个视频• 总计1分钟
- Data Quality and Observability - Overview Video• 1分钟
8篇阅读材料• 总计90分钟
- Introduction• 10分钟
- Completeness• 10分钟
- Relevance• 10分钟
- Completeness• 10分钟
- Documentation• 10分钟
- Metadata Management• 10分钟
- Data Lineage• 20分钟
- The Benefits of Data Catalogs for Data Quality• 10分钟
1个作业• 总计10分钟
- Data Quality and Observability Fundamentals• 10分钟
In this section, we explore version control, coding standards, and code reviews to enhance team collaboration and ensure code quality and maintainability in shared environments.
涵盖的内容
1个视频12篇阅读材料1个作业
1个视频• 总计1分钟
- Writing Code in a Team - Overview Video• 1分钟
12篇阅读材料• 总计135分钟
- Introduction• 10分钟
- Tracking Tasks and Issues• 10分钟
- Categorization and Tagging• 10分钟
- Managing Versions with Version Control• 10分钟
- Development Workflow for Analytics Engineers• 10分钟
- Working with Coding Standards• 10分钟
- ANSI• 10分钟
- Pre-commit Hooks• 10分钟
- Continuous Integration/Continuous Deployment• 20分钟
- Code Comments• 10分钟
- Working with Containers• 20分钟
- Refactoring and Technical Debt• 5分钟
1个作业• 总计10分钟
- Team-Based Software Development Fundamentals• 10分钟
In this section, we will learn about data orchestration, CI/CD pipelines, and their implementation in dbt Cloud.
涵盖的内容
12篇阅读材料1个作业
12篇阅读材料• 总计145分钟
- Introduction• 10分钟
- Airflow• 20分钟
- Continuous Integration• 10分钟
- Pre-commit Hooks• 10分钟
- Code Formatting• 10分钟
- Separate Schema• 5分钟
- Pipeline Stages, Jobs, and Steps• 30分钟
- Linting• 10分钟
- Continuous Deployment• 10分钟
- State Deferral• 10分钟
- Configuring CI/CD in dbt Cloud• 10分钟
- Continuous Delivery• 10分钟
1个作业• 总计10分钟
- Pipeline Development and Management Fundamentals• 10分钟
In this section, we explore translating business needs into analytics, scoping use cases with stakeholders, and ensuring adoption through incremental delivery and communication.
涵盖的内容
2篇阅读材料1个作业
2篇阅读材料• 总计60分钟
- Introduction• 30分钟
- Ensuring Business Adoption• 30分钟
1个作业• 总计10分钟
- Business Requirements in Analytics Projects• 10分钟
In this section, we will learn about data governance, ownership, quality, and its role in data management.
涵盖的内容
4篇阅读材料1个作业
4篇阅读材料• 总计50分钟
- Introduction• 10分钟
- Applying Data Governance in Analytics Engineering• 10分钟
- Data Quality and Integrity• 10分钟
- Data Definitions• 20分钟
1个作业• 总计10分钟
- Foundations of Data Governance• 10分钟
In this section, we review core analytics insights and explore strategies for career growth, emphasizing continuous learning, networking, and portfolio development for long-term success.
涵盖的内容
1篇阅读材料1个作业
1篇阅读材料• 总计20分钟
- Introduction• 20分钟
1个作业• 总计10分钟
- Understanding Data Governance and Career Growth in Analytics• 10分钟
位教师
提供方
提供方
Packt
Packt helps tech professionals put software to work by distilling and sharing the working knowledge of their peers. Packt is an established global technical learning content provider, founded in Birmingham, UK, with over twenty years of experience delivering premium, rich content from groundbreaking authors on a wide range of emerging and popular technologies.
人们为什么选择 Coursera 来帮助自己实现职业发展
Felipe M.
自 2018开始学习的学生
''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情，我就可以学习。'
Jennifer J.
自 2020开始学习的学生
''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'
Larry W.
自 2021开始学习的学生
''如果我的大学不提供我需要的主题课程，Coursera 便是最好的去处之一。'
Chaitanya A.
''学习不仅仅是在工作中做的更好：它远不止于此。Coursera 让我无限制地学习。'
常见问题
Yes, you can preview the first video and view the syllabus before you enroll. You must purchase the course to access content not included in the preview.
If you decide to enroll in the course before the session start date, you will have access to all of the lecture videos and readings for the course. You’ll be able to submit assignments once the session starts.
Once you enroll and your session begins, you will have access to all videos and other resources, including reading items and the course discussion forum. You’ll be able to view and submit practice assessments, and complete required graded assignments to earn a grade and a Course Certificate.
If you complete the course successfully, your electronic Course Certificate will be added to your Accomplishments page - from there, you can print your Course Certificate or add it to your LinkedIn profile.
This course is currently available only to learners who have paid or received financial aid, when available.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
更多问题
提供助学金，