Browsed by
Category: Business Intelligence

Power BI Reportserver Goes Mainstream: Cost‑Effective On‑Prem BI with SQL 2025

Power BI Reportserver Goes Mainstream: Cost‑Effective On‑Prem BI with SQL 2025

Comments 0 Comment

SQL Server 2025 hit GA on November 18, 2025, and it brings real on‑prem momentum—especially for teams invested in Power BI Report Server (PBIRS). SQL Server Standard edition now scales more comfortably, supporting up to 32 cores and 256 GB RAM (previously 128 GB), which gives mid‑size workloads room to breathe without jumping to Enterprise. That said, SSAS Tabular in Standard remains capped at 16 GB, so if Tabular models are central to your stack, that limit is still the…

Read More Read More

Review SQL Days – Meine Sessions und Begegnungen

Review SQL Days – Meine Sessions und Begegnungen

Comments 0 Comment

English Version Es ist nun schon wieder über ein Monat her, und der stressige Alltag hat mich längst zurück. Trotzdem schaue ich gerne auf die SQL Days zurück und möchte meine Zusammenfassung hier weiterführen – diesmal mit meinen eigenen Sessions und den vielen Gesprächen, die sich ergeben haben. Session 1: Power BI Reportserver – Vielleicht nische, aber spannend Meine erste Session drehte sich um den Power BI Reportserver. Ein Thema, das bei vielen Speaker-Kollegen erstmal für Stirnrunzeln sorgt: „Power BI…

Read More Read More

Review SQL days: Wenn der Osterhase stolpert – Datenqualität als unterschätzter Erfolgsfaktor

Review SQL days: Wenn der Osterhase stolpert – Datenqualität als unterschätzter Erfolgsfaktor

Comments 0 Comment

English version Eindrücke und Learnings aus dem Vortrag von Jasmin Simader und Christian Schneider bei den SQLDays Erding 2025 Die Geschichte beginnt mit einem augenzwinkernden Beispiel: Ein Osterfest gerät ins Chaos, weil die Osterhasen mit der Auslieferung nicht hinterherkommen. Körbchen bleiben leer, Routen sind doppelt belegt, und manche Adressen existieren gar nicht. Der Grund? Schlechte Datenqualität. Was humorvoll beginnt, trifft den Kern eines ernsten Problems: mangelhafte Daten kosten Zeit, Geld und Vertrauen – jeden Tag. Dieser Einstieg stammt aus dem…

Read More Read More

Exploring Many-to-Many Modeling Between Fact and Dimension in Power BI: What I Learned

Exploring Many-to-Many Modeling Between Fact and Dimension in Power BI: What I Learned

Comments 2 comments

Disclaimer This article was drafted with the help of Copilot (AI) – so if it is unusually well structured or my English sounds unusually polished, that’s probably why 😊. I’m not a DAX expert (yet), and the DAX code used here was generated by Copilot too. It worked well for testing, but I’d recommend reviewing it thoroughly before using it in production. The test reflects my specific use case – a many-to-many relationship between a fact and a dimension table. Your scenario might differ,…

Read More Read More

Theme Sentiment Colours with Power BI

Theme Sentiment Colours with Power BI

Comments 0 Comment

WoW 2024_26 Today I worked on my first submission to Workout Wednesday. Okay it’s technically Thursday here in Germany but more important I managed to do the whole thing. I chose week 26 which is about Reference Theme Sentiment Colors in DAX and practiced how to design a dashboard in a way where color scheme changes are reflected automatically in the formatting of the visual. I would like to share my personal learnings in a short bullet point list. This…

Read More Read More

A matter of data visualization

A matter of data visualization

Comments 0 Comment

Some time ago my boss asked me for advice on a report he just created. Here’s an example with sample data of what he liked to visualize: For different dates we have a count of objects which had a specific final status. You can reproduce the sample data using the following select statement: query-with-inline-sample-data Goal of the visualization should be to show the distribution across the different status and the overall development of the measured data. Our first approach was…

Read More Read More

Create your own shapefile

Create your own shapefile

Comments 4 comments

This blog post is about creating custom shapefiles to support your own visualizations. A shapefile is a vector graphic used for visualisation of spatial data (like maps) by numerous BI frontends or reporting tools.  The blogpost was inspired by a presentation on “free visualisation with the CSP C8 Frontends” given by Matthias Jüstel and Ivo Pawlow at the Cubeware Infotag 2015 in Rosenheim. The presenters repeated their presentation in a webcast on 25.02.2016 which can be viewed on the Cubeware…

Read More Read More