Lien

For the ones interested: these are all the ways the organization "Raad Van State" and its legal id where spelled in the EU Tender data, for a very limited subset of data (50ish procedures).

ted.europa.eu/en/

Screenshot that shows 6 objects called a variation of "Raad van State" having an id that is a variation of "0931.814.266".

Haters gonna hate but I love wild data. It just doesn't hit the same after all the little human footprints are scrubbed clean #databs

Hit my goal early this year 🌟

(and made a chart of course #databs)

Ending a busy weekend with solving days 5, 6 and 7 in one sitting. Only 5 days left of unconventional SQL fun 😊

When you picked the right programming language for day 5 😄

Day 4 was definitely a lot harder then the first three, but happy to report I eventually figured out how to do it with SQL 😊

#AdventOfCode #databs adventofcode.com/2025/day/4

Day 3... Strap in for some recursive SQL
🔋🔋🔋🔋🔋🔋🔋🔋🔋🔋🔋🔋

adventofcode.com/2025/day/3

GitHub - LienBosmans/AdventOfCode2025: Solving Advent of Code puzzles with SQL (DuckDB) Solving Advent of Code puzzles with SQL (DuckDB). Contribute to LienBosmans/AdventOfCode2025 development by creating an account on GitHub.

Should I use SQL for Advent of Code? ...probably not

But can I solve all puzzles using SQL? ...again, probably not

But will I try anyway? ... definitely yes 🦆

#databs

github.com/LienBosmans/...

Fab Reporting Business Analyst | imec As a Fab Reporting Business Analyst, you provide the Fab teams with the data and reports they need to run the Pilot Lines effectively and efficiently.

To all data peeps that want to work on very cool data & all (semiconductor) industry peeps that want to move into a full-time data role, this is your chance!

www.imec-int.com/en/work-at-i...

Fab Reporting Business Analyst | imec As a Fab Reporting Business Analyst, you provide the Fab teams with the data and reports they need to run the Pilot Lines effectively and efficiently.

To all data peeps that want to work on very cool data & all (semiconductor) industry peeps that want to move into a full-time data role, this is your chance!

www.imec-int.com/en/work-at-i...

If you're not making yourself the hero of the internal documentation you're writing, what's even the point? #databs

You are faced with two data sources. One mostly tells the truth, the other sometimes lies. They never answer your questions at the same time. A small mob of stake-holders is demanding a fresh and perfectly trustworthy report of events. In short, you are utterly and completely fucked. Luckily, ...

Screenshot of eProcurementOntology documentation (link at end). The text "TODO: add defintion" is highlighted. https://docs.ted.europa.eu/EPO/latest/_attachments/html_reports/ePO/EARoot/EA1/EA2/EA102.htm

hehe, spotted a "TODO" in the documentation... Can't even blame them, I do it all the time 😂

Those pesky datasets never are 🥲

I'm currently in the muddy part of getting to know a new dataset... and a new API... and a new query language... wish me luck #databs! At least the documentation seems pretty complete 😊

ICT Solution architect data platforms | imec

Damn... If you know data people that want to move to Europe, they'd be very welcome... imec is a cool organization and pretty international.

www.imec-int.com/en/work-at-i...

www.imec-int.com/en/work-at-i...

www.imec-int.com/en/work-at-i...

New PyStack't documentation site is live!

lienbosmans.github.io/pystackt/

#pystackt #opensource #OCED #processmining

Not yet, I'm sure they are out there! But I'm guessing they are busy doing more useful things than giving these kind of demos 😄

Drawing of a wombat with clean, simple lines. The gray wombat is sitting and stacking three rounded cubes in front of it. The cubes are brown. To the left of the wombat, in light brown, the letters of PyStack't are stacked a bit jumbly in three rows: p y - s t a - c k 't.

What's awesome about building open source is that you don't have to worry about sales prospects. For example, using your favourite animal stacking poo cubes as the logo for a data preparation tool, is a totally valid option.

#databs

Drake No/Yes Meme. No: Improving PyStack't. Yes: Creating a cute logo. The logo in question shows a black-and-white drawing of a wombat with clean, simple lines. The wombat is sitting and stacking three rounded cubes in front of it. To the left of the wombat, in light grey, the letters of PyStack't are stacked a bit jumbly in three rows: py - sta - ck't.

How's your side project going? #databs #opensource

Mister Crabs (from Spongebob) lying in a pile of money. Caption reads "Software vendors after showing demo of AI going brrrrr to C-suite."

Mostly DuckDB & some Polars at home, SQL, Excel, Databricks and PowerBI at work.

Vendor demos be like "give us money because AI goes brrrrr"

Ooooh, I made a tool that can extract a dataset from the activity data (issues/pull requests) of a GirHub repo. I'll try it with the tidytuesday repo next week to see what comes out 😄

#objectcentric #processmining #pystackt #databs

👑 Improve the docs. (I'm known as a queen of typos after all)

🐍 Fix my code. (Apparently, it's not "pythonic" enough... or so I'm told)

🎁 Contribute a data exporter to your favorite OCED format, or a data extractor for an open data source you're excited to dive into.

📣 Shamelessly promote your compatible & open-source tool, method, use-case, ... by dropping a link in our docs.

GitHub - LienBosmans/pystackt: Data preparation for object-centric process mining Data preparation for object-centric process mining - LienBosmans/pystackt

📢 PyStack't is now open for contributions!

(To be honest, it always was, but now there is a contributing guide to make it more obvious and to help you get started.)

So, for anyone out there working on object-centric process mining, you're invited to 🧵

github.com/LienBosmans/...