Introduction to Analytics Engineering

57mBeginner2023-06-13

Authors

Amataverna Lee

Data Engineer

Course details

Analytics engineering is a relatively new role in the field of data. If you are looking to begin a career as an analytics engineer or hire for an analytics engineering position in your company, this course can give you the information you need to get started. Instructor and analytics engineer Amataverna Lee guides you through what analytics engineering is, why it matters, and which roles can transition most easily into analytics engineering. She explains data modeling, cloud data warehouses, data pipeline tools, and business intelligence tools. Amataverna goes over several software engineering best practices. Plus, she shows you how documentation and communication are important in analytics engineering roles.

Skills covered

Data EngineeringData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOne-Off

Concepts

0. Introduction

01 - What is analytics engineering
02 - Prerequisites for the course

1. Why Analytics Engineering

03 - How the field of data has changed in the last couple of years
04 - How did analytics engineering come to be
05 - Where do analytics engineers come from
06 - What skills are needed for analytics engineering

2. Data Modeling

07 - What is data modeling
08 - Cloud data warehouses - Snowflake
09 - Data pipeline tools - DBT
10 - Business intelligence (BI) tools - Looker
11 - Challenge - Build a simple data model
12 - Solution - Build a simple data model

3. Software Engineering Best Practices

13 - Using Git
14 - Version control and testing
15 - Challenge - Add a pull request
16 - Solution - Add a pull request

4. Documentation and Communication

17 - Writing documentation
18 - Communicating with the business team
19 - Challenge - Writing documentation
20 - Solution - Writing documentation

Conclusion

21 - Wrap up and consider the analytics engineer role