Recently, I created an SSRS report which used pareto charts to help a client analyze the impact of unplanned events in their production facilities across multiple dimensions (ex. Location, Equipment, Reason Code etc). In this … Continue reading Creating a Pareto Chart in SSRS
Pareto Analysis
Pareto Analysis is a nice technique for exploring the distribution of a measure across its contributors. Regardless of whether the measure is positive (ex. sales amount) or negative (ex. production defects) the goal is the same. In … Continue reading Pareto Analysis
SSRS + MDX: Dynamic Dimension Attribute on Row Axis
Earlier this year, while building an SSRS report against a Cube data source, I got stuck trying to parameterize the dimension attribute on the rows axis of the dataset query. What I wanted was to … Continue reading SSRS + MDX: Dynamic Dimension Attribute on Row Axis
How to Create a Copy of an SSRS Dataset
A lot of times, when creating SSRS reports, I find myself wanting to copy/paste existing objects from the report data window (ex. parameters, data sources, and datasets) either to create duplicates in the same report … Continue reading How to Create a Copy of an SSRS Dataset
Reporting Against the SSIS 2012 Catalog
This weekend, on the way home from a nice few days at the beach with family, I was listening to a SQLBitsX session (A Lap Around the SSIS Catalog) by Jamie Thomson (b | t) and … Continue reading Reporting Against the SSIS 2012 Catalog
Passed 70-466 and 70-467 Exams + Study Guides
Earlier this month, I passed the following two exams putting me 1 away (70-462) from the MCSE Business Intelligence certification. 70-466 – Implementing Data Models and Reports with Microsoft SQL Server 2012 70-467 – Designing Business Intelligence … Continue reading Passed 70-466 and 70-467 Exams + Study Guides