Alex Abalo
@dataworld.bsky.social
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
Great walkthrough on building a robust data quality score using dbt + Elementary Data. Clear, actionable, and perfect for modern data teams. medium.com/@alexandroab... #DataEngineering #AnalyticsEngineering #dbt #DataQuality #Data
How to build a Data Quality Score with DBT + Elementary Data
A practical approach to quantify and visualize data reliability
medium.com
November 17, 2025 at 8:09 AM
Great walkthrough on building a robust data quality score using dbt + Elementary Data. Clear, actionable, and perfect for modern data teams. medium.com/@alexandroab... #DataEngineering #AnalyticsEngineering #dbt #DataQuality #Data
About Quality and Data Testing medium.com/p/382581ae9a55
Unlocking Business Success: The Power of Data Quality and Testing
If you want to read the article in Spanish, click here
medium.com
July 20, 2025 at 4:35 PM
About Quality and Data Testing medium.com/p/382581ae9a55
Semantic layer open.substack.com/pub/alexabal...
Semantic Layer
Qué es y cómo implementarla con DBT
open.substack.com
March 7, 2025 at 10:23 AM
Semantic layer open.substack.com/pub/alexabal...
Self-service analytics
open.substack.com/pub/alexabal...
open.substack.com/pub/alexabal...
Self-service analytics
El camino hacia una empresa data-driven
open.substack.com
February 25, 2025 at 1:00 PM
Self-service analytics
open.substack.com/pub/alexabal...
open.substack.com/pub/alexabal...
Reposted by Alex Abalo
𝟏/𝟖 🚨 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫𝐢𝐧𝐠 𝐯𝐬. 𝐃𝐚𝐭𝐚 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫𝐢𝐧𝐠: 𝐓𝐡𝐞 𝐆𝐫𝐞𝐚𝐭 𝐁𝐥𝐮𝐫 𝐢𝐬 𝐇𝐄𝐑𝐄.
With tools like #dbt redefining workflows, where do these roles start to merge? Let’s unpack it. 🔍
(Hint: SQL is the new battleground.) ⚔️
#DataEngineering #AnalyticsEngineering #ModernDataStack
With tools like #dbt redefining workflows, where do these roles start to merge? Let’s unpack it. 🔍
(Hint: SQL is the new battleground.) ⚔️
#DataEngineering #AnalyticsEngineering #ModernDataStack
February 22, 2025 at 5:28 PM
𝟏/𝟖 🚨 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫𝐢𝐧𝐠 𝐯𝐬. 𝐃𝐚𝐭𝐚 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫𝐢𝐧𝐠: 𝐓𝐡𝐞 𝐆𝐫𝐞𝐚𝐭 𝐁𝐥𝐮𝐫 𝐢𝐬 𝐇𝐄𝐑𝐄.
With tools like #dbt redefining workflows, where do these roles start to merge? Let’s unpack it. 🔍
(Hint: SQL is the new battleground.) ⚔️
#DataEngineering #AnalyticsEngineering #ModernDataStack
With tools like #dbt redefining workflows, where do these roles start to merge? Let’s unpack it. 🔍
(Hint: SQL is the new battleground.) ⚔️
#DataEngineering #AnalyticsEngineering #ModernDataStack
➡️ LOGICAL_OR returns TRUE because at least one of the values in the array is less than 3.
SELECT LOGICAL_OR(x < 3) AS logical_or FROM UNNEST([1, 2, 4]) AS x;
Learned in medium.com/data-enginee...
SELECT LOGICAL_OR(x < 3) AS logical_or FROM UNNEST([1, 2, 4]) AS x;
Learned in medium.com/data-enginee...
Using EXISTS with LOGICAL_OR in BigQuery
Long time, no see! Here’s a quick SQL exercise that illustrates some important modern concepts.
medium.com
February 12, 2025 at 12:11 AM
➡️ LOGICAL_OR returns TRUE because at least one of the values in the array is less than 3.
SELECT LOGICAL_OR(x < 3) AS logical_or FROM UNNEST([1, 2, 4]) AS x;
Learned in medium.com/data-enginee...
SELECT LOGICAL_OR(x < 3) AS logical_or FROM UNNEST([1, 2, 4]) AS x;
Learned in medium.com/data-enginee...
Need to adjust a date field to the start of the week in #BigQuery ?
Do you prefer sunday or monday as the first day?
For sunday, use:
DATE_TRUNC(date_field, WEEK)
For Monday, use:
DATE_TRUNC(date_field, WEEK(monday))
Quick and easy! #SQL #Data #DataAnalysis
Do you prefer sunday or monday as the first day?
For sunday, use:
DATE_TRUNC(date_field, WEEK)
For Monday, use:
DATE_TRUNC(date_field, WEEK(monday))
Quick and easy! #SQL #Data #DataAnalysis
December 6, 2024 at 2:43 PM
Need to adjust a date field to the start of the week in #BigQuery ?
Do you prefer sunday or monday as the first day?
For sunday, use:
DATE_TRUNC(date_field, WEEK)
For Monday, use:
DATE_TRUNC(date_field, WEEK(monday))
Quick and easy! #SQL #Data #DataAnalysis
Do you prefer sunday or monday as the first day?
For sunday, use:
DATE_TRUNC(date_field, WEEK)
For Monday, use:
DATE_TRUNC(date_field, WEEK(monday))
Quick and easy! #SQL #Data #DataAnalysis
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
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
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
You can do it in one step instead of using a CTE and filtering. Less code, same result. #BigQuery #DataBS #DataAnalysis
Definitely, IMHO, one of the biggest challenges within a Data & Analytics department is teaching stakeholders to correctly interpret the data. What do you think would be yours? #DBT #DATABS #DataEngineer www.linkedin.com/posts/dbtlab...
dbt Labs on LinkedIn: What’s next for data teams? Help us find out by taking the 2025 State of…
What’s next for data teams? Help us find out by taking the 2025 State of Analytics Engineering survey.
We want to hear about the wins, the challenges, and…
www.linkedin.com
November 26, 2024 at 3:12 PM
Definitely, IMHO, one of the biggest challenges within a Data & Analytics department is teaching stakeholders to correctly interpret the data. What do you think would be yours? #DBT #DATABS #DataEngineer www.linkedin.com/posts/dbtlab...
November 25, 2024 at 8:31 AM
Metabase 51 is here! 🚀 New features include chart-level permissions for secure sharing, interactive filters for embedded analytics, and an upgraded UI for better usability. Power up your data game! 🔍✨ Full release: www.metabase.com/releases/met... #Metabase #DataWorld
Metabase 51
A bunch of new stuff to help your team make the most of your data: viz upgrades, revamped metrics, more tools to manage accounts and keep your Metabase tidy, and a lot more.
www.metabase.com
November 19, 2024 at 9:40 AM
Metabase 51 is here! 🚀 New features include chart-level permissions for secure sharing, interactive filters for embedded analytics, and an upgraded UI for better usability. Power up your data game! 🔍✨ Full release: www.metabase.com/releases/met... #Metabase #DataWorld
Using Jinja in dbt is like adding superpowers to your SQL! 💪✨ From dynamic filters to reusable macros, it boosts efficiency and keeps your code DRY. Just remember: a little Jinja goes a long way, don’t overcomplicate! #dbt #Jinja #DataWorld
November 18, 2024 at 8:39 AM
Using Jinja in dbt is like adding superpowers to your SQL! 💪✨ From dynamic filters to reusable macros, it boosts efficiency and keeps your code DRY. Just remember: a little Jinja goes a long way, don’t overcomplicate! #dbt #Jinja #DataWorld
Discover what's new in dbt Cloud this November! 🚀 Exciting updates include enhanced collaboration features, improved testing workflows, and more. Check out the full details here: www.getdbt.com/blog/whats-n... #dbt #DataEngineering #DataWorld
What's new in dbt Cloud - November 2024 | dbt Labs
Learn about the latest features and capabilities that just landed in dbt.
www.getdbt.com
November 17, 2024 at 2:57 PM
Discover what's new in dbt Cloud this November! 🚀 Exciting updates include enhanced collaboration features, improved testing workflows, and more. Check out the full details here: www.getdbt.com/blog/whats-n... #dbt #DataEngineering #DataWorld
Ever heard of dbt? 🚀 It's the magic wand for transforming raw data into actionable insights! With dbt, analysts own the transformation layer, enabling version control, testing, and modularity. 💻✨ #dbt #DataAnalytics #DataWorld
November 15, 2024 at 10:43 AM
Ever heard of dbt? 🚀 It's the magic wand for transforming raw data into actionable insights! With dbt, analysts own the transformation layer, enabling version control, testing, and modularity. 💻✨ #dbt #DataAnalytics #DataWorld
Data visualization is more than charts and graphs, it's storytelling! 📊 The best visualizations help uncover patterns, trends, and insights. I recommend having a look at Storytelling with Data by Cole Nussbaumer. #DataViz #BI #DataWorld
November 14, 2024 at 12:49 PM
Data visualization is more than charts and graphs, it's storytelling! 📊 The best visualizations help uncover patterns, trends, and insights. I recommend having a look at Storytelling with Data by Cole Nussbaumer. #DataViz #BI #DataWorld
Did you know SQL has been around since the 1970s? 🎉 It's the backbone of data querying, and still relevant today! Start with basics like SELECT, WHERE, and JOIN to unlock data insights. What's your favorite SQL trick? #SQL #DataAnalysis #DataWorld
November 13, 2024 at 4:07 PM
Did you know SQL has been around since the 1970s? 🎉 It's the backbone of data querying, and still relevant today! Start with basics like SELECT, WHERE, and JOIN to unlock data insights. What's your favorite SQL trick? #SQL #DataAnalysis #DataWorld
Since I started working, I've seen several 'dinosaur' companies that, purely for the sake of 'prestige', have implemented BI tools so poorly designed, dense, and slow that they end up achieving the opposite of becoming a data-driven company.
November 10, 2024 at 8:03 PM
Since I started working, I've seen several 'dinosaur' companies that, purely for the sake of 'prestige', have implemented BI tools so poorly designed, dense, and slow that they end up achieving the opposite of becoming a data-driven company.