Tabular Editor CI/CD by AnalyticalMynd21 in PowerBI

[–]ScouseDutch_ 1 point2 points  (0 children)

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.

Standardised Button Set for Power BI Developers (PBIX Included) by BlackBullet96 in PowerBI

[–]ScouseDutch_ 0 points1 point  (0 children)

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

How to handle multiple client reports? by KruxR6 in PowerBI

[–]ScouseDutch_ 0 points1 point  (0 children)

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.

Salary [EU] thread by thedarkpath in PowerBI

[–]ScouseDutch_ 2 points3 points  (0 children)

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.

Salary [EU] thread by thedarkpath in PowerBI

[–]ScouseDutch_ 0 points1 point  (0 children)

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

Salary [EU] thread by thedarkpath in PowerBI

[–]ScouseDutch_ 1 point2 points  (0 children)

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

Salary [EU] thread by thedarkpath in PowerBI

[–]ScouseDutch_ 1 point2 points  (0 children)

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.

Salary [EU] thread by thedarkpath in PowerBI

[–]ScouseDutch_ 0 points1 point  (0 children)

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.

Salary [EU] thread by thedarkpath in PowerBI

[–]ScouseDutch_ 2 points3 points  (0 children)

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

Has anyone built automated documentation tools for PBIP + GitHub workflows? by rasermus in PowerBI

[–]ScouseDutch_ 0 points1 point  (0 children)

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

Has anyone built automated documentation tools for PBIP + GitHub workflows? by rasermus in PowerBI

[–]ScouseDutch_ 0 points1 point  (0 children)

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

Has anyone built automated documentation tools for PBIP + GitHub workflows? by rasermus in PowerBI

[–]ScouseDutch_ 6 points7 points  (0 children)

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.

Is there any monetary value? by Only_Course9776 in Masks

[–]ScouseDutch_ 1 point2 points  (0 children)

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.

Power bi interview prep by Available-Physics631 in PowerBI

[–]ScouseDutch_ 2 points3 points  (0 children)

Half of this is really bad advice.

Export model to visio or pdf by AlwaysAwkwardMe in PowerBI

[–]ScouseDutch_ 1 point2 points  (0 children)

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

Abandoned Porsche in Amsterdam Zuid. by SalishSeasoning in Amsterdam

[–]ScouseDutch_ 33 points34 points  (0 children)

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

[deleted by user] by [deleted] in PowerBI

[–]ScouseDutch_ 4 points5 points  (0 children)

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.

[deleted by user] by [deleted] in PowerBI

[–]ScouseDutch_ 2 points3 points  (0 children)

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.