James πŸ³οΈβ€πŸŒˆ

120 Followers
118 Following
529 Posts

All posts reflect my own thoughts and not those of any employer or organization.

Analytics Professional dabbling in MDM and Power BI

He/Him

@jenk oh no!! I'm so sorry Jen 😭
Happy election day, @jenk ! πŸ‡¨πŸ‡¦πŸ‡¨πŸ‡¦

The perfect scientific paper for @SQLAllFather doesn't exist....

Oh wait...
https://www.vox.com/2014/11/21/7259207/scientific-paper-scam

🀣

β€œGet Me Off Your Fucking Mailing List” is an actual science paper accepted by a journal

Vox

In this video, I take a deep dive into optimizing #powerquery folding in #powerbi with Reid.

Query folding is often referred to as if it is a performance panacea. In fact, query folding just means that M is compiled to a semantically equivalent expression in the data source.

How do we understand the relative performance of multiple different folded queries that yield the same result?

https://www.youtube.com/watch?v=fcNNKa8KC2E

Not All Query Folding is Created Equal...Performance Tuning PQ

YouTube
@jamesttu 🎸
Welp, I guess a 4 year streak of negatives had to eventually give way at some point. Luckily it's been very mild and tolerable.
@Sqlgene haha, I promise it's real!
I'm on a quest to throw out/compost as little as possible and today decided to try my hand at making banana peel bacon. I was skeptical but it was actually tasty. Super cheap and easy!
Turned on fediverse sharing... Hello World. πŸ‘‹πŸ»
The case sensitivity of Power Query gets me EVERY.SINGLE.TIME however I still love it more than DAX πŸ€·πŸ»β€β™‚οΈ #PowerBi