BeyeBLOGS | BeyeBLOGS Home | Get Your Own Blog

« Is your project on time, on budget, on the mark? | Main | Common hierarchies in Project star schemas »

September 19, 2009

Pareto Charts in Project BI

I wanted to spend just a short time blogging about a specific type of chart that is used to good effect in project management, the Pareto chart.

The most common applicatio of Pareto analysis in projects is around quality analysis. Paretos are popular in this regard because they graphically display the relationships between groups of data. This is handy in quality analysis because it helps you to identify the 20% of sources cause 80% of the problem. In most cases, the data groups in Pareto charts are displayed as vertical bars, in descending order of significance.

This image below is a sample in Microsoft SSRS of a Pareto Charts, not for projects, but for sales data. I included it because I liked the approach that was to display the groupings and rankings:

Here is the full link to the MSDN article about creating Pareto charts in Microsoft SQL Server Reporting Services.

Many times when I have worked with Pareto Chart in project quality analysis, they have been much more simple in that typically project managers will align the data in a tabular Excel spreadsheet and then build a report in Excel with just a column chart.

These next examples are specific to quality metrics, much more applicable to project portfolio management:

Here is a sample Pareto used in quality control from iSixSigma.

And this is another example, this one from Duncan Haughey, PMP, again showing the use of Pareto analysis by charting the ranking to 100% of defect categories.

In most cases, quality engineers will use more advanced tools that have built-in capabilities to create Pareto charts for you as well as fishbone diagrams and control charts. You'll find these sorts of capabilities in SAS & Oracle applications, for example.

Posted by Mark Kromer at September 19, 2009 6:00 PM


Hey There. I found your blog using msn. This is an extremely well written article. I will make sure to bookmark it and come back to read more of your useful info. Thanks for the blog post. I will definitely return. Garland Masley

Posted by: Garland Masley at May 13, 2011 12:06 PM

I envy your capability to write wonderful post - simply wannted to state I love this !

Posted by: swarovskiego at May 15, 2011 2:43 PM

I loved as much as you'll receive carried out right here. The sketch is tasteful, your authored material stylish. nonetheless, you command get got an shakiness over that you wish be delivering the following. unwell unquestionably come more formerly again as exactly the same nearly very often inside case you shield this increase.

Posted by: cheap escort London at May 16, 2011 2:45 PM

I have been exploring for a little bit for any high quality articles or blog posts on this sort of area . Exploring in Yahoo I at last stumbled upon this web site. Reading this info So i am happy to convey that I have a very good uncanny feeling I discovered exactly what I needed. I most certainly will make certain to do not forget this web site and give it a glance regularly.

Posted by: escort service at May 17, 2011 1:34 AM

very nice post, i certainly love this website, keep on it

Posted by: at May 17, 2011 12:52 PM

Post a comment

Remember Me?