Tag Archive For "SSRS"
Creating a Pareto Chart in SSRS
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 post I’ll walk you through the steps to re-create this report based on the AdventureWorks sample dataset. Create a Basic …
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 many cases, the bulk (~80%) of a measured quantity (ex. sales amount) is contributed by a minority (~20%) of the …
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 provide the user with the ability to select the dimension (via an SSRS parameter) along which to calculate the measure. …
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 or create copies in separate reports. Sometimes it’s just easier to start from a copy of an existing object and …
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 it got me thinking about some work I did at my last client and how I would do that work …
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 Solutions with Microsoft SQL Server 2012 Below is an outline of the material I worked through in preparation for these …