Nadia Selas Noversegadbt Application — Command Loops and Executing Shell ScriptMany data modeling tasks often require executing models that can’t inherently accommodate date range parameters. In such scenarios, we…3 min read·Apr 2, 2024----
Nadia Selas NoversegaExploring 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…5 min read·Feb 13, 2024----
Nadia Selas NoversegaSQL Application — Dynamic Pivot Using Execute Immediate & dbtWhen working with data analysis, many times you need to pivot data to gain valuable insights and present information in a more structured…3 min read·Jan 25, 2024----
Nadia Selas NoversegaAutomation — Automated Jira Ticket Based on BigQuery ResultIn the world of handling data, we data folks have a mission: to make our tasks easier by automating things. Whether it’s putting together…4 min read·Jan 23, 2024----
Nadia Selas NoversegaSQL 101 — Mastering Data Filtering: WHERE, HAVING, and QUALIFY ClauseAs a BI analyst, I have spent countless hours working with SQL to extract meaningful insights from large datasets. During my journey, I…4 min read·Feb 1, 2023----
Nadia Selas NoversegaSQL Application: Cohort AnalysisCohort analysis is one of the most frequent performed analysis, especially if you are working in a B2C company. So, what is cohort…5 min read·Aug 24, 2022--1--1
Nadia Selas NoversegaExploring BigQuery: Scheduled QueryIf 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…3 min read·Jun 29, 2022----
Nadia Selas NoversegaSQL 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…3 min read·Jun 15, 2022--3--3
Nadia Selas NoversegaSQL 101 — Window FunctionMany 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…4 min read·Mar 6, 2022--1--1
Nadia Selas NoversegaSQL 101 — Choose Your Join WiselyThe 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…7 min read·Dec 30, 2021----