Monday, August 30, 2010

Easy analysis with fishbone diagram template (Ishikawa)

I spent some time recently and created a fishbone diagram template .  To view/use the diagram follow the link here


Here is a short article on fishbone diagrams and how/when to use them.
The output of will look like this


Here are the steps to produce the chart

Monday, August 23, 2010

MicroCharts in Excel

I ran across this post the other day.  It's an old post but a cool concept for anyone creating dashboards in Excel.  You can actually use some of the concepts in Microsoft Reporting Services as well. 

http://chandoo.org/wp/2008/09/05/microcharting-excel-howto/

These guys have a lot of great ideas.  I just stumbled across them for micro charting but many great Excel charting solutions.

You can go here to read a little more about microcharts and how to use them.
Click here to download a template I created based on one of the charts.  As it exists today it will allow for 50 lines of data.  To add more lines follow the steps below.

Wednesday, August 18, 2010

How to use a Sharepoint list as a datasource for Microsoft Reporting Services

Step 1:

Create Sharepoint List that contains the data you would like to report against.
 Step 2: Once in SSRS:
     1. Create a new datasource
          a. Name – Name of datasource
          b. Type – XML
          c. Connection String – Home page of the Sharepoint site where the list exists.
               NOTE: After the name of the site remove the “default” and replace it with   <</_vti_bin/Lists.asmx>>
               http://<server>/<path>/_vti_bin/Lists.asmx
          d. Use Windows Authentication

Tuesday, August 17, 2010

Scorecard Analysis - an Introduction

I decided to start a blog as an outlet for many of the things I am working on in my job right now.  I am a data analyst.  Recently I have taken on a new role where I am responsible for designing and implementing a scorecard for most of our IT department.  My plan is to start small and attempt to get this model adopted by the entire IT department. 

My intentions with this blog is to put out some How-tos, some general knowledge sharing, and a way to share the things I've learned and resources I've used with everyone else.