Learn dbt core using Paradime

Name: Learn dbt core using Paradime
Rating: 4.6 (13 reviews)

Everything you need to get started with Paradime and build reliable dbt models faster, in an hour!

Highest Rated

Created byRahul Prasad

Last updated 3/2023

English

English [Auto],

What you'll learn

Learn how to use Paradime to accelerate Analytics Engineering workloads
Learn hands-on skills required to build a data model using dbt core + Paradime
Create data models that are intuitive, flexible, and optimized for performance using Paradime.
Understand the various functionalities of Paradime, including the home page, editor, Bolt scheduler, and SQL workbench.
Gain practical experience in designing, building, and deploying data transformations using Paradime and dbt through hands-on exercises and real-world examples.

Course content

7 sections • 30 lectures • 1h 51m total length

Introduction1:10
Course Overview1:10
Tips on getting best out of this course1:53
Set your own pace, pause to note questions, and Google concepts as you build problem-solving skills while following along with hands-on exercises and paradigm documentation.
Resources0:03
This zip folder contains csv files that you need to setup to follow hands-on exercises.

Paradime Home Page2:40
Editor - General features3:14
Editor - Terminal & Git functionality3:17
Editor - Doc, Data Explorer & Lineage7:59
Explore the editor features in Paradime, including docs, the data explorer, and the lineage graph, to visualize upstream dependencies, annotate changes, and compare branches for safe dbt development.
Bolt - Scheduler2:52
Explore bolt, Paradigm's scheduler, to manage hourly and daily schedules, inspect failures, view logs, annotate issues, and notify colleagues, then explore the SQL area for data model insights.
SQL Workbench3:39
Explore the SQL workbench in Paradigm to preview data from the fact orders table, run queries, and inspect decompiled and compiled SQL with the jaffle model.

Dimensional Modelling Overview2:09
Build a dimensional model with dbt and Paradigm, connecting data sources to a cloud data lake and staging layer to a dimensional data warehouse.
Setup dbt core project6:44
Build dbt models within a dimensional data warehouse using Paradigm, initialize a repository, configure BigQuery with OAuth, and push changes via git to the project dataset.
Configure dbt connection to BigQuery4:47
Various ways to interact with Git in Paradime1:58
Configure dbt_project.yml5:31
Commit dbt_project.yml4:03
Commit dbt_project.yml changes by creating a feature branch, pushing, and merging to main via a pull request, validating a YAML update that includes staging and warehouse models.
Data Modelling - Create Staging Layer (pt.1)5:32
Data Modelling - Create Staging Layer (pt.2)4:47
Data Modelling - Create Staging Layer (pt.3)3:39
Git stash & pop4:11
Data Modelling - Create Warehouse Layer (pt.1)4:53
Build warehouse layer by creating dim customer, dim date (as a view), and fact purchase order tables, using a source CTE and selecting a unique record from the customer source.
Data Modelling - Create Warehouse Layer (pt.2)2:39
Paradime Data Lineage1:45
Commit code changes to reflect data lineage, view the fact purchase order lineage with source and staging tables, and annotate for team review and Slack collaboration.

Requirements

Basic understanding of SQL
Basic understanding of Analytics Engineering
Some familiarity of terminal

Description

Requirements

Basic understanding of SQL is required
Basic understanding dbt is required
Basic understanding of what Analytics Engineering is required (We suggest taking our Analytics Engineering Bootcamp course on Udemy)

Note

You'll need Paradime trial account to practice hands-on exercises

Description

Are you looking to take your data transformation skills to the next level? If so, you’re in the right place! Our course “Learn dbt-core using Paradime” is designed to help you build strong knowledge in dbt (data build tool) and Paradime, the modern operation system for analytics! Paradime is the new operating system for Analytics and this is the first ever course on Udemy.

In this course, you’ll learn how to leverage dbt-core & Paradime to transform raw data into valuable insights that drive informed business decisions. With hands-on exercises and real-world examples, you’ll gain practical experience in designing, building, and deploying data transformations using dbt and Paradime.

By the end of this course, you’ll have the skills and knowledge you need to:

Set up Paradime from scratch and configure git & data warehouse
Confidently use Paradime & dbt-core to build data pipelines that are scalable, maintainable, and easy to understand
Create data models that are intuitive, flexible, and optimized for performance using Paradime
Collaborate effectively with team members using version control and annotations
Analyze and interpret data to extract valuable insights and drive informed decision-making

Whether you’re a data engineer, data analyst, or data scientist, this course will give you the tools you need to take your data transformation skills to the next level. Start your journey to becoming a dbt and Paradime expert!

By enrolling in this course, you'll get:

Lifetime access to the course and all future updates
Free access to Paradime Platform for 6 months
1.5 hours of high quality, up to date video lectures
Practical dbt+Paradime course with step by step instructions

Who this course is for:

Users with some experience with SQL and Analytics Engineering
BI Analysts
Data Analysts
Analytics Engineers
Data Engineers
Data Scientists

Who this course is for:

Anyone who is interested in becoming an Analytics Engineer
Anyone who is interested in learning Paradime

Learn dbt core using Paradime

What you'll learn

Explore related topics

Course content

Introduction & Course Overview4 lectures • 4min

Paradime Overview1 lecture • 3min

dbt Overview1 lecture • 5min

Paradime UI & Functionality Walkthrough6 lectures • 24min

Hands-on (Setup & Connect Project)4 lectures • 23min

Hands-on (Build Dimensional Model using Paradime + dbt)13 lectures • 53min

Wrap up1 lecture • 1min

Requirements

Description

Who this course is for: