DataCapt

Cohort 1

Cohort Feb2025

Free webinar on Dec 6th, 6pm-7pm ET.We will discuss how to break into Analytics Engineering with Daniel Gonzalez - Analytics Engineer at Sweetwater. For more info and to register for the Webinar: https://www.touchdowncoaching.com/events

Free webinar on December 6th, 2024

Analytics Engineering is a dynamic blend of Data Engineering and Data Analytics, serving as the bridge between these two domains. Analytics Engineers develop and maintain a good portion of the data lifecycle, from the ingestion of Data Sources, to the development of Data Warehouses and the corresponding data pipelines, to Business Intelligence tools. Whether you are a Data Analyst/Scientist that would like to practice on modern Data Engineering tools, or an aspiring Analytics Engineer, this workshop is for you. You will learn how to:● Start and develop a modern Data Warehouse, using Snowflake.● Ingest data, on a schedule, from multiple sources, using connectors in Fivetran.● Clean and transform data, and the basics of ELT (Extract, Load, Transform), using DBT and SQL.● Spin up and connect a Business Intelligence tool (Preset) to a Data Warehouse.

Analytics Engineering is the foundation of Data Science and AI

Course syllabus

<ul><li>Monday: introduction to the Modern Data Stack</li><li>Tuesday: Snowflake and Fivetran</li><li>Thursday: dbt and Github</li></ul> Live sessions will be recorded.

Week 1 - Mon, Tues, Thu

<ul><li>Monday: transforming data with DBT and SQL</li><li>Wednesday: dashboarding in Preset</li></ul> Live sessions will be recorded.

Week 2 - Mon, Wed

Follow the course by implementing your own Data Stack!

Course project

Course schedule

A Data Analyst or Data Scientist looking to sharpen their Data Engineering skills using modern data tools.

A recent graduate looking to land their first Analytics Engineering role with practical skills that are highly marketable.

A professional trying to pivot into a Data role and curious about what Analytics Engineering is about.

Who is this course for

Key outcomes

Build an end-to-end data engineering product, from raw data to data visualization.

Start and develop a modern Data Warehouse, using Snowflake.

Ingest data, on a schedule, from multiple sources, using connectors in Fivetran.

Clean and transform data using DBT and the universal data language of SQL.

Spin up and connect a Business Intelligence tool (Preset) to a Data Warehouse.

Add this hands-on project to your portfolio, showcasing new marketable skills.

🔥 Code OFF250 for $250 discount (4 redemptions left)🔥 The course: spin up a modern Data Stack using Snowflake, Fivetran, dbt / SQL, Preset

Learn directly from DataCapt

DataCapt

Courses

Analytics Engineering for Data Professionals

Resources

Free webinar on December 6th, 2024