Jörg Schmidt
joschkos.bsky.social
Jörg Schmidt
@joschkos.bsky.social
BI Consultant, MS Data Platform, Power BI, Excel-DNA
Reposted by Jörg Schmidt
🏛️ We launched the DuckDB Library: a curated collection of papers, podcasts, talks and books about DuckDB.

📚 We already have a collection of almost one hundred entities. The thumbnails show whether a piece is from the DuckDB team (yellow) or from others (purple).

➡️ duckdb.org/library/
December 19, 2025 at 6:26 PM
Reposted by Jörg Schmidt
Could I get you all to share this post please? I’d be very grateful. #Kikorangi
Finally!!!
I pushed through lots of pain to finish her. Really need to sell her quickly, & for as much $ as I can possibly get… definitely wanting at least $1500 as she’s very big.
78.5cm x 70cm.
Please share widely, I would greatly appreciate the help.
#CrossStitch #Kikorangi
#nzpol
December 15, 2025 at 7:45 AM
Reposted by Jörg Schmidt
A real 99M-row benchmark reveals why Import Mode still outperforms Direct Lake in Microsoft Fabric and what the engine truth means for your BI architecture. #microsoftfabric
The Direct Lake Mirage: What Really Happens at 99 Million Rows
hackernoon.com
December 10, 2025 at 2:17 AM
Reposted by Jörg Schmidt
Simple OLAP cache based on DuckDB, adding instant speed up for your DuckDB queries.

This is a deep dive into OLAP and Caches, a never-ending (love/hate) story 😃.
Simplicity of a Database, but the Speed of a Cache: OLAP Caches for DuckDB - MotherDuck Blog
Speed up slow dashboards without adding new infrastructure. Learn how DuckDB's caching extensions can drop query times from minutes to seconds. | Reading time: 18 min read
motherduck.com
December 5, 2025 at 1:15 PM
Reposted by Jörg Schmidt
A look at the impact of calendar-based time intelligence on #PowerBI DirectQuery performance blog.crossjoin.co.uk/2025/11/30/a...
Impact of Calendar Based Time Intelligence on Power BI DirectQuery performance
Significant performance improvements are possible but not in all cases
blog.crossjoin.co.uk
December 1, 2025 at 8:31 AM
Just checked out what Fabric IQ might be.
For me it is the milk ordering fridge. But at enterprise scale.
And that did not work either.
November 30, 2025 at 12:33 PM
Reposted by Jörg Schmidt
Anyways. I’m fine. I have the support system I need

I’ve also come to terms with the fact that I’m not going to be the person doing soothing emotional labour to help mediocre white men in power feel better about their refusal to fix the system. I’m not gonna paint the band aids pink
November 28, 2025 at 9:38 PM
Updated my report because of the new button slicer.
I have to admit that Power Bi is a real good product.
The click/hacking/trick tax could be lower. But hey.
My emotional distance to Power BI has shortened.

Dashboard can be viewed here.
www.sysaccount.de/powerbi

Refreshable Pbix is available.
November 27, 2025 at 3:33 PM
Books on data analysis and business intelligence
at Humble. Tableau, Power BI, DAX, Power Query.

www.humblebundle.com/books/modern...
Humble Tech Book Bundle: Modern Data Analytics & Business Intelligence (BI) Mastery Bundle by Packt
Pay what you want for Python machine learning courses and more with the Modern Data Analytics & Business Intelligence Mastery Bundle!
www.humblebundle.com
November 22, 2025 at 11:16 AM
Reposted by Jörg Schmidt
The latest update for #Qlik includes "Benchmarking Ingestion Costs and Performance of Qlik Open Lakehouse Vs a #DataWarehouse" and "Qlik + Microsoft Fabric Open Mirroring: The Fast Track to Real-Time Data Intelligence".

#analytics #bigdata #BusinessIntelligence https://opsmtrs.com/3Ch8wkM
Qlik
Qlik® delivers intuitive platform solutions for self-service data visualization, guided analytics applications, embedded analytics and reporting to approximately 45,000 customers worldwide.
opsmtrs.com
November 18, 2025 at 3:44 AM
Reposted by Jörg Schmidt
I added my notes here, in case of interest.
History of General Architecture in Data
KEYNOTE: [[Hannes Mühleisen]] - Data Architecture Turned Upside Down at the PyData in Amsterdam 2025. Below some of my prelimitary notes, and also note, that this is heavily focused on [[DuckDB]]. B...
www.ssp.sh
November 4, 2025 at 9:30 AM
Reposted by Jörg Schmidt
Huey 1.0.11 is now released! This upgrades @duckdb WASM to latest (1.4.2).

Also, I welcome Roger Chi as new contributor.

github.com/rpbouman/hue...
November 12, 2025 at 8:01 PM
Reposted by Jörg Schmidt
Listen this might be the only chance you get to use the discount code "ALFHOG"
Because all y’all have been so supportive of my weird obsessive work:

This weekend you can use the code ALFHOG for 25% off anything in my store. 🪶📊🎨
www.jerthorp.me/category/of-...
November 9, 2025 at 4:26 AM
Reposted by Jörg Schmidt
One of the most beautiful pieces of work I have ever seen!
It took me about three months to get here but...

Here's a 🪶 for (nearly) every species of bird, with colors extracted from wikipedia descriptions.

10,151 species.

#dataviz #birds #data
November 5, 2025 at 6:44 AM
Reposted by Jörg Schmidt
Reposted by Jörg Schmidt
I learned Power BI from people who shared their work for free, wrote articles, and made videos. And I am incredibly grateful for that. Now I try to do the same and give back to the community: examples/videos/articles: www.porcu.bi
#PowerBI #DataViz #DataVisualization
November 4, 2025 at 1:30 PM
Reposted by Jörg Schmidt
New blog post: SQL Server Diagnostic Information Queries for November 2025

glennsqlperformance.com/2025/11/03/s...

#SQLServer #SQLServer2025
November 3, 2025 at 9:42 PM
Reposted by Jörg Schmidt
Reposted by Jörg Schmidt
Books of Data Engineering. Which one is your favorite, and what are you reading?

Also, what books do you read that are not related to DE, but have influenced how you think or design data work?
Books of Data Engineering
Below are books related to data engineering. Starters and general knowledge: Data Engineering Design Patterns (DEDP) - My partially free online book to get you started :) The Data Warehouse Toolk...
www.ssp.sh
November 2, 2025 at 9:53 AM
Reposted by Jörg Schmidt
Fabric Studio by Gerhard Brueckl saved my butt this morning. I was able to lowercase all the tables and columns in a copy job in 30 minutes instead of manually doing it for 8 hours. Simply fantastic. #MicrosoftFabric

marketplace.visualstudio.com/items?itemNa...
October 29, 2025 at 2:54 PM
Reposted by Jörg Schmidt
October 19, 2025 at 2:05 PM
Reposted by Jörg Schmidt
In case of interest, my latest presentations and podcasts at gigs.ssp.sh.
My Gigs (Podcasts, Videos, Slides, etc.)
Here I have a list of my appearance online or slides I shared during an event. 9. Andreas Kretz Podcast: Why Writing Is Thinking, and What Data Engineers Can Learn from It In this episode, [[Andreas K...
gigs.ssp.sh
October 9, 2025 at 6:14 AM