…brew your own Business Intelligence

Posts Tagged ‘Data Visualization’

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 […]

Read more

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 […]

Read more

Analyzing SQL Server Object Dependencies with NodeXL

One time I was tasked with developing a handful of custom reports for a legacy application.  The data model was an absolute nightmare – overflowing with technical debt and being held together with duct tape and views…tons and tons of views.  In this post, I’ll show you how NodeXL can […]

Read more

Robert Frost and Pie Charts

Earlier this year, Microsoft released an incredible self-service reporting and presentation tool called Power View (with SQL Server 2012).  It’s highly interactive, has excellent visualizations, and I could go on and on about the value it adds to businesses currently leveraging the Microsoft BI stack.  Instead, I’d like to point out […]

Read more