Business Intelligence

SQL Server Reporting Services (SSRS) is not just about displaying data; it’s about presenting it in a way that is clear and easy to work with. This post explores two sophisticated features: creating cross-chart filtering refresh effects and ensuring column headings repeat across multiple pages. Creating Cross-Chart Filtering in SSRS Reports Cross-chart filtering is a […]

SQL Server Reporting Services (SSRS) has come a long way over the years. This post covers two useful techniques: implementing column-level security and creating dynamic drill-down functionality. Implementing Column-Level Security in SSRS Reports While SSRS doesn’t offer out-of-the-box support for column-level security, you can implement it manually to control data visibility based on user roles.

Lately, I’ve been experimenting with the latest features in SQL Server Reporting Services (SSRS), and wanted to write up a few things I’ve learned about building more complex reports. For instance, I recently tackled a project involving a multi-dimensional report. The goal was to show sales data across various dimensions like time, geography, and product

I’ve been working with the latest Power BI update and I’m particularly impressed with two features: the DAX Query View and Semantic Model Scale-Out. These have significantly improved how I handle data analysis. DAX Query View The DAX Query View is a big step forward. It gives you a much better way to test and