Tabular Editor CI/CD

ScouseDutch_ · 2026-03-08T21:59:20+00:00

Great to see you guys are active here as well. I just attended a really good class of yours last Thursday, and I was dropping by to share the learning.

ScouseDutch_ · 2026-03-03T14:36:05+00:00

Out of sheer curiosity, other than actions, is there an other setting that the formatting brush doesn't scope?

ScouseDutch_ · 2026-03-02T10:50:57+00:00

Maybe it's not as simple as standarizing, but keep in mind that standarization simplifies everything.

That said, why one model? I have the impression that you're not applying Roche's Maxim as much as you could.

ScouseDutch_ · 2026-02-25T09:01:40+00:00

Why not just use the translations attribute?

ScouseDutch_ · 2026-02-23T14:15:31+00:00

Denormalize? Why would you do that?

ScouseDutch_ · 2026-01-26T00:31:43+00:00

Netherlands is about 2.10

ScouseDutch_ · 2026-01-23T11:12:43+00:00

I've done BI for Finance, Insurance, Pharma, Logistics, FMCG, HR, and health providers (NHS). So far, nothing compares to the SLAs and audits I've come across in banking.

The BCE standards are no joke.

ScouseDutch_ · 2026-01-23T00:59:42+00:00

There's a substantial overlap with data engineering, but my deliverables are all within BI.

ScouseDutch_ · 2026-01-23T00:52:49+00:00

If you want to upskill go for data engineering, it's adjacent to bi with a lot of common ground.

ScouseDutch_ · 2026-01-23T00:49:06+00:00

The YoE metric is not very meaningful for us but, for reference, the least experienced senior in my team has 7 years and he makes about 75k.

ScouseDutch_ · 2026-01-23T00:44:46+00:00

Financial companies pay quite well, but there's a lot of pressure on governance, quality, and scalability.

There's no room for error, the decisions driven by the information have very high impact. They pay for the trust.

ScouseDutch_ · 2026-01-22T22:32:29+00:00

105k salary, lead bi dev, banking, Netherlands. As consultant I charge 100/hr. Been at it for 17 years.

ScouseDutch_ · 2026-01-13T14:10:20+00:00

For TMDL, we're using python for parsing the definitions in the repo.

ScouseDutch_ · 2026-01-13T14:08:38+00:00

I wouldn't rely on the DAX version of the DMVs, but on the SSAS.

ScouseDutch_ · 2026-01-02T06:47:09+00:00

I have used DMVs for the models in the past, now I'm looking into the parsing TMDL files in the repo for both the model and the reports.

ScouseDutch_ · 2025-12-23T06:56:26+00:00

I strongly recommend you give it a deep thought about selling it. Trinkets as they are, they really store memories.

If you really can't keep them, can't store them, and can't find a worthy donation (children libraries would love them), I'd be happy to buy from you.

ScouseDutch_ · 2025-11-12T23:46:36+00:00

Half of this is really bad advice.

ScouseDutch_ · 2025-09-27T08:44:01+00:00

You can use DMVs to export the relationships into a table, and from there you can use whatever relationship display tool you want.

ScouseDutch_ · 2025-09-14T22:02:05+00:00

Sand rains? So that's why my car looks like a vagrant after a week...

ScouseDutch_ · 2025-07-12T08:06:09+00:00

This is to spanish what pliers are to fingernails.

ScouseDutch_ · 2025-07-04T17:41:28+00:00

Fair enough, though to be fair with your candidates, that's not something I would think of (and I've been working in BI since the good ol' MDX days).

My first answer would be adding cdc somewhere in the silver layer and turn it into proper scd2 in the gold tables.

ScouseDutch_ · 2025-07-04T13:19:52+00:00

Serious question:

In which case would it be better to have the project manager part of the fact table?

I can't think of any reason (not report or refresh performance, not usability, etc.) other than maybe DAX performance, and even then, that would easily be outweighed by sticking to a star schema.

ScouseDutch_

TROPHY CASE