We’ve completed reviewing the major Microsoft tools and now you have to make “The Decision”. Which tool(s) is the best fit for the reporting needs? Remember just picking one tool and using it for all reports may not be the best decision because you are missing out on a lot of the benefits of other tools.
One tool I like to use that helps me make a decision like this is a decision matrix. With a decision matrix you provide the possible options, which for us has been the following tools:
You also provide the factors that are important to you in making a decision. You can see in the screenshot below I’m considering tools based on:
- Ad Hoc Reporting
- Content Sharing
- User Flexibility
- Developer Flexibility
- Time to Develop
Within the matrix you rate each of the tools (0-100) in their capabilities of the factors you’re considering. This rating should only be done once.
Some factors to making a reporting decision may be more important than others depending on the need. For example, for one report Ad Hoc Reporting may be the most important thing while another report Content Sharing may be the most important thing. That’s why you sign a relative weight (0-10) to each decision you need to make. That way if Ad Hoc Reporting is most important than rate it higher than the other factors. Again, this weighting system would be changed for each report you need to make a decision on choosing a tool.
Download a sample Decision Matrix here:
Using a tool like a Decision Matrix can help you make decisions quickly and with more confidence. I hope this series has been helpful. If you need to catch up on previous posts follow the links below.
- Part 1: Reporting Services
- Part 2: Excel
- Part 3: PowerPivot
- Part 4: PerformancePoint
- Part 5: Power View
- Part 6: Making the Decision