Projects

dbt sample project

I created this sample project on GitHub using a public dataset in BigQuery (Google Analytics session data) and dbt. This is meant to illustrate basic knowledge in dbt, but in my day-to-day I have created a much more robust dbt project utilizing features like snapshots, third party packages, more macros, and more complex lineage.

Skills showcased:

🖥️ SQL

🤝 dbt familiarity

🔢 Tool setup w/ BigQuery (service account management)

🧠 Macros & code reusability w/ Jinja and dbt packages
💪🏻 Custom configurations

🧹 Data modeling & transformation

Visit the sample project on GitHub.

SQL & Python sample snippets

A few sample projects to showcase advanced SQL and Python skills

Skills showcased:

🖥️ advanced SQL & Python

🛠️ Data notebooks

🤓 Git/GitHub

📈 Basic data viz

Code:

Intermediate SQL snippets (grouping, calculating min/max, counts, math) Project
Advanced SQL snippets (windows functions, de-duping, cleaning, calculating distance) and some dbt examples Project
Retrieving data from API w/ Python. Project
Analysis of 211 data in Pittsburgh with Python Project
Fivetran usage explorer (this actually is not functional but an example of an automated report I built at a previous job) Notebook
Exploring UFO sightings data set Notebook
Scraping web data with Python Notebook