Nadia Selas Noversega – Medium

Nadia Selas Noversega

Nadia Selas Noversega

dbt Application — Command Loops and Executing Shell Script

Many data modeling tasks often require executing models that can’t inherently accommodate date range parameters. In such scenarios, we…

Apr 2

dbt Application — Command Loops and Executing Shell Script

Apr 2

Nadia Selas Noversega

Exploring BigQuery: UDF (User-defined Function)

If you’ve ever felt bogged down by rewriting the same functions repeatedly, then this article is just what you need! BigQuery’s…

Feb 13

Exploring BigQuery: UDF (User-defined Function)

Feb 13

Nadia Selas Noversega

SQL Application — Dynamic Pivot Using Execute Immediate & dbt

When working with data analysis, many times you need to pivot data to gain valuable insights and present information in a more structured…

Jan 25

SQL Application — Dynamic Pivot Using Execute Immediate & dbt

Jan 25

Nadia Selas Noversega

Automation — Automated Jira Ticket Based on BigQuery Result

In the world of handling data, we data folks have a mission: to make our tasks easier by automating things. Whether it’s putting together…

Jan 23

Automation — Automated Jira Ticket Based on BigQuery Result

Jan 23

Nadia Selas Noversega

SQL 101 — Mastering Data Filtering: WHERE, HAVING, and QUALIFY Clause

As a BI analyst, I have spent countless hours working with SQL to extract meaningful insights from large datasets. During my journey, I…

Feb 1, 2023

SQL 101 — Mastering Data Filtering: WHERE, HAVING, and QUALIFY Clause

Feb 1, 2023

Nadia Selas Noversega

SQL Application: Cohort Analysis

Cohort analysis is one of the most frequent performed analysis, especially if you are working in a B2C company. So, what is cohort…

Aug 24, 2022

SQL Application: Cohort Analysis

Aug 24, 2022

Nadia Selas Noversega

Exploring BigQuery: Scheduled Query

If you ever need to run a query on a recurring basis, then this article is for you! BigQuery has a Scheduled Query feature that will…

Jun 29, 2022

Exploring BigQuery: Scheduled Query

Jun 29, 2022

Nadia Selas Noversega

SQL 101 — CTE (Common Table Expression)

Have you found yourself in a situation where you needed several steps to process data until you get desired results, but creating a bunch…

Jun 15, 2022

SQL 101 — CTE (Common Table Expression)

Jun 15, 2022

Nadia Selas Noversega

SQL 101 — Window Function

Many of us are using group by to get aggregated values (i.e: max, min, count, sum, etc). This will return with only one value. In many…

Mar 6, 2022

SQL 101 — Window Function

Mar 6, 2022

Nadia Selas Noversega

SQL 101 — Choose Your Join Wisely

The first thing we need to master in SQL is join statement as it can make our life so much easier and make our query efficient if we are…

Dec 30, 2021

SQL 101 — Choose Your Join Wisely

Dec 30, 2021

Nadia Selas Noversega

Nadia Selas Noversega

Swimming in the sea of data 🏊 — Sharing my data journey. Visit my profile https://www.linkedin.com/in/nadselnov/

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams