Alex Abalo
LightNews LightNews
dataworld.bsky.social
Alex Abalo
@dataworld.bsky.social
15 followers 8 following 23 posts
Exploring the world of data, SQL, BI tools, and analytics. 📊 Working with #DBT, #GCP, #Fivetran, #Python. Empower data-driven decisions! My LI account Lwww.linkedin.com/in/alexandro-abalo-garcía-1bb627a7
Posts Replies Media Videos
dataworld.bsky.social
Can anyone figure out what the window function in this query does? What do you think? 🤔 #SQL #DataBS
December 9, 2024 at 12:36 PM
dataworld.bsky.social
Simplify ROW_NUMBER() usage with QUALIFY.
You can do it in one step instead of using a CTE and filtering. Less code, same result. #BigQuery #DataBS #DataAnalysis
November 29, 2024 at 8:15 AM
dataworld.bsky.social
Want to reuse the same OVER clause across multiple fields in #BigQuery? Define the WINDOW once at the end of your query! Example #DataBS #SQL
November 28, 2024 at 2:37 PM
dataworld.bsky.social
Do you know which #attribution model this query corresponds to? #DataBS #Data #Analytics
November 25, 2024 at 8:31 AM
dataworld.bsky.social
Understanding RANK() vs DENSE_RANK() in BigQuery:
Example: Scores in descending order
🔑 RANK() skips numbers after ties, while DENSE_RANK() doesn't. Use wisely! #SQL #BigQuery #Data
November 20, 2024 at 10:38 AM
dataworld.bsky.social
Really important to keep this in mind every time we run a simple query.
1. FROM + JOIN
2. WHERE
3. GROUP BY
4. HAVING
5. SELECT
6. ORDER BY
7. LIMIT
#SQL #Data
November 18, 2024 at 10:47 AM
dataworld.bsky.social
A simple use case of #Jinja code
#jinja
November 18, 2024 at 10:22 AM